融资租赁实际利率计算表

1、融资租赁实际利率计算表项目交行-期二期三期本金100,000,000.00100,000,000.00100,000,000.00银行名义利率6.900%6.080%6.080%期限每3个月付本息*5年每3个月付本息*5年每3个月付本息*5年二期数202020先付手续费5,000,000.004,000,000.004,000,000.00先付保证金2,000,000.003,000,000.003,000,000.00剔除可取得手续费增值税发票额726,495.73-581,196.58581,196.58合计6,273,504.276,418,803.426,418,803.42三基期获得

2、本金93,726,495.7393,581,196.5893,581,196.581本息合计当期还款额5,839,577.31-5,802,285.775,936,396.882本息合计当期还款额-5,954,577.31-5,836,063.555,836,063.553本息合计当期还款额-5,954,577.31-5,836,063.555,836,063.554本息合计当期还款额-5,954,577.31-5,836,063.555,836,063.555本息合计当期还款额5,895,204.79-5,836,063.555,836,063.556本息合计当期还款额5,895,204.7

3、9-5,836,063.555,836,063.557本息合计当期还款额5,895,204.79-5,836,063.555,836,063.558本息合计当期还款额5,895,204.79-5,836,063.555,836,063.559本息合计当期还款额5,895,204.79-5,836,063.555,836,063.5510本息合计当期还款额5,895,204.79-5,836,063.555,836,063.5511本息合计当期还款额5,895,204.79-5,836,063.555,836,063.5512本息合计当期还款额5,895,204.79-5,836,063.555

4、,836,063.55本息合计116,026,585.88113,687,493.22-113,821,604.33按单利计算的名义利率4.759%4.297%4.326%每期按复利计算的实际利率2.161%1.977%1.992%年率8.9263%8.1446%8.2077%利用这张表，可15%年利率36月份数100000贷款本金pmt函数-3,466.53求月还款额22%年利率36月份数100000贷款本金单变量求解功能-3,800.00求月还款额以准确的测算融资租赁的实际利率，便于各借款人在各金融机构间选择成本较低者鬲招行平安，期二期利息100,000,000.00100,000,000

5、.00500000006.650%5.843%6.9766个月付息一次*3年6个月付息一次*3年每6个月付息一次6673,000,000.003,000,000.0022000005,000,000.003,000,000.003000000-435,897.448,000,000.005,564,102.565,200,000.00-92,000,000.0094,435,897.4444,800,000.00-18,659,083.63411,597.18-8,974,083.331,300,248.4718,659,083.63411,597.18-8,710,316.891,642,0

6、13.89-18,548,190.42411,597.18-8,463,147.331,375,319.44-18,548,190.42411,597.18-8,207,679.331,098,841.32-18,548,190.42-18,411,597.18-7,952,211.33821,543.64-13,548,190.42-15,411,597.18-7,694,028.89540,425.08-4,041,275.33264,350.59-106,510,928.94107,469,583.08-54,042,742.437,042,742.435.258%4.601%4.513

7、%3.903%9.2297%7.9594%-9,999,512.00虫资。表中数据均为举例数据。如果考虑获得利息的增值税，可参考平安租赁数据。阻赁汝!算利思对丿W的增值合计利息利息对应的增值税500000001000000003个月付息一次12只有160万元有VAT22000003000000300000014000000232478.6325232478.6325-435897.44-232,478.634,967,521.3716,564,102.56232,478.6345,032,478.6383,435,897.44188,924.99-8,785,158.349,128,333.3

8、31,430,462.17207,844.93238,583.21-8,471,733.689,128,333.331,320,347.03191,845.30199,832.74-8,263,314.599,128,333.331,20&656.74175,616.79159,660.70-8,048,018.639,128,333.331,095,368.76159,156.15119,369.597,832,841.749,128,333.33980,460.24142,460.0478,523.307,615,505.599,128,333.33863,908.00125,525.09

9、38,409.91-4,002,865.429,128,333.33745,688.53108,347.919,128,333.33625,777.9690,925.009,128,333.33504,152.1373,252.879,128,333.33380,786.4855,327.957,628,333.33255,656.1337,146.627,628,333.33128,735.8418,705.211,023,304.46-53,019,437.97U上丄上77trIlli11IIIILLTfTTTTJJ77111111TTJTJJJJTT5.067%7.912%4.629%-6.257%9.4727%-12.1224%合计1000000003个月付息一次123,000,000.003,000,000.00-435897.445,564,102.5694,435,897.44-8,920,488.40-8,936,488.04-8,952,716.54-8,969,177.19-8,985,873.30-9,002,808.