3. Create a one-input data table as follows to determine how variable interest rates in the range A12:A22 will affect the total cost of the new inn:

a. In cell B11, insert a formula that references cell D5 (the monthly payments).

b. In cell C11, insert a formula that references cell D6 (the total interest paid on the loan).

c. In cell D11, insert a formula that references cell D7 (the total cost of the mortgage).

d. Based on the range A11:D22, create a one-input data table using an absolute reference to cell D3 (the mortgage interest rate) as the Column input cell.

E F G L M N Adela Mountain Resort 2 Interest Paid Mortgage Loan Payment Calculator 3 Date 12-Sep-18 Rate 4 Item Nordic Inn Term (Years) 5 Price $ 876,000.00 Monthly Payment $ 6 Down Payment $ 197,200.00 Total Interest $ 7 Loan Amount $ 678,800.00 Total Cost $ 4.250% 15 5,106.47 240,363.85 1,116,363.85 Varying Interest Rate Schedule Monthly Payment Total Interest Rate Total Cost Amortization Schedule Year Beginning Balance Ending Balance Paid on Principal $ 678,800.00 $ 645,732.21 2 $ 645,732.21 $ 611,231.34 3 $ 611,231.34 $ 575,235.28 4 $ 575,235.28 $ 537,679.23 5 $ 537,679.23 $ 498,495.59 6 $ 498,495.59 $ 457,613.82 7 $ 457,613.82 $ 414,960.33 8 $ 414,960.33 $ 370,458.33 9 $ 370,458.33 $ 324,027.71 10 $ 324,027.71 $ 275,584.90 Il $ 275,584.90 $ 225,042.69 12 $ 225,042.69 $ 172,310.10 13 $ 172,310.10 $ 117,292.19 14 $ 117,292.19 $ 59,889.94 Pinehill Lodge All Locations ... TO 3.500% 3.650% 3.800% 3.950% 4.100% 4.250% Documentation Inn Mortgage Highland Hotel Adela Condos Edit