Business Valuation & EBITDA Calculator
Build an auditable business-value scenario from your own earnings records, comparable evidence and transaction assumptions. Reconcile net income to EBITDA for each period, retain included and excluded adjustments, and assign explicit period weights. Compare entered multiples or the minimum, median and maximum of eligible comparable EV/EBITDA ratios. Signed waterfalls then separate enterprise value, equity value and your modeled consideration after owner-specific fees. A nine-cell sensitivity grid shows how earnings and multiples change the result. This complements discounted cash-flow analysis with a historical earnings and transaction bridge; the illustrative examples are not market data, an appraisal or recommended sale prices.
Trace earnings into business value—and your share
Reconcile adjusted EBITDA, compare entered multiples, and follow the transaction from enterprise value to modeled owner proceeds.
Make the assumptions visible before comparing values
These examples contain illustrative amounts and multiples, not market data or an appraisal. Use consistent earnings definitions and transaction terms. EBITDA is not cash flow; no tax, financing, earnout or control discount is inferred.
Set one consistent financial basis
Enter full currency amounts, not thousands or millions. Use comparable period lengths and consistent accounting definitions. No annualization, currency conversion or market-data lookup is performed. Signed expense adjustments allow benefits and reversals; blank is not zero.
One label for all earnings, comparables and transaction amounts.
Reconcile earnings, then assign period weights
EBITDA starts with net income and adds the entered interest, income tax, depreciation and amortization. Your further signed adjustments produce adjusted EBITDA. Inclusion is a modeling choice, not confirmation that a buyer or reporting standard accepts an adjustment.
Entered period weights: 100%. Required total: 100%.
Period 1: prior
For example, a year or trailing twelve months. Dates do not trigger automatic scaling.
All period weights must total exactly 100%. Added and copied periods start at zero weight.
Use the net income for this period, including a loss as a negative number.
Positive expense is added back; net interest income can be negative. Keep definitions consistent with comparable earnings.
Use a negative amount for an income tax benefit. This is an entered reconciliation item, not a tax estimate.
Do not include the same depreciation or amortization twice.
Signed adjustments to EBITDA
A positive amount increases modeled earnings; a negative amount decreases them. Name the reason for each adjustment. Ordinary recurring costs should not disappear simply to increase value.
Draft earnings check: EBITDA USD 190,000; included adjustments USD 10,000; adjusted EBITDA USD 200,000.
Period 2: recent
For example, a year or trailing twelve months. Dates do not trigger automatic scaling.
All period weights must total exactly 100%. Added and copied periods start at zero weight.
Use the net income for this period, including a loss as a negative number.
Positive expense is added back; net interest income can be negative. Keep definitions consistent with comparable earnings.
Use a negative amount for an income tax benefit. This is an entered reconciliation item, not a tax estimate.
Do not include the same depreciation or amortization twice.
Signed adjustments to EBITDA
A positive amount increases modeled earnings; a negative amount decreases them. Name the reason for each adjustment. Ordinary recurring costs should not disappear simply to increase value.
Draft earnings check: EBITDA USD 230,000; included adjustments USD 20,000; adjusted EBITDA USD 250,000.
Choose the source of valuation multiples
The selected source determines low/base/high scenarios. These are assumptions or descriptive statistics, not probabilities or an appraisal.
Entered multiples stay visible and must remain valid in either mode. A comparable range requires at least one included row with positive EBITDA. A single eligible comparable produces the same low, base and high multiple.
Nonnegative; no greater than the base multiple.
At least the low and no greater than the high multiple.
At most 1,000; this limit is not a recommended market multiple.
Record the comparable evidence
Use enterprise value with a matching EBITDA definition and period. Equity purchase prices alone are not enterprise value. Source notes help you keep track of dates and adjustments. The calculator neither verifies comparability nor imports market transactions.
Bridge enterprise value to equity and your share
These are entered transaction assumptions. Include each item once. Delivered and target working capital must use the same definition, excluding cash or debt already entered elsewhere. Only their difference adjusts enterprise value.
Added to enterprise value under your modeled transaction terms.
Enter the debt amount included in these terms, not a negative number.
Separate non-overlapping items. No lease, pension or other liability treatment is inferred.
Signed amount under your transaction definition.
Delivered minus target is added to enterprise value; a deficit reduces it.
Applied to equity value, including negative equity. No minority or control discount is inferred.
Owner-specific fees
The variable fee applies only to positive modeled owner consideration after the ownership calculation. It is not a percentage of enterprise value. The fixed fee applies independently, even at zero ownership or negative proceeds. No capital-gains tax, financing, escrow or earnout is calculated.
0–100%; enter the fee assumption for this scenario, not an implied standard rate.
Nonnegative; subtracted once from your consideration after the variable fee.
The earnings basis behind every scenario
| Period | Weight | EBITDA | Included adjustments | Adjusted EBITDA | Weighted contribution |
|---|---|---|---|---|---|
| prior | 40% | 190,000 | 10,000 | 200,000 | 80,000 |
| recent | 60% | 230,000 | 20,000 | 250,000 | 150,000 |
Compare enterprise value, equity and your proceeds
Using your entered low, base and high multiples. These are scenarios, not probabilities, confidence intervals or recommended transaction prices.
Low · 4× EBITDA
Modeled owner proceeds
USD 583,000
- Enterprise value
- USD 920,000
- Equity value
- USD 750,000
- Your share before fees
- USD 600,000
- Variable / fixed fee
- USD 12,000 / USD 5,000
Base · 5× EBITDA
Modeled owner proceeds
USD 763,320
- Enterprise value
- USD 1,150,000
- Equity value
- USD 980,000
- Your share before fees
- USD 784,000
- Variable / fixed fee
- USD 15,680 / USD 5,000
High · 6× EBITDA
Modeled owner proceeds
USD 943,640
- Enterprise value
- USD 1,380,000
- Equity value
- USD 1,210,000
- Your share before fees
- USD 968,000
- Variable / fixed fee
- USD 19,360 / USD 5,000
Negative equity and owner proceeds remain visible. They are modeled arithmetic, not a determination of legal payment obligations. Fees use your entered basis; proceeds are not after-tax income.
Inspect the comparable evidence
3 of 3 entered comparables are eligible. Inclusion and positive EBITDA determine eligibility; they do not establish economic comparability. Ratios below use a common zero-anchored scale. Exact fractions are retained in the export.
alpha4×
beta5×
gamma6×
| Comparable | Enterprise value | EBITDA | Multiple | Status | Source / date note |
|---|---|---|---|---|---|
| alpha | 800,000 | 200,000 | 4× | Included and positive EBITDA | Illustrative input; not market data |
| beta | 1,250,000 | 250,000 | 5× | Included and positive EBITDA | Illustrative input; not market data |
| gamma | 1,800,000 | 300,000 | 6× | Included and positive EBITDA | Illustrative input; not market data |
From net income to adjusted EBITDA
Inspecting prior: USD 190,000 EBITDA becomes USD 200,000 adjusted EBITDA. The first five lines reconcile net income to EBITDA; subsequent lines are your included adjustments.
- 1. Net incomeIncrease: USD 120,000
Running value: USD 120,000
- 2. Net interest expenseIncrease: USD 15,000
Running value: USD 135,000
- 3. Income tax expense / benefitIncrease: USD 30,000
Running value: USD 165,000
- 4. DepreciationIncrease: USD 20,000
Running value: USD 185,000
- 5. AmortizationIncrease: USD 5,000
Running value: USD 190,000
- 6. oneoffIncrease: USD 20,000
Running value: USD 210,000
- 7. replacementDecrease: USD −10,000
Running value: USD 200,000
View the complete bridge table
| Step | Before | Change | After |
|---|---|---|---|
| Net income | 0 | 120,000 | 120,000 |
| Net interest expense | 120,000 | 15,000 | 135,000 |
| Income tax expense / benefit | 135,000 | 30,000 | 165,000 |
| Depreciation | 165,000 | 20,000 | 185,000 |
| Amortization | 185,000 | 5,000 | 190,000 |
| oneoff | 190,000 | 20,000 | 210,000 |
| replacement | 210,000 | −10,000 | 200,000 |
Adjustment review
- oneoff: USD 20,000 — included.
- replacement: USD −10,000 — included.
From enterprise value to your modeled proceeds
Base scenario: USD 1,150,000 enterprise value → USD 980,000 equity → USD 763,320 modeled owner proceeds.
The ownership step allocates equity to your entered share; it is not another transaction fee or cash flow. The variable fee applies only to positive owner consideration. Delivered working capital enters only as the difference from the target.
- 1. Enterprise valueIncrease: USD 1,150,000
Running value: USD 1,150,000
- 2. Included cashIncrease: USD 50,000
Running value: USD 1,200,000
- 3. DebtDecrease: USD −200,000
Running value: USD 1,000,000
- 4. Other debt-like itemsDecrease: USD −10,000
Running value: USD 990,000
- 5. Delivered less target working capitalDecrease: USD −10,000
Running value: USD 980,000
- 6. Adjustment to your ownership shareDecrease: USD −196,000
Running value: USD 784,000
- 7. Fee on positive owner considerationDecrease: USD −15,680
Running value: USD 768,320
- 8. Owner-specific fixed feeDecrease: USD −5,000
Running value: USD 763,320
View the complete bridge table
| Step | Before | Change | After |
|---|---|---|---|
| Enterprise value | 0 | 1,150,000 | 1,150,000 |
| Included cash | 1,150,000 | 50,000 | 1,200,000 |
| Debt | 1,200,000 | −200,000 | 1,000,000 |
| Other debt-like items | 1,000,000 | −10,000 | 990,000 |
| Delivered less target working capital | 990,000 | −10,000 | 980,000 |
| Adjustment to your ownership share | 980,000 | −196,000 | 784,000 |
| Fee on positive owner consideration | 784,000 | −15,680 | 768,320 |
| Owner-specific fixed fee | 768,320 | −5,000 | 763,320 |
What changes when earnings or multiples move?
Nine modeled combinations use 80%, 100% and 120% of weighted adjusted EBITDA, holding the transaction bridge, ownership and fee assumptions fixed. This is a discrete sensitivity grid, not an exhaustive forecast.
| Earnings basis | Low · 4× | Base · 5× | High · 6× |
|---|---|---|---|
| 80%USD 184,000 | 438,744Enterprise: 736,000 | 583,000Enterprise: 920,000 | 727,256Enterprise: 1,104,000 |
| 100%USD 230,000 | 583,000Enterprise: 920,000 | 763,320Enterprise: 1,150,000 | 943,640Enterprise: 1,380,000 |
| 120%USD 276,000 | 727,256Enterprise: 1,104,000 | 943,640Enterprise: 1,380,000 | 1,160,024Enterprise: 1,656,000 |
Keep the full valuation ledger
CSV includes every assumption, included and excluded adjustment, comparable note, exact weighted earnings, multiple, scenario and sensitivity cell. Formula-like values receive a leading apostrophe for spreadsheet safety; keep it when preserving the original text. Displayed rounding does not feed back into calculations.
How to use this calculator
- Load Weighted earnings example or Review adjustments and comparables. Open Edit earnings and transaction terms, set your currency label and enter full amounts rather than figures already scaled to thousands or millions.
- For each comparable-length period, enter net income, net interest expense, income tax expense or benefit, depreciation and amortization. Add named signed adjustments and choose which to include. Assign period weights totaling exactly 100%; copied periods start at zero weight.
- Choose entered multiples or comparable minimum/median/maximum. Enter ordered low, base and high multiples. For comparable evidence, enter enterprise value, a compatible EBITDA amount, source/date notes and inclusion status. Review excluded or nonpositive-denominator rows rather than assuming every row belongs in the range.
- Enter the cash, debt and other debt-like amounts included in the modeled terms, then delivered and target working capital under one consistent definition. Enter your ownership percentage, the fee on positive owner consideration and any owner-specific fixed fee.
- Update business valuation. Compare the three scenarios, inspect a period's earnings reconciliation and the selected enterprise-to-owner bridge, and review the sensitivity grid. Download the full CSV or use its selectable copy, retaining unsupported-status diagnostics where no multiple-based valuation is available.
The Formula
The mathematical logic powering this calculation is:
For each period, EBITDA = net income + net interest expense + income tax expense + depreciation + amortization. Enter signed reconciliation amounts: a tax benefit or net interest income may be negative. Additional modeled adjustments must be identified separately. Adjusted EBITDA = EBITDA + sum of included signed adjustments. Positive adjustments increase earnings and negative adjustments reduce them. Excluded rows retain their values and reasons for review; inclusion does not establish accounting validity, buyer acceptance or regulatory compliance.
Assign a nonnegative weight to every period, summing exactly to 100%. Weighted EBITDA = sum(period EBITDA × weight / 100). Weighted included adjustments are calculated the same way. Weighted adjusted EBITDA is their sum. The periods must use comparable durations and definitions; the tool does not annualize partial periods, infer accounting policies, normalize weights or remove recurring expenses automatically. Neither EBITDA nor adjusted EBITDA is a complete cash-flow measure.
For an included comparable with positive entered EBITDA, multiple = entered enterprise value / entered EBITDA. Zero enterprise value with positive EBITDA produces an eligible zero multiple. Excluded rows and zero or negative EBITDA do not enter the comparable range; their reasons remain visible. Sort eligible ratios exactly. The low and high comparable multiples are the minimum and maximum. The base is the median: the middle ratio for an odd count, or the average of the two middle ratios for an even count. This is an unweighted descriptive range without outlier trimming. A single eligible row produces three equal multiples. Source notes preserve your provenance, but the tool does not verify economic comparability or import market transactions.
Choose either your entered ordered low/base/high multiples or that comparable range. Manual inputs remain visible and validated in either mode. If weighted adjusted EBITDA is zero or negative, multiple-based valuation is unavailable; the earnings and comparable diagnostics remain. If comparable mode has no eligible rows, its valuation is also unavailable. Neither condition is replaced by a zero business value. A manually entered zero multiple is different: it explicitly creates zero enterprise value when the earnings basis is positive.
For each scenario, enterprise value = weighted adjusted EBITDA × selected multiple, rounded to cents. The transaction bridge is cash − debt − other debt-like deductions + delivered working capital − target working capital. Equity value = enterprise value + transaction bridge. Enter non-overlapping amounts under a consistent transaction definition. Only the delivered-minus-target working-capital adjustment enters the bridge; do not add all operating working capital again or include cash and debt twice. Treatment of excess cash, leases, pensions and other debt-like items is not inferred. Negative equity is retained.
Owner consideration before fees = equity value × ownership percentage, rounded to cents. Variable fee = max(0, rounded owner consideration) × fee percentage, rounded to cents. Modeled owner proceeds = owner consideration − variable fee − owner-specific fixed fee. This fee basis is positive owner consideration, not enterprise value. The fixed fee is independent of ownership and applies even when consideration is zero or negative. Negative outputs are retained as modeled arithmetic, not a determination of legal payment obligations. There is no capital-gains tax, financing, earnout, escrow, minority discount, control premium or other unentered closing adjustment.
The sensitivity grid recomputes the three multiples at 80%, 100% and 120% of the weighted adjusted earnings basis. Cash, debt, debt-like items, working-capital inputs, ownership and fee assumptions stay fixed. Each cell repeats the same cent-rounding stages. These nine combinations are not probabilities, confidence intervals, an exhaustive forecast or optimization.
Arithmetic is exact rational arithmetic until the declared monetary stages. Enterprise value, owner consideration and variable fee each round half away from zero to cents. Weighted earnings and comparable ratios are not rounded before use. Displayed earnings and multiples show up to six decimal places, with exact small fractions retained when rounding would hide a nonzero value. The CSV preserves canonical inputs, exact fractions, included/excluded rows and every scenario and sensitivity result. Formula-like values are prefixed with an apostrophe for spreadsheet safety. Currency is a label, not an exchange-rate conversion.
Input limits: 1–5 periods, 0–12 adjustments per period and 0–12 comparables. Period weights, ownership and fee percentages are 0–100% with up to six decimal places. Entered multiples are ordered low ≤ base ≤ high, each 0–1,000 with up to six decimal places. Computed comparable ratios can exceed that manual-input limit. Money inputs use plain decimal amounts with at most two places and absolute value at most 1 trillion currency units. Cash, debt, debt-like items, comparable enterprise value and fixed fees are nonnegative; earnings components, adjustments, delivered/target working capital and comparable EBITDA may be signed. Derived amounts can exceed the input caps and retain exact precision. Names are trimmed strings of 1–100 characters, the currency label has 1–12 characters, and comparable source notes allow up to 300 characters without control codes. Numerical limits are not recommended valuation assumptions.
SEC guidance supplies the distinction between EBITDA and differently adjusted measures and the importance of reconciliation and clear labels. Damodaran's materials explain value multiples and the separation of enterprise value from equity, debt and cash. The specific weighting, comparable range, working-capital bridge, owner-fee basis and rounding rules above are this calculator's declared planning conventions; they are not a prescribed appraisal method or universal transaction contract.Worked Example
If you input:
- Prior period: Net income USD 120,000 + interest 15,000 + tax 30,000 + depreciation 20,000 + amortization 5,000 = EBITDA 190,000. Included adjustments +20,000 and −10,000; weight 40%.
- Recent period: Net income USD 150,000 + interest 12,000 + tax 38,000 + depreciation 24,000 + amortization 6,000 = EBITDA 230,000. Included adjustments +30,000 and −10,000; weight 60%.
- Illustrative multiples: Entered low/base/high multiples of 4×, 5× and 6×. Example comparable EV/EBITDA pairs are 800,000/200,000, 1,250,000/250,000 and 1,800,000/300,000; these are not market observations.
- Transaction bridge: Cash USD 50,000, debt 200,000, other debt-like deductions 10,000, delivered working capital 90,000 and target working capital 100,000.
- Ownership and fees: 80% ownership; 2% fee on positive owner consideration; USD 5,000 owner-specific fixed fee.
Result:
Adjusted earnings are USD 200,000 and USD 250,000. Weighting them 40%/60% gives USD 230,000, consisting of USD 214,000 weighted EBITDA and USD 16,000 weighted adjustments. At the base 5× multiple, enterprise value is USD 1,150,000. The cash/debt/working-capital bridge is 50,000 − 200,000 − 10,000 + 90,000 − 100,000 = −170,000, so equity value is USD 980,000. The 80% owner share is USD 784,000; its 2% variable fee is USD 15,680. After the USD 5,000 fixed fee, modeled owner proceeds are USD 763,320. Low and high scenarios produce USD 583,000 and USD 943,640. In the separate review example, excluding the recent +30,000 adjustment reduces weighted adjusted earnings to USD 212,000. Two eligible comparables at 4× and 6× have a 5× median; the base owner proceeds become USD 692,760.
Frequently Asked Questions
How does this business value calculator differ from a DCF calculator?
This planner applies entered or comparable-derived multiples to weighted historical adjusted EBITDA, then traces a transaction bridge to owner proceeds. A DCF discounts projected future cash flows or earnings. These are different assumption-based views, and neither establishes a sale price by itself.
Which business valuation multiple should I use?
The calculator does not recommend an industry multiple. Enter justified low/base/high assumptions or compatible comparable observations with source notes. The comparable minimum, median and maximum describe only the rows you include; they are not a market estimate or confidence interval.
Why are EBITDA and adjusted EBITDA shown separately?
The first reconciliation starts from net income and adds the entered interest, tax, depreciation and amortization. Further signed changes are separately labeled adjustments. Keeping them visible helps reveal what drives the valuation, but does not certify that an adjustment is appropriate, accepted by a buyer or compliant with reporting requirements.
Why is valuation unavailable for zero or negative adjusted EBITDA?
An EBITDA multiple is not applied to a nonpositive weighted earnings basis in this planner. The earnings and comparable diagnostics remain visible without substituting a zero value. Other valuation approaches may be relevant, but they are not inferred here.
Why is enterprise value different from what the owner receives?
The entered cash, debt, other debt-like deductions and delivered-minus-target working-capital adjustment bridge enterprise value to equity. Your ownership percentage then determines modeled consideration, before owner-specific fees. Taxes, financing, escrow, earnouts and other unentered terms are excluded.
What does the working-capital adjustment represent?
It is delivered working capital minus the agreed target under your entered definition. A surplus increases the bridge and a deficit reduces it. Do not double-count cash, debt or normal working capital already reflected elsewhere. The tool does not choose the contractual definition or target.
Why can a zero ownership share or negative equity still produce a fee or negative result?
The percentage fee applies only to positive modeled owner consideration. The separately entered fixed fee applies independently, so it can leave a negative result at zero ownership. Negative equity and proceeds are shown without being floored at zero; they do not establish legal payment obligations.
Can I export excluded rows and the sensitivity analysis?
Yes. CSV includes inputs, source notes, inclusion status, exact weighted earnings and comparable ratios, all valuation scenarios and the nine sensitivity combinations. If valuation is unavailable, the export retains inputs and diagnostic status. Edited or invalid drafts cannot export a stale result as current.
Similar Calculators
DCF Calculator
Build a professional two-stage discounted cash flow valuation with growth-stage, terminal-stage, book value, and margin-of-safety analysis.
Profit Margin Calculator
Calculate gross, operating, and net profit margin percentages for your business or product.
Cash Conversion Cycle & Inventory Days Calculator
Calculate inventory, receivable and payable days together. Compare growth and timing scenarios, visualize operating-capital changes, weight balance snapshots and export the full analysis.
