Sample deliverable
Financial Model Review, on a synthetic model
What the review delivers, shown on a synthetic company's five-year model as a lender would receive it: the issues ranked by their effect on the result, with cell references, the assumptions listed with their sources, and the sensitivity of the result to the main drivers.
The model shows coverage of at least 5.21x. Corrected, operating cash covers 0.89x of 2026 debt service.
The company and the model are made up for this sample, and six errors were placed in the model on purpose. As built, the model tells a lender that debt service is covered at least 5.21x over the five years. With the six errors corrected, and coverage measured as a lender measures it, on cash available for debt service, operations cover 0.89x of interest and principal in 2026 and at least 1.00x from 2027 on. In 2026 the shortfall is paid from the opening cash, which falls by $166,406. The first year depends on that cash, which the model as built does not show.
| Result | As built | Corrected |
|---|---|---|
| Minimum debt service coverage, 2026 to 2030 | 5.21x | 0.89x |
| Lowest year-end cash, 2026 to 2030 | $1,930,498 | $1,683,594 |
| Cash at the end of 2030 | $5,973,140 | $3,163,911 |
| Net income, 2030 | $2,815,373 | $2,125,733 |
| Net income, 2026 to 2030 | $9,282,197 | $8,329,470 |
| Largest balance sheet imbalance | $1,833,490 | $0 |
| By year | 2026 | 2027 | 2028 | 2029 | 2030 |
|---|---|---|---|---|---|
| Coverage, as built | 5.21x | 6.94x | 9.48x | 17.38x | 28.51x |
| Cash available for debt service, corrected | $1,313,594 | $1,444,049 | $1,579,914 | $1,718,727 | $1,857,627 |
| Interest and principal, corrected | $1,480,000 | $1,400,000 | $1,320,000 | $1,240,000 | $1,160,000 |
| Coverage, corrected | 0.89x (below 1.00x) | 1.03x | 1.20x | 1.39x | 1.60x |
| Cash, corrected | $1,683,594 | $1,727,643 | $1,987,557 | $2,466,284 | $3,163,911 |
Issues, ranked by their effect on the result
Each effect is measured by adding that error alone to the corrected model and letting Excel recalculate it. The issues are ranked by their effect on minimum coverage, then on 2030 cash, the two figures a lender reads first. Cash effects are cumulative to 2030; net income effects are for 2030 alone.
The debt service coverage ratio divides EBITDA by interest, instead of cash available for debt service by interest and principal
Model!C40:G40 =C9/C12 uses EBITDA and Interest expense instead of Cash available for debt service and Debt service (interest and principal).
This error alone: coverage +4.32x; 2030 cash no change; 2030 net income no change.
The change in receivables enters the cash flow with the wrong sign
Model!C26 Assets and liabilities plus equity differ from 2026E on, by 1,833,490 in 2030E.
Model!C30:G30 =C18-B18 adds the increase in receivables to cash; inventory, correctly, subtracts it (=B19-C19).
This error alone: coverage +0.25x; 2030 cash +$1,864,621; 2030 net income no change.
Tax computed on operating profit (EBIT) instead of profit before tax
Model!C14:G14 =MAX(0,C11*Assumptions!C9) uses EBIT instead of Profit before tax.
This error alone: coverage -0.08x; 2030 cash -$400,000; 2030 net income -$40,000.
EBITDA for 2030 leaves out research and development
Model!G9 =G6-G7 against the row's pattern, for example =C6-C7-C8 in 2026E.
This error alone: coverage no change; 2030 cash +$748,577; 2030 net income +$748,578.
Cost of goods sold for 2029 computed on the prior year's revenue
Model!F5 =E4*(1-Assumptions!F4) against the row's pattern, for example =C4*(1-Assumptions!C4) in 2026E.
This error alone: coverage no change; 2030 cash +$652,430; 2030 net income no change.
Revenue for 2028 typed in as a number
Model!E4 The cell holds 16,850,000 where the rest of the row computes the value.
This error alone: coverage no change; 2030 cash -$16,408; 2030 net income -$14,203.
Also noted
- Model!B26:G26 Check row hidden: The balance check is formatted in white text, so its result cannot be seen.
- Assumptions!H Assumptions without a source: SG&A, % of revenue; R&D, % of revenue; D&A, % of revenue; Capex, % of revenue; Inventory days; Payable days
Every input, with its source
In a client review each assumption also gets an owner, the person who answers for it. This sample has no client, so the owner column is left for the call.
| Assumption | Value | Source given in the model | Owner |
|---|---|---|---|
| Revenue growth | 12% falling to 8% | Management plan, March 2026 | To be named |
| Gross margin | 43% | 2025 audited accounts | To be named |
| SG&A, % of revenue | 20% | None given | To be named |
| R&D, % of revenue | 5% | None given | To be named |
| D&A, % of revenue | 3% | None given | To be named |
| Capex, % of revenue | 4% | None given | To be named |
| Tax rate | 25% | Statutory rate | To be named |
| Receivable days | 45 | 2025 audited accounts | To be named |
| Inventory days | 60 | None given | To be named |
| Payable days | 40 | None given | To be named |
| Interest rate on term loan | 8% | Term sheet | To be named |
| Annual principal repayment | $1,000,000 | Term sheet | To be named |
Corrected model: how much room the plan has
Minimum debt service coverage and cash at the end of 2030, when revenue growth and gross margin move two points from the plan in each year. Each cell is a separate Excel recalculation of the corrected model.
| Gross margin | Growth -2 points | Growth as planned | Growth +2 points |
|---|---|---|---|
| -2 points | 0.75x * $1,728,269 | 0.74x * $1,871,438 | 0.73x * $2,015,732 |
| as planned | 0.90x * $2,947,589 | 0.89x * $3,163,911 | 0.88x * $3,385,216 |
| +2 points | 1.04x $4,166,909 | 1.04x $4,456,383 | 1.03x $4,754,700 |
* Below 1.00x: operations do not cover debt service in at least one year. Margin moves the result more than growth does: two points of margin change minimum coverage by about 0.15x and 2030 cash by about $1,292,473; two points of growth, by about 0.01x and $218,814.
What this sample is and is not
- It is a sample, not client work. The company and its model are synthetic, and the six errors were placed on purpose. The model as built can be downloaded and opened in Excel.
- The checks read the formulas in the workbook: formulas that change pattern across a row, numbers typed into formula rows, the balance check, the signs of the working-capital lines, lines whose formula does not use what the label names, hidden rows, and assumptions without a source. The run stops if the checks miss any of the six errors.
- Every figure on this page comes from values Microsoft Excel calculated, from a copy of the model per case; the differences between them are computed when the page is built. Figures generated on 2026-11-15.
- Coverage is cash available for debt service (EBITDA less tax, capital expenditure and the change in working capital) divided by interest and principal.
- Scripted checks find structural errors. Whether an assumption is reasonable for the business is a judgment, and a client review includes it: the memo comments on each assumption's source and on the ones that move the result most.
- A review checks that the model computes what it claims to. It is not a valuation, a credit opinion or a fairness opinion.
The same review, on your model.
$1,900 fixed, five business days. Tell us who will read the model and what decision it supports.