金融租赁融资成本测算

,,,,,,,,,,,,,,,,

向融资租赁公司融资成本测算(按租赁公司方案测算）期末支付单位：元,,,,,,,,,,,,,,期末支付的内部收益率（IRR),

,融入资金10000万元,,每期租金6093562元,,手续费750万元,,保证金1000万元,,,,,,,,

,支付日期,保证金,手续费用,每期付款合计,其中:本金,利息,租凭成本余额,日利率,计息天数,手续费分摊率,手续费分摊额,利息,,-82500000,-90000000

0,2015/6/1,"10,000,000","7,500,000","7,500,000",,,"100,000,000",0.000186111,,,,,,"6,093,562","6,093,562"

1,2015/8/31,"10,000,000","7,500,000","6,093,562","4,131,062","1,962,500","95,868,938",0.000186111,92,0.089729673,"672,972.55",,,"6,093,562","6,093,562"

2,2015/11/30,"10,000,000","7,500,000","6,093,562","4,212,135","1,881,428","91,656,803",0.000186111,92,0.086022884,"645,171.63",,,"6,093,562","6,093,562"

3,2016/2/29,"10,000,000","7,500,000","6,093,562","4,294,798","1,798,765","87,362,005",0.000186111,92,0.082243349,"616,825.12",,,"6,093,562","6,093,562"

4,2016/5/31,"10,000,000","7,500,000","6,093,562","4,379,083","1,714,479","82,982,922",0.000186111,89,0.078389641,"587,922.31",,,"6,093,562","6,093,562"

5,2016/8/31,"10,000,000","7,500,000","6,093,562","4,465,023","1,628,540","78,517,900",0.000186111,92,0.074460305,"558,452.28",,,"6,093,562","6,093,562"

6,2016/11/30,"10,000,000","7,500,000","6,093,562","4,552,649","1,540,914","73,965,251",0.000186111,92,0.070453854,"528,403.91",,,"6,093,562","6,093,562"

7,2017/2/28,"10,000,000","7,500,000","6,093,562","4,641,994","1,451,568","69,323,257",0.000186111,92,0.066368778,"497,765.83",,,"6,093,562","6,093,562"

8,2017/5/31,"10,000,000","7,500,000","6,093,562","4,733,094","1,360,469","64,590,163",0.000186111,89,0.062203531,"466,526.48",,,"6,093,562","6,093,562"

9,2017/8/31,"10,000,000","7,500,000","6,093,562","4,825,980","1,267,582","59,764,183",0.000186111,92,0.057956542,"434,674.06",,,"6,093,562","6,093,562"

10,2017/11/30,"10,000,000","7,500,000","6,093,562","4,920,690","1,172,872","54,843,492",0.000186111,92,0.053626205,"402,196.54",,,"6,093,562","6,093,562"

11,2018/2/28,"10,000,000","7,500,000","6,093,562","5,017,259","1,076,304","49,826,233",0.000186111,92,0.049210886,"369,081.65",,,"6,093,562","6,093,562"

12,2018/5/31,"10,000,000","7,500,000","6,093,562","5,115,723","977,840","44,710,511",0.000186111,89,0.044708916,"335,316.87",,,"6,093,562","6,093,562"

13,2018/8/31,"10,000,000","7,500,000","6,093,562","5,216,119","877,444","39,494,392",0.000186111,92,0.040118595,"300,889.46",,,"6,093,562","6,093,562"

14,2018/11/30,"10,000,000","7,500,000","6,093,562","5,318,485","775,077","34,175,907",0.000186111,92,0.035438189,"265,786.42",,,"6,093,562","6,093,562"

15,2019/2/28,"10,000,000","7,500,000","6,093,562","5,422,860","670,702","28,753,047",0.000186111,92,0.03066593,"229,994.47",,,"6,093,562","6,093,562"

16,2019/5/31,"10,000,000","7,500,000","6,093,562","5,529,284","564,279","23,223,763",0.000186111,89,0.025800015,"193,500.11",,,"6,093,562","6,093,562"

17,2019/8/31,"10,000,000","7,500,000","6,093,562","5,637,796","455,766","17,585,967",0.000186111,92,0.020838606,"156,289.55",,,"6,093,562","6,093,562"

18,2019/11/30,"10,000,000","7,500,000","6,093,562","5,748,438","345,125","11,837,529",0.000186111,92,0.01577983,"118,348.73",,,"6,093,562","6,093,562"

19,2020/2/29,"10,000,000","7,500,000","6,093,562","5,861,251","232,312","5,976,278",0.000186111,92,0.010621776,"79,663.32",,,"6,093,562","6,093,562"

20,2020/5/31,"10,000,000","7,500,000","6,093,562","5,976,278","117,284",-0,0.000186111,89,0.005362495,"40,218.71",,季,4.04%,3.08%

,,,,"129,371,249","100,000,000",21871248.84,"1,114,458,540",,1825,0.008972967,"7,500,000.00",-,年,16.17%,12.32%

,,综合成本1（%）,,11.713,（未考虑押金定期利息）,,综合成本2（%）,12.778,,（未考虑押金定期利息）,,,,考虑保证金、手续费后可用资金,只考虑保证金

,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

,,,,,,,,,,,