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

Show answers

Another question on Mathematics

Mathematics, 21.06.2019 18:00

Fanny mendelssohn manages all the magazines and paperback books at a local grocery store. she prices many paperbacks to sell at $7.99. the cost to the store is $5.29. what is the markup rate on a paperback book, based on its cost?

Answers: 1

Answer

Mathematics, 21.06.2019 18:00

Darian wants to build a regulation size pool table that is 9 feet in length.he plans he ordered are 18 by 36 inches. what is the scale factor of the dilation he must use to build a regulation pool table

Answers: 1

Answer

Mathematics, 22.06.2019 01:30

(01.02 mc) asap plzzzwhich of the following correctly simplifies the expression 3 to the power of 2 multiplied by 5 to the power of 0 whole over 4, the whole squared.? select one: a. 3 to the power of 2 multiplied by 1 whole over 4, the whole squared. = 3 to the power of 1 multiplied by 1 squared over 4 squared. = 1 over 6.b. 3 to the power of 2 multiplied by 0 whole over 4, the whole squared. = 3 to the power of 4 multiplied by 0 over 4 squared. = 0c. 3 to the power of 2 multiplied by 0 whole over 4, the whole squared. = 3 to the power of 1 multiplied by 0 over 4 squared. = 0d. 3 to the power of 2 multiplied by 1 whole over 4, the whole squared. = 3 to the power of 4 multiplied by 1 squared over 4 squared. = 81 over 16.

Answers: 1

Answer

Mathematics, 22.06.2019 02:00

Reading tests are compared for two students. sara got 98, 100, 65, 78, 98, 46, 100, 100, 45, and 50 on her reading test. lee got 97, 67, 89, 99, 100, 45, 79, 89, 58, and 67 on his reading test.

Answers: 1

Answer

You know the right answer?

Vanna has just financed the purchase of a home for $280 000. she agreed to repay the loan by making...

Questions