Forecasting the Balance Sheet — Working Capital, PP&E, Debt, and the Plug

Working capital is often the most underestimated component of the capital investment required to grow a business. A company growing revenue at 20% per year with 45 days of receivables and 30 days of inventory must fund the cash tied up in these assets every year — and this funding requirement is a direct reduction of free cash flow. The balance sheet forecast must translate revenue and margin assumptions into specific working capital balances, and the change in those balances feeds directly into the FCFF calculation.

Property, plant, and equipment (PP&E) is the balance sheet's record of cumulative capital investment in long-lived productive assets. The PP&E rollforward is the mechanical link between capex (the investment in new assets) and D&A (the cost allocation of those assets' economic consumption). The rollforward must be built for every model — not because it is complex, but because it is where capex and D&A assumptions must be made consistent with each other.

The capex and D&A assumptions must be mutually consistent. A company with $500M of gross PP&E at an average 8% annual depreciation rate needs $40M of capex just to keep the asset base constant (maintenance capex = D&A). The $55M–$75M capex in the above forecast represents $15–35M of growth capex above maintenance — consistent with modest revenue growth. A forecast showing $100M of capex but only $20M of D&A implies the company is dramatically growing its asset base — the model must justify this expansion with corresponding revenue growth.

The debt schedule tracks the company's financial obligations and is the bridge between the income statement (interest expense) and the balance sheet (total debt). For LBO models and highly leveraged companies, the debt schedule is elaborate — but even for investment-grade companies, it must be built correctly to produce consistent FCFF and FCFE figures.

• Term loan / bond amortization: any debt with a fixed repayment schedule (term loan A or B, scheduled bond redemptions) must be modeled with explicit annual repayments. The interest expense for each debt tranche = Beginning Balance × Interest Rate. The ending balance = beginning balance − scheduled repayments. This produces the correct interest expense line in the income statement and the correct debt balance in the balance sheet.
• Revolving credit facility (revolver): the revolver is a flexible borrowing line that the company draws or repays based on its cash needs. The model draws the revolver when the company needs cash (before minimum cash balance) and repays it when excess cash is generated. For companies with seasonal working capital needs, the revolver often peaks mid-year and repays by year-end. The mechanics: if after all operating cash flows and fixed debt service the cash balance would fall below minimum, draw revolver to restore; if cash balance exceeds minimum, sweep revolver repayment first.
• Cash sweep mechanism: in LBO models and covenant-heavy debt structures, excess cash is automatically applied to debt repayment ('cash sweep'). The sweep provisions are typically: 50% or 75% of excess cash flow (defined precisely in the credit agreement) applied to term loan prepayment in order of maturity. The model must implement this mechanically: compute available excess cash flow, apply the sweep percentage, reduce the term loan balance accordingly.
• Interest coverage and leverage covenants: most debt structures include financial maintenance covenants — ratios like Net Debt/EBITDA ≤ 4.0× or Interest Coverage ≥ 3.0× that must be maintained throughout the forecast period. The debt schedule must flag when these covenants are at risk of breach — because a breach triggers immediate repayment obligations that can change the entire model's cash flow structure.

In a linked three-statement model, the equity section of the balance sheet is the balancing item — it is not independently forecast but calculated from the income statement and other equity transactions. This is the 'plug' that makes the balance sheet balance: