Assgnment: Construction of an Amortization Schedule
SEE EXCEL TEMPLATE - ATTACHED
You plan to purchase a $750,000 home using a 30-year mortgage obtained from a local commercial bank.
The mortgage rate offered is 5.25 percent and requires a 20 percent down payment.
a. What are the monthly payments on the mortgage?
b. Construct the amortization schedule for the first 10 payments. see chart on excel file.
c. If the rate offered was 7.50 percent, what would the monthly payments be?
d. If a 15-year mortgage with a 4.50 percent rate and 20 percent down payment was obtained for the purchase, what would the monthly payments be?
Attachment:- Construction-of-an-Amortization-Schedule.rar