专业级 综合资金成本IRR测算表.xls

专业级 综合资金成本IRR测算表.xls

《专业级 综合资金成本IRR测算表.xls》由会员分享，可在线阅读，更多相关《专业级 综合资金成本IRR测算表.xls（68页珍藏版）》请在冰点文库上搜索。

融融资资租租赁赁租租金金及及收收益益测测算算表表租金计算方式PM存量占用PM存量收入PM总收益率部门存量占用部门存量收入部门总收益率项项目目总总额额15,000,000.00租租期期（年年）2返返点点收收入入首首付付款款0.00年年利利率率9.00%手手续续费费收收入入保保证证金金1,500,000.00年年还还租租次次数数4其其他他收收入入资资产产余余值值0.00每每期期租租金金2,069,769.27残残值值收收入入租租前前息息项项目目租租金金收收入入利利息息收收入入回回收收成成本本未未回回收收成成本本2006/9/30起租日15,000,000.002006/12/3012,069,769.27337,500.001,732,269.2713,267,730.732007/3/3022,069,769.27298,523.941,771,245.3311,496,485.402007/6/3032,069,769.27258,670.921,811,098.359,685,387.052007/9/3042,069,769.27217,921.211,851,848.067,833,538.992007/12/3052,069,769.27176,254.631,893,514.645,940,024.342008/3/3062,069,769.27133,650.551,936,118.724,003,905.622008/6/3072,069,769.2790,087.881,979,681.392,024,224.232008/9/3082,069,769.2745,545.052,024,224.230.0016,558,154.171,558,154.1715,000,000.0069,251,296.3623.46%总总收收益益总总资资金金占占用用收收益益率率23.46%3,358,254.172004年后收入0.000.00总总资资金金占占用用2004年后占用0.001,800,000.0014,312,824.090.00%0.00收收益益率率2005年后收入0.00100.0023.46%2005年后占用0.000.00%现现金金流流量量IRRIRR2006年后收入0.00-11,700,000.002006年后占用0.002,069,769.270.00%2,069,769.272007年后收入0.002,069,769.272007年后占用0.002,069,769.270.00%2,069,769.272008年后收入155.822,069,769.272008年后占用1,429.952,069,769.2710.90%569,869.276.49%2009年后收入121.732009年后占用1,090.153,358,254.1725.96%11.17%2010年后收入26.782010年后占用185.8114.41%2011年后收入0.002011年后占用0.000.00%2012年后收入0.002012年后占用0.000.00%2013年后收入0.002013年后占用0.000.00%2014年后收入0.002014年后占用0.000.00%6321448.62#VALUE!

融融资资租租赁赁租租金金及及收收益益测测算算表表76642040.2868669445.417972594.87融资租赁租金及收益测算表租金计算方式PM存量占用PM存量收入PM总收益率14.32%总总收收益益总总资资金金占占用用收收益益率率部门存量占用部门存量收入部门总收益率14.32%695,196.822004年以后收入项项目目总总额额4,000,000.00租租期期（年年）3返返点点收收入入240,000.00总总资资金金占占用用2004年后占用首首付付款款0.00年年利利率率7.56%手手续续费费收收入入0.004,854,455.34保保证证金金400,000.00年年还还租租次次数数12其其他他收收入入收收益益率率2005年后收入资资产产余余值值0.00每每期期租租金金123,755.47残残值值收收入入0.0014.32%2005年后占用租租前前息息项项目目租租金金收收入入利利息息收收入入回回收收成成本本未未回回收收成成本本现现金金流流量量IRRIRR2006年后收入2006/1/1起租日4,000,000.00-3,360,000.002006年后占用2006/4/11123,755.470.00123,755.473,876,244.53-3,236,244.532006/5/12123,755.4724,420.3499,335.133,776,909.41123,755.472007年后收入2006/6/13123,755.4723,794.5399,960.943,676,948.47123,755.472007年后占用2006/7/14123,755.4723,164.78100,590.693,576,357.78123,755.472006/8/15123,755.4722,531.05101,224.413,475,133.36123,755.472008年后收入2006/9/16123,755.4721,893.34101,862.133,373,271.24123,755.472008年后占用2006/10/17123,755.4721,251.61102,503.863,270,767.38123,755.472006/11/18123,755.4720,605.83103,149.633,167,617.74123,755.472009年后收入2006/12/19123,755.4719,955.99103,799.483,063,818.27123,755.472009年后占用2007/1/110123,755.4719,302.06104,453.412,959,364.86123,755.472007/2/111123,755.4718,644.00105,111.472,854,253.39123,755.472010年后收入2007/3/112123,755.4717,981.80105,773.672,748,479.72123,755.472010年后占用2007/4/113123,755.4717,315.42106,440.052,642,039.67123,755.472007/5/114123,755.4716,644.85107,110.622,534,929.05123,755.472011年后收入2007/6/115123,755.4715,970.05107,785.412,427,143.64123,755.472011年后占用2007/7/116123,755.4715,291.00108,464.462,318,679.18123,755.472007/8/117123,755.4714,607.68109,147.792,209,531.39123,755.472012年后收入2007/9/118123,755.4713,920.05109,835.422,099,695.97123,755.472012年后占用2007/10/119123,755.4713,228.08110,527.381,989,168.59123,755.472007/11/120123,755.4712,531.76111,223.711,877,944.88123,755.472013年后收入2007/12/121123,755.4711,831.05111,924.411,766,020.47123,755.472013年后占用2008/1/122123,755.4711,125.93112,629.541,653,390.93123,755.472008/2/123123,755.4710,416.36113,339.101,540,051.82123,755.472014年后收入2008/3/124123,755.479,702.33114,053.141,425,998.68123,755.472012年后占用2008/4/125123,755.478,983.79114,771.681,311,227.01123,755.472008/5/126123,755.478,260.73115,494.741,195,732.27123,755.472008/6/127123,755.477,533.11116,222.351,079,509.92123,755.472008/7/128123,755.476,800.91116,954.55962,555.36123,755.472008/8/129123,755.476,064.10117,691.37844,863.99123,755.472008/9/130123,755.475,322.64118,432.82726,431.17123,755.472008/10/131123,755.474,576.52119,178.95607,252.22123,755.472008/11/132123,755.473,825.69119,929.78487,322.44123,755.472008/12/133123,755.473,070.13120,685.34366,637.10123,755.472009/1/134123,755.472,309.81121,445.65245,191.45123,755.472009/2/135123,755.471,544.71122,210.76122,980.69123,755.472009/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%0.000.000.00%0.000.000.00%0.000.000.00%0.000.000.00%45.52575.107.92%25.89255.5910.13%7.9558.6213.57%0.24-3.45-6.94%0.000.000.00%0.000.00总总资资金金占占用用收收益益率率0.00%0.000.000.00%融资租赁租金及收益测算表PM存量占用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,118,891.22残残值值收收入入9.56%2003年后占用0.00租租金金公公差差-1,000.00现现值值系系数数0.02租租前前息息0.00%项项目目租租金金收收入入利利息息收收入入回回收收成成本本未未回回收收成成本本现现金金流流量量IRR2004年后收入12,536.352004/9/30起租日600,000,000.00-539,200,000.002004年后占用132,276.852004/10/30112,118,891.223,870,000.008,248,891.22591,751,108.7812,118,891.229.48%2004/11/30212,117,891.223,816,794.658,301,096.57583,450,012.2112,117,891.222005年后收入11,379.382004/12/30312,116,891.223,763,252.588,353,638.64575,096,373.5712,116,891.222005年后占用118,878.802005/1/30412,115,891.223,709,371.618,406,519.61566,689,853.9612,115,891.229.57%2005/3/2512,114,891.223,655,149.568,459,741.66558,230,112.3012,114,891.222006年后收入7,325.582005/4/2612,113,891.223,600,584.228,513,307.00549,716,805.3012,113,891.222006年后占用72,068.872005/5/2712,112,891.223,545,673.398,567,217.83541,149,587.4812,112,891.2210.16%2005/6/2812,111,891.223,490,414.848,621,476.38532,528,111.1012,111,891.222007年后收入4,072.572005/7/2912,110,891.223,434,806.328,676,084.90523,852,026.2012,110,891.222007年后占用36,063.432005/8/21012,109,891.223,378,845.578,731,045.65515,120,980.5512,109,891.2211.29%2005/9/21112,108,891.223,322,530.328,786,360.90506,334,619.6512,108,891.222008年后收入1,722.572005/10/21212,107,891.223,265,858.308,842,032.92497,492,586.7312,107,891.222008年后占用11,726.552005/11/21312,106,891.223,208,827.188,898,064.04488,594,522.6912,106,891.2214.69%2005/12/21412,105,891.223,151,434.678,954,456.55479,640,066.1412,105,891.222009年后收入346.842006/1/21512,104,891.223,093,678.439,011,212.79470,628,853.3512,104,891.222009年后占用-66.212006/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.222010年后收入0.002006/4/21812,101,891.222,918,203.779,183,687.45443,251,004.9012,101,891.222010年后占用0.002006/5/21912,100,891.222,858,968.989,241,922.24434,009,082.6712,100,891.220.00%2006/6/22012,099,891.222,799,358.589,300,532.64424,708,550.0312,099,891.222011年后收入0.002006/7/22112,098,891.222,739,370.159,359,521.07415,349,028.9612,098,891.222011年后占用0.002006/8/22212,097,891.222,679,001.249,418,889.98405,930,138.9812,097,891.220.00%2006/9/22312,096,891.222,618,249.409,478,641.82396,451,497.1512,096,891.222012年后收入0.002006/10/22412,095,891.222,557,112.169,538,779.06386,912,718.0912,095,891.222012年后占用0.002006/11/22512,094,891.222,495,587.039,599,304.19377,313,413.9012,094,891.220.00%2006/12/22612,093,891.222,433,671.529,660,219.70367,653,194.2012,093,891.222007/1/22712,092,891.222,371,363.109,721,528.12357,931,666.0812,092,891.222007/2/22812,091,891.222,308,659.259,783,231.97348,148,434.1112,091,891.222007/3/22912,090,891.222,245,557.409,845,333.82338,303,100.2912,090,891.222007/4/23012,089,891.222,182,055.009,907,836.22328,395,264.0712,089,891.222007/5/23112,088,891.222,118,149.459,970,741.77318,424,522.3012,088,891.222007/6/23212,087,891.222,053,838.1710,034,053.05308,390,469.2512,087,891.222007/7/23312,086,891.221,989,118.5310,097,772.69298,292,696.5612,086,891.222007/8/23412,085,891.221,923,987.8910,161,903.33288,130,793.2312,085,891.222007/9/23512,084,891.221,858,443.6210,226,447.60277,904,345.6312,084,891.222007/10/23612,083,891.221,792,483.0310,291,408.19267,612,937.4412,083,891.222007/11/23712,082,891.221,726,103.4510,356,787.77257,256,149.6712,082,891.222007/12/23812,081,891.221,659,302.1710,422,589.05246,833,560.6112,081,891.222008/1/23912,080,891.221,592,076.4710,488,814.75236,344,745.8612,080,891.222008/2/24012,079,891.221,524,423.6110,555,467.61225,789,278.2512,079,891.222008/3/24112,078,891.221,456,340.8410,622,550.37215,166,727.8712,078,891.222008/4/24212,077,891.221,387,825.3910,690,065.82204,476,662.0512,077,891.222008/5/24312,076,891.221,318,874.4710,758,016.75193,718,645.3012,076,891.222008/6/24412,075,891.221,249,485.2610,826,405.96182,892,239.3412,075,891.222008/7/24512,074,891.221,179,654.9410,895,236.28171,997,003.0712,074,891.222008/8/24612,073,891.221,109,380.6710,964,510.55161,032,492.5212,073,891.222008/9/24712,072,891.221,038,659.5811,034,231.64149,998,260.8712,072,891.222008/10/24812,071,891.22967,488.7811,104,402.44138,893,858.4412,071,891.222008/11/24912,070,891.22895,865.3911,175,025.83127,718,832.6012,070,891.222008/12/25012,069,891.22823,786.4711,246,104.75116,472,727.8512,069,891.222009/1/25112,068,891.22751,249.0911,317,642.12105,155,085.7312,068,891.222009/2/25212,067,891.22678,250.3011,389,640.9293,765,444.8112,067,891.222009/3/25312,066,891.22604,787.1211,462,104.1082,303,340.7112,066,891.222009/4/25412,065,891.22530,856.5511,535,034.6770,768,306.0412,065,891.222009/5/25512,064,891.22456,455.5711,608,435.6559,159,870.4012,064,891.222009/6/25612,063,891.22381,581.1611,682,310.0647,477,560.3412,063,891.222009/7/25712,062,891.22306,230.2611,756,660.9635,720,899.3812,062,891.222009/8/25812,061,891.22230,399.8011,831,491.4223,889,407.9712,061,891.222009/9/25912,060,891.22154,086.6811,906,804.5411,982,603.4312,060,891.222009/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.00#126,163,473.189.43%融资租赁租金及收益测算表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