借款还本付息估算表.xls

序年 份计 算 期号项 目1234561借款1（长期借款）1.1期 初 借 款余额07836432201566350780343038993817424.6011.2当期借款76104013318201141560570780001.3本 期 应 计利息2260386103164677225316255651.6006226755.02131.4本 期 还 本付息00007421264044179.622其 中：还本0000486474.39943817424.601付息0000255651.6006226755.02131.5期 末 借 款余额7836432201566350780343038993817424.60102借款2（流动资金）2.1期 初 借 款余额002.2当期借款268272.63580862.3本 期 应 计利息15935.3924 21270.30842.4本 期 还 本付息284207.9924379356.3084其 中：还本268272.6358086付息15935.3924 21270.30842.5期 末 借 款余额003债券003.1期 初 债 务余额003.2当 期 发 行债券003.3本 期 应 计利息003.4本 期 还 本付息00其 中：还本00付息003.5期 末 债 务余额004借 款 和 债券合计15672864403132701560686077985383618.1865029647.264.1期初余额0783643220156635078034.2当期借款76104013318201141560570780268272.63580864.3本 期 应 计利息2260386103164677225316271586.993248025.32974.4本 期 还 本付息00001026333.9924423535.93其 中：还本0000754746.99944175510.601付息000015935.3924421270.30844.5期末余额7836432201566350780343038993817424.60105还 款 资 金来源0000742126.01481409666.3375.1当 期 可 用于 还 本 的未 分 配 利润0000398424.01481065964.3375.2当 期 可 用于 还 本 的折 旧 和 摊销00003437023437025.3以 前 年 度结 余 可 用于 还 本 资金000005.4可 用 于 还款 的 其 他资金计算指标利 息 备 付率（%）00002.8973538525.812120814偿 债 备 付率（%）0.2084812540.063392320.031386350.020297290.1378489320.280271411建设期利息计算表时间第一年第二年第三年第四年总和时间年初欠款078364322015663507803总和当年借款76104013318201141560570780债务资金当年利息2260386103164677225316498699利息欠款累计783643220156635078034303899利润总额（1-2-3）-22603-86103-164677-225316531232.02 1421285.78利息支出2260386103164677225316 255651.601 20267.3988利润总额（1-2-3）0000786883.62 1441553.18折旧和摊销343702343702343702343702343702343702净利润-16952.25-64577.3-123508-168987 398424.015 1065964.34可用于还本付息的资金326749.75 279124.8 220194.3174715 742126.015 1409666.34789101112131400000000040738240738240738240738240738240738240738240738224198.4908 24198.49 24198.49 24198.49 24198.49 24198.49 24198.49 24198.49431580.4908431580.491431580.491431580.491431580.491431580.491431580.491431580.49140738240738240738240738240738240738240738240738224198.4908 24198.49 24198.49 24198.49 24198.49 24198.49 24198.49 24198.49000000000000000000000000000000000000000000000000000000000000000000000000431580.4908431580.491431580.491431580.491431580.491431580.491431580.491431580.4910407382407382407382407382407382407382407382407382计 算 期24198.490824198.490824198.490824198.490824198.490824198.490824198.490824198.490840738240738240738240738240738240738240738240738224198.490824198.490824198.490824198.490824198.490824198.490824198.490824198.490859.4704297168.590091468.590091468.590091468.590091468.590091468.590091468.59009143.2551844823.638685453.638685453.638685453.638685453.638685453.638685453.63868545流动估资估算第五年第六年达产后447121596810678970268272.635808640738215935.3924 21270.31 24198.491414896.16163557816355781635578163557816355781635578163557824198.4908 24198.49 24198.49 24198.49 24198.49 24198.49 24198.49 24198.491439094.6516597771659777165977716597771659777165977716597773437023437023437023437023437023437023437023437021061172.1212266841226684122668412266841226684122668412266841404874.12157038615703861570386157038615703861570386157038615161718192021222300000000040738240738240738240738240738240738240738240738240738224198.49 24198.49 24198.49 24198.49 24198.49 24198.49 24198.49 24198.49 24198.49431580.491431580.491431580.491431580.491431580.491431580.49 431580.491431580.491431580.49140738240738240738240738240738240738240738240738240738224198.49 24198.49 24198.49 24198.49 24198.49 24198.49 24198.49 24198.49 24198.49000000000000000000000000000000000000000000000000000000000000000000000000000000000431580.491431580.491431580.491431580.491431580.491431580.49 431580.491431580.491431580.49140738240738240738240738240738240738240738240738240738224198.490824198.490824198.490824198.490824198.490824198.491 24198.490824198.490824198.490840738240738240738240738240738240738240738240738240738224198.490824198.490824198.490824198.490824198.490824198.491 24198.490824198.490824198.490868.590091468.590091468.590091468.590091468.590091468.590091 68.590091468.590091468.59009143.638685453.638685453.638685453.638685453.638685453.6386855 3.638685453.638685453.6386854516355781635578163557816355781635578163557816355781635578163557824198.49 24198.49 24198.49 24198.49 24198.49 24198.49 24198.49 24198.49 24198.4916597771659777165977716597771659777165977716597771659777165977734370234370234370234370234370234370234370234370234370212266841226684122668412266841226684122668412266841226684122668415703861570386157038615703861570386157038615703861570386157038624040738224198.49431580.49140738224198.49000000000431580.49140738224198.490840738224198.490868.59009143.63868545163557824198.49165977734370212266841570386