Business Valuation Workbook
Work out what your business is worth without telling anyone you are asking. A broker will value it free, and from that moment a salesperson knows you are considering a sale — and their number is also their pitch to win the listing. This is the arithmetic done quietly, on your own machine, before you say a word to anyone.
Two linked sheets, every formula visible
You get an .xlsx workbook that opens in Excel or Google Sheets. Sheet one takes your figures and works out normalised profit. Sheet two applies the multiples and adjusts for debt and cash. Nothing is hidden: below is the entire input sheet, read out of the actual file.
| Row | Type | What the cell does |
|---|---|---|
| CORE FINANCIALS (most recent full fiscal year) | ||
| Annual Revenue | INPUT | you type it |
| Cost of Goods Sold / Direct Costs | INPUT | you type it |
| Operating Expenses (excl. owner pay, D&A, interest, tax) | INPUT | you type it |
| Owner's Reported Salary/Compensation | INPUT | you type it |
| Depreciation & Amortisation | INPUT | you type it |
| Interest Expense | INPUT | you type it |
| Taxes Paid | INPUT | you type it |
| REPORTED PROFITABILITY (calculated from the above) | ||
| Reported EBITDA | CALCULATED | =C3-C4-C5-C6 |
| Reported Net Income | CALCULATED | =C11-C7-C8-C9 |
| EBITDA NORMALISATION — ADD-BACKS | INPUT | you type it |
| Fair Market Owner Replacement Salary | INPUT | you type it |
| Owner Compensation Add-back | CALCULATED | =MAX(0,C6-C14) |
| One-Time / Non-Recurring Expenses | INPUT | you type it |
| Personal Expenses Run Through the Business | INPUT | you type it |
| Related-Party Rent Adjustment | INPUT | you type it |
| Other Add-backs | INPUT | you type it |
| Total Add-backs | CALCULATED | =C15+C16+C17+C18+C19 |
| NORMALISED EBITDA | CALCULATED | =C11+C20 |
| BALANCE SHEET INPUTS | ||
| Total Interest-Bearing Debt | INPUT | you type it |
| Cash & Cash Equivalents on Hand | ||
The bit most calculators get wrong
Owner pay. Most free tools add your whole salary back to profit, which flatters the number badly — a buyer still has to pay somebody to do your job. This workbook adds back only the excess of your pay over the cost of replacing you: =MAX(0, your pay − fair market replacement).
That single distinction is the most common reason an owner's expectation and a buyer's offer end up far apart.
Business Valuation Workbook — $39, one payment. Downloaded to your machine. No account, no subscription, nothing to log into.
The free calculator adds back owner pay alone and stops at enterprise value. This workbook adds the other four add-back categories a buyer will raise, then takes the figure through debt and cash to equity value — the number that would actually reach you. If you also want the readiness assessment, preparation checklist and adviser summary, that is the full toolkit — see inside it here.
Arithmetic and general information only — not financial, tax, legal or investment advice. It is a workbook you run yourself, not a valuation you can file; going to market still needs a solicitor and an accountant.