Loan Emi.xlsx

6% 18 50,000

($4,617.83)

Annual interest rate Years you plan on saving Amount you want to have save in 18 years

Original Principal Loan Term Annual Interest rate Payments per year payments

Month

353000 2 7.00% 12 16768 ($30,543.94)

Payment 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

16768 16768 16768 16768 16768 16768 16768 16768 16768 16768 16768 16768 16768 16768 16768 16768 16768 16768 16768 16768 16768 16768 16768 16768

Interest 2059.166667 1973.365139 1887.063102 1800.257637 1712.945807 1625.124657 1536.791218 1447.9425 1358.575498 1268.687188 1178.27453 1087.334465 995.8639157 903.8597885 811.3189706 718.2383313 624.6147216 530.4449741 435.7259031 340.4543042 244.6269543 148.2406116 51.29201514 -46.2221148

-15804.7204

Principal Balance 353000 14708.83 338291.1667 14794.63 323496.5318 14880.94 308615.5949 14967.74 293647.8525 15055.05 278592.7984 15142.88 263449.923 15231.21 248218.7142 15320.06 232898.6567 15409.42 217489.2322 15499.31 201989.9194 15589.73 186400.1939 15680.67 170719.5284 15772.14 154947.3923 15864.14 139083.2521 15956.68 123126.5711 16049.76 107076.8094 16143.39 90933.42413 16237.56 74695.86911 16332.27 58363.59501 16427.55 41936.04931 16523.37 25412.67627 16619.76 8792.916881 16716.71 -7923.7911 16814.22 -24738.0132

402420