Lender reporting

Review forecast cash, debt, and sample covenant headroom for 2027. Forecast preparation only; not a lender submission.

Fictional ExampleCo data. All modeled months are forecasts.

Debt and liquidity

ExampleCo Services · January–December 2027 · USD

Scenario assumptions

Results update as you edit; linked tools carry your assumptions. Revenue growth and hiring are independent.

Month 1 revenue ($)Monthly revenue growth (%)Direct costs (% of revenue)Additional hiresCollection days (DSO)Monthly capital expenditure ($)

More assumptions: cost, working capital, financing, and taxes

Monthly fixed operating costs ($)Hires start in monthMonthly cost per hire ($)Supplier payment days (DPO)Opening cash ($)Opening gross debt ($)Opening receivables ($)Opening payables ($)Annual interest rate (%)Monthly debt repayment ($)Illustrative cash tax rate (%)

View updated overview ↑

Saved scenarios and case files

Keep up to eight named cases in this browser. Case files contain numeric assumptions only; decision notes, scorecard evidence, and lender checklist marks stay separate. Saving an existing name updates that case.

Case name

Import cases JSON

Import adds cases without changing the active scenario. Matching names with different assumptions receive a numbered name; identical cases are skipped.

Forecast monitoring only. All months are projected. An actual lender submission requires closed actuals, agreement-specific definitions, required schedules, and authorized sign-off.

Cash and leverage

Compare scenarios

Reference case

Numeric assumptions and results for the current and reference cases; no private notes.

The reference is Original Base. This table includes every assumption you change.

Save a named case in Scenario assumptions, then choose it here as a reference.

Monthly covenant headroom

Decision brief

Export results and assumptions with a decision and owner. Changing assumptions resets these decision fields.

Decision requested / next actionAccountable owner roleNext review date

Include saved scorecard owner roles, milestones, and review evidence in this brief

Preview the decision brief and assumption appendix

What the leverage exception means

Fixed fictional example · Downside preset · December 2027. These figures do not change with your edits.

The Downside preset ends December with $11.4M of gross debt and $2,752,082 of trailing EBITDA. Gross leverage is 4.14×, above the hypothetical 4.00× maximum.

How the example works and what to review

At unchanged debt, EBITDA would need to be $97,918 higher to reach 4.00×. At unchanged EBITDA, debt would need to be $391,672 lower. These are two views of the same ratio gap. They cannot be added together, do not show available borrowing capacity, and do not demonstrate that repayment is funded.

The next review is the forecast-to-actual EBITDA bridge, debt reconciliation, and executed agreement’s definitions and test dates. Confirm the source of any proposed repayment and whether operating assumptions are achievable. Escalate a projected exception early; this fictional forecast does not establish an actual covenant breach or a lender’s response.

Choose Downside in Scenario assumptions ↑

Model definitions and limits

January–December 2027 forecast. Historical TTM revenue is $24M; historical monthly EBITDA is $300,000. No historical seasonality is modeled.
Revenue grows monthly. Direct costs are a percentage of revenue. Additional hires become a fixed cost from the selected start month.
Receivables = monthly revenue × DSO ÷ 30; payables = monthly direct costs × DPO ÷ 30. These are steady-state approximations, not invoice-level collection or payment schedules. Opening balances stay fixed when you change assumptions.
Cash change = EBITDA − increase in receivables + increase in payables − interest − illustrative cash taxes − capex − debt repayment. Negative cash represents an unfunded gap; no automatic borrowing is assumed.
Interest is based on opening gross debt. Principal repayment cannot exceed debt outstanding. Cash taxes are a simplified rate on positive EBITDA less interest; depreciation, tax losses, and payment timing are excluded.
Hypothetical gross leverage = closing gross debt ÷ trailing 12-month EBITDA, without addbacks or cash netting. Nonpositive EBITDA is not meaningful. The sample maximum is 4.00×; sample minimum cash is $1M. These are illustrative monitoring limits, not contractual terms.
This model excludes a complete balance sheet, acquisitions, inventory, restricted cash, and a revolver. It is not a three-statement or 13-week cash model.

Reporting calendar

Example internal deadlines. Use your agreement’s contractual calendar.

Sample lender reporting preparation calendar
Target	Deliverable	Accountable owner
Day 3	Cash, debt, and receivables reconciliations	Controller
Day 6	Closed financials and variance commentary	Controller / FP&A
Day 8	Covenant calculation and supporting schedules	Finance lead
Day 9	Review exceptions and headroom; escalate issues	CFO
Day 10	Approved reporting pack ready for contractual delivery	CFO / authorized signatory

Download editable reporting calendar ↓

Submission checklist

Reviews save by month in this browser and reset when assumptions change. Checkmarks record review, not compliance.

Financial statements tie to the general ledger and reporting period.Bank balances, unrestricted cash, and debt balances reconcile.Covenant definitions, addbacks, exclusions, and testing dates checked against the executed agreement.EBITDA and working capital movements explained; forecasts distinguished from actuals.Supporting schedules and prior-period comparisons attached.Preparer and reviewer approvals completed; required signatory confirmed.Delivery recipients, deadline, secure channel, and submission evidence confirmed.

Download checklist ↓

Open rolling forecast →Open value creation plan →

ExampleCo Excel workbook

Editable assumptions, forecast, lender schedule, reporting calendar, and initiative tracker. No email required.

The workbook starts with the original Base case. Export CSV for your current browser scenario.

Download workbook ↓