Vanna has just financed the purchase of a home for $200 000. She agreed to repay the loan by making equal monthly blended payments of $3000 each at 4%/a, compounded monthly. (15)
Create an amortization table using a Microsoft Excel spreadsheet. In your answer include all the formulas used.
How long will it take to repay the loan?
How much will be the final payment?
Determine how much interest she will pay for her loan.
Use Microsoft Excel to graph the amortization of the loan (Hint: Graph outstanding principal vs. month)
How much sooner would the loan be paid if she made a 15% down payme

Hey! We 've verified this expert answer for you, click below to unlock the details :)

I got my questions answered at brainly.com in under 10 minutes. Go to brainly.com now for free help!

I'd really appreciate your help guys:)

Medals to everyone who tries.

Guy is university math too difficult?

Looking for something else?

Not the answer you are looking for? Search for more explanations.