融资租赁 IRR 项目收益测算表

融资租赁业务收益测算表 单位：元（人民币）（版本号：2014-12-11）项目名称租赁方式直租合同编号项 目 参 数租赁融资额85,000,000.00租赁物价格85,000,000.00购货相关费用支付0.00购货相关税收支付0.00租赁利率6.5000%租赁期限（年）9年付租次数12租金支付方式后付期末残值0.00残值计入本金否贴现率10.0000%保证金存款利率0.0000%保证金率5.0000%保证金4,250,000.00手续费率3.0000%手续费2,550,000.00 2,550,000.00 5,100,000.00供应商折扣率0.0000%供应商折扣额0.00管理费率0.0000%管理费0.00收 益 测 算每期租金1,041,633.78租金总额124,821,448.24收回本金84,999,999.52收回利息33,021,448.72净融资额现值78,200,000.00净现值NPV(6,778,855.07)现值收益率-8.6686%年化现值收益率8.0000%项目IRR（年付分次不计复利）7.6038%项目IRR（年付分次计算复利）现 金 流 量日期租赁相关流入利息收回本金尚未收回本金其他现金流入其他现金流出现金流入现金流出净现金流起租日6,800,000.000.0085,000,000.000.0085,000,000.006,800,000.0085,000,000.00-78,200,000.002016年5月1日1460,416.67460,416.670.0085,000,000.000.000.00460,416.670.00460,416.672016年6月1日2460,416.67460,416.670.0085,000,000.000.000.00460,416.670.00460,416.672016年7月1日3460,416.67460,416.670.0085,000,000.000.000.00460,416.670.00460,416.672016年8月1日4460,416.67460,416.670.0085,000,000.000.000.00460,416.670.00460,416.672016年9月1日5460,416.67460,416.670.0085,000,000.000.000.00460,416.670.00460,416.67############6460,416.67460,416.670.0085,000,000.000.000.00460,416.670.00460,416.67############7460,416.67460,416.670.0085,000,000.000.000.00460,416.670.00460,416.67############8460,416.67460,416.670.0085,000,000.000.000.00460,416.670.00460,416.672017年1月1日9460,416.67460,416.670.0085,000,000.000.000.00460,416.670.00460,416.672017年2月1日10460,416.67460,416.670.0085,000,000.000.000.00460,416.670.00460,416.672017年3月1日11460,416.67460,416.670.0085,000,000.000.000.00460,416.670.00460,416.672017年4月1日12460,416.67460,416.6785,000,000.002,550,000.000.003,010,416.670.003,010,416.672017年5月1日第1期1,041,633.78460,416.67581,217.1184,418,782.890.000.001,041,633.780.001,041,633.782017年6月1日第2期1,041,633.78457,268.41584,365.3783,834,417.510.000.001,041,633.780.001,041,633.782017年7月1日第3期1,041,633.78454,103.09587,530.6983,246,886.830.000.001,041,633.780.001,041,633.782017年8月1日第4期1,041,633.78450,920.64590,713.1482,656,173.690.000.001,041,633.780.001,041,633.782017年9月1日第5期1,041,633.78447,720.94593,912.8482,062,260.850.000.001,041,633.780.001,041,633.78############第6期1,041,633.78444,503.91597,129.8781,465,130.980.000.001,041,633.780.001,041,633.78############第7期1,041,633.78441,269.46600,364.3280,864,766.660.000.001,041,633.780.001,041,633.78############第8期1,041,633.78438,017.49603,616.2980,261,150.370.000.001,041,633.780.001,041,633.782018年1月1日第9期1,041,633.78434,747.90606,885.8879,654,264.480.000.001,041,633.780.001,041,633.782018年2月1日第10期1,041,633.78431,460.60610,173.1879,044,091.300.000.001,041,633.780.001,041,633.78第1页/共5页

12750000

gues#NUM!手续费扣税租金扣税

144,339.620.0066898.150.0066898.150.0066898.150.0066898.150.0066898.150.0066898.150.0066898.150.0066898.150.0066898.150.0066898.150.0066898.15144,339.6266898.150.0066898.150.0066440.710.0065980.790.0065518.380.0065053.470.0064586.040.0064116.080.0063643.570.0063168.500.0062690.86

扣税后

6.1864%-78,344,339.62

78,344,339.62393,518.52-393,518.52393,518.52-393,518.52393,518.52-393,518.52393,518.52-393,518.52393,518.52-393,518.52393,518.52-393,518.52393,518.52-393,518.52393,518.52-393,518.52393,518.52-393,518.52393,518.52-393,518.52393,518.52-393,518.522,799,178.90-2,799,178.90974,735.63-974,735.63975,193.07-975,193.07975,652.99-975,652.99976,115.40-976,115.40976,580.31-976,580.31977,047.74-977,047.74977,517.70-977,517.70977,990.21-977,990.21978,465.28-978,465.28978,942.92

-978,942.92

融资租赁业务收益测算表（版本号：2014-12-11） 单位：元（人民币）项目名称租赁方式直租合同编号2018年3月1日第11期1,041,633.78428,155.49613,478.2978,430,613.020.000.001,041,633.780.001,041,633.782018年4月1日第12期1,041,633.78424,832.49616,801.2977,813,811.722,550,000.000.003,591,633.780.003,591,633.782018年5月1日第13期1,041,633.78421,491.48620,142.3077,193,669.420.000.001,041,633.780.001,041,633.782018年6月1日第14期1,041,633.78418,132.38623,501.4076,570,168.020.000.001,041,633.780.001,041,633.782018年7月1日第15期1,041,633.78414,755.08626,878.7075,943,289.320.000.001,041,633.780.001,041,633.782018年8月1日第16期1,041,633.78411,359.48630,274.3075,313,015.020.000.001,041,633.780.001,041,633.782018年9月1日第17期1,041,633.78407,945.50633,688.2874,679,326.740.000.001,041,633.780.001,041,633.78############第18期1,041,633.78404,513.02637,120.7674,042,205.980.000.001,041,633.780.001,041,633.78############第19期1,041,633.78401,061.95640,571.8373,401,634.150.000.001,041,633.780.001,041,633.78############第20期1,041,633.78397,592.18644,041.6072,757,592.550.000.001,041,633.780.001,041,633.782019年1月1日第21期1,041,633.78394,103.63647,530.1572,110,062.400.000.001,041,633.780.001,041,633.782019年2月1日第22期1,041,633.78390,596.17651,037.6171,459,024.790.000.001,041,633.780.001,041,633.782019年3月1日第23期1,041,633.78387,069.72654,564.0670,804,460.730.000.001,041,633.780.001,041,633.782019年4月1日第24期1,041,633.78383,524.16658,109.6270,146,351.112,550,000.000.003,591,633.780.003,591,633.782019年5月1日第25期1,041,633.78379,959.40661,674.3869,484,676.730.000.001,041,633.780.001,041,633.782019年6月1日第26期1,041,633.78376,375.33665,258.4568,819,418.280.000.001,041,633.780.001,041,633.782019年7月1日第27期1,041,633.78372,771.85668,861.9368,150,556.350.000.001,041,633.780.001,041,633.782019年8月1日第28期1,041,633.78369,148.85672,484.9367,478,071.420.000.001,041,633.780.001,041,633.782019年9月1日第29期1,041,633.78365,506.22676,127.5666,801,943.860.000.001,041,633.780.001,041,633.78############第30期1,041,633.78361,843.86679,789.9266,122,153.940.000.001,041,633.780.001,041,633.78############第31期1,041,633.78358,161.67683,472.1165,438,681.830.000.001,041,633.780.001,041,633.78############第32期1,041,633.78354,459.53687,174.2564,751,507.580.000.001,041,633.780.001,041,633.782020年1月1日第33期1,041,633.78350,737.33690,896.4564,060,611.130.000.001,041,633.780.001,041,633.782020年2月1日第34期1,041,633.78346,994.98694,638.8063,365,972.330.000.001,041,633.780.001,041,633.782020年3月1日第35期1,041,633.78343,232.35698,401.4362,667,570.900.000.001,041,633.780.001,041,633.782020年4月1日第36期1,041,633.78339,449.34702,184.4461,965,386.462,550,000.000.003,591,633.780.003,591,633.782020年5月1日第37期1,041,633.78335,645.84705,987.9461,259,398.520.000.001,041,633.780.001,041,633.782020年6月1日第38期1,041,633.78331,821.74709,812.0460,549,586.480.000.001,041,633.780.001,041,633.782020年7月1日第39期1,041,633.78327,976.93713,656.8559,835,929.630.000.001,041,633.780.001,041,633.782020年8月1日第40期1,041,633.78324,111.29717,522.4959,118,407.140.000.001,041,633.780.001,041,633.782020年9月1日第41期1,041,633.78320,224.71721,409.0758,396,998.060.000.001,041,633.780.001,041,633.78############第42期1,041,633.78316,317.07725,316.7157,671,681.350.000.001,041,633.780.001,041,633.78############第43期1,041,633.78312,388.27729,245.5156,942,435.850.000.001,041,633.780.001,041,633.78############第44期1,041,633.78308,438.19733,195.5956,209,240.260.000.001,041,633.780.001,041,633.78第2页/共5页

0.0062210.63144,339.62

61727.800.0061242.350.0060754.280.0060263.560.0059770.180.0059274.130.0058775.400.0058273.960.0057769.800.0057262.920.0056753.290.0056240.90144,339.62

55725.730.0055207.780.0054687.010.0054163.430.0053637.010.0053107.740.0052575.600.0052040.580.0051502.670.0050961.830.0050418.070.0049871.37144,339.62

49321.700.0048769.050.0048213.420.0047654.770.0047093.090.0046528.380.0045960.600.0045389.750.00

44815.81

979,423.153,385,566.36980,391.43980,879.50981,370.22981,863.60982,359.65982,858.38983,359.82983,863.98984,370.86984,880.49985,392.883,391,568.42986,426.00986,946.77987,470.35987,996.77988,526.04989,058.18989,593.20990,131.11990,671.95991,215.71991,762.413,397,972.46992,864.73993,420.36993,979.01994,540.69995,105.40995,673.18996,244.03996,817.97

-979,423.15-3,385,566.36-980,391.43-980,879.50-981,370.22-981,863.60-982,359.65-982,858.38-983,359.82-983,863.98-984,370.86-984,880.49-985,392.88-3,391,568.42-986,426.00-986,946.77-987,470.35-987,996.77-988,526.04-989,058.18-989,593.20-990,131.11-990,671.95-991,215.71-991,762.41-3,397,972.46-992,864.73-993,420.36-993,979.01-994,540.69-995,105.40-995,673.18-996,244.03-996,817.97

融资租赁业务收益测算表（版本号：2014-12-11） 单位：元（人民币）项目名称租赁方式直租合同编号2021年1月1日第45期1,041,633.78304,466.72737,167.0655,472,073.200.000.001,041,633.780.001,041,633.782021年2月1日第46期1,041,633.78300,473.73741,160.0554,730,913.150.000.001,041,633.780.001,041,633.782021年3月1日第47期1,041,633.78296,459.11745,174.6753,985,738.480.000.001,041,633.780.001,041,633.782021年4月1日第48期1,041,633.78292,422.75749,211.0353,236,527.450.001,041,633.780.001,041,633.782021年5月1日第49期1,041,633.78288,364.52753,269.2652,483,258.200.000.001,041,633.780.001,041,633.782021年6月1日第50期1,041,633.78284,284.32757,349.4651,725,908.730.000.001,041,633.780.001,041,633.782021年7月1日第51期1,041,633.78280,182.01761,451.7750,964,456.960.000.001,041,633.780.001,041,633.782021年8月1日第52期1,041,633.78276,057.48765,576.3050,198,880.650.000.001,041,633.780.001,041,633.782021年9月1日第53期1,041,633.78271,910.60769,723.1849,429,157.480.000.001,041,633.780.001,041,633.78############第54期1,041,633.78267,741.27773,892.5148,655,264.970.000.001,041,633.780.001,041,633.78############第55期1,041,633.78263,549.35778,084.4347,877,180.540.000.001,041,633.780.001,041,633.78############第56期1,041,633.78259,334.73782,299.0547,094,881.490.000.001,041,633.780.001,041,633.782022年1月1日第57期1,041,633.78255,097.27786,536.5146,308,344.980.000.001,041,633.780.001,041,633.782022年2月1日第58期1,041,633.78250,836.87790,796.9145,517,548.070.000.001,041,633.780.001,041,633.782022年3月1日第59期1,041,633.78246,553.39795,080.3944,722,467.680.000.001,041,633.780.001,041,633.782022年4月1日第60期1,041,633.78242,246.70799,387.0843,923,080.600.001,041,633.780.001,041,633.782022年5月1日第61期1,041,633.78237,916.69803,717.0943,119,363.500.000.001,041,633.780.001,041,633.782022年6月1日第62期1,041,633.78233,563.22808,070.5642,311,292.940.000.001,041,633.780.001,041,633.782022年7月1日第63期1,041,633.78229,186.17812,447.6141,498,845.330.000.001,041,633.780.001,041,633.782022年8月1日第64期1,041,633.78224,785.41816,848.3740,681,996.960.000.001,041,633.780.001,041,633.782022年9月1日第65期1,041,633.78220,360.82821,272.9639,860,724.000.000.001,041,633.780.001,041,633.78############第66期1,041,633.78215,912.25825,721.5339,035,002.470.000.001,041,633.780.001,041,633.78############第67期1,041,633.78211,439.60830,194.1838,204,808.290.000.001,041,633.780.001,041,633.78############第68期1,041,633.78206,942.71834,691.0737,370,117.220.000.001,041,633.780.001,041,633.782023年1月1日第69期1,041,633.78202,421.47839,212.3136,530,904.910.000.001,041,633.780.001,041,633.782023年2月1日第70期1,041,633.78197,875.73843,758.0535,687,146.870.000.001,041,633.780.001,041,633.782023年3月1日第71期1,041,633.78193,305.38848,328.4034,838,818.470.000.001,041,633.780.001,041,633.782023年4月1日第72期1,041,633.78188,710.27852,923.5133,985,894.950.000.001,041,633.780.001,041,633.782023年5月1日第73期1,041,633.78184,090.26857,543.5233,128,351.440.000.001,041,633.780.001,041,633.782023年6月1日第74期1,041,633.78179,445.24862,188.5432,266,162.890.000.001,041,633.780.001,041,633.782023年7月1日第75期1,041,633.78174,775.05866,858.7331,399,304.160.000.001,041,633.780.001,041,633.782023年8月1日第76期1,041,633.78170,079.56871,554.2230,527,749.950.000.001,041,633.780.001,041,633.782023年9月1日第77期1,041,633.78165,358.65876,275.1329,651,474.810.000.001,041,633.780.001,041,633.78############第78期1,041,633.78160,612.16881,021.6228,770,453.190.000.001,041,633.780.001,041,633.78第3页/共5页

0.0044238.750.0043658.580.0043075.260.0042488.780.0041899.120.0041306.270.0040710.210.0040110.920.0039508.380.0038902.580.0038293.500.0037681.110.0037065.420.0036446.380.0035824.000.0035198.240.0034569.090.0033936.540.0033300.550.0032661.130.0032018.240.0031371.870.0030721.990.0030068.600.0029411.670.0028751.180.0028087.110.0027419.440.0026748.160.0026073.240.0025394.670.0024712.420.0024026.470.00

23336.81

997,395.03997,975.20998,558.52999,145.00999,734.661,000,327.511,000,923.571,001,522.861,002,125.401,002,731.201,003,340.281,003,952.671,004,568.361,005,187.401,005,809.781,006,435.541,007,064.691,007,697.241,008,333.231,008,972.651,009,615.541,010,261.911,010,911.791,011,565.181,012,222.111,012,882.601,013,546.671,014,214.341,014,885.621,015,560.541,016,239.111,016,921.361,017,607.311,018,296.97

-997,395.03-997,975.20-998,558.52-999,145.00-999,734.66-1,000,327.51-1,000,923.57-1,001,522.86-1,002,125.40-1,002,731.20-1,003,340.28-1,003,952.67-1,004,568.36-1,005,187.40-1,005,809.78-1,006,435.54-1,007,064.69-1,007,697.24-1,008,333.23-1,008,972.65-1,009,615.54-1,010,261.91-1,010,911.79-1,011,565.18-1,012,222.11-1,012,882.60-1,013,546.67-1,014,214.34-1,014,885.62-1,015,560.54-1,016,239.11-1,016,921.36-1,017,607.31-1,018,296.97

融资租赁业务收益测算表 单位：元（人民币）（版本号：2014-12-11）项目名称租赁方式直租合同编号############第79期1,041,633.78155,839.95885,793.8327,884,659.360.000.001,041,633.780.001,041,633.78############第80期1,041,633.78151,041.90890,591.8826,994,067.490.000.001,041,633.780.001,041,633.782024年1月1日第81期1,041,633.78146,217.87895,415.9126,098,651.570.000.001,041,633.780.001,041,633.782024年2月1日第82期1,041,633.78141,367.70900,266.0825,198,385.490.000.001,041,633.780.001,041,633.782024年3月1日第83期1,041,633.78136,491.25905,142.5324,293,242.960.000.001,041,633.780.001,041,633.782024年4月1日第84期1,041,633.78131,588.40910,045.3823,383,197.580.000.001,041,633.780.001,041,633.782024年5月1日第85期1,041,633.78126,658.99914,974.7922,468,222.790.000.001,041,633.780.001,041,633.782024年6月1日第86期1,041,633.78121,702.87919,930.9121,548,291.880.000.001,041,633.780.001,041,633.782024年7月1日第87期1,041,633.78116,719.91924,913.8720,623,378.020.000.001,041,633.780.001,041,633.782024年8月1日第88期1,041,633.78111,709.96929,923.8219,693,454.200.000.001,041,633.780.001,041,633.782024年9月1日第89期1,041,633.78106,672.88934,960.9018,758,493.300.000.001,041,633.780.001,041,633.78############第90期1,041,633.78101,608.51940,025.2717,818,468.020.000.001,041,633.780.001,041,633.78############第91期1,041,633.7896,516.70945,117.0816,873,350.950.000.001,041,633.780.001,041,633.78############第92期1,041,633.7891,397.32950,236.4615,923,114.480.000.001,041,633.780.001,041,633.782025年1月1日第93期1,041,633.7886,250.20955,383.5814,967,730.910.000.001,041,633.780.001,041,633.782025年2月1日第94期1,041,633.7881,075.21960,558.5714,007,172.340.000.001,041,633.780.001,041,633.782025年3月1日第95期1,041,633.7875,872.18965,761.6013,041,410.740.000.001,041,633.780.001,041,633.782025年4月1日第96期1,041,633.7870,640.97970,992.8112,070,417.930.000.001,041,633.780.001,041,633.782025年5月1日第97期1,041,633.7865,381.43976,252.3511,094,165.580.000.001,041,633.780.001,041,633.782025年6月1日第98期1,041,633.7860,093.40981,540.3810,112,625.200.000.001,041,633.780.001,041,633.782025年7月1日第99期1,041,633.7854,776.72986,857.069,125,768.140.000.001,041,633.780.001,041,633.782025年8月1日第100期1,041,633.7849,431.24992,202.548,133,565.610.000.001,041,633.780.001,041,633.782025年9月1日第101期1,041,633.7844,056.81997,576.977,135,988.640.000.001,041,633.780.001,041,633.78############第102期1,041,633.7838,653.271,002,980.516,133,008.130.000.001,041,633.780.001,041,633.78############第103期1,041,633.7833,220.461,008,413.325,124,594.810.000.001,041,633.780.001,041,633.78############第104期1,041,633.7827,758.221,013,875.564,110,719.250.000.001,041,633.780.001,041,633.782026年1月1日第105期1,041,633.7822,266.401,019,367.383,091,351.870.000.001,041,633.780.001,041,633.782026年2月1日第106期1,041,633.7816,744.821,024,888.962,066,462.910.000.001,041,633.780.001,041,633.782026年3月1日第107期1,041,633.7811,193.341,030,440.441,036,022.470.000.001,041,633.780.001,041,633.782026年4月1日第108期1,041,633.785,611.791,036,021.990.480.004,250,000.001,041,633.784,250,000.00-3,208,366.22合计124,821,448.2433,021,448.7284,999,999.526,096,267,456.7310,200,000.00第4页/共5页

0.0022643.410.0021946.260.0021245.330.0020540.610.0019832.060.0019119.680.0018403.440.0017683.320.0016959.300.0016231.360.0015499.480.0014763.630.0014023.790.0013279.950.0012532.080.0011780.160.0011024.160.0010264.070.009499.870.008731.520.007959.010.007182.320.006401.420.005616.290.004826.900.004033.250.003235.290.002433.010.001626.380.00

815.39

40,681,448.72

12,750,000.004,068.14

##############

1,018,990.371,019,687.521,020,388.451,021,093.171,021,801.721,022,514.101,023,230.341,023,950.461,024,674.481,025,402.421,026,134.301,026,870.151,027,609.991,028,353.831,029,101.701,029,853.621,030,609.621,031,369.711,032,133.911,032,902.261,033,674.771,034,451.461,035,232.361,036,017.491,036,806.881,037,600.531,038,398.491,039,200.771,040,007.40-3,209,181.61

15.00%

-1,018,990.37-1,019,687.52-1,020,388.45-1,021,093.17-1,021,801.72-1,022,514.10-1,023,230.34-1,023,950.46-1,024,674.48-1,025,402.42-1,026,134.30-1,026,870.15-1,027,609.99-1,028,353.83-1,029,101.70-1,029,853.62-1,030,609.62-1,031,369.71-1,032,133.91-1,032,902.26-1,033,674.77-1,034,451.46-1,035,232.36-1,036,017.49-1,036,806.88-1,037,600.53-1,038,398.49-1,039,200.77-1,040,007.403,209,181.61

-0.15

融资租赁业务收益测算表（版本号：2014-12-11）租赁方式直租612500

单位：元（人民币）合同编号第5页/共5页

项目名称