收益测算表

 融资租赁租金及收益测算表租金计算方式PM存量占用部门存量占用项目总额首付款保证金资产余值项目起租日12345671011121314151617181920212,000,000.0020.000.00租金收入95,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.09PM存量收入部门存量收入租期（年）年利率年还租次数每期租金利息收入0.0023,802.8022,903.1321,992.2221,069.9220,136.0919,190.5918,233.2817,263.9916,282.5915,288.9214,282.8313,2.1712,232.7711,188.4710,131.139,060.577,976.626,879.135,767.924,2.82215.00%1295,776.09回收成本95,776.0971,973.3072,872.9673,783.8774,706.1775,0.0076,585.5077,2.8278,512.1079,493.5180,487.1781,493.2682,511.9383,3.3384,587.6285,4.9786,715.5387,799.4788,6.9790,008.11,133.28PM总收益率部门总收益率返点收入手续费收入其他收入残值收入租前息未回收成本2,000,000.001,904,223.911,832,250.611,759,377.651,685,593.771,610,887.601,535,247.601,458,662.101,381,119.281,302,607.181,223,113.671,142,626.501,061,133.23978,621.305,077.98810,490.36724,845.39638,129.86550,330.39461,433.43371,425.25280,291.9717.52%17.52%总收益总资金占用2004年后占用2005年后收入2005年后占用2006年后收入2006年后占用 2007年后收入2007年后占用2008年后收入2008年后占用2009年后收入2009年后占用2010年后收入2010年后占用2011年后收入2011年后占用2012年后收入2012年后占用2013年后收入2013年后占用

348,726.282004年以后收入

0.00总资金占用50,000.00 1,990,803.52收益率100.0017.52%现金流量-1,949,980.00-1,8,203.9195,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.0995,776.09IRR2015/1/112015/3/12015/4/12015/5/12015/6/12015/7/12015/8/12015/9/12015/10/12015/11/12015/12/12016/1/12016/2/12016/3/12016/4/12016/5/12016/6/12016/7/12016/8/12016/9/12016/10/12016/11/1

2016/12/12017/1/12017/2/1

222324 95,776.0995,776.0995,776.09 2,298,626.28 3,503.652,350.241,182.42 298,626.28 92,272.4593,425.8594,593.67 2,000,000.00 188,019.5294,593.670.00 23,0,102.22 95,776.0995,776.0995,856.09 348,726.28 1.49% 17.84% 2014年后收入2012年后占用

占用收益率

0.000.000.00%0.000.000.00%0.000.000.00%0.000.000.00%0.000.000.00%0.000.000.00%0.000.000.00%0.000.000.00%0.000.000.00%0.000.00

0.00%0.000.000.00%