A community for students.
Here's the question you clicked on:
 0 viewing
anonymous
 one year ago
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
anonymous
 one year ago
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

This Question is Closed

anonymous
 one year ago
Best ResponseYou've already chosen the best response.0I'd really appreciate your help guys:)

anonymous
 one year ago
Best ResponseYou've already chosen the best response.0Medals to everyone who tries.

anonymous
 one year ago
Best ResponseYou've already chosen the best response.0Guy is university math too difficult?
Ask your own question
Sign UpFind more explanations on OpenStudy
Your question is ready. Sign up for free to start getting answers.
spraguer
(Moderator)
5
→ View Detailed Profile
is replying to Can someone tell me what button the professor is hitting...
23
 Teamwork 19 Teammate
 Problem Solving 19 Hero
 Engagement 19 Mad Hatter
 You have blocked this person.
 ✔ You're a fan Checking fan status...
Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.