等额本金与等额本息按揭贷款还款方式比较

  • 格式:xls
  • 大小:284.50 KB
  • 文档页数:28

期限:1-30年
期限 利息和 187,726.46 利息 3,102.92 3,077.06 3,051.20 3,025.34 2,999.49 2,973.63 2,947.77 2,921.91 2,896.06 2,870.20 2,844.34 2,818.48 2,792.63 2,766.77 2,740.91 2,715.05 2,689.19 2,663.34 2,637.48 2,611.62 2,585.76 2,559.91 2,534.05 2,508.19 2,482.33 2,456.48 2,430.62
按揭贷款
55 利率 贷款额度 550,000.00 月份 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 合计偿付 月初本金 550,000.00 546,781.96 543,545.76 540,291.30 537,018.48 533,727.20 530,417.35 527,088.83 523,741.53 520,375.34 516,990.16 513,585.89 510,162.41 506,719.61 503,257.40 499,775.65 496,274.25 492,753.11 489,212.09 485,651.10 482,070.03 478,468.74 474,847.14 471,205.11 467,542.53 463,859.29 460,155.27 6.77%第 1Fra bibliotek页,共 28 页
按揭贷款
55 利率 贷款额度 550,000.00 月份 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 合计偿付 月初本金 456,430.35 452,684.42 448,917.35 445,129.03 441,319.34 437,488.16 433,635.36 429,760.82 425,864.43 421,946.06 418,005.57 414,042.86 410,057.79 406,050.24 402,020.08 397,967.18 393,891.42 389,792.66 385,670.78 381,525.65 377,357.13 373,165.09 368,949.40 364,709.93 360,446.54 356,159.10 351,847.47 6.77%
第 2 页,共 28 页
按揭贷款
55 利率 贷款额度 550,000.00 月份 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 合计偿付 月初本金 347,511.51 343,151.10 338,766.08 334,356.32 329,921.69 325,462.04 320,977.23 316,467.11 311,931.55 307,370.41 302,783.53 298,170.77 293,531.99 288,867.04 284,175.77 279,458.03 274,713.68 269,942.56 265,144.53 260,319.42 255,467.10 250,587.40 245,680.17 240,745.25 235,782.50 230,791.74 225,772.83 6.77%
等额本息和等额本金还款对比分析
等额本息还款法 677.00 本息和 758,515.30 月末偿还 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 期限 利息和 208,515.30 利息 3,102.92 3,084.76 3,066.50 3,048.14 3,029.68 3,011.11 2,992.44 2,973.66 2,954.78 2,935.78 2,916.69 2,897.48 2,878.17 2,858.74 2,839.21 2,819.57 2,799.81 2,779.95 2,759.97 2,739.88 2,719.68 2,699.36 2,678.93 2,658.38 2,637.72 2,616.94 2,596.04 10 本金和 550,000.00 本金 3,218.04 3,236.20 3,254.46 3,272.82 3,291.28 3,309.85 3,328.52 3,347.30 3,366.19 3,385.18 3,404.27 3,423.48 3,442.79 3,462.22 3,481.75 3,501.39 3,521.15 3,541.01 3,560.99 3,581.08 3,601.28 3,621.60 3,642.03 3,662.58 3,683.24 3,704.02 3,724.92 55 利率 贷款额度 550,000.00 月份 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 合计偿付 月初本金 550,000.00 545,416.67 540,833.33 536,250.00 531,666.67 527,083.33 522,500.00 517,916.67 513,333.33 508,750.00 504,166.67 499,583.33 495,000.00 490,416.67 485,833.33 481,250.00 476,666.67 472,083.33 467,500.00 462,916.67 458,333.33 453,750.00 449,166.67 444,583.33 440,000.00 435,416.67 430,833.33 6.77% 本息和 737,726.46 月末偿还 7,686.25 7,660.39 7,634.53 7,608.68 7,582.82 7,556.96 7,531.10 7,505.25 7,479.39 7,453.53 7,427.67 7,401.82 7,375.96 7,350.10 7,324.24 7,298.39 7,272.53 7,246.67 7,220.81 7,194.95 7,169.10 7,143.24 7,117.38 7,091.52 7,065.67 7,039.81 7,013.95 等额本金还款法
期限:1-30年
期限 利息和 187,726.46 利息 2,404.76 2,378.90 2,353.05 2,327.19 2,301.33 2,275.47 2,249.61 2,223.76 2,197.90 2,172.04 2,146.18 2,120.33 2,094.47 2,068.61 2,042.75 2,016.90 1,991.04 1,965.18 1,939.32 1,913.47 1,887.61 1,861.75 1,835.89 1,810.03 1,784.18 1,758.32 1,732.46
等额本息和等额本金还款对比分析
等额本息还款法 677.00 本息和 758,515.30 月末偿还 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 6,320.96 期限 利息和 208,515.30 利息 2,575.03 2,553.89 2,532.64 2,511.27 2,489.78 2,468.16 2,446.43 2,424.57 2,402.59 2,380.48 2,358.25 2,335.89 2,313.41 2,290.80 2,268.06 2,245.20 2,222.20 2,199.08 2,175.83 2,152.44 2,128.92 2,105.27 2,081.49 2,057.57 2,033.52 2,009.33 1,985.01 10 本金和 550,000.00 本金 3,745.93 3,767.07 3,788.32 3,809.69 3,831.18 3,852.80 3,874.53 3,896.39 3,918.38 3,940.48 3,962.71 3,985.07 4,007.55 4,030.16 4,052.90 4,075.76 4,098.76 4,121.88 4,145.13 4,168.52 4,192.04 4,215.69 4,239.47 4,263.39 4,287.44 4,311.63 4,335.95 55 利率 贷款额度 550,000.00 月份 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 合计偿付 月初本金 426,250.00 421,666.67 417,083.33 412,500.00 407,916.67 403,333.33 398,750.00 394,166.67 389,583.33 385,000.00 380,416.67 375,833.33 371,250.00 366,666.67 362,083.33 357,500.00 352,916.67 348,333.33 343,750.00 339,166.67 334,583.33 330,000.00 325,416.67 320,833.33 316,250.00 311,666.67 307,083.33 6.77% 本息和 737,726.46 月末偿还 6,988.09 6,962.24 6,936.38 6,910.52 6,884.66 6,858.81 6,832.95 6,807.09 6,781.23 6,755.38 6,729.52 6,703.66 6,677.80 6,651.94 6,626.09 6,600.23 6,574.37 6,548.51 6,522.66 6,496.80 6,470.94 6,445.08 6,419.23 6,393.37 6,367.51 6,341.65 6,315.80 等额本金还款法