融资租赁综合成本测算模板表格文件下载.xls

融资租赁综合成本测算模板表格文件下载.xls

《融资租赁综合成本测算模板表格文件下载.xls》由会员分享，可在线阅读，更多相关《融资租赁综合成本测算模板表格文件下载.xls（2页珍藏版）》请在冰豆网上搜索。

设备净值综综合合成成本本测测算算融资额200,000,000.00费用总计15,834,671.95租赁利率4.750000%加权融资额220,098,356.72租赁手续费5,000,000.00综合成本率7.194362%保证金4,000,000.00基准上浮浮度51.460247%首付款期期次次租租金金金金额额每每期期计计息息本本金金金金额额应应确确认认融融资资租租赁赁费费用用应应付付本本金金减减少少额额应应付付本本金金余余额额加加权权融融资资金金额额第第11期期26,354,333.99200,000,000.002,375,000.0023,979,333.99176,020,666.0149,000,000.00第2期26,354,333.99176,020,666.012,090,245.4124,264,088.58151,756,577.4343,005,166.50第3期26,354,333.99151,756,577.431,802,109.3624,552,224.63127,204,352.8036,939,144.36第4期26,354,333.99127,204,352.801,510,551.6924,843,782.30102,360,570.5030,801,088.20第第55期期26,354,333.99102,360,570.501,215,531.7725,138,802.2277,221,768.2824,590,142.63第6期26,354,333.9977,221,768.28917,008.5025,437,325.4951,784,442.7918,305,442.07第7期26,354,333.9951,784,442.79614,940.2625,739,393.7326,045,049.0611,946,110.70第8期26,354,333.9926,045,049.06309,284.9626,045,049.030.035,511,262.27合合计计210,834,671.92210,834,671.9210,834,671.9510,834,671.95199,999,999.97199,999,999.97220,098,356.72220,098,356.72设备净值综综合合成成本本测测算算融资额200,000,000.00费用总计14,435,000.00租赁利率3.980000%加权融资额325,000,000.00租赁手续费1,500,000.00综合成本率4.441538%保证金-基准上浮浮度-6.493927%首付款期期次次租租金金金金额额每每期期计计息息本本金金金金额额应应确确认认融融资资租租赁赁费费用用应应付付本本金金减减少少额额应应付付本本金金余余额额加加权权融融资资金金额额第第11期期18,656,666.67200,000,000.001,990,000.0016,666,666.67183,333,333.3350,000,000.00第2期18,490,833.33183,333,333.331,824,166.6716,666,666.67166,666,666.6745,833,333.33第3期18,325,000.00166,666,666.671,658,333.3316,666,666.67150,000,000.0041,666,666.67第4期18,159,166.67150,000,000.001,492,500.0016,666,666.67133,333,333.3337,500,000.00第第55期期17,993,333.33133,333,333.331,326,666.6716,666,666.67116,666,666.6733,333,333.33第6期17,827,500.00116,666,666.671,160,833.3316,666,666.67100,000,000.0029,166,666.67第7期17,661,666.67100,000,000.00995,000.0016,666,666.6783,333,333.3325,000,000.00第8期17,495,833.3383,333,333.33829,166.6716,666,666.6766,666,666.6720,833,333.33第9期17,330,000.0066,666,666.67663,333.3316,666,666.6750,000,000.0016,666,666.67第10期17,164,166.6750,000,000.00497,500.0016,666,666.6733,333,333.3312,500,000.00第11期16,998,333.3333,333,333.33331,666.6716,666,666.6716,666,666.678,333,333.33第12期16,832,500.0016,666,666.67165,833.3316,666,666.670.004,166,666.67合合计计212,935,000.00212,935,000.0012,935,000.0012,935,000.00200,000,000.00200,000,000.00325,000,000.00325,000,000.00