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.

ResultAs builtCorrected
Minimum debt service coverage, 2026 to 20305.21x0.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 year20262027202820292030
Coverage, as built5.21x6.94x9.48x17.38x28.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, corrected0.89x (below 1.00x)1.03x1.20x1.39x1.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.

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

AssumptionValueSource given in the modelOwner
Revenue growth12% falling to 8%Management plan, March 2026To be named
Gross margin43%2025 audited accountsTo be named
SG&A, % of revenue20%None givenTo be named
R&D, % of revenue5%None givenTo be named
D&A, % of revenue3%None givenTo be named
Capex, % of revenue4%None givenTo be named
Tax rate25%Statutory rateTo be named
Receivable days452025 audited accountsTo be named
Inventory days60None givenTo be named
Payable days40None givenTo be named
Interest rate on term loan8%Term sheetTo be named
Annual principal repayment$1,000,000Term sheetTo 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 marginGrowth -2 pointsGrowth as plannedGrowth +2 points
-2 points0.75x *
$1,728,269
0.74x *
$1,871,438
0.73x *
$2,015,732
as planned0.90x *
$2,947,589
0.89x *
$3,163,911
0.88x *
$3,385,216
+2 points1.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.