等额本金与等额本息按揭贷款还款方式比较(excel表格自动套用格式计算).xls

等额本金还款法 等额本息还款法 两种还款方式对比分析 图表15_单击 利息 本金 期限 月初本金 合计偿付 等额本息还款法 月份 本息和 利息和 本金 等额本金还款法 贷款额度 贷款额度 利率 月末偿还 35.00 .05 10000.00 450.00 20.00 350000.00 10000.00 508156.25 158156.25 350000.00 1.00 350000.00 2770.83 1312.50 12.00 1458.33 12.00 .00 12.00 .00 2.00 348541.67 .00 .00 2765.36 1307.03 1458.33 3.00 347083.33 2759.90 1301.56 1458.33 4.00 345625.00 2754.43 1296.09 1458.33 5.00 344166.67 2748.96 1290.63 1458.33 6.00 342708.33 2743.49 1285.16 1458.33 7.00 341250.00 2738.02 1279.69 1458.33 8.00 339791.67 2732.55 1274.22 1458.33 9.00 338333.33 2727.08 1268.75 1458.33 10.00 336875.00 2721.61 1263.28 1458.33 11.00 335416.67 2716.15 1257.81 1458.33 12.00 333958.33 2710.68 1252.34 1458.33 13.00 332500.00 2705.21 1246.88 1458.33 14.00 331041.67 2699.74 1241.41 1458.33 15.00 329583.33 2694.27 1235.94 1458.33 16.00 328125.00 2688.80 1230.47 1458.33 17.00 326666.67 2683.33 1225.00 1458.33 18.00 325208.33 2677.86 1219.53 1458.33 19.00 323750.00 2672.40 1214.06 1458.33 20.00 322291.67 2666.93 1208.59 1458.33 21.00 320833.33 2661.46 1203.13 1458.33 22.00 319375.00 2655.99 1197.66 1458.33 23.00 317916.67 2650.52 1192.19 1458.33 24.00 316458.33 2645.05 1186.72 1458.33 25.00 315000.00 2639.58 1181.25 1458.33 26.00 313541.67 2634.11 1175.78 1458.33 27.00 312083.33 2628.65 1170.31 1458.33 28.00 310625.00 2623.18 1164.84 1458.33 29.00 309166.67 2617.71 1159.38 1458.33 30.00 307708.33 2612.24 1153.91 1458.33 31.00 306250.00 2606.77 1148.44 1458.33 32.00 304791.67 2601.30 1142.97 1458.33 33.00 303333.33 2595.83 1137.50 1458.33 34.00 301875.00 2590.36 1132.03 1458.33 35.00 300416.67 2584.90 1126.56 1458.33 36.00 298958.33 2579.43 1121.09 1458.33 37.00 297500.00 2573.96 1115.63 1458.33 38.00 296041.67 2568.49 1110.16 1458.33 39.00 294583.33 2563.02 1104.69 1458.33 40.00 293125.00 2557.55 1099.22 1458.33 41.00 291666.67 2552.08 1093.75 1458.33 42.00 290208.33 2546.61 1088.28 1458.33 43.00 288750.00 2541.15 1082.81 1458.33 44.00 287291.67 2535.68 1077.34 1458.33 45.00 285833.33 2530.21 1071.88