I need help with E through to H 2. Vanna has just financed the purchase of a hom
ID: 2549739 • Letter: I
Question
I need help with E through to H
2. 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) 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 390/a, compounded monthly? h. Write a concluding statement about the importance of interest rates and down payments when taking out loans.Explanation / Answer
Answer a. Installment No. Installment Paid Interest Principal Loan Balance 0 - - - 200,000.00 1 3,000.00 666.67 2,333.33 197,666.67 2 3,000.00 658.89 2,341.11 195,325.56 3 3,000.00 651.09 2,348.91 192,976.64 4 3,000.00 643.26 2,356.74 190,619.90 5 3,000.00 635.40 2,364.60 188,255.30 6 3,000.00 627.52 2,372.48 185,882.81 7 3,000.00 619.61 2,380.39 183,502.42 8 3,000.00 611.67 2,388.33 181,114.10 9 3,000.00 603.71 2,396.29 178,717.81 10 3,000.00 595.73 2,404.27 176,313.54 11 3,000.00 587.71 2,412.29 173,901.25 12 3,000.00 579.67 2,420.33 171,480.92 13 3,000.00 571.60 2,428.40 169,052.52 14 3,000.00 563.51 2,436.49 166,616.03 15 3,000.00 555.39 2,444.61 164,171.42 16 3,000.00 547.24 2,452.76 161,718.66 17 3,000.00 539.06 2,460.94 159,257.72 18 3,000.00 530.86 2,469.14 156,788.58 19 3,000.00 522.63 2,477.37 154,311.21 20 3,000.00 514.37 2,485.63 151,825.58 21 3,000.00 506.09 2,493.91 149,331.66 22 3,000.00 497.77 2,502.23 146,829.43 23 3,000.00 489.43 2,510.57 144,318.87 24 3,000.00 481.06 2,518.94 141,799.93 25 3,000.00 472.67 2,527.33 139,272.60 26 3,000.00 464.24 2,535.76 136,736.84 27 3,000.00 455.79 2,544.21 134,192.63 28 3,000.00 447.31 2,552.69 131,639.94 29 3,000.00 438.80 2,561.20 129,078.73 30 3,000.00 430.26 2,569.74 126,509.00 31 3,000.00 421.70 2,578.30 123,930.69 32 3,000.00 413.10 2,586.90 121,343.80 33 3,000.00 404.48 2,595.52 118,748.28 34 3,000.00 395.83 2,604.17 116,144.10 35 3,000.00 387.15 2,612.85 113,531.25 36 3,000.00 378.44 2,621.56 110,909.69 37 3,000.00 369.70 2,630.30 108,279.39 38 3,000.00 360.93 2,639.07 105,640.32 39 3,000.00 352.13 2,647.87 102,992.45 40 3,000.00 343.31 2,656.69 100,335.76 41 3,000.00 334.45 2,665.55 97,670.21 42 3,000.00 325.57 2,674.43 94,995.78 43 3,000.00 316.65 2,683.35 92,312.43 44 3,000.00 307.71 2,692.29 89,620.14 45 3,000.00 298.73 2,701.27 86,918.88 46 3,000.00 289.73 2,710.27 84,208.60 47 3,000.00 280.70 2,719.30 81,489.30 48 3,000.00 271.63 2,728.37 78,760.93 49 3,000.00 262.54 2,737.46 76,023.47 50 3,000.00 253.41 2,746.59 73,276.88 51 3,000.00 244.26 2,755.74 70,521.14 52 3,000.00 235.07 2,764.93 67,756.21 53 3,000.00 225.85 2,774.15 64,982.06 54 3,000.00 216.61 2,783.39 62,198.67 55 3,000.00 207.33 2,792.67 59,406.00 56 3,000.00 198.02 2,801.98 56,604.02 57 3,000.00 188.68 2,811.32 53,792.70 58 3,000.00 179.31 2,820.69 50,972.00 59 3,000.00 169.91 2,830.09 48,141.91 60 3,000.00 160.47 2,839.53 45,302.38 61 3,000.00 151.01 2,848.99 42,453.39 62 3,000.00 141.51 2,858.49 39,594.90 63 3,000.00 131.98 2,868.02 36,726.89 64 3,000.00 122.42 2,877.58 33,849.31 65 3,000.00 112.83 2,887.17 30,962.14 66 3,000.00 103.21 2,896.79 28,065.35 67 3,000.00 93.55 2,906.45 25,158.90 68 3,000.00 83.86 2,916.14 22,242.76 69 3,000.00 74.14 2,925.86 19,316.90 70 3,000.00 64.39 2,935.61 16,381.29 71 3,000.00 54.60 2,945.40 13,435.90 72 3,000.00 44.79 2,955.21 10,480.68 73 3,000.00 34.94 2,965.06 7,515.62 74 3,000.00 25.05 2,974.95 4,540.67 75 3,000.00 15.14 2,984.86 1,555.81 76 1,560.99 5.19 1,555.81 - Total 226,560.99 26,560.99 200,000.00 Answer b. Time to repay Loan = 76 Months Answer c. Final payment = $1,560.99 Answer d. Total Interest Paid = $26,560.99
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.