Amortizing loans Suppose that you take out a $200,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 6%, and payments on the loan are made annually at the end of each year.
a. What is your annual payment on the loan?
b. Construct a mortgage amortization table in Excel similar to Table 2.1, showing the interest payment, the amortization of the loan, and the loan balance for each year.
c. What fraction of your initial loan payment is interest? What about the last payment? What fraction of the loan has been paid off after 10 years? Why is the fraction less than half?