Construction of an Amortization Schedule

profileMarcoPolo239

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?

  • 7 years ago
  • 8
Answer(1)

Purchase the answer to view it

blurred-text
  • attachment
    amortazation_schedule.xlsx