a Create a two-variable data table as follows to provide the comparison that Bao requests: In cell A12, enter a formula without using a function that references the Monthly_Payment amount (cell D6) because Bao wants to compare the monthly payments. b. Based on the range A12:D25, create a two-variable data table that uses the term in months (cell D5) as the row input cell and the rate (cell D4) as the column input cell. D E F G H J $ 5 Years 1,720,000 4.55% 4.35% 180 $13,026.41 $ 624,753.96 $2,774,753.96 Scenarios Loan Amount Annual Interest Rate Monthly Interest Rate Loan Period in Years Loan Period in Months Start Date Monthly Payment Future Value 10 Years 1,720,000 4.45% 0.37% 10 120 1/3/2022 0.38% 15 Years $ 4.40% 0.37% 15 180 1/3/2022 $ (16,000) $ n/a 5 60 1/3/2022 (20,000) n/a 240 B 1 Business Expansion 2 Loan Calculator 3 Loan Payment Calculator 4 Date 10/12/2021 Rate 5 Purchase Distribution center Term in Months 6 Price $ 2,150,000 Monthly Payment 7 Down Payment $ 430,000 Total Interest 8 Loan Amount $ 1,720,000 Total Cost 9 10 Varying Interest Rates and Terms 11 Rate Number of Months 12 $ 13,026 120 180 13 3.85% 14 3.95% 15 4.05% 16 4.15% 17 4.25% 18 4.35% 19 4.45% 20 4.55% 21 4.65% 22 4.75% 23 4.85% 24 4.95% 25 5.05% 26 Candidate Properties Contact State Type Months on Mkt a Create a two-variable data table as follows to provide the comparison that Bao requests: In cell A12, enter a formula without using a function that references the Monthly_Payment amount (cell D6) because Bao wants to compare the monthly payments. b. Based on the range A12:D25, create a two-variable data table that uses the term in months (cell D5) as the row input cell and the rate (cell D4) as the column input cell. D E F G H J $ 5 Years 1,720,000 4.55% 4.35% 180 $13,026.41 $ 624,753.96 $2,774,753.96 Scenarios Loan Amount Annual Interest Rate Monthly Interest Rate Loan Period in Years Loan Period in Months Start Date Monthly Payment Future Value 10 Years 1,720,000 4.45% 0.37% 10 120 1/3/2022 0.38% 15 Years $ 4.40% 0.37% 15 180 1/3/2022 $ (16,000) $ n/a 5 60 1/3/2022 (20,000) n/a 240 B 1 Business Expansion 2 Loan Calculator 3 Loan Payment Calculator 4 Date 10/12/2021 Rate 5 Purchase Distribution center Term in Months 6 Price $ 2,150,000 Monthly Payment 7 Down Payment $ 430,000 Total Interest 8 Loan Amount $ 1,720,000 Total Cost 9 10 Varying Interest Rates and Terms 11 Rate Number of Months 12 $ 13,026 120 180 13 3.85% 14 3.95% 15 4.05% 16 4.15% 17 4.25% 18 4.35% 19 4.45% 20 4.55% 21 4.65% 22 4.75% 23 4.85% 24 4.95% 25 5.05% 26 Candidate Properties Contact State Type Months on Mkt
