Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need help fixing this mistake 2. In cel B8, calculate the loan amount by entering a formula without using a function that subtracts the

i need help fixing this mistake
image text in transcribed
image text in transcribed
2. In cel B8, calculate the loan amount by entering a formula without using a function that subtracts the Down Payment from the price. X Create a formula In the Loan Calculator worksheet, the formula in cel B8 should subtract the Down_Payment from the Price. 12 13 000 Cell Styles FO Loan Amx fx =B6-B7 A B D E F G H 2 Loan Calculator 3 Loan Payment Calculator Scenarios Renovation 4 Date 20 Years 8 Years 9/15/21 Rate 4.45% Loan Amount 5 Property $ 1,020,000 5 920,000 Charles Street 968,938 $ Term in Months 180 Annual Interest Rate 4,45% 6 Price 4.25% 5 1,150,000 Monthly Payment 4.45% $7,014.45 7 Down Payment Monthly Interest Rate 0.37% 0.35% 0.37% 230.000. Ta Grading Error 8 Loan Amount $ 920.69 Te Step 2: In the Loan Calculator worksheet, the formula in cell 08 should subtract the Down Payment from the Prion 9 10 Varying Interest Rates 7 11 My Paymer Rate TIT TVVVT TUVUVI Number of Months Future Value n/a 12$ 7,014 120 n/a (5392,082.42) 180 240 3 13 3.95% $ 9,292.715 6,782.10 S 5,550.81 14 4.05X $ 9,336.435 6,828.20 S 5,599.29 15 4.15% $ 9,380.28 $ 6,874.49 5,648.00 16 4.25% 9,424.25$ 6,920.96 5,696.96 17 4.35% 9,468.35 6,967.625 5,746.15 18 4.45% 9,512.585 7,014.45$ 5,795.57 19 4.55% $ 9,556.925 7,061.47 $ 5,845.23 20 4.65% $ 9,601.40 $ 7,108.67$ 5,895.13 21 4.75% S 9,645.99 $ 7,156.05$ 5,945.26 22 4.85% $ 9,690.71S 7,203.62 5,995.62 4.95% $ 9,735.56S 7,251.36 $ 6,046.21 24 5.05% $ 9,780.53S 7,299.29 $ 6,097.03 25 5.15% $ 9,825.625 7,347.395 6,148.09 26 27 28

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Finance

Authors: Harvey Rosen, Ted Gayer

10th edition

9781259716874, 78021685, 1259716872, 978-0078021688

More Books

Students also viewed these Finance questions