Dynamic Debt & Liquidity Schedule Updated Technical Summary:...

Dynamic Debt & Liquidity Schedule

Updated Technical Summary:

Debt Reclassification: Implemented a US GAAP-compliant structure that reclassifies long-term liabilities into the Current Portion of Long-Term Debt (CPLTD) as they approach maturity.

Liquidity Analysis: Designed the Current Liabilities section to distinguish between operational credit (Revolvers) and structural principal payments, providing a more accurate Current Ratio.

Model Integrity: Tied the debt balances directly to the Financing section of the Cash Flow Statement, ensuring that every dollar of repayment or issuance is accounted for in the cash "tie."

Advanced "Plug" Logic: Set the foundation for a dynamic cash sweep where short-term debt acts as a buffer to maintain a positive cash balance during low-liquidity quarters.