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
each of the next 20 years at an interest rate of 10 percent. What is the annual payment?