EBITDA flows from the P&L on the FS, to where it is involved in the Tax Computation, calculating tax paid which flows through to the FS (Cashflow Waterfall).Capex flows into the D&T tab, where it feeds into the depreciation calculations, which go into the tax calculations (which feed back into the FS).Max Principal is calculated on the debt tab from sculpting calculations, and flows to the macro along with funding required, which when applied to the gearing ratio, calculates the max debt size.This is the crucial ingredient off which sculpting calculations are done, and debt ratios ( DSCR, LLCR, PLCR) are calculated. CFADS flows from the FS (CFW in particular) to the Debt tab.All the calculation modules flow into the financial statements, calculating the various line items in the Cashflow Waterfall, for example CFADS. The debt tab usually represents the repayment of debt, hence the drawdown (or the refinanced amount from construction facility to term loan) transfers. They are calculated on the Cons tab in order to match the timing between Uses of Capital and Sources of Capital. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |