1. To determine the effects of different interest rates on the total cost of the inn, fill the range A14:A22 with a percent series based on the values in the range A12:A13.

1. 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:
   1. In cell B11, insert a formula that references cell D5 (the monthly payments).
   2. In cell C11, insert a formula that references cell D6 (the total interest paid on the loan).
   3. In cell D11, insert a formula that references cell D7 (the total cost of the mortgage).
   4. 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.

A B D E F G H L M N Adela Mountain Resort | Year Interest Paid 2 Mortgage Loan Payment Calculator 3 Date 12-Sep-18 Rate 4.250% 4 Item Nordic Inn Term (Years) 15 5 Price $ 876,000.00 Monthly Payment $ 5, 106.47 6 Down Payment $ 197,200.00 Total Interest $ 240,363.85 7 Loan Amount $ 678,800.00 Total Cost $ 1,116,363.85 Amortization Schedule 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 8 5 $ 537,679.23 $ 498,495.59 9 $ 498,495.59 $ 457,613.82 Varying Interest Rate Schedule Monthly Payment Total Interest TO Rate Total Cost 7 $ $ 414,960.33 457,613.82 414,960.33 IL 8 $ $ 370,458.33 12 3.500% 9 $ 370,458.33 $ 324,027.71 13 3.650% 10 $ 324,027.71 $ 275,584.90 14 Il $ 275,584.90 $ 225,042.69 15 12 $ 225,042.69 $ 172,310.10 117,292.19 16 13 $ 172,310.10 $ 17 14 $ 117,292.19 $ 59,889.94 18 15 $ 59,889.94 $ 19 Subtotal $ $ 20 Down Payment 21 Total Cost $ 22 Documentation Inn Mortgage Highland Hotel Adela Condos Pinehill Lodge All Locations Cabin Rentals +