Question

А в Camp Millowski Mortgage Loan Payment Calculator 15-Aug-18 Rate Campground Term (Years) IS 486,000.00 Monthly Payment $ $ 97,200.00 Total Interest $ $ 388,800.00 Total Cost $ 5.750% Year 15 Date Item Price 6 Down Payment 7 Loan Amount 3,228.63 192,354.20 678,354.20 Rate Varying Interest Rate Schedule Monthly Payment Total Interest $3,228.63 $ 192,354.20 3.500% $2,779.46 111,503.40 3.750% $2,827.44 120,139.35 4.000% $2,875.91 128,863.20 4.250% 2,924.86 137,674.52 4.500% 2,974.29 146,572.90 4.750% 3,024.21 155,557.89 5.000% 3,074.61 164,629.01 5.250% 3,125.48 173,785.78 5.500% 3,176.82 183,027.68 5.750% 3,228.63 192,354.20 6.000% 3,280.92 201,764.76 6.250% 3,333.66 211,258.82 6.500% 3,386.87 220,835.78 6.750% 3,440.53 230,495.04 7.000% 3,494.64 240,235.98 Total Cost $ 678,354.20 597,503.40 606,139.35 614,863.20 623,674.52 632,572.90 641,557.89 650,629.01 659,785.78 669,027.68 678,354.20 687,764.76 697,258.82 706,835.78 716,495.04 726,235.98 Amortization Schedule Beginning Balance Ending Balance Paid on Principal Interest Paid 1 $ 388,800.00 $ 371,973.53 2 $ 371,973.53 $ 354,153.63 3 $ 354,153.63 $ 335,281.65 4 $ 335,281.65 $ 315,295.47 5 $ 315,295.47 $ 294,129.30 294,129.30 $ 271,713.49 7 $ 271,713.49 $ 247,974.26 8 $ 247,974.26 $ 222,833.46 9 $ 222,833.46 $ 196,208.36 10 $ 196,208.36 $ 168,011.31 11 $ 168,011.31 $ 138,149.52 12 $ 138,149.52 $ 106,524.69 13 $ 106,524.69 $ 73,032.73 14 $ 73,032.73 $ 37,563.42 15 $ 37,563.42 $ Subtotal $ (1,863.00) $ . Down Payment Total Cost $ (1,863.00) $ 11 862

In cell J4, create a formula without using a function that subtracts the value in cell I4 from the value in cell H4 to determine how much of the mortgage principal is being paid off each year.

Answer 1

IF ANY QUERY, FEEL FREE TO ASK Solution As we know that principal paid for a year is Beginning Balance - Ending Balance. Hence, formula to be used in cell J4 is Formula =H4-14 The result of above formula shall be principal paid during year. After getting result, the cell must be copied in cell below such as J5, J6, J7 ..... To get principal paid for respective years.