融資租賃收益成本計算,,,,,,,,,,

項目參數,,,,,,,,,,

租賃貸款融資額,1000000,租賃物價格,1000000,手續(xù)費率,1%,,,,,

租賃利率（名義利率）,7.83%,租賃期限（年）,5,手續(xù)費,10000,,,,,

期末殘值,0,年付款次數,4,租金支付方式,先付,,,,,

保證金率,10%,保證金,100000,總期數,20,,,,,

供應商折扣,0,供應商折扣額,0,基準利率（基準利率）,4.35%,,,,,

融資租賃收益測算,,,,,,,,,,

每期租金,50000,租金總額,"1,000,000.00",總利息,"205,537.50",,,,,

總支出,"1,205,537.50",回報率(NPV),11.55%,內部報酬率IRR,3%,,,,,

客戶成本測算,,,,,,,,,,

名義利率,7.83%,實際利率,11.55%,,,,,,,

日期,租賃相關流入,利息,本金收回,未收回本金,其他現金流入,其他現金流出,現金流入,現金流出,凈現金流,凈現值

起租日,"110,000.00",-,-,"1,000,000.00",-,"1,000,000.00","110,000.00","1,000,000.00","-890,000.00","￥-890,000.00"

1,"69,575.00","19,575.00","50,000.00","950,000.00",-,-,"69,575.00",-,"69,575.00","￥68,838.29"

2,"68,596.25","18,596.25","50,000.00","900,000.00",-,-,"68,596.25",-,"68,596.25","￥67,151.26"

3,"67,617.50","17,617.50","50,000.00","850,000.00",-,-,"67,617.50",-,"67,617.50","￥65,492.23"

4,"66,638.75","16,638.75","50,000.00","800,000.00",-,-,"66,638.75",-,"66,638.75","￥63,860.80"

5,"65,660.00","15,660.00","50,000.00","750,000.00",-,-,"65,660.00",-,"65,660.00","￥62,256.59"

6,"64,681.25","14,681.25","50,000.00","700,000.00",-,-,"64,681.25",-,"64,681.25","￥60,679.18"

7,"63,702.50","13,702.50","50,000.00","650,000.00",-,-,"63,702.50",-,"63,702.50","￥59,128.20"

8,"62,723.75","12,723.75","50,000.00","600,000.00",-,-,"62,723.75",-,"62,723.75","￥57,603.27"

9,"61,745.00","11,745.00","50,000.00","550,000.00",-,-,"61,745.00",-,"61,745.00","￥56,103.99"

10,"60,766.25","10,766.25","50,000.00","500,000.00",-,-,"60,766.25",-,"60,766.25","￥54,630.01"

11,"59,787.50","9,787.50","50,000.00","450,000.00",-,-,"59,787.50",-,"59,787.50","￥53,180.96"

12,"58,808.75","8,808.75","50,000.00","400,000.00",-,-,"58,808.75",-,"58,808.75","￥51,756.46"

13,"57,830.00","7,830.00","50,000.00","350,000.00",-,-,"57,830.00",-,"57,830.00","￥50,356.17"

14,"56,851.25","6,851.25","50,000.00","300,000.00",-,-,"56,851.25",-,"56,851.25","￥48,979.74"

15,"55,872.50","5,872.50","50,000.00","250,000.00",-,-,"55,872.50",-,"55,872.50","￥47,626.80"

16,"54,893.75","4,893.75","50,000.00","200,000.00",-,-,"54,893.75",-,"54,893.75","￥46,297.03"

17,"53,915.00","3,915.00","50,000.00","150,000.00",-,-,"53,915.00",-,"53,915.00","￥44,990.07"

18,"52,936.25","2,936.25","50,000.00","100,000.00",-,-,"52,936.25",-,"52,936.25","￥43,705.60"

19,"51,957.50","1,957.50","50,000.00","50,000.00",-,-,"51,957.50",-,"51,957.50","￥4