融资租赁业务测算表1

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

（版本号：2014-09-18）",,,,,,,,,单位：元（人民币）

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

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

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

租赁利率,7.6800%,租赁期限（年）,3,年付租次数,4,租金支付方式,后付,后付,0

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

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

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

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

每期租金,"47,047,813.38",租金总额,"564,573,760.56",收回本金,"500,000,000.00",收回利息,"64,573,760.54",净融资额现值,"440,000,000.00"

净现值NPV,"28,663,921.70",现值收益率,6.5145%,年化现值收益率,2.1715%,项目IRR,10.8809%,,

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

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

起租日,"60,000,000.00",,0.00,"500,000,000.00",0.00,"500,000,000.00","60,000,000.00","500,000,000.00","-440,000,000.00"

第1期,"47,047,813.38","9,600,000.00","37,447,813.38","462,552,186.62",0.00,0.00,"47,047,813.38",0.00,"47,047,813.38"

第2期,"47,047,813.38","8,881,001.98","38,166,811.40","424,385,375.23",0.00,0.00,"47,047,813.38",0.00,"47,047,813.38"

第3期,"47,047,813.38","8,148,199.20","38,899,614.17","385,485,761.05",0.00,0.00,"47,047,813.38",0.00,"47,047,813.38"

第4期,"47,047,813.38","7,401,326.61","39,646,486.77","345,839,274.29",0.00,0.00,"47,047,813.38",0.00,"47,047,813.38"

第5期,"47,047,813.38","6,640,114.07","40,407,699.31","305,431,574.97",0.00,0.00,"47,047,813.38",0.00,"47,047,813.38"

第6期,"47,047,813.38","5,864,286.24","41,183,527.14","264,248,047.83",0.00,0.00,"47,047,813.38",0.00,"47,047,813.38"

第7期,"47,047,813.38","5,073,562.52","41,974,250.86","222,273,796.97",0.00,0.00,"47,047,813.38",0.00,"47,047,813.38"

第8期,"47,047,813.38","4,267,656.90","42,780,156.48","179,493,640.50",0.00,0.00,"47,047,813.38",0.00,"47,047,813.38"

第9期,"47,047,813.38","3,446,277.90","43,601,535.48","135,892,105.02",0.00,0.00,"47,047,813.38",0.00,"47,047,813.38"

第10期,"47,047,813.38","2,609,128.42","44,438,684.96","91,453,420.05",0.00,0.00,"47,047,813.38",0.00,"47,047,813.38"

第11期,"47,047,813.38","1,755,905.67","45,291,907.71","46,161,512.34",0.00,0.00,"47,047,813.38",0.00,"47,047,813.38"

第12期,"47,047,813.38","886,301.04","46,161,512.34",0.00,0.00,"50,000,000.00","47,047,813.38","50,000,000.00","-2,952,186.62"

第13期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第14期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第15期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第16期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第17期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第18期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第19期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第20期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第21期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第22期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第23期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

第24期,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.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

合计,"564,573,760.56","64,573,760.54","500,000,000.00",,,,,,

,,,,,,,,,,

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

编者：刘金鸿QQ:168320103，欢迎沟通讨论，共同完善。,,,,,,,,,

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

1.本表仅支持等额本息还款方式，即每次还款金额相同，如需等额本金还款方式（等额本金还款、按月还款、半年还款、每年还款、自由还款另外再调整。,,,,,,,,,

2.折现率可以根据公司具体情况自由取值。,,,,,,,,,

3.未解决的问题：保证金在融资租赁合同执行完毕后才退还给承租人，实际合同中，大部分用来抵扣最后几期租金（手动解决很方便，自动解决待调整）。,,,,,,,,,

4.管理费和手续费默认期初一次性交清，实际上手续费一般期初一次性交清，但管理费一般不是期初一次性付清。,,,,,,,,,

鸣谢：本表格以田刚版本（2008-07-20）为基础修订而成，没有田大大这个表格什么都不是！,,,,,,,,,

1.