Instruction
Assess a mortgage payment schedule. At the website http://realstate.yahoo.com/calculators/amortization.html. Assume a loan amount of $120,000, an interest rate of 7.4 percent, and a 30-year maturity. Given this information, what is the monthly payment? In the first month, how much of the monthly payment is interest, and how much is principal? What is the outstanding balance after the first year? In the last month of payment, how much of the monthly payment is interest, and how much is principal? whay is there such a diffrent in the composition of the principal versus interest payment over time ? I need it in excel