融资租赁测算表-2016-2

"融资租赁业务收益测算表

（版本号：）",,,,,,,,,单位：元（人民币）

项目名称,,,,租赁方式,,,合同编号,,

项目参数,,,,,,,,,

租赁融资额,"5,000,000.00",租赁物价格,"5,000,000.00",购货相关费用支付,0.00,购货相关税收支付,0.00,后付先付代码,1

租赁利率,15.0000%,租赁期限（年）,2,年付租次数,12,租金支付方式,先付,后付,0

期末残值,0.00,残值计入本金,否,折现值,#NUM!,保证金存款利率,0.0000%,先付,1

保证金率,10.0000%,保证金,"500,000.00",手续费率,2.0000%,手续费,"100,000.00",残值计入本金代码,是

供应商折扣率,0.0000%,供应商折扣额,0.00,管理费率,0.0000%,管理费,0.00,,否

收益测算,,,,,,,,,

每期租金,,租金总额,"6,500,000.00",收回本金,"5,000,000.00",收回利息,"1,500,000.00",净融资额现值,"4,400,000.00"

净现值NPV,#NUM!,现值收益率,#NUM!,年化现值收益率,#NUM!,项目IRR（年付分次不计复利）,#NUM!,项目IRR（年付分次计算复利）,#NUM!

现金流量,,,,,,,,,

日期,租赁相关流入,利息,收回本金,尚未收回本金,其他现金流入,其他现金流出,现金流入,现金流出,净现金流

起租日,"600,000.00",,0.00,"5,000,000.00",0.00,"5,000,000.00","600,000.00","5,000,000.00","-4,400,000.00"

第1期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第2期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第3期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第4期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第5期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第6期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第7期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第8期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第9期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第10期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第11期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第12期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第13期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第14期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第15期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第16期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第17期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第18期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第19期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第20期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第21期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第22期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第23期,"62,500.00","62,500.00",0.00,"5,000,000.00",0.00,0.00,"62,500.00",0.00,"62,500.00"

第24期,"5,062,500.00","62,500.00","5,000,000.00",0.00,0.00,"500,000.00","5,062,500.00","500,000.00","4,562,500.00"

第25期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第26期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第27期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第28期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第29期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第30期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第31期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第32期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第33期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第34期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第35期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第36期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第37期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第38期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第39期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第40期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第41期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第42期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第43期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第44期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第45期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第46期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第47期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第48期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第49期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第50期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第51期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第52期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第53期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第54期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第55期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第56期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第57期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第58期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第59期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第60期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

合计,"6,500,000.00","1,500,000.00","5,000,000.00",,,,,,

,,,,,,,,,,

测算表说明,,,,,,,,,

编者：阿不QQ:168320103，欢迎沟通讨论，共同完善（本表格的只读密码为168320103，建议使用时另存为一份，保留原版本）。,,,,,,,,,

特别说明（必看）：（2014-12-11）,,,,,,,,,

1.本表格支持任意自由现金流还款，包括指定任意一期的还款本息总额或还款本金或还款利息都可以计算，但本表格计算是半自动的；上表只是给定每期归还的本金计算的。,,,,,,,,,

2.手动计算步骤，先确定年限和每年还款次数，然后手动调整表格。,,,,,,,,,

3.手动调整表格的原理：任意一期的本息总额=上一期本金产生的利息+本期应该归还的本金；如一年分4期，则上一期本金产生的利息=上一期本金*租赁利率/4。,,,,,,,,,

更新：（2014-12-11）,,,,,,,,,

1.项目IRR计算方式在2014-09-22根据QQ41792052的修正为按复利计算，但由此导致贴现值去IRR时，净现值不为零。在此加入项目IRR（年付分次不计复利）和项目IRR（年付分次计算复利）两个项目IRR；贴现值=项目IRR（年付分次不计复利）时，净现值为零；但项目IRR（年付分次计算复利）更能反映项目的真实收益情况（即计算了年付分次时非年底利息的复利，有点搅，可以想象下自然对数e=2.71828是怎么来的，呵呵）（感谢QQ569983574的使用反馈意见）。,,,,,,,,,

更新：（2014-09-22）,,,,,,,,,

1.项目IRR计算方式修正为按复利计算（感谢QQ41792052的修正意见）。,,,