Marketing SRDS Assignment

1) Excel Models: Static & Dynamic

Home Mortgage:

Loan Amount: $200000

Interest Rate: 4.5%

Years: 30

Q1: What is the monthly mortgage amount?

Q2: If the borrowers decide to pay $500 extra every period, starting from the seventh month, when will they be able to pay off their mortgage?

2) check the pdf file