Business Valuation for SMEs: A Practical Excel Model for Owners and Buyers

Introduction

Every SME owner eventually faces the valuation question. You might be preparing to sell, buying out a partner, raising capital, or simply wanting to know what you've built. But valuation feels like a dark art-something the professionals do with complex models and proprietary databases.

The reality is simpler. Business valuation is an estimate supported by evidence, not a precise number. And most of the evidence lives in your financial statements. With a well-structured Excel model, you can produce a defensible valuation range using three common approaches.

This guide walks through building that model.

Approach 1: Capitalised Earnings (Multiple) Method

The most common approach for SMEs. You take a normalised profit figure and multiply it by a market-derived multiple.

Step 1: Normalise Profit

Start with your reported net profit, then adjust for:

• Owner's salary - if the owner is paid above or below market rate, adjust to market rate
• Discretionary expenses - personal cars, family travel, above-market rent paid to a related entity
• One-off items - a large legal settlement, a bad debt write-off, an insurance payout
• Non-recurring revenue - a large project that won't repeat

The goal is to arrive at maintainable earnings - the profit a new owner could reasonably expect to earn.

Step 2: Determine the Multiple

This is the hardest part because multiples are context-dependent. As a starting point:

These ranges vary by growth rate, customer concentration, recurring revenue, and industry conditions. A business growing 20% per year with high recurring revenue commands a higher multiple than a flat, project-based business.

Step 3: Calculate

Estimated Value = Normalised Earnings × Industry Multiple

If your normalised profit is $300,000 and the appropriate multiple is 3.5x, the indicated value is $1,050,000.

Approach 2: Discounted Cash Flow (DCF) Method

DCF values a business based on its future cash flows, discounted back to today. It's more rigorous than the multiple method but requires more assumptions.

Building the DCF in Excel

Create a 5-year projection:

Discount rate - for most SMEs, a discount rate of 10-15% is appropriate. This reflects the risk of the business versus a risk-free alternative (government bonds at ~5%). Higher risk = higher discount rate = lower valuation.

Terminal value - after year 5, assume the business continues growing at a steady rate (typically 2-3%). Calculate terminal value as:

Terminal Value = (Year 5 Cash Flow × (1 + Growth Rate)) / (Discount Rate - Growth Rate)

Then discount the terminal value back to present.

Total value = Sum of PV of cash flows + PV of terminal value.

The DCF gives you a more precise number, but that precision is an illusion if your assumptions are wrong. Run it with different growth rates and discount rates to see a range.

Approach 3: Asset-Based Method

This approach values the business as the sum of its net assets. It's most useful for:

• Asset-heavy businesses (construction, transport, manufacturing)
• Businesses that aren't profitable
• A floor value below which you wouldn't sell

Net Asset Value = Total Assets - Total Liabilities

This includes tangible assets (equipment, vehicles, inventory, cash, receivables) minus all debts. For most SMEs, this produces a lower valuation than the earnings-based methods, because it doesn't capture goodwill, customer relationships, brand value, or the assembled workforce.

Triangulating to a Valuation Range

No single method gives you a definitive answer. The value of a business is what a willing buyer will pay a willing seller. The three methods together give you a range:

If the earnings-based methods are above the asset value, the business has goodwill. If they're below, the business is destroying value - it would be worth more liquidated than operating.

A reasonable valuation range for this business would be $850K - $1,150K, with the final price depending on negotiation, deal structure, and strategic fit.

Adjustments for Negotiation

The model gives you a number. The deal delivers a different one. Key adjustments:

• Working capital - is there enough cash and receivables to run the business post-sale?
• Customer concentration - does one customer represent more than 20% of revenue? Deduct 10-20%.
• Owner dependence - does the business rely entirely on the current owner? If so, value is lower.
• Growth trajectory - clear growth plan with evidence? Value is higher.
• Deal structure - cash upfront commands a higher price than earn-outs or vendor finance.

Add a sheet in your model for these qualitative adjustments, so you can see the impact on the final range.

Common Mistakes

• Using EBITDA when net profit tells a different story - EBITDA strips out capital structure, but for SMEs, the owner's decisions around debt, depreciation, and capital expenditure are part of the business reality.
• Ignoring capital expenditure requirements - if the business needs to replace $50K of equipment every two years, that's a real cost.
• Over-optimistic growth projections - your business might grow 20% next year. Will it grow 20% in year five when competitors have caught up?
• Confusing revenue with value - a $2M revenue business with 5% margins is worth less than a $500K revenue business with 30% margins.

Conclusion

Business valuation isn't magic. It's a structured analysis of your financial data, supported by market evidence and reasonable assumptions. A well-built Excel model using all three approaches gives you a defensible range-and the confidence to negotiate from a position of knowledge.