借款还本付息计算表表格文件下载.xls

1、借借款款还还本本付付息息计计划划表表1-91-9项目合计计算期1234567891011121314建设投资借款400010003000期初借款余额0106043043874344430142584215417241294864434本期还本付息688.2 662.4 636.6 610.8585 559.2 533.4 507.6 481.8460还本430430430430430430430430430434付息258.2 232.4 206.6 180.8155 129.2 103.4 77.64 51.84 26.04期末本息余额3874344430142584215417241294

2、8644340流动资金借款740395230115000000000期初借款余额395625740740740740740740740740740740当期还本付息15.82529.629.629.629.629.629.629.629.629.6 769.6还本00000000000740付息15.82529.629.629.629.629.629.629.629.629.629.6期末本息余额3956257407407407407407407407407400借款合计474010003000395230115期初本息余额01060469944994184375433242894246420

3、3416041174740740本期还本付息00704 687.4 666.2 640.4 614.6 588.8563 537.2 511.4 489.629.6 769.6还本004304304304304304304304304304340740付息00274 257.4 236.2 210.4 184.6 158.8133 107.2 81.44 55.6429.629.6期末本息余额004269406937543324289424642034160411747407400还本资金来源560072008000800080008000800080008000800080008000当期可

4、用于还本的未分配利润142 598.6 839.8 865.6 891.4 977.2100310291055108011551155当期可以用于还本的折旧费413413413413413413413413413413413413当期可用于还本的摊销费109109109109109109109109109109109109以前年度结余可用于还本资金00118 574.6 815.8 841.6 867.4 953.297910051031105611311131息税前利润4168561076107610761136113611361136113611851185利息背付率1.518 3.325 4.555 5.113 5.828 7.152 8.539 10.59 13.95 20.42 40.03 40.03偿债付率0.202 0.8711.26 1.3521.45 1.659 1.781 1.915 2.062 2.206 39.03 1.501总利润118 574.6 815.8 841.6 867.4 953.297910051031105611311131累计118 692.5150823503217417051496154718582419372 10504