Determine the quarterly payment necessary to fully amortize a loan of $100,000 over5 years. The annual percentage rate is 4 percent, which you will need to convert to a quarterlyrate. Next, please provide an amortization schedule to support your payment amount.
Solution: Excel Sheet - Loan Amortized