"融資租賃業(yè)務(wù)收益測(cè)算表

（版本號(hào)：）",,,,,,,,,單位：元（人民幣）

項(xiàng)目名稱,,,,租賃方式,,,合同編號(hào),,

項(xiàng)目參數(shù),,,,,,,,,

租賃融資額,"5,000,000.00",租賃物價(jià)格,"5,000,000.00",購(gòu)貨相關(guān)費(fèi)用支付,0.00,購(gòu)貨相關(guān)稅收支付,0.00,后付先付代碼,1

租賃利率,15.0000%,租賃期限（年）,2,年付租次數(shù),12,租金支付方式,先付,后付,0

期末殘值,0.00,殘值計(jì)入本金,否,折現(xiàn)值,#NUM!,保證金存款利率,0.0000%,先付,1

保證金率,10.0000%,保證金,"500,000.00",手續(xù)費(fèi)率,2.0000%,手續(xù)費(fèi),"100,000.00",殘值計(jì)入本金代碼,是

供應(yīng)商折扣率,0.0000%,供應(yīng)商折扣額,0.00,管理費(fèi)率,0.0000%,管理費(fèi),0.00,,否

收益測(cè)算,,,,,,,,,

每期租金,,租金總額,"6,500,000.00",收回本金,"5,000,000.00",收回利息,"1,500,000.00",凈融資額現(xiàn)值,"4,400,000.00"

凈現(xiàn)值NPV,#NUM!,現(xiàn)值收益率,#NUM!,年化現(xiàn)值收益率,#NUM!,項(xiàng)目IRR（年付分次不計(jì)復(fù)利）,#NUM!,項(xiàng)目IRR（年付分次計(jì)算復(fù)利）,#NUM!

現(xiàn)金流量,,,,,,,,,

日期,租賃相關(guān)流入,利息,收回本金,尚未收回本金,其他現(xiàn)金流入,其他現(xiàn)金流出,現(xiàn)金流入,現(xiàn)金流出,凈現(xiàn)金流

起租日,"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

合計(jì),"6,500,000.00","1,500,000.00","5,000,000.00",,,,,,

,,,,,,,,,,

測(cè)算表說(shuō)明,,,,,,,,,

編者：阿不QQ:168320103，歡迎溝通討論，共同完善（本表格的只讀密碼為168320103，建議使用時(shí)另存為一份，保留原版本）。,,,,,,,,,

特別說(shuō)明（必看）：（2014-12-11）,,,,,,,,,

1.本表格支持任意自由現(xiàn)金流還款，包括指定任意一期的還款本息總額或還款本金或還款利息都可以計(jì)算，但本表格計(jì)算是半自動(dòng)的；上表只是給定每期歸還的本金計(jì)算的。,,,,,,,,,

2.手動(dòng)計(jì)算步驟，先確定年限和每年還款次數(shù)，然后手動(dòng)調(diào)整表格。,,,,,,,,,

3.手動(dòng)調(diào)整表格的原理：任意一期的本息總額=上一期本金產(chǎn)生的利息+本期應(yīng)該歸還的本金；如一年分4期，則上一期本金產(chǎn)生的利息=上一期本金*租賃利率/4。,,,,,,,,,

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

1.項(xiàng)目IRR計(jì)算方式在2014-09-22根據(jù)QQ41792052的修正為按復(fù)利計(jì)算，但由此導(dǎo)致貼現(xiàn)值去IRR時(shí)，凈現(xiàn)值不為零。在此加入項(xiàng)目IRR（年付分次不計(jì)復(fù)利）和項(xiàng)目IRR（年付分次計(jì)算復(fù)利）兩個(gè)項(xiàng)目IRR；貼現(xiàn)值=項(xiàng)目IRR（年付分次不計(jì)復(fù)利）時(shí)，凈現(xiàn)值為零；但項(xiàng)目IRR（年付分次計(jì)算復(fù)利）更能反映項(xiàng)目的真實(shí)收益情況（即計(jì)算了年付分次時(shí)非年底利息的復(fù)利，有點(diǎn)攪，可以想象下自然對(duì)數(shù)e=2.71828是怎么來(lái)的，呵呵）（感謝QQ569983574的使用反饋意見(jiàn)）。,,,,,,,,,

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

1.項(xiàng)目IRR計(jì)算方式修正為按復(fù)利計(jì)算（感謝QQ41792052的修正意見(jiàn)）。,,,