2.a
a.Make an amortization table using a Microsoft Excel spreadsheet. In your answer include all the formulas used.
b.How long will it take to repay the loan?
c.How much will be the final payment?
d.Determine how much interest she will pay for her loan.
e.Use Microsoft Excel to graph the amortization of the loan (Hint: Graph outstanding principal vs. month)
f.How much sooner would the loan be paid if she made a 15% down payment?
g.How much would Vanna have saved if she had obtained a loan 3%/a, compounded monthly?
h.Make concluding statement about the importance of interest rates and down payments when taking out loans.
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."
