Basic future values



Download 49.43 Kb.
Page15/16
Date17.12.2020
Size49.43 Kb.
#55401
1   ...   8   9   10   11   12   13   14   15   16
Chapter 2 Questions, Edition 11
36.

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.

  1. What is your annual payment on the loan?

  2. 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.

  3. 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?

CHALLENGE

37.


Download 49.43 Kb.

Share with your friends:
1   ...   8   9   10   11   12   13   14   15   16




The database is protected by copyright ©ininet.org 2024
send message

    Main page