融資租賃租金計(jì)算模板

,融資租賃租金計(jì)算器,,,,,,,,

,融資金額,融資期限（月）,起租時(shí)間（年月日）,利率浮動(dòng)方式,浮動(dòng)比例,利率,保證金（按融資金額比例）,,手續(xù)費(fèi)支付方式

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

,,,,,,,,,,

,手續(xù)費(fèi)（按融資金額比例）,租金期數(shù),寬限期（月數(shù)，錄入0則為無寬限期，（寬限期是指只還息不還本金的期間））,租金支付周期,租賃余值,租金支付方式,"每期租金額PMT(rate,nper,pv,fv,type)",,IRR

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

,,,,,,,,,,

,,,,,,,,,,

,,,,,,,,,,

,租金計(jì)算表,,,,,,,,

,,日期,融資金額,保證金

,手續(xù)費(fèi),租金,當(dāng)期本金,當(dāng)期利息,本金余額

,,,,,,,,,,

,起租時(shí)間,2012/8/1,"￥1,000,000.00","￥100,000.00","￥20,000.00",,,,"￥1,000,000.00"

,第1期租金時(shí)間,2012/9/30,,,,"￥90,435.36","￥77,622.86","12,812.50","￥922,377.14"

,第2期租金時(shí)間,2012/11/30,,,,"￥90,435.36","￥78,617.40","11,817.96","￥843,759.74"

,第3期租金時(shí)間,2013/1/31,,,,"￥90,435.36","￥79,624.69","10,810.67","￥764,135.05"

,第4期租金時(shí)間,2013/4/30,,,,"￥90,435.36","￥80,644.88","9,790.48","￥683,490.17"

,第5期租金時(shí)間,2013/6/30,,,,"￥90,435.36","￥81,678.14","8,757.22","￥601,812.03"

,第6期租金時(shí)間,2013/8/31,,,,"￥90,435.36","￥82,724.64","7,710.72","￥519,087.39"

,第7期租金時(shí)間,2013/10/31,,,,"￥90,435.36","￥83,784.55","6,650.81","￥435,302.84"

,第8期租金時(shí)間,2013/12/31,,,,"￥90,435.36","￥84,858.04","5,577.32","￥350,444.80"

,第9期租金時(shí)間,2014/3/31,,,,"￥90,435.36","￥85,945.28","4,490.07","￥264,499.51"

,第10期租金時(shí)間,2014/5/31,,,,"￥90,435.36","￥87,046.46","3,388.90","￥177,453.06"

,第11期租金時(shí)間,2014/7/31,,,,"￥90,435.36","￥88,161.74","2,273.62","￥89,291.31"

,第12期租金時(shí)間,2014/9/30,,,,"￥90,435.36","￥89,291.31","1,144.04",￥0.00

,第13期租金時(shí)間,2014/11/30,,,,,,,

,第14期租金時(shí)間,2015/1/31,,,,,,,

,第15期租金時(shí)間,2015/4/30,,,,,,,

,第16期租金時(shí)間,2015/6/30,,,,,,,

,第17期租金時(shí)間,2015/8/31,,,,,,,

,第18期租金時(shí)間,2015/10/31,,,,,,,

,第19期租金時(shí)間,2015/12/31,,,,,,,

,第20期租金時(shí)間,2016/2/29,,,,,,,

,第21期租金時(shí)間,2016/4/30,,,,,,,

,第22期租金時(shí)間,2016/6/30,,,,,,,

,第23期租金時(shí)間,2016/8/31,,,,,,,

,第24期租金時(shí)間,2016/10/31,,,,,,,

,第25期租金時(shí)間,2016/12/31,,,,,,,

,第26期租金時(shí)間,2017/3/31,,,,,,,

,第27期租金時(shí)間,2017/5/31,,,,,,,

,第28期租金時(shí)間,2017/7/31,,,,,,,

,第29期租金時(shí)間,2017/9/30,,,,,,,

,第30期租金時(shí)間,2017/11/30,,,,,,,

,第31期租金時(shí)間,2018/1/31,,,,,,,

,第32期租金時(shí)間,2018/4/30,,,,,,,

,第33期租金時(shí)間,2018/6/30,,,,,,,

,第34期租金時(shí)間,2018/8/31,,,,,,,

,第35期租金時(shí)間,2018/10/31,,,,,,,

,第36期租金時(shí)間,2018/12/31,,,,,,,

,,,,,,,,,,

,合計(jì),,"￥1,000,000.00","￥100,000.00","￥20,000.00","￥1,085,224.30","1,000,000.00","￥85,224.30",-