Go to the Loan Calculator The cells in the range B6:B8 have defined names, but one is incomplete and could be confusing. Cell A2 also has a defined name, which is unnecessary for a cell that will not...

1. Go to the
   Loan Calculator
   The cells in the range B6:B8 have defined names, but one is incomplete and could be confusing. Cell A2 also has a defined name, which is unnecessary for a cell that will not be used in a formula.
   
   
   Update the defined names in the worksheet as follows:

a)Delete the Loan_Calculator defined name.

b)For cell B8, edit the defined name to use
Loan_Amount
as the name.

2. In cell B8, calculate the loan amount by entering a formula without using a function that subtracts the
Down_Payment
from the
Price.

3.Liam also wants to use defined names in other calculations to help him interpret the formulas.


a) In the range D4:D8, create defined names based on the values in the range C4:C8.

Extracted text: SC EX19_4a_AisetouMagassouba_1-2 AutoSave OFF Home Insert Draw Page Layout Formulas Data Review View Tell me Share O Comments 2010 fx Define Name ♥ praw Σ Trace Precedents ? A CE Use in Formula v Trace Dependents Calculation Options AutoSum Recently Financial Logical Date & Time Lookup & Math & Reference More Functions Insert Тext Name Show Error Watch na Function Trig Manager Create from Selection Remove Arrows v Formulas Checking Window Used J12 fx "1941 P A В C D E F J K L M 1 New Office Building 2 Loan Calculator 3 Loan Payment Calculator Scenarios Renovation 20 Years 8 Years 4 Date 5 Property 6 Price 7 Down Payment $ 1,020,000 4.45% 9/15/21 Rate 4.45% Loan Amount $4 Charles Street Term in Months 180 Annual Interest Rate 4.25% 4.45% 2$ $ 1,150,000 Monthly Payment 230,000 Total Interest Month ly Interest Rate 0.37% 0.35% 0.37% Loan Period in Years 15 20 8 8 Loan Amount Total Cost Loan Period in Months 180 240 96 2 PM Start Date 1/3/22 1/3/22 1/3/22 Varying Interest Rates and Terms Number of Months 10 Monthly Payment 2$ (6,000) $ (8,000) 11 Rate Future Value n/a n/a 120 180 240 13 3.95% 14 4.05% 15 4.15% 16 4.25% 1 PM 17 4.35% 18 4.45% 19 4.55% 20 4.65% 21 4.75% 22 4.85% 23 4.95% t 24 5.05% 5 PM 25 5.15% 26 27 28 29 30 31 ot 32 M CIB 33 Documentation Loan Calculator Properties Equipment Loan Ready + 100% Special_Programs_ Transfer...est copy 160 words English (United States) Focus 180% 2022-02...3 PM CB 2022-02...2.39 PM 2022-02...7.00 PM 囲 115 1