![融资租赁测算表-2016-2_第1页](http://file4.renrendoc.com/view/0ccdf82d40b22dd0f159013bf75a4272/0ccdf82d40b22dd0f159013bf75a42721.gif)
![融资租赁测算表-2016-2_第2页](http://file4.renrendoc.com/view/0ccdf82d40b22dd0f159013bf75a4272/0ccdf82d40b22dd0f159013bf75a42722.gif)
![融资租赁测算表-2016-2_第3页](http://file4.renrendoc.com/view/0ccdf82d40b22dd0f159013bf75a4272/0ccdf82d40b22dd0f159013bf75a42723.gif)
![融资租赁测算表-2016-2_第4页](http://file4.renrendoc.com/view/0ccdf82d40b22dd0f159013bf75a4272/0ccdf82d40b22dd0f159013bf75a42724.gif)
![融资租赁测算表-2016-2_第5页](http://file4.renrendoc.com/view/0ccdf82d40b22dd0f159013bf75a4272/0ccdf82d40b22dd0f159013bf75a42725.gif)
版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
"融资租赁业务收益测算表
(版本号:)",,,,,,,,,单位:元(人民币)
项目名称,,,,租赁方式,,,合同编号,,
项目参数,,,,,,,,,
租赁融资额,"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的修正意见)。,,,
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 细菌类诊断抗原产品项目运营指导方案
- C语言程序设计 课件 第5章-数组
- 贵州省黔西南州兴仁市黔龙学校2023年数学三下期末经典试题含解析
- 检测专项及检测能力表
- 贵州省黔南州都匀市重点名校2024-2025学年初三生物试题下学期3月教学质量监测考试试卷含解析
- 开闭幕词之六一联欢会开幕词
- 2024-2034年全球及中国m钴永磁材料行业市场发展分析及前景趋势与投资发展研究报告
- 幼儿园拟晋升教师专业技术职务人员课堂教学能力考核评分标准
- 2024年版矿产资源开发合作合同书
- 重型燃气轮机行业前景分析及投资动向研究报告模板
- 小学劳动教育中红色文化渗透研究 论文
- 汽车行车记录仪检验规范及标准
- 休闲体育活动策划与组织-课程标准
- 基于“六化”策略的小学低年级无纸笔测评思考与实践
- 耿左军-颅内脑外肿瘤影像诊断思路
- 军事地形学的要点
- 七年级地理教学工作总结范文(3篇)
- 机动车维修竣工出厂合格证
- 配电室巡检记录表
- 环境催化-课件1
- 口腔检查 口腔检查
评论
0/150
提交评论