融资租赁租金及收益测算表租金计算方式PM存量占用部门存量占用项目总额首付款保证金资产余值项目起租日123456789101112131415161718192021222324252627282930313233343536 25,000,000.000.000.000.00租金收入779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83 28,070,057.76 PM存量收入部门存量收入租期（年）年利率年还租次数每期租金利息收入160,000.00156,033.77152,042.15148,024.99143,982.12139,913.37135,818.58131,697.59127,550.22123,376.31119,175.69114,948.18110,693.61106,411.82102,102.6297,765.8593,401.3289,008.8584,588.2880,139.4175,662.0771,156.0766,621.2462,057.3857,464.3252,841.8648,189.8143,507.9938,796.2134,054.2829,281.9924,479.1619,645.6014,781.109,885.464,958.50 3,070,057.76 37.68%12779,723.83回收成本619,723.83623,690.06627,681.68631,698.84635,741.71639,810.46643,905.24648,026.24652,173.61656,347.52660,548.14664,775.65669,030.21673,312.01677,621.20681,957.98686,322.51690,714.97695,135.55699,584.42704,061.76708,567.75713,102.59717,666.44722,259.51726,881.97731,534.01736,215.83740,927.61745,669.55750,441.84755,244.66760,078.23764,942.73769,838.36774,765.33 25,000,000.00 PM总收益率部门总收益率返点收入手续费收入其他收入残值收入租前息未回收成本25,000,000.0024,380,276.1723,756,586.1123,128,904.4422,497,205.6021,861,463.8921,221,653.4320,577,748.1919,929,721.9519,277,548.3418,621,200.8317,960,652.6917,295,877.0416,626,846.8215,953,534.8215,275,913.6114,593,955.6313,907,633.1213,216,918.1512,521,782.6011,822,198.1811,118,136.4210,409,568.679,696,466.088,978,799.648,256,540.137,529,658.166,798,124.146,061,908.315,320,980.704,575,311.153,824,869.313,069,624.652,309,546.421,544,603.69774,765.330.00 479,696,524.40 2006-9-302006-10-302006-11-302006-12-302007-1-302007-3-22007-4-22007-5-22007-6-22007-7-22007-8-22007-9-22007-10-22007-11-22007-12-22008-1-22008-2-22008-3-22008-4-22008-5-22008-6-22008-7-22008-8-22008-9-22008-10-22008-11-22008-12-22009-1-22009-2-22009-3-22009-4-22009-5-22009-6-22009-7-22009-8-22009-9-22009-10-2
测算表
13.68%13.68%总收益 5,470,057.76总资金占用收益率2004年后收入2004年后占用2005年后收入
2005年后占用2006年后收入2006年后占用2007年后收入2007年后占用2008年后收入2008年后占用2009年后收入2009年后占用2010年后收入2010年后占用2011年后收入2011年后占用2012年后收入2012年后占用2013年后收入2013年后占用2014年后收入2014年后占用
0.000.000.00%0.000.000.00%0.000.000.00%0.000.000.00%307.014,012.967.65%259.723,398.827.64%110.491,439.167.68%22.25287.987.73%0.000.000.00%0.000.000.00%0.000.000.00%
0.00总资金占用2,400,000.00 39,974,710.370.00收益率0.0013.68%现金流量-22,600,000.00779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83779,723.83 5,470,057.76 IRR 1.22% 14.66%