租赁成本收益测算表8-23VIP

融资租赁收益成本计算,,,,,,,,,,

项目参数,,,,,,,,,,

租赁贷款融资额,1000000,租赁物价格,1000000,手续费率,1%,,,,,

租赁利率（名义利率）,7.83%,租赁期限（年）,5,手续费,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