Response Questions Part A To B A) Show Your Steps How You Do It: cells in the range A10:D25 should be formatted using a Gold, Accent 1 outside cell border. B) Show Your Steps How You Do It: the formula in cell G10 should contain the PMT function. 1 New Office Building 2 Loan Calculator Loan Payment Calculator 4 Date 9/15/2021 Rate 5 Property Charles Street Term in Months 6 Price $ 1,150,000 Monthly Payment 7 Down Payment 230,000 Total Interest 8 Loan Amount (920,000) Total Cost 4.45% 180 Scenarios Loan Amount Annual Interest Rate Monthly Interest Rate Loan Period in Years Loan Period in Months Start Date Monthly Payment Future Value Renovation 20 Years 8 Years $1,020,000 $ 968,938 $ (920,000) 4.45% 4.25% 4.45% 0.37% 0.35% 0.37% 20 180 240 96 1/3/20221/3/2022 1/3/2022 $ (6,000) $ (8,000) n/a n/a $2,232,986.33 Rate Varying Interest Rates and Terms Number of Months 120 180 240 - 5 3.95% 4.05% 4.15% 4.25% 4.35% 4.45% 4.55% 4.65% 4.75% 4.85% 4.95% 5.05% 5.15%