1. in cell K20, insert a formula that references the defined name Down_Payment to insert the down payment amount.
2. What am I doing wrong, why total cost goes weird?
3. I tried multiple ways; copy paste of word,formula, type =Down_payment

K21 X v Ft =J19+k19+K20 Adela Mountain Resort 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 Rate 3.500% Amortization Schedule Year Beginning Balance Ending Balance Paid on Principal Interest Paid $ 678,800.00 $ 645,732.21 $ 33,067.79 $ 28,209.80 2 $ 645,732.21 $ 611,231.34 $ 34,500.87 $ 26,776.72 3 $ 611,231.34 $ 575,235.28 $ 35,996.06 $ 25,281.53 4 $ 575,235.28 $ 537,679.23 $ 37,556.05 $ 23,721.54 5 $ 537,679.23 $ 498,495.59 $ 39,183.64 $ 22,093.95 6 $ 498,495.59 $ 457,613.82 $ 40,881.77 $ 20,395.82 7 $ 457,613.82 $ 414,960.33 $ 42,653.49 $ 18,624.10 8 $ 414,960.33 $ 370,458.33 $ 44,502.00 $ 16,775.59 9 $ 370,458.33 $ 324,027.71 $ 46,430.61 $ 14,846.98 10 $ 324,027.71 $ 275,584.90 $ 48,442.81 $ 12.834.78 |$ 275,584.90 $ 225,042.69 $ 50,542.21 $ 10,735.38 12 $ 225,042.69 $ 172,310.10 $ 52,732.59 $ 8,545.00 13 $ 172,310.10 $ 117,292.19 $ 55,017.90 $ 6,259.69 14 $ 117,292.19 $ 59,889.94 $ 57,402.26 $ 3,875.33 15 $ 59,889.94 $ - $ 59,889.94 $ 1,387.65 Subtotal $ 678,800.00 $ 240,363.85 Down Payment $ 197,200.00 Total Cost 3.650% 3.800% 3.950% 4.100% 4.250% 4.400% 4.550% 4.700% 4.850% 5.000% Varying Interest Rate Schedule Monthly Payment Total Interest $ 5,106.47 $ 240,363.85 4,852.62 194,672.08 4,902.78 203,700.06 4,953.24 212,783.38 5,004.01 221,921.89 5,055.09 231,115.43 5,106.47 240,363.85 5,158.15 249,666.99 5,210.14 259,024.68 5,262.43 268,436.74 5,315.02 277,903.01 5,367.91 287,423.28 Total Cost $ 1,116,363.85 1,070,672.08 1,079,700.06 1,088,783.38 1,097,92 1.89 1,107,1 15.43 1,116,363.85 1,125,666.99 1,135,024.68 1,144,436.74 1,153,903.01 1,163,423.28