small business valuation excel

Small Business Valuation: Master Excel

By Olivia King
AD

Valuing a small business is a critical step when the time comes to buy, sell, or pass down your enterprise. While several methods exist for large corporations, small businesses often rely on simple, efficient approaches. Excel, a versatile tool widely used by both small business owners and professionals, offers an effective way to valuate your small business. This article delves into the process of small business valuation using Excel, offering practical tips and common methods.

Before diving into the valuating process, it's crucial to understand that no single approach precisely determines a business's worth. Instead, multiple methods provide a range of values, helping you better understand your business's worth in today's market.

Key Small Business Valuation Methods in Excel

This section explores three key methods for valuing a small business in Excel: Assets-Based, Income-Based, and Market-Based approaches.

AD
Business Valuation Sheet | Excel and Google Sheets | Financial Metrics Tracker | Business Worth Calculator | Valuation Ratios & Analysis
Business Valuation Sheet | Excel and Google Sheets | Financial Metrics Tracker | Business Worth Calculator | Valuation Ratios & Analysis
Business Valuation Calculator for a Startup | Plan Projections
Business Valuation Calculator for a Startup | Plan Projections
Business Valuation Excel Template: Financial Planner for Investors (Digital Download)
Business Valuation Excel Template: Financial Planner for Investors (Digital Download)

The Assets-Based Approach involves summing up the liquidation value of your business's assets minus its liabilities. It is handy for businesses heavily reliant on tangible assets like machinery, equipment, or real estate.

Asset-Based Valuation

To perform an assets-based valuation in Excel:

Startup Valuation Template | Easy DCF Excel Model for Beginners & Small Businesses
Startup Valuation Template | Easy DCF Excel Model for Beginners & Small Businesses
Business Valuation Excel Worksheet Template
Business Valuation Excel Worksheet Template
See Profit at a Glance – Small Business Excel Dashboard
See Profit at a Glance – Small Business Excel Dashboard
  1. List all business assets (current and long-term) in one column.
  2. In the adjacent column, estimate each asset's value, either through market research or appraisal.
  3. Use Excel's SUM function to calculate the total asset value.
  4. List all business liabilities in a separate section, summing their total using another SUM function.
  5. Subtract the total liabilities from the total assets to obtain the asset-based business value.

Income-Based Valuation

The Income-Based Approach focuses on your business's earnings, using historical or projected financial data to estimate its value. This method is useful for businesses with steady or growing incomes, such as service-based enterprises and professional practices.

In Excel, you can use the Discretionary Earnings Capitalization method, a popular income-based valuation method:

AD
  1. Estimate the business's annual discretionary earnings (net profits plus owner's compensation).
  2. Determine the capitalization rate, which represents the risk of investing in your business. Industry-specific benchmarks can provide a starting point.
  3. Divide the estimated discretionary earnings by the capitalization rate to calculate the business's value.

Market-Based Business Valuation

The Market-Based Approach involves comparing similar businesses that have recently sold to estimate your business's value. This method is ideal for established businesses with consistent earnings and those in competitive markets.

What's Your Business Really Worth? Calculate It in Minutes
What's Your Business Really Worth? Calculate It in Minutes
Business Valuation Model | Excel Spreadsheet | Buy a Business Toolkit | DCF & SDE Template
Business Valuation Model | Excel Spreadsheet | Buy a Business Toolkit | DCF & SDE Template
24 Valuations for a Small Business - Printable Template with Formulas
24 Valuations for a Small Business - Printable Template with Formulas
Business Valuation Template - Google and Excel Sheets, Financial Metrics & Valuation Ratios
Business Valuation Template - Google and Excel Sheets, Financial Metrics & Valuation Ratios
New Business Valuation Tool Discounted Cash Flow Analysis Financial Excel Template Digital Download
New Business Valuation Tool Discounted Cash Flow Analysis Financial Excel Template Digital Download
One Workbook for Your Whole Business – Excel Template
One Workbook for Your Whole Business – Excel Template

For this method, gather data on recent sales of similar businesses, focusing on:

  • Business type and size
  • Location
  • Sales revenue, earnings, or other key metrics
  • Prices paid for each sale

UseExcel's AVERAGEIFS function to calculate the average sale price of similar businesses based on their sales revenue or earnings. Multiply this average by your business's corresponding revenue or earnings to estimate its market-based value.

AD

After calculating your business's value using these methods, you'll have a range of values to aid in decision-making. Keep in mind that other factors unique to your business or industry may affect its ultimate selling price.

a spreadsheet showing the financial statement and budget sheet for an apartment development project
a spreadsheet showing the financial statement and budget sheet for an apartment development project

Professional appraisers often use a combination of methods and consider intangible factors to provide a more accurate valuation. If you're planning to sell your business, consider hiring a professional for a comprehensive appraisal. However, using Excel to perform these basic valuation methods empowers small business owners to gain valuable insights into their company's worth and better plan for the future.

AD