融资租赁租金计算模板

,融资租赁租金计算器,,,,,,,,

,融资金额,融资期限（月）,起租时间（年月日）,利率浮动方式,浮动比例,利率,保证金（按融资金额比例）,,手续费支付方式

,"1,000,000.00",24,2012/8/1,12个月-36个月（含36个月）,25%,7.69%,10.00%,,一次性支付

,,,,,,,,,,

,手续费（按融资金额比例）,租金期数,宽限期（月数，录入0则为无宽限期，（宽限期是指只还息不还本金的期间））,租金支付周期,租赁余值,租金支付方式,"每期租金额PMT(rate,nper,pv,fv,type)",,IRR

,2%,12,0,双月,0,0,"90,435.36",,20.29%

,,,,,,,,,,

,,,,,,,,,,

,,,,,,,,,,

,租金计算表,,,,,,,,

,,日期,融资金额,保证金

,手续费,租金,当期本金,当期利息,本金余额

,,,,,,,,,,

,起租时间,2012/8/1,"¥1,000,000.00","¥100,000.00","¥20,000.00",,,,"¥1,000,000.00"

,第1期租金时间,2012/9/30,,,,"¥90,435.36","¥77,622.86","12,812.50","¥922,377.14"

,第2期租金时间,2012/11/30,,,,"¥90,435.36","¥78,617.40","11,817.96","¥843,759.74"

,第3期租金时间,2013/1/31,,,,"¥90,435.36","¥79,624.69","10,810.67","¥764,135.05"

,第4期租金时间,2013/4/30,,,,"¥90,435.36","¥80,644.88","9,790.48","¥683,490.17"

,第5期租金时间,2013/6/30,,,,"¥90,435.36","¥81,678.14","8,757.22","¥601,812.03"

,第6期租金时间,2013/8/31,,,,"¥90,435.36","¥82,724.64","7,710.72","¥519,087.39"

,第7期租金时间,2013/10/31,,,,"¥90,435.36","¥83,784.55","6,650.81","¥435,302.84"

,第8期租金时间,2013/12/31,,,,"¥90,435.36","¥84,858.04","5,577.32","¥350,444.80"

,第9期租金时间,2014/3/31,,,,"¥90,435.36","¥85,945.28","4,490.07","¥264,499.51"

,第10期租金时间,2014/5/31,,,,"¥90,435.36","¥87,046.46","3,388.90","¥177,453.06"

,第11期租金时间,2014/7/31,,,,"¥90,435.36","¥88,161.74","2,273.62","¥89,291.31"

,第12期租金时间,2014/9/30,,,,"¥90,435.36","¥89,291.31","1,144.04",¥0.00

,第13期租金时间,2014/11/30,,,,,,,

,第14期租金时间,2015/1/31,,,,,,,

,第15期租金时间,2015/4/30,,,,,,,

,第16期租金时间,2015/6/30,,,,,,,

,第17期租金时间,2015/8/31,,,,,,,

,第18期租金时间,2015/10/31,,,,,,,

,第19期租金时间,2015/12/31,,,,,,,

,第20期租金时间,2016/2/29,,,,,,,

,第21期租金时间,2016/4/30,,,,,,,

,第22期租金时间,2016/6/30,,,,,,,

,第23期租金时间,2016/8/31,,,,,,,

,第24期租金时间,2016/10/31,,,,,,,

,第25期租金时间,2016/12/31,,,,,,,

,第26期租金时间,2017/3/31,,,,,,,

,第27期租金时间,2017/5/31,,,,,,,

,第28期租金时间,2017/7/31,,,,,,,

,第29期租金时间,2017/9/30,,,,,,,

,第30期租金时间,2017/11/30,,,,,,,

,第31期租金时间,2018/1/31,,,,,,,

,第32期租金时间,2018/4/30,,,,,,,

,第33期租金时间,2018/6/30,,,,,,,

,第34期租金时间,2018/8/31,,,,,,,

,第35期租金时间,2018/10/31,,,,,,,

,第36期租金时间,2018/12/31,,,,,,,

,,,,,,,,,,

,合计,,"¥1,000,000.00","¥100,000.00","¥20,000.00","¥1,085,224.30","1,000,000.00","¥85,224.30",-