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

Excel File Edit View Insert Format Tools Data Window Help X17% Fri 5:55 PM .. AutoSave ON SC_EX19_CS4-7a_Kaitlyn Johnson_2 - Saved a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments fx 1912 A o Y @ Define Name v Di A Calculate Now e Trace Precedents Trace Dependente Show Error Watch Remove Arrows Formulas Checking Window Text Insert Function AutoSum Recently Financial Logical Used Date & Lookup & Math & Time Reference Trig More Functions Fo Create from Selection Calculation Calculate Sheet Options 329 C D F G . J J K L M N Q R S T 15 Years 1 Business Expansion 2 Loan Calculator 3 Loan Payment Calculate 4 Date 10/12/21 Rate 5 Purchase Distribution center Term in Months 6 Price $ 2,150,000 Monthly Payment 7 Down Payment $ 430,000 Tatal Interest 8 Loan Amount $ 1,720,000 Total Cost 4.35% 180 Scenarias Loan Amount Annual Interest Rate Monthly Interest Rate Loan Period in Years Loan Period in Months Start Date Monthly Payment Future Value 10 Years NAME? 4.45% 0.37% 10 120 1/3/22 4.40% 0.37% 15 180 1/3/22 $ (16,000) $ n/a 5 Years NAME? 4.55% 0.38% 5 5 60 1/3/22 (20,000) Varying Interest Rates and Terms Number of Months 120 180 240 Candidate Properties Contact Stale Type Months un Mkt 10 11 Ratc 12 13 3.858 14 3.95% 154.034 16 1 1.15% 17 1.29% 18 4.35% 19 4.45% 20 4.55% 21 4.69% 22 4.75% 23 4.854 24 4.95% 25 5.09'5 26 27 28 29 30 31 32 33 35 36 37 38 39 40 Documentation U.S. Canada U.K. All Locations Original Content Subtotals Expansion Funding + Ready 9 100% 20 A W