融资租赁租金计算表V

报价计算表 融资租赁报价计算表 设备总价 首付款比例 首付款 融资金额 融资期限（月） 起租时间（年月日） 65,000,000.00 0% 0.0 65,000,000.00 96 8/1/16 利率浮动方式 浮动比例 利率 保证金（按融资金额比例） 手续费支付方式 手续费（按设备总价比例） 固定利率 10.00% 0.00% 随租金支付 0% 租金期数 宽限期（月数，录入0则为无宽限期） 租金支付周期 租赁余值 租金支付方式 每期租金额PMT(rate,nper,pv,fv,type) 96 0 月 0 0 986,320.67 使用说明： 1.请输入黄色阴影部分的数值，灰色部分为公式自动生成，请不要改变。 2.蓝色部分，请根据下拉菜单选择选项。 3.手续费为设备售价乘以手续费比率，保证金为融资额乘以保证金比率。 所得税 /0.75 增值税 /.8574作者:当利率为固定利率时此处为空作者:（宽限期是指只还息不还本金的期间）作者:0表示期末支付1表示期初支付还款计划表 XXXX融资租赁还款计划表 设备总价 65,000,000.00 起租日 2016/08/01 首付款比例 0.00% 手续费 0.0 首付款 0.0 保证金 0.0 融资本金 65,000,000.00 年利率 10.00% 融资期数 96 租金支付周期 月 每期租金 986,320.67 金额：元 总计还款金额 总计还款本金 总计还款利息 最终本金余额 总计还款本金 总计还款利息 最终本金余额 合计 94,686,783.97 65,000,000.00 29,686,783.97 0.0 35,164,297.06 25,001,263.58 29,835,702.94 还款日期 期数 还款金额 本金余额 还款本息 本金余额 30 本金部分 利息部分 本金部分 利息部分 2016/09/30 1 $986,320.67 444,654.00 541,666.67 64,555,346.00 444,654.00 541,666.67 64,555,346.00 2016/10/30 2 $986,320.67 448,359.45 537,961.22 64,106,986.55 448,359.45 537,961.22 64,106,986.55 2016/11/30 3 $986,320.67 452,095.78 534,224.89 63,654,890.77 452,095.78 534,224.89 63,654,890.77 2016/12/30 4 $986,320.67 455,863.24 530,457.42 63,199,027.53 455,863.24 530,457.42 63,199,027.53 2017/01/30 5 $986,320.67 459,662.10 526,658.56 62,739,365.43 459,662.10 526,658.56 62,739,365.43 2017/03/02 6 $986,320.67 463,492.62 522,828.05 62,275,872.80 463,492.62 522,828.05 62,275,872.80 2017/04/02 7 $986,320.67 467,355.06 518,965.61 61,808,517.74 467,355.06 518,965.61 61,808,517.74 2017/05/02 8 $986,320.67 471,249.69 515,070.98 61,337,268.06 471,249.69 515,070.98 61,337,268.06 2017/06/02 9 $986,320.67 475,176.77 511,143.90 60,862,091.29 475,176.77 511,143.90 60,862,091.29 2017/07/02 10 $986,320.67 479,136.57 507,184.09 60,382,954.72 479,136.57 507,184.09 60,382,954.72 2017/08/02 11 $986,320.67 483,129.38 503,191.29 59,899,825.34 483,129.38 503,191.29 59,899,825.34 2017/09/02 12 $986,320.67 487,155.46 499,165.21 59,412,669.89 487,155.46 499,165.21 59,412,669.89 2017/10/02 13 $986,320.67 491,215.08 495,105.58 58,921,454.81 491,215.08 495,105.58 58,921,454.81 2017/11/02 14 $986,320.67 495,308.54 491,012.12 58,426,146.26 495,308.54 491,012.12 58,426,146.26 2017/12/02 15 $986,320.67 499,436.11 486,884.55 57,926,710.15 499,436.11 486,884.55 57,926,710.15 2018/01/02 16 $986,320.67 503,598.08 482,722.58 57,423,112.07 503,598.08 482,722.58 57,423,112.07 2018/02/02 17 $986,320.67 507,794.73 478,525.93 56,915,317.33 507,794.73 478,525.93 56,915,317.33 2018/03/02 18 $986,320.67 512,026.36 474,294.31 56,403,290.98 512,026.36 474,294.31 56,403,290.98 2018/04/02 19 $986,320.67 516,293.24 470,027.42 55,886,997.74 516,293.24 470,027.42 55,886,997.74 2018/05/02 20 $986,320.67 520,595.69 465,724.98 55,366,402.05 520,595.69 465,724.98 55,366,402.05 2018/06/02 21 $986,320.67 524,933.98 461,386.68 54,841,468.07 524,933.98 461,386.68 54,841,468.07 2018/07/02 22 $986,320.67 529,308.43 457,012.23 54,312,159.64 529,308.43 457,012.23 54,312,159.64 2018/08/02 23 $986,320.67 533,719.34 452,601.33 53,778,440.30 533,719.34 452,601.33 53,778,440.30 2018/09/02 24 $986,320.67 538,167.00 448,153.67 53,240,273.30 538,167.00 448,153.67 53,240,273.30 2018/10/02 25 $986,320.67 542,651.72 443,668.94 52,697,621.58 542,651.72 443,668.94 52,697,621.58 2018/11/02 26 $986,320.67 547,173.82 439,146.85 52,150,447.76 547,173.82 439,146.85 52,150,447.76 2018/12/02 27 $986,320.67 551,733.60 434,587.06 51,598,714.16 551,733.60 434,587.06 51,598,714.16 2019/01/02 28 $986,320.67 556,331.38 429,989.28 51,042,382.78 556,331.38 429,989.28 51,042,382.78 2019/02/02 29 $986,320.67 560,967.48 425,353.19 50,481,415.30 560,967.48 425,353.19 50,481,415.30 2019/03/02 30 $986,320.67 565,642.21 420,678.46 49,915,773.10 565,642.21 420,678.46 49,915,773.10 2019/04/02 31 $986,320.67 570,355.89 415,964.78 49,345,417.21 570,355.89 415,964.78 49,345,417.21 2019/05/02 32 $986,320.67 575,108.86 411,211.81 48,770,308.35 575,108.86 411,211.81 48,770,308.35 2019/06/02 33 $986,320.67 579,901.43 406,419.24 48,190,406.92 579,901.43 406,419.24 48,190,406.92 2019/07/02 34 $986,320.67 584,733.94 401,586.72 47,605,672.98 584,733.94 401,586.72 47,605,672.98 2019/08/02 35 $986,320.67 589,606.72 396,713.94 47,016,066.25 589,606.72 396,713.94 47,016,066.25 2019/09/02 36 $986,320.67 594,520.11 391,800.55 46,421,546.14 594,520.11 391,800.55 46,421,546.14 2019/10/02 37 $986,320.67 599,474.45 386,846.22 45,822,071.69 599,474.45 386,846.22 45,822,071.69 2019/11/02 38 $986,320.67 604,470.07 381,850.60 45,217,601.62 604,470.07 381,850.60 45,217,601.62 2019/12/02 39 $986,320.67 609,507.32 376,813.35 44,608,094.30 609,507.32 376,813.35 44,608,094.30 2020/01/02 40 $986,320.67 614,586.55 371,734.12 43,993,507.75 614,586.55 371,734.12 43,993,507.75 2020/02/02 41 $986,320.67 619,708.10 366,612.56 43,373,799.65 619,708.10 366,612.56 43,373,799.65 2020/03/02 42 $986,320.67 624,872.34 361,448.33 42,748,927.32 624,872.34 361,448.33 42,748,927.32 2020/04/02 43 $986,320.67 630,079.61 356,241.06 42,118,847.71 630,079.61 356,241.06 42,118,847.71 2020/05/02 44 $986,320.67 635,330.27 350,990.40 41,483,517.44 635,330.27 350,990.40 41,483,517.44 2020/06/02 45 $986,320.67 640,624.69 345,695.98 40,842,892.75 640,624.69 345,695.98 40,842,892.75 2020/07/02 46 $986,320.67 645,963.23 340,357.44 40,196,929.53 645,963.23 340,357.44 40,196,929.53 2020/08/02 47 $986,320.67 651,346.25 334,974.41 39,545,583.27 651,346.25 334,974.41 39,545,583.27 2020/09/02 48 $986,320.67 656,774.14 329,546.53 38,888,809.13 656,774.14 329,546.53 38,888,809.13 2020/10/02 49 $986,320.67 662,247.26 324,073.41 38,226,561.88 662,247.26 324,073.41 38,226,561.88 2020/11/02 50 $986,320.67 667,765.98 318,554.68 37,558,795.89 667,765.98 318,554.68 37,558,795.89 2020/12/02 51 $986,320.67 673,330.70 312,989.97 36,885,465.19 673,330.70 312,989.97 36,885,465.19 2021/01/02 52 $986,320.67 678,941.79 307,378.88 36,206,523.40 678,941.79 307,378.88 36,206,523.40 2021/02/02 53 $986,320.67 684,599.64 301,721.03 35,521,923.77 684,599.64 301,721.03 35,521,923.77 2021/03/02 54 $986,320.67 690,304.63 296,016.03 34,831,619.13 690,304.63 296,016.03 34,831,619.13 2021/04/02 55 $986,320.67 696,057.17 290,263.49 34,135,561.96 696,057.17 290,263.49 34,135,561.96 2021/05/02 56 $986,320.67 701,857.65 284,463.02 33,433,704.31 701,857.65 284,463.02 33,433,704.31 2021/06/02 57 $986,320.67 707,706.46 278,614.20 32,725,997.84 707,706.46 278,614.20 32,725,997.84 2021/07/02 58 $986,320.67 713,604.02 272,716.65 32,012,393.83 713,604.02 272,716.65 32,012,393.83 2021/08/02 59 $986,320.67 719,550.72 266,769.95 31,292,843.11 719,550.72 266,769.95 31,292,843.11 2021/09/02 60 $986,320.67 725,546.97 260,773.69 30,567,296.13 725,546.97 260,773.69 30,567,296.13 2021/10/02 61 $986,320.67 731,593.20 254,727.47 29,835,702.94 731,593.20 254,727.47 29,835,702.94 2021/11/02 62 $986,320.67 737,689.81 248,630.86 29,098,013.13 737,689.81 248,630.86 29,098,013.13 2021/12/02 63 $986,320.67 743,837.22 242,483.44 28,354,175.90 743,837.22 242,483.44 28,354,175.90 2022/01/02 64 $986,320.67 750,035.87 236,284.80 27,604,140.04 750,035.87 236,284.80 27,604,140.04 2022/02/02 65 $986,320.67 756,286.17 230,034.50 26,847,853.87 756,286.17 230,034.50 26,847,853.87 2022/03/02 66 $986,320.67 762,588.55 223,732.12 26,085,265.32 762,588.55 223,732.12 26,085,265.32 2022/04/02 67 $986,320.67 768,943.46 217,377.21 25,316,321.86 768,943.46 217,377.21 25,316,321.86 2022/05/02 68 $986,320.67 775,351.32 210,969.35 24,540,970.55 775,351.32 210,969.35 24,540,970.55 2022/06/02 69 $986,320.67 781,812.58 204,508.09 23,759,157.97 781,812.58 204,508.09 23,759,157.97 2022/07/02 70 $986,320.67 788,327.68 197,992.98 22,970,830.28 788,327.68 197,992.98 22,970,830.28 2022/08/02 71 $986,320.67 794,897.08 191,423.59 22,175,933.20 794,897.08 191,423.59 22,175,933.20 2022/09/02 72 $986,320.67 801,521.22 184,799.44 21,374,411.98 801,521.22 184,799.44 21,374,411.98 2022/10/02 73 $986,320.67 808,200.57 178,120.10 20,566,211.41 808,200.57 178,120.10 20,566,211.41 2022/11/02 74 $986,320.67 814,935.57 171,385.10 19,751,275.84 814,935.57 171,385.10 19,751,275.84 2022/12/02 75 $986,320.67 821,726.70 164,593.97 18,929,549.14 821,726.70 164,593.97 18,929,549.14 2023/01/02 76 $986,320.67 828,574.42 157,746.24 18,100,974.72 828,574.42 157,746.24 18,100,974.72 2023/02/02 77 $986,320.67 835,479.21 150,841.46 17,265,495.51 835,479.21 150,841.46 17,265,495.51 2023/03/02 78 $986,320.67 842,441.54 143,879.13 16,423,053.97 842,441.54 143,879.13 16,423,053.97 2023/04/02 79 $986,320.67 849,461.88 136,858.78 15,573,592.09 849,461.88 136,858.78 15,573,592.09 2023/05/02 80 $986,320.67 856,540.73 129,779.93 14,717,051.36 856,540.73 129,779.93 14,717,051.36 2023/06/02 81 $986,320.67 863,678.57 122,642.09 13,853,372.78 863,678.57 122,642.09 13,853,372.78 2023/07/02 82 $986,320.67 870,875.89 115,444.77 12,982,496.89 870,875.89 115,444.77 12,982,496.89 2023/08/02 83 $986,320.67 878,133.19 108,187.47 12,104,363.70 878,133.19 108,187.47 12,104,363.70 2023/09/02 84 $986,320.67 885,450.97 100,869.70 11,218,912.73 885,450.97 100,869.70 11,218,912.73 2023/10/02 85 $986,320.67 892,829.73 93,490.94 10,326,083.00 892,829.73 93,490.94 10,326,083.00 2023/11/02 86 $986,320.67 900,269.97 86,050.69 9,425,813.03 900,269.97 86,050.69 9,425,813.03 2023/12/02 87 $986,320.67 907,772.22 78,548.44 8,518,040.80 907,772.22 78,548.44 8,518,040.80 2024/01/02 88 $986,320.67 915,336.99 70,983.67 7,602,703.81 915,336.99 70,983.67 7,602,703.81 2024/02/02 89 $986,320.67 922,964.80 63,355.87 6,679,739.01 922,964.80 63,355.87 6,679,739.01 2024/03/02 90 $986,320.67 930,656.17 55,664.49 5,749,082.83 930,656.17 55,664.49 5,749,082.83 2024/04/02 91 $986,320.67 938,411.64 47,909.02 4,810,671.19 938,411.64 47,909.02 4,810,671.19 2024/05/02 92 $986,320.67 946,231.74 40,088.93 3,864,439.45 946,231.74 40,088.93 3,864,439.45 2024/06/02 93 $986,320.67 954,117.00 32,203.66 2,910,322.45 954,117.00 32,203.66 2,910,322.45 2024/07/02 94 $986,320.67 962,067.98 24,252.69 1,948,254.47 962,067.98 24,252.69 1,948,254.47 2024/08/02 95 $986,320.67 970,085.21 16,235.45 978,169.26 970,085.21 16,235.45 978,169.26 2024/09/01 96 $986,320.67 978,169.26 8,151.41 0.0 978,169.26 8,151.41 0.00IRR 贷款净额 IRR 65,000,000.00 3.167% 手续费及租金现值 65,000,000.00参数范围 融资期限（月） 利率浮动方式 手续费支付方式 租金支付周期 租金支付方式（1表示前付，0表示后付） PBOC贷款基准利率 租金支付周期 年期数 月份数 天数 24 固定利率 起租时一次性支付 月 0 固定利率 10.00% 月 12 1 30 36 按年浮动 每年初支付 双月 1 6至12个月（含12个月） 6至12个月 6.00% 双月 6 2 60 48 按季浮动 随租金支付 季度 6个月以内（含6个月） 6个月以内 5.60% 季度 4 3 90 60 半年 12个月-36个月（含36个月） 12个月-36个月 6.15% 半年 2 6 180 72 一年 36个月-60个月（含60个月） 36个月-60个月 6.40% 一年 1 12 360 96 一年 60个月以上 60个月以上 6.55% 利率项目 年利率(%) 六个月以内（含6个月）贷款 5.6 六个月至一年（含1年）贷款 6 一至三年（含3年）贷款 6.15 三至五年（含5年）贷款 6.4 五年以上贷款 6.55PBOC贷款基准利率 中国人民银行人民币存贷款基准利率历次调整一览表（1年期） 调整日期 存款基准利率 贷款基准利率 调整前 调整后 幅度 调整前 调整后 幅度 reserved-41095x1f 3.25% 3.00% -0.25% 6.31% 6.00% -0.31% reserved-41068x1f 3.50% 3.25% -0.25% 6.56% 6.31% -0.25% reserved-40731x1f 3.25% 3.50% 0.25% 6.31% 6.56% 0.25% reserved-40639x1f 3.00% 3.25% 0.25% 6.06% 6.31% 0.25% reserved-40583x1f 2.75% 3.00% 0.25% 5.81% 6.06% 0.25% reserved-40538x1f 2.50% 2.75% 0.25% 5.56% 5.81% 0.25% reserved-40471x1f 2.25% 2.50% 0.25% 5.31% 5.56% 0.25% reserved-39805x1f 2.52% 2.25% -0.27% 5.58% 5.31% -0.27% reserved-39779x1f 3.60% 2.52% -1.08% 6.66% 5.58% -1.08% reserved-39751x1f 3.87% 3.60% -0.27% 6.93% 6.66% -0.27% reserved-39730x1f 4.14% 3.87% -0.27% 7.20% 6.93% -0.27% reserved-39707x1f 4.14% 4.14% 0.00% 7.47% 7.20% -0.27% reserved-39437x1f 3.87% 4.14% 0.27% 7.29% 7.47% 0.18% reserved-39340x1f 3.60% 3.87% 0.27% 7.02% 7.29% 0.27% reserved-39316x1f 3.33% 3.60% 0.27% 6.84% 7.02% 0.18% reserved-39284x1f 3.06% 3.33% 0.27% 6.57% 6.84% 0.27% reserved-39221x1f 2.79% 3.06% 0.27% 6.39% 6.57% 0.18% reserved-39159x1f 2.52% 2.79% 0.27% 6.12% 6.39% 0.27% reserved-38948x1f 2.25% 2.52% 0.27% 5.85% 6.12% 0.27% reserved-38835x1f 2.25% 2.25% 0.00% 5.58% 5.85% 0.27% reserved-38289x1f 1.98% 2.25% 0.27% 5.31% 5.58% 0.27% reserved-37308x1f 2.25% 1.98% -0.27% 5.85% 5.31% -0.54%Sheet1