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

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

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

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

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

租賃利率,7.6800%,租賃期限（年）,3,年付租次數(shù),4,租金支付方式,后付,后付,0

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

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

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

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

每期租金,"47,047,813.38",租金總額,"564,573,760.56",收回本金,"500,000,000.00",收回利息,"64,573,760.54",凈融資額現(xiàn)值,"440,000,000.00"

凈現(xiàn)值NPV,"28,663,921.70",現(xiàn)值收益率,6.5145%,年化現(xiàn)值收益率,2.1715%,項(xiàng)目IRR,10.8809%,,

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

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

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

合計(jì),"564,573,760.56","64,573,760.54","500,000,000.00",,,,,,

,,,,,,,,,,

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

編者：劉金鴻QQ:168320103，歡迎溝通討論，共同完善。,,,,,,,,,

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

1.本表僅支持等額本息還款方式，即每次還款金額相同，如需等額本金還款方式（等額本金還款、按月還款、半年還款、每年還款、自由還款另外再調(diào)整。,,,,,,,,,

2.折現(xiàn)率可以根據(jù)公司具體情況自由取值。,,,,,,,,,

3.未解決的問題：保證金在融資租賃合同執(zhí)行完畢后才退還給承租人，實(shí)際合同中，大部分用來(lái)抵扣最后幾期租金（手動(dòng)解決很方便，自動(dòng)解決待調(diào)整）。,,,,,,,,,

4.管理費(fèi)和手續(xù)費(fèi)默認(rèn)期初一次性交清，實(shí)際上手續(xù)費(fèi)一般期初一次性交清，但管理費(fèi)一般不是期初一次性付清。,,,,,,,,,

鳴謝：本表格以田剛版本（2008-07-20）為基礎(chǔ)修訂而成，沒有田大大這個(gè)表格什么都不是！,,,,,,,,,

1.