Sample deliverable
Financial Model Build, for a synthetic distributor
What the build delivers, shown on the synthetic US wholesale distributor of our other finance samples: a five-year, three-statement model with an assumptions book, three cases, checks and a sensitivity table, in a workbook someone else can maintain.
The base case covers its debt service, with little room: 1.09x at the low point. The downside does not.
The company is made up for this sample. Its 2025 revenue, $15,068,234, is the delivered revenue found in the Diligence Data Analysis sample; the other inputs were set for this sample and are labeled that way in the book. In the base case revenue reaches $19.0 million in 2030 and operating cash covers interest and principal at least 1.09x, lowest in 2027. In the downside it covers 0.47x in 2026 and stays below 1.00x in every year; the opening cash pays the difference until it runs out in 2030. A lender reading the downside would ask for a credit line or a slower repayment schedule before that year; the cash line by year shows when it is needed.
| Result | Base | Downside | Upside |
|---|---|---|---|
| Revenue, 2030 | $19,046,426 | $16,794,775 | $21,318,554 |
| Revenue growth a year, 2025 to 2030 | 4.8% | 2.2% | 7.2% |
| EBITDA, 2030 (margin) | $1,523,714 (8.0%) | $1,007,687 (6.0%) | $1,961,307 (9.2%) |
| Net income, 2026 to 2030 | $4,004,936 | $2,301,334 | $5,258,010 |
| Cash at the end of 2030 | $1,710,687 | ($27,028) | $2,395,115 |
| Lowest year-end cash, 2026 to 2030 | $1,014,796 | ($27,028) | $1,070,932 |
| Minimum debt service coverage | 1.09x | 0.47x | 1.23x |
| Net debt to EBITDA, end of 2026 | 1.16x | 2.22x | 0.94x |
| By year | 2026 | 2027 | 2028 | 2029 | 2030 |
|---|---|---|---|---|---|
| Coverage, base | 1.16x | 1.09x | 1.20x | 1.35x | 1.48x |
| Cash, base | $1,014,796 | $1,080,011 | $1,210,988 | $1,429,664 | $1,710,687 |
| Coverage, downside | 0.47x (below 1.00x) | 0.75x (below 1.00x) | 0.76x (below 1.00x) | 0.82x (below 1.00x) | 0.89x (below 1.00x) |
| Cash, downside | $490,959 | $310,550 | $149,901 | $37,233 | ($27,028) |
Coverage is cash available for debt service (cash from operations before interest, less capital expenditure) divided by interest and principal. The term loan amortizes $500,000 a year.
Every input on one sheet, with its source and date
Eleven drivers, each with a base, a downside and an upside value for each year from 2026 to 2030, and one switch that selects the case. The model reads only the live row, so changing a case never means editing a formula.
| Driver, 2026 to 2030 | Base | Downside | Upside | Source |
|---|---|---|---|---|
| Revenue growth | 6.0% to 4.0% | 0.0% to 3.0% | 10.0% to 5.0% | Base well below the 24.1% of 2025, because revenue fell in Q3 and Q4 2025 (Diligence Data Analysis sample); downside flat in 2026 |
| Gross margin | 24.0% | 22.5% | 25.0% | Set for this sample (synthetic company) |
| Operating expenses, % of revenue | 16.0% | 16.5% | 15.8% | Set for this sample (synthetic company) |
| Depreciation, % of revenue | 1.0% | 1.0% | 1.0% | Set for this sample (synthetic company) |
| Capital expenditure, % of revenue | 1.2% | 1.2% | 1.4% | Set for this sample (synthetic company) |
| Receivable days | 45 | 50 | 45 | Set for this sample (synthetic company) |
| Inventory days | 55 | 60 | 55 | Set for this sample (synthetic company) |
| Payable days | 35 | 35 | 35 | Set for this sample (synthetic company) |
| Tax rate | 25.0% | 25.0% | 25.0% | Federal 21% plus an assumed 4% state rate |
| Interest rate on term loan | 8.0% | 9.0% | 8.0% | Set for this sample (synthetic company) |
| Scheduled principal repayment | $500,000 | $500,000 | $500,000 | Set for this sample (synthetic company) |
The twelve 2025 figures the forecast starts from
| Figure | Value | Source |
|---|---|---|
| Revenue 2025 | $15,068,234 | Delivered revenue 2025, Diligence Data Analysis sample |
| Gross margin 2025 | 23.8% | Set for this sample (synthetic company) |
| Operating expenses 2025, % of revenue | 16.2% | Set for this sample (synthetic company) |
| Depreciation 2025 | $140,000 | Set for this sample (synthetic company) |
| Interest expense 2025 | $270,000 | Set for this sample (synthetic company) |
| Cash, end of 2025 | $900,000 | Set for this sample (synthetic company) |
| Property and equipment, end of 2025 | $1,400,000 | Set for this sample (synthetic company) |
| Term loan, end of 2025 | $3,000,000 | Set for this sample (synthetic company) |
| Receivable days 2025 | 46 | Set for this sample (synthetic company) |
| Inventory days 2025 | 57 | Set for this sample (synthetic company) |
| Payable days 2025 | 34 | Set for this sample (synthetic company) |
| Tax rate 2025 | 25.0% | Federal 21% plus an assumed 4% state rate |
In a client model the sources are the trial balance, the plan and the term sheet, and each driver gets an owner. Here most inputs are set for the sample, and the book says so instead of pretending otherwise.
For this distributor, margin matters more than growth, and growth costs cash
Base case, cash at the end of 2030 and minimum debt service coverage when revenue growth moves two points and gross margin one point from the base in every year. Each cell is a separate recalculation of the workbook.
| Gross margin | Growth -2 points | Growth as in the base | Growth +2 points |
|---|---|---|---|
| -1 point | $1,116,002 0.95x * | $1,042,403 0.91x * | $957,392 0.87x * |
| as in the base | $1,745,671 1.13x | $1,710,687 1.09x | $1,666,383 1.06x |
| +1 point | $2,375,340 1.30x | $2,378,971 1.27x | $2,375,373 1.25x |
* Below 1.00x in at least one year. One point of gross margin moves 2030 cash by about $668,284; two points of growth, at the base margin, by about $39,644, and in the other direction: faster growth ties more cash up in receivables and inventory than it earns by 2030. One point of margin lost is enough to take base-case coverage below 1.00x. These are the two figures to test hardest with the client.
Five sheets, and a model that tells you when it is broken
- Guide
- What each sheet does, the conventions (inputs in blue, formulas in black, signs, days), and how to add a year.
- Assumptions
- The case switch, then eleven drivers with a base, a downside and an upside value for each year, a live row that the switch selects, and the source and date of each; then the twelve 2025 figures the forecast starts from.
- Model
- Income statement, balance sheet, cash flow and the lender view, linked. From 2026 every cell is a formula, the same formula across each row.
- Checks
- The balance sheet balances, the loan never goes below zero, the case switch is valid: every cell must read zero. Below them, a warning counts the years the selected case runs out of cash.
- Sensitivity
- Base-case cash at the end of 2030 and minimum coverage, with growth and margin moved from the base.
The build is checked by reading the workbook back, not by trusting it: all 33 forecast rows on the Model sheet carry one formula across the five years (165 formulas, none that changes pattern), the Model sheet holds no typed numbers, and every input has a source and a date. All checks read zero in each of the twelve recalculated copies (three cases, nine sensitivity cells).
What this sample is and is not
- It is a sample, not client work. The company is synthetic; nothing here describes a real business. The workbook opens in Excel, Google Sheets or LibreOffice with the base case selected.
- Every figure on this page is a value the spreadsheet calculated (LibreOffice, recalculating each copy of the workbook); the script that writes the workbook computes none of them. Figures generated on 2026-11-20.
- The sample is a three-statement operating model. The package can instead be a transaction model with sources and uses, financing and returns.
- A client build starts from three years of historical statements reconciled to the trial balance; this sample starts from one synthetic year. It includes a walkthrough session and a written guide; here the guide is the first sheet of the workbook.
- A model shows what follows from its assumptions. It is not a valuation, a credit opinion or a forecast of what will happen.
A model like this, for your plan or deal.
From $4,900, two to four weeks. Tell us who will read the model and what decision it supports.