融资租赁实际利率计算表

融资租赁实际利率计算 表 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf 利用这张表，可以项目交行一期二期三期一本金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.58-581,196.58票额合计6,273,504.276,418,803.426,418,803.42三基期获得本金93,726,495.7393,581,196.5893,581,196.581本息合计当期还款额-5,839,577.31-5,802,285.77-5,936,396.882本息合计当期还款额-5,954,577.31-5,836,063.55-5,836,063.553本息合计当期还款额-5,954,577.31-5,836,063.55-5,836,063.554本息合计当期还款额-5,954,577.31-5,836,063.55-5,836,063.555本息合计当期还款额-5,895,204.79-5,836,063.55-5,836,063.556本息合计当期还款额-5,895,204.79-5,836,063.55-5,836,063.557本息合计当期还款额-5,895,204.79-5,836,063.55-5,836,063.558本息合计当期还款额-5,895,204.79-5,836,063.55-5,836,063.559本息合计当期还款额-5,895,204.79-5,836,063.55-5,836,063.5510本息合计当期还款额-5,895,204.79-5,836,063.55-5,836,063.5511本息合计当期还款额-5,895,204.79-5,836,063.55-5,836,063.5512本息合计当期还款额-5,895,204.79-5,836,063.55-5,836,063.55本息合计-116,026,585.88-113,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.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.63-18,411,597.18-8,974,083.331,300,248.47-18,659,083.63-18,411,597.18-8,710,316.891,642,013.89-18,548,190.42-18,411,597.18-8,463,147.331,375,319.44-18,548,190.42-18,411,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.94-107,469,583.08-54,042,742.437,042,742.435.258%4.601%4.513%3.903%9.2297%7.9594%￥-9,999,512.00者融资。表中数据均为举例数据。如果考虑获得利息的增值税，可参考平安租赁数据。安租赁利息对应的增值税合计利息测算利息对应的增值税500000001000000003个月付息一次12只有160万元有VAT22000003000000300000014000000-232478.6325-232478.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.34-9,128,333.331,430,462.17207,844.93238,583.21-8,471,733.68-9,128,333.331,320,347.03191,845.30199,832.74-8,263,314.59-9,128,333.331,208,656.74175,616.79159,660.70-8,048,018.63-9,128,333.331,095,368.76159,156.15119,369.59-7,832,841.74-9,128,333.33980,460.24142,460.0478,523.30-7,615,505.59-9,128,333.33863,908.00125,525.0938,409.91-4,002,865.42-9,128,333.33745,688.53108,347.91-9,128,333.33625,777.9690,925.00-9,128,333.33504,152.1373,252.87-9,128,333.33380,786.4855,327.95-7,628,333.33255,656.1337,146.62-7,628,333.33128,735.8418,705.211,023,304.46-53,019,437.97#############5.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.24-9,019,985.43-9,037,408.33-9,055,080.46-9,073,005.38-7,591,186.72-7,609,628.13############3.783%1.726%7.0846%