说明:目录1、本工作薄用于租赁项目尽调信息录入,并测算项目租金及收益;2、根据项目租赁方案选择租金测算表,鉴于各行业报表项目有所差异,如果是内部报表请转化成以企业会计准则为准的报表格式;3、该工作薄处于试用阶段,欢迎提出意见以供改进;4、该工作薄要求至少使用0ffice2007版,低版本需升级后使用;5、标黄单元格如不带公式需手动填列,带公式的如有需要可自行修改;6、非标黄单元格如带公式,请谨慎修改。工作表名称工作表标签1租金测算2财务数据丰汇租赁FENGHUILEASING目录Contents收益分析【必填】附表1等额本息附表1-1等额本金附表1-2等息期末附表1-3不等额本息附表1-4财务图表附表2-1报表分析附表2-2租赁物清单附表2-3经营活动附表2-4投资活动附表2-5筹资活动附表2-6利润表附表2-7现金流附表2-8公司名称利率表浮动比率50%基准利率浮动后4.35%6.53%4.35%6.53%4.75%7.13%4.75%7.13%五年以上4.90%7.35%融资额(元)###起租日期1/20/2016残值1结束日期1/31/2024租息率(年)8%先付后付0租赁期限(年)8残值计入本金0年付息次数4保证金率0%其他收益(起租日)0保证金(元)-0%手续费-保证金利息0%宽限期(年)1手续费率0.0%首付款比例0%首付款是否计入本金0手续费支付方式一次性13%注:仅“标黄”单元格允许手动修改16%8.24%8.24%8.24%8.24%附表1收益分析返回目录年利率(%)六个月以内(含6个月)六个月至一年(含1年)一至三年(含3年)三至五年(含5年)试用实际年利率RATEIRR参考值项目收益IRR(等额本息)项目收益IRR(等额本金)项目收益IRR(等息期末还本)IRR(不等额本息)单位:元客户名称0租赁方式回租增值税率0%项目参数融资额30,000,000,000租赁物价格30,000,000,000租金支付方式0手续费支付一次性与企业的税差0%租赁利率8.00%租赁期限(年)8年付租次数4其他收益(起租日)0补税方式分期期末残值1残值计入本金否贷款基准利率4.75%保证金率0.00%保证金0手续费率0.00%折现率16.00%保证金存款利率0.00%手续费0收益测算每期租金1,278,318,220.05租金总额###收回本金30,000,000,000收回利息10,906,183,042净融资额现值30,000,000,000(6,503,020,923)现值收益率-21.68%年化现值收益率-2.71%XIRR8.24%IRR8.24%现金流量日期租赁相关流入利息收回本金尚未收回本金其他现金流入其他现金流出现金流入现金流出净现金流日历日利息交税本金销项本金进项起租日0.000.00###0.00###0.00###-30,000,000,000.001/20/2016-1,278,318,220.05600,000,000.00678,318,220.05###0.000.001,278,318,220.050.001,278,318,220.054/20/2016--1,278,318,220.05586,433,635.60691,884,584.46###0.000.001,278,318,220.050.001,278,318,220.057/20/2016--1,278,318,220.05572,595,943.91705,722,276.14###0.000.001,278,318,220.050.001,278,318,220.0510/20/2016--1,278,318,220.05558,481,498.39719,836,721.67###0.000.001,278,318,220.050.001,278,318,220.051/20/2017--1,278,318,220.05544,084,763.95734,233,456.10###0.000.001,278,318,220.050.001,278,318,220.054/20/2017--1,278,318,220.05529,400,094.83748,918,125.22###0.000.001,278,318,220.050.001,278,318,220.057/20/2017--1,278,318,220.05514,421,732.33763,896,487.73###0.000.001,278,318,220.050.001,278,318,220.0510/20/2017--1,278,318,220.05499,143,802.57779,174,417.48###0.000.001,278,318,220.050.001,278,318,220.051/20/2018--1,278,318,220.05483,560,314.22794,757,905.83###0.000.001,278,318,220.050.001,278,318,220.054/20/2018--1,278,318,220.05467,665,156.11810,653,063.95###0.000.001,278,318,220.050.001,278,318,220.057/20/2018--1,278,318,220.05451,452,094.83826,866,125.23###0.000.001,278,318,220.050.001,278,318,220.0510/20/2018--1,278,318,220.05434,914,772.32843,403,447.73###0.000.001,278,318,220.050.001,278,318,220.051/20/2019--1,278,318,220.05418,046,703.37860,271,516.69###0.000.001,278,318,220.050.001,278,318,220.054/20/2019--1,278,318,220.05400,841,273.038...