CFIN6
Chapter 4 Spreadsheet Problem
Time Value of Money
Use the computerized model in the File C02 to solve this problem.
a. Set up an amortization schedule for a $30,000 loan to be repaid in equal installments at the end of
b. Set up an amortization schedule for a $60,000 loan to be repaid in 20 equal annual installments at an
interest rate of 10 percent. What is the annual payment?