Debt maturities and cash reserves: build a funding worksheet beyond net debt

Start with the payment calendar

A company can report a manageable-looking net debt number and still face an uncomfortable payment deadline. Net debt summarizes selected balances; it does not tell you when principal must be repaid, which cash is available, or how much money the business needs to keep operating. A useful debt review therefore puts amounts on a calendar before reaching a conclusion about financial flexibility.

This worksheet is designed for reading the disclosures of a nonfinancial operating company. It is not a credit rating or a model for banks and insurers, whose funding structures require different analysis. The example company is entirely fictional. The aim is to identify the evidence needed for a funding assessment, not to label a real stock safe or unsafe from one ratio.

Find the three parts of the evidence

The SEC’s financial-statement guide distinguishes a balance sheet, which describes a position at a reporting date, from cash flows over a period. That distinction is the foundation of the worksheet: starting cash is a balance, future cash generation is an assumption, and scheduled repayments are uses of cash at particular times.

The SEC’s guide to reading a 10-K points readers to financial statements and their notes, alongside management’s discussion of liquidity and capital resources. For a practical review, open the latest annual filing, the subsequent quarterly filing and any later financing disclosure. Record the reporting date separately from the filing date so an old balance is not treated as today’s cash.

Locate the debt note, cash disclosures and management’s financing discussion. Copy the relevant page or section reference into your worksheet. If a maturity table and the balance-sheet debt figure differ, investigate the stated basis before forcing them to match. Preserve unexplained differences as open questions.

Define debt and cash before subtracting them

Assume fictional Harbor Components reports 30 million dollars of current borrowings and 90 million of long-term borrowings. For this exercise, gross borrowing principal totals 120 million. It also has 45 million of trade payables. We keep those payables outside this narrow borrowing subtotal, while remembering that suppliers still need to be paid through the operating cash budget.

Harbor reports 30 million of cash-related balances, but our explicit example assumes that 10 million cannot be used for the debt payments being studied. Subtracting all 30 million produces a simple net borrowing figure of 90 million. Subtracting only the 20 million available for this exercise produces 100 million. Neither calculation changes the 120 million of borrowing principal outstanding.

These are defined worksheet measures, not a claim that every issuer calculates net debt this way. State whether a real company’s measure includes leases, investments or other adjustments. Use its reconciliation when available, and avoid comparing differently defined figures as though they were identical. Never assume that a reported asset can fund a repayment without checking the relevant disclosure.

A positive year-end cash balance can still miss the reserve

Continue the hypothetical example. Harbor starts with 20 million of available cash. Assume it generates 25 million of net operating cash during the next year, spends 12 million on capital projects and repays 30 million of principal. Under those assumptions, ending cash is 20 plus 25 minus 12 minus 30, or 3 million.

Now suppose management needs a minimum operating cash reserve of 15 million. That reserve is an explicit assumption in this example, not a universal financial rule. The business finishes 12 million below the assumed reserve despite having a positive ending balance. The useful question is how it would cover that gap or change its spending plan—not whether three million is greater than zero.

The operating cash assumption here already includes cash interest and routine operating payments. Do not subtract those payments again. Principal repayment and the stated capital spending are separate uses. For an actual filing, inspect how the relevant cash flows are presented and make the worksheet internally consistent before calculating a funding need.

Test borrowing capacity as a separate scenario

Suppose Harbor also has a 20 million undrawn credit facility. In the base scenario, a 12 million draw would restore the assumed cash reserve, leaving eight million of the stated facility unused. That is an arithmetic possibility, not proof that the company can draw or that borrowing is its preferred response.

Investor.gov’s corporate-bond bulletin explains that debt terms can contain covenants, including restrictions on borrowing or financial-ratio requirements. The general lesson is to read contractual conditions rather than treating a headline financing amount as unconditional cash. A specific credit facility must be assessed from its own terms; a bond bulletin does not establish those terms.

Record the facility’s expiry, disclosed conditions and any existing usage. Keep a proposed refinancing separate from a completed financing. If the source does not establish availability, leave the scenario conditional. An announced intention to borrow does not create money in the opening cash balance, and unused capacity should not be subtracted from gross debt as though it were a cash asset.

These simplified funding scenarios exclude incremental interest and fees on new borrowing and other unstated cash movements. Adding those costs could increase the required funding; the worksheet is not a complete financing forecast.

Change cash generation before changing the conclusion

Run a second explicitly hypothetical case with operating cash generation of only 10 million, holding capital spending and principal repayments unchanged. Ending cash before new financing becomes 20 plus 10 minus 12 minus 30, or negative 12 million. Reaching the same 15 million reserve now requires 27 million of additional funding or equivalent changes in cash uses.

Even if the entire assumed 20 million facility were drawable, ending cash would be eight million, leaving a seven million gap to the reserve. This does not predict default. It identifies the remaining question in this simplified scenario: could spending be deferred, other funding be completed, or operating cash recover, and what evidence supports each possibility?

Do not turn an illustrative downside case into a probability estimate. Explain which input changed and why that input would matter. A sensitivity is most useful when another reader can reproduce it and see precisely what evidence would invalidate the assumption.

Check timing inside the year

Annual totals can conceal an earlier shortfall. Suppose 10 million of Harbor’s annual principal repayments falls due before any of the assumed net cash inflows arrive. Starting from 20 million, that payment leaves 10 million, already five million below the assumed operating reserve. This is a timing illustration within the same annual principal total, not an additional ten million payment.

For a real company, place material maturities and expected cash uses into the periods disclosed. Use monthly or quarterly detail only where evidence supports it. Do not spread seasonal cash generation evenly across the year just to make the spreadsheet look complete.

Investor.gov describes maturity as the time principal comes due and distinguishes fixed from floating interest arrangements. For this worksheet, principal timing comes first; any interest-rate scenario belongs in a separately documented cash forecast. A fixed coupon does not remove the obligation to repay principal, while a distant maturity does not answer questions about nearer operating payments.

Finish with a short, dated research conclusion

A useful conclusion names the starting resources, the next material deadline, the assumed cash generation and the condition that would change the assessment. For Harbor, the base case needs 12 million to preserve the assumed reserve; the weaker-cash case needs 27 million. The assumed facility may cover the former, but not all of the latter. All of those conclusions remain conditional on the fictional inputs.

When updating a real company note, replace assumptions only with identified new evidence. A completed refinancing, a changed repayment schedule or revised cash-generation disclosure could matter more than a small movement in a net debt ratio. Keep the previous calculation so the reason for the change stays visible.

The three educational sources below come from the SEC and its Investor.gov website, one originating institution. They support the reading framework, not the hypothetical numbers. Use the company’s actual filings for the final assessment, and preserve uncertainty wherever those filings do not answer the funding question.