Mathematics, 30.12.2019 00:31, autumnskye1
Vanna has just financed the purchase of a home for $280 000. she agreed to repay the loan by making equal monthly blended payments of $3000 each at 4%/a, compounded monthly.
a. create 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. write a concluding statement about the importance of interest rates and down payments when taking out loans.
Answers: 1
Mathematics, 21.06.2019 22:00, wEKLJHFKLJEBFR2460
Luke started a weight-loss program. the first week, he lost x pounds. the second week, he lost pounds less than times the pounds he lost the first week. the third week, he lost 1 pound more than of the pounds he lost the first week. liam started a weight-loss program when luke did. the first week, he lost 1 pound less than times the pounds luke lost the first week. the second week, he lost 4 pounds less than times the pounds luke lost the first week. the third week, he lost pound more than times the pounds luke lost the first week.
Answers: 2
Vanna has just financed the purchase of a home for $280 000. she agreed to repay the loan by making...
Spanish, 21.09.2019 23:10
English, 21.09.2019 23:10