融资租赁租金、IRR测算表

1、 融融资资租租赁赁租租金金及及收收益益测测算算表表 租金计算方式 PM存量占用PM存量收入PM总收益率23.46% 部门存量占用部门存量收入部门总收益率23.46% 项项目目总总额额15,000,000.00租租期期（年年）2返返点点收收入入0.00 首首付付款款0.00年年利利率率9.00%手手续续费费收收入入1,800,000.00 保保证证金金1,500,000.00年年还还租租次次数数4其其他他收收入入0.00 资资产产余余值值0.00每每期期租租金金2,069,769.27残残值值收收入入100.00 租租前前息息 项项目目租租金金收收入入利利息息收收入入回回收收成成本本未未回回收收

2、成成本本现现金金流流量量 2006/9/30起租日15,000,000.00-11,700,000.00 2006/12/3012,069,769.27337,500.001,732,269.2713,267,730.732,069,769.27 2007/3/3022,069,769.27298,523.941,771,245.3311,496,485.402,069,769.27 2007/6/3032,069,769.27258,670.921,811,098.359,685,387.052,069,769.27 2007/9/3042,069,769.27217,921.211,851

3、,848.067,833,538.992,069,769.27 2007/12/3052,069,769.27176,254.631,893,514.645,940,024.342,069,769.27 2008/3/3062,069,769.27133,650.551,936,118.724,003,905.622,069,769.27 2008/6/3072,069,769.2790,087.881,979,681.392,024,224.232,069,769.27 2008/9/3082,069,769.2745,545.052,024,224.230.00569,869.27 16,

4、558,154.171,558,154.1715,000,000.0069,251,296.363,358,254.17 总总收收益益总总资资金金占占用用收收益益率率 3,358,254.172004年后收入0.00 总总资资金金占占用用2004年后占用0.00 14,312,824.090.00% 收收益益率率2005年后收入0.00 23.46%2005年后占用0.00 0.00% IRRIRR2006年后收入0.00 2006年后占用0.00 0.00% 2007年后收入0.00 2007年后占用0.00 0.00% 2008年后收入155.82 2008年后占用1,429.95 10.

5、90% 6.49%2009年后收入121.73 2009年后占用1,090.15 25.96%11.17% 2010年后收入26.78 2010年后占用185.81 14.41% 2011年后收入0.00 2011年后占用0.00 0.00% 2012年后收入0.00 2012年后占用0.00 0.00% 2013年后收入0.00 2013年后占用0.00 0.00% 2014年后收入0.00 2014年后占用0.00 0.00% 6321448.62 #VALUE! 76642040.28 68669445.41 7972594.87 融资租赁租金及收益测算表 租金计算方式 PM存量占用PM

6、存量收入PM总收益率14.32%总总收收益益总总资资金金占占用用收收益益率率 部门存量占用部门存量收入部门总收益率14.32%695,196.82 2004年以后收入0.00 项项目目总总额额4,000,000.00租租期期（年年）3返返点点收收入入240,000.00总总资资金金占占用用2004年后占用0.00 首首付付款款0.00年年利利率率7.56%手手续续费费收收入入0.004,854,455.340.00% 保保证证金金400,000.00年年还还租租次次数数12其其他他收收入入收收益益率率2005年后收入0.00 资资产产余余值值0.00每每期期租租金金123,755.47残残值值

7、收收入入0.0014.32%2005年后占用0.00 租租前前息息0.00% 项项目目租租金金收收入入利利息息收收入入回回收收成成本本未未回回收收成成本本现现金金流流量量IRRIRR2006年后收入0.00 2006/1/1起租日4,000,000.00-3,360,000.002006年后占用0.00 2006/4/11123,755.470.00123,755.473,876,244.53-3,236,244.53 0.00% 2006/5/12123,755.4724,420.3499,335.133,776,909.41123,755.47 2007年后收入0.00 2006/6/13

8、123,755.4723,794.5399,960.943,676,948.47123,755.47 2007年后占用0.00 2006/7/14123,755.4723,164.78100,590.693,576,357.78123,755.47 0.00% 2006/8/15123,755.4722,531.05101,224.413,475,133.36123,755.47 2008年后收入45.52 2006/9/16123,755.4721,893.34101,862.133,373,271.24123,755.47 2008年后占用575.10 2006/10/17123,755.

9、4721,251.61102,503.863,270,767.38123,755.47 7.92% 2006/11/18123,755.4720,605.83103,149.633,167,617.74123,755.47 2009年后收入25.89 2006/12/19123,755.4719,955.99103,799.483,063,818.27123,755.47 2009年后占用255.59 2007/1/110123,755.4719,302.06104,453.412,959,364.86123,755.47 10.13% 2007/2/111123,755.4718,644.0

10、0105,111.472,854,253.39123,755.47 2010年后收入7.95 2007/3/112123,755.4717,981.80105,773.672,748,479.72123,755.47 2010年后占用58.62 2007/4/113123,755.4717,315.42106,440.052,642,039.67123,755.47 13.57% 2007/5/114123,755.4716,644.85107,110.622,534,929.05123,755.47 2011年后收入0.24 2007/6/115123,755.4715,970.05107,

11、785.412,427,143.64123,755.47 2011年后占用-3.45 2007/7/116123,755.4715,291.00108,464.462,318,679.18123,755.47 -6.94% 2007/8/117123,755.4714,607.68109,147.792,209,531.39123,755.47 2012年后收入0.00 2007/9/118123,755.4713,920.05109,835.422,099,695.97123,755.47 2012年后占用0.00 2007/10/119123,755.4713,228.08110,527.

12、381,989,168.59123,755.47 0.00% 2007/11/120123,755.4712,531.76111,223.711,877,944.88123,755.47 2013年后收入0.00 2007/12/121123,755.4711,831.05111,924.411,766,020.47123,755.47 2013年后占用0.00 2008/1/122123,755.4711,125.93112,629.541,653,390.93123,755.47 0.00% 2008/2/123123,755.4710,416.36113,339.101,540,051.

13、82123,755.47 2014年后收入0.00 2008/3/124123,755.479,702.33114,053.141,425,998.68123,755.47 2012年后占用0.00 2008/4/125123,755.478,983.79114,771.681,311,227.01123,755.47 0.00% 2008/5/126123,755.478,260.73115,494.741,195,732.27123,755.47 2008/6/127123,755.477,533.11116,222.351,079,509.92123,755.47 2008/7/1281

14、23,755.476,800.91116,954.55962,555.36123,755.47 2008/8/129123,755.476,064.10117,691.37844,863.99123,755.47 2008/9/130123,755.475,322.64118,432.82726,431.17123,755.47 2008/10/131123,755.474,576.52119,178.95607,252.22123,755.47 2008/11/132123,755.473,825.69119,929.78487,322.44123,755.47 2008/12/133123

15、,755.473,070.13120,685.34366,637.10123,755.47 2009/1/134123,755.472,309.81121,445.65245,191.45123,755.47 2009/2/135123,755.471,544.71122,210.76122,980.69123,755.47 2009/3/136123,755.47774.78122,980.690.00-276,244.531.24% 4,455,196.82455,196.824,000,000.0072,253,464.02695,196.8214.89% 融资租赁租金及收益测算表 PM

16、存量占用PM存量收入PM总收益率9.56%总总收收益益总总资资金金占占用用收收益益率率 部门存量占用部门存量收入部门总收益率9.56%126,163,473.182002年后收入0.00 项项目目总总额额600,000,000.00租租期期（年年）5返返点点收收入入800,000.00总总资资金金占占用用2002年后占用0.00 首首付付款款0.00年年利利率率7.74%手手续续费费收收入入1,319,683,115.960.00% 保保证证金金60,000,000.00年年还还租租次次数数12其其他他收收入入0.00收收益益率率2003年后收入0.00 资资产产余余值值首首期期租租金金12,

17、118,891.22残残值值收收入入9.56%2003年后占用0.00 租租金金公公差差-1,000.00现现值值系系数数0.02租租前前息息0.00% 项项目目租租金金收收入入利利息息收收入入回回收收成成本本未未回回收收成成本本现现金金流流量量IRR2004年后收入12,536.35 2004/9/30起租日600,000,000.00-539,200,000.002004年后占用132,276.85 2004/10/30112,118,891.223,870,000.008,248,891.22591,751,108.7812,118,891.22 9.48% 2004/11/30212,

18、117,891.223,816,794.658,301,096.57583,450,012.2112,117,891.22 2005年后收入11,379.38 2004/12/30312,116,891.223,763,252.588,353,638.64575,096,373.5712,116,891.22 2005年后占用118,878.80 2005/1/30412,115,891.223,709,371.618,406,519.61566,689,853.9612,115,891.22 9.57% 2005/3/2512,114,891.223,655,149.568,459,741.

19、66558,230,112.3012,114,891.22 2006年后收入7,325.58 2005/4/2612,113,891.223,600,584.228,513,307.00549,716,805.3012,113,891.22 2006年后占用72,068.87 2005/5/2712,112,891.223,545,673.398,567,217.83541,149,587.4812,112,891.22 10.16% 2005/6/2812,111,891.223,490,414.848,621,476.38532,528,111.1012,111,891.22 2007年后

20、收入4,072.57 2005/7/2912,110,891.223,434,806.328,676,084.90523,852,026.2012,110,891.22 2007年后占用36,063.43 2005/8/21012,109,891.223,378,845.578,731,045.65515,120,980.5512,109,891.22 11.29% 2005/9/21112,108,891.223,322,530.328,786,360.90506,334,619.6512,108,891.22 2008年后收入1,722.57 2005/10/21212,107,891.2

21、23,265,858.308,842,032.92497,492,586.7312,107,891.22 2008年后占用11,726.55 2005/11/21312,106,891.223,208,827.188,898,064.04488,594,522.6912,106,891.22 14.69% 2005/12/21412,105,891.223,151,434.678,954,456.55479,640,066.1412,105,891.22 2009年后收入346.84 2006/1/21512,104,891.223,093,678.439,011,212.79470,628,

22、853.3512,104,891.22 2009年后占用-66.21 2006/2/21612,103,891.223,035,556.109,068,335.12461,560,518.2412,103,891.22 -523.82% 2006/3/21712,102,891.222,977,065.349,125,825.88452,434,692.3612,102,891.22 2010年后收入0.00 2006/4/21812,101,891.222,918,203.779,183,687.45443,251,004.9012,101,891.22 2010年后占用0.00 2006/

23、5/21912,100,891.222,858,968.989,241,922.24434,009,082.6712,100,891.22 0.00% 2006/6/22012,099,891.222,799,358.589,300,532.64424,708,550.0312,099,891.22 2011年后收入0.00 2006/7/22112,098,891.222,739,370.159,359,521.07415,349,028.9612,098,891.22 2011年后占用0.00 2006/8/22212,097,891.222,679,001.249,418,889.984

24、05,930,138.9812,097,891.22 0.00% 2006/9/22312,096,891.222,618,249.409,478,641.82396,451,497.1512,096,891.22 2012年后收入0.00 2006/10/22412,095,891.222,557,112.169,538,779.06386,912,718.0912,095,891.22 2012年后占用0.00 2006/11/22512,094,891.222,495,587.039,599,304.19377,313,413.9012,094,891.22 0.00% 2006/12/

25、22612,093,891.222,433,671.529,660,219.70367,653,194.2012,093,891.22 2007/1/22712,092,891.222,371,363.109,721,528.12357,931,666.0812,092,891.22 2007/2/22812,091,891.222,308,659.259,783,231.97348,148,434.1112,091,891.22 2007/3/22912,090,891.222,245,557.409,845,333.82338,303,100.2912,090,891.22 2007/4/

26、23012,089,891.222,182,055.009,907,836.22328,395,264.0712,089,891.22 2007/5/23112,088,891.222,118,149.459,970,741.77318,424,522.3012,088,891.22 2007/6/23212,087,891.222,053,838.1710,034,053.05308,390,469.2512,087,891.22 2007/7/23312,086,891.221,989,118.5310,097,772.69298,292,696.5612,086,891.22 2007/

27、8/23412,085,891.221,923,987.8910,161,903.33288,130,793.2312,085,891.22 2007/9/23512,084,891.221,858,443.6210,226,447.60277,904,345.6312,084,891.22 2007/10/23612,083,891.221,792,483.0310,291,408.19267,612,937.4412,083,891.22 2007/11/23712,082,891.221,726,103.4510,356,787.77257,256,149.6712,082,891.22

28、 2007/12/23812,081,891.221,659,302.1710,422,589.05246,833,560.6112,081,891.22 2008/1/23912,080,891.221,592,076.4710,488,814.75236,344,745.8612,080,891.22 2008/2/24012,079,891.221,524,423.6110,555,467.61225,789,278.2512,079,891.22 2008/3/24112,078,891.221,456,340.8410,622,550.37215,166,727.8712,078,8

29、91.22 2008/4/24212,077,891.221,387,825.3910,690,065.82204,476,662.0512,077,891.22 2008/5/24312,076,891.221,318,874.4710,758,016.75193,718,645.3012,076,891.22 2008/6/24412,075,891.221,249,485.2610,826,405.96182,892,239.3412,075,891.22 2008/7/24512,074,891.221,179,654.9410,895,236.28171,997,003.0712,0

30、74,891.22 2008/8/24612,073,891.221,109,380.6710,964,510.55161,032,492.5212,073,891.22 2008/9/24712,072,891.221,038,659.5811,034,231.64149,998,260.8712,072,891.22 2008/10/24812,071,891.22967,488.7811,104,402.44138,893,858.4412,071,891.22 2008/11/24912,070,891.22895,865.3911,175,025.83127,718,832.6012

31、,070,891.22 2008/12/25012,069,891.22823,786.4711,246,104.75116,472,727.8512,069,891.22 2009/1/25112,068,891.22751,249.0911,317,642.12105,155,085.7312,068,891.22 2009/2/25212,067,891.22678,250.3011,389,640.9293,765,444.8112,067,891.22 2009/3/25312,066,891.22604,787.1211,462,104.1082,303,340.7112,066,

32、891.22 2009/4/25412,065,891.22530,856.5511,535,034.6770,768,306.0412,065,891.22 2009/5/25512,064,891.22456,455.5711,608,435.6559,159,870.4012,064,891.22 2009/6/25612,063,891.22381,581.1611,682,310.0647,477,560.3412,063,891.22 2009/7/25712,062,891.22306,230.2611,756,660.9635,720,899.3812,062,891.22 2

33、009/8/25812,061,891.22230,399.8011,831,491.4223,889,407.9712,061,891.22 2009/9/25912,060,891.22154,086.6811,906,804.5411,982,603.4312,060,891.22 2009/10/26012,059,891.2277,287.7911,982,603.430.00-47,940,108.780.79% 725,363,473.18125,363,473.18600,000,000.0019,436,197,391.57126,163,473.189.43% 融资租赁租金

34、及收益测算表 PM存量占用PM存量收入PM总收益率12.23%总总收收益益总总资资金金占占用用收收益益率率 部门存量占用部门存量收入部门总收益率12.23%2,698,416.502002年后收入0.00 项项目目总总额额10,000,000.00租租期期（年年）5返返点点收收入入800,000.00总总资资金金占占用用2002年后占用0.00 首首付付款款0.00年年利利率率7.74%手手续续费费收收入入22,069,011.660.00% 保保证证金金500,000.00年年还还租租次次数数12其其他他收收入入0.00收收益益率率2003年后收入0.00 资资产产余余值值首首期期租租金金2

35、27,806.94残残值值收收入入12.23%2003年后占用0.00 租租金金公公差差-1,000.00现现值值系系数数0.02租租前前息息0.00% 项项目目租租金金收收入入利利息息收收入入回回收收成成本本未未回回收收成成本本现现金金流流量量IRR2004年后收入189.84 2004/9/30起租日10,000,000.00-8,700,000.002004年后占用2,212.05 2004/9/301227,806.940.00227,806.949,772,193.06-8,472,193.06 8.58% 2004/10/302226,806.9463,030.65163,776.

36、309,608,416.76226,806.94 2005年后收入171.06 2004/11/303225,806.9461,974.29163,832.659,444,584.11225,806.94 2005年后占用1,982.56 2004/12/304224,806.9460,917.57163,889.379,280,694.73224,806.94 8.63% 2005/1/305223,806.9459,860.48163,946.469,116,748.27223,806.94 2006年后收入106.72 2005/3/26222,806.9458,803.03164,00

37、3.928,952,744.36222,806.94 2006年后占用1,194.34 2005/4/27221,806.9457,745.20164,061.748,788,682.62221,806.94 8.94% 2005/5/28220,806.9456,687.00164,119.948,624,562.68220,806.94 2007年后收入57.08 2005/6/29219,806.9455,628.43164,178.518,460,384.17219,806.94 2007年后占用603.41 2005/7/210218,806.9454,569.48164,237.4

38、68,296,146.70218,806.94 9.46% 2005/8/211217,806.9453,510.15164,296.808,131,849.91217,806.94 2008年后收入22.80 2005/9/212216,806.9452,450.43164,356.517,967,493.40216,806.94 2008年后占用210.93 2005/10/213215,806.9451,390.33164,416.617,803,076.79215,806.94 10.81% 2005/11/214214,806.9450,329.85164,477.107,638,5

39、99.69214,806.94 2009年后收入3.95 2005/12/215213,806.9449,268.97164,537.977,474,061.72213,806.94 2009年后占用17.16 2006/1/216212,806.9448,207.70164,599.247,309,462.47212,806.94 23.04% 2006/2/217211,806.9447,146.03164,660.917,144,801.57211,806.94 2010年后收入0.00 2006/3/218210,806.9446,083.97164,722.976,980,078.5

40、9210,806.94 2010年后占用0.00 2006/4/219209,806.9445,021.51164,785.436,815,293.16209,806.94 0.00% 2006/5/220208,806.9443,958.64164,848.306,650,444.86208,806.94 2011年后收入0.00 2006/6/221207,806.9442,895.37164,911.576,485,533.29207,806.94 2011年后占用0.00 2006/7/222206,806.9441,831.69164,975.256,320,558.03206,80

41、6.94 0.00% 2006/8/223205,806.9440,767.60165,039.346,155,518.69205,806.94 2012年后收入0.00 2006/9/224204,806.9439,703.10165,103.855,990,414.85204,806.94 2012年后占用0.00 2006/10/225203,806.9438,638.18165,168.775,825,246.08203,806.94 0.00% 2006/11/226202,806.9437,572.84165,234.105,660,011.97202,806.94 2006/12

42、/227201,806.9436,507.08165,299.865,494,712.11201,806.94 2007/1/228200,806.9435,440.89165,366.055,329,346.06200,806.94 2007/2/229199,806.9434,374.28165,432.665,163,913.40199,806.94 2007/3/230198,806.9433,307.24165,499.704,998,413.70198,806.94 2007/4/231197,806.9432,239.77165,567.174,832,846.53197,806

43、.94 2007/5/232196,806.9431,171.86165,635.084,667,211.45196,806.94 2007/6/233195,806.9430,103.51165,703.434,501,508.02195,806.94 2007/7/234194,806.9429,034.73165,772.214,335,735.80194,806.94 2007/8/235193,806.9427,965.50165,841.454,169,894.36193,806.94 2007/9/236192,806.9426,895.82165,911.124,003,983

44、.24192,806.94 2007/10/237191,806.9425,825.69165,981.253,838,001.99191,806.94 2007/11/238190,806.9424,755.11166,051.833,671,950.16190,806.94 2007/12/239189,806.9423,684.08166,122.863,505,827.29189,806.94 2008/1/240188,806.9422,612.59166,194.363,339,632.94188,806.94 2008/2/241187,806.9421,540.63166,26

45、6.313,173,366.63187,806.94 2008/3/242186,806.9420,468.21166,338.733,007,027.90186,806.94 2008/4/243185,806.9419,395.33166,411.612,840,616.29185,806.94 2008/5/244184,806.9418,321.98166,484.972,674,131.32184,806.94 2008/6/245183,806.9417,248.15166,558.792,507,572.53183,806.94 2008/7/246182,806.9416,17

46、3.84166,633.102,340,939.43182,806.94 2008/8/247181,806.9415,099.06166,707.882,174,231.55181,806.94 2008/9/248180,806.9414,023.79166,783.152,007,448.40180,806.94 2008/10/249179,806.9412,948.04166,858.901,840,589.50179,806.94 2008/11/250178,806.9411,871.80166,935.141,673,654.36178,806.94 2008/12/25117

47、7,806.9410,795.07167,011.871,506,642.49177,806.94 2009/1/252176,806.949,717.84167,089.101,339,553.39176,806.94 2009/2/253175,806.948,640.12167,166.821,172,386.57175,806.94 2009/3/254174,806.947,561.89167,245.051,005,141.52174,806.94 2009/4/255173,806.946,483.16167,323.78837,817.74173,806.94 2009/5/2

48、56172,806.945,403.92167,403.02670,414.72172,806.94 2009/6/257171,806.944,324.17167,482.77502,931.96171,806.94 2009/7/258170,806.943,243.91167,563.03335,368.93170,806.94 2009/8/259169,806.942,163.13167,643.81167,725.11169,806.94 2009/9/260168,806.941,081.83167,725.110.00-331,193.061.08% 11,898,416.50

49、1,898,416.5010,000,000.00294,328,139.892,698,416.5012.93% 融资租赁租金及收益测算表 租金计算方式 PM存量占用PM存量收入PM总收益率17.17% 部门存量占用部门存量收入部门总收益率17.17% 项项目目总总额额80,000,000.00租租期期（年年）3返返点点收收入入0.00 首首付付款款0.00年年利利率率9.00%手手续续费费收收入入9,600,000.00 保保证证金金8,000,000.00年年还还租租次次数数12其其他他收收入入0.00 资资产产余余值值首首期期租租金金992,465.93残残值值收收入入 租租金金公公比

50、比1.05租租前前息息 项项目目租租金金收收入入利利息息收收入入回回收收成成本本未未回回收收成成本本现现金金流流量量 2004/9/30起租日80,000,000.00-62,400,000.00 2004/10/301992,465.93600,000.00392,465.9379,607,534.07992,465.93 2004/11/3021,042,089.23597,056.51445,032.7379,162,501.341,042,089.23 2004/12/3031,094,193.69593,718.76500,474.9378,662,026.411,094,193.6

51、9 2005/1/3041,148,903.38589,965.20558,938.1878,103,088.231,148,903.38 2005/3/251,206,348.55585,773.16620,575.3877,482,512.851,206,348.55 2005/4/261,266,665.97581,118.85685,547.1376,796,965.721,266,665.97 2005/5/271,329,999.27575,977.24754,022.0376,042,943.691,329,999.27 2005/6/281,396,499.24570,322.

52、08826,177.1675,216,766.531,396,499.24 2005/7/291,466,324.20564,125.75902,198.4574,314,568.081,466,324.20 2005/8/2101,539,640.41557,359.26982,281.1573,332,286.941,539,640.41 2005/9/2111,616,622.43549,992.151,066,630.2872,265,656.661,616,622.43 2005/10/2121,697,453.55541,992.421,155,461.1271,110,195.5

53、41,697,453.55 2005/11/2131,782,326.23533,326.471,248,999.7669,861,195.781,782,326.23 2005/12/2141,871,442.54523,958.971,347,483.5768,513,712.211,871,442.54 2006/1/2151,965,014.66513,852.841,451,161.8267,062,550.391,965,014.66 2006/2/2162,063,265.40502,969.131,560,296.2765,502,254.122,063,265.40 2006

54、/3/2172,166,428.67491,266.911,675,161.7663,827,092.362,166,428.67 2006/4/2182,274,750.10478,703.191,796,046.9162,031,045.452,274,750.10 2006/5/2192,388,487.61465,232.841,923,254.7660,107,790.682,388,487.61 2006/6/2202,507,911.99450,808.432,057,103.5658,050,687.132,507,911.99 2006/7/2212,633,307.59435,380.152,197,927.4355,852,759.692,633,307.59 2006/8/2222,764,972.96418,895.702,346,077.2753,506,682.432,764,972.96 2006/9/2232,903,221.61401,300.122,501,921.4951,004,760.932,903,221.61 2006