Publication number: ELQ-93939-1
View all versions & Certificate
Business Valuation Template
Determine the value of your firm using three methods to use in different buy/sell situations
At various times privately held firms face the need to put a monetary value on the business. This need may arise due to an impending merger or acquisition, a need for additional private financing, the establishment of an employee stock ownership program (ESOP), a need to define management succession, or family issues such as death or divorce.
Determining the exact value of a private firm is a complex task which involves the appraisal of assets, reviewing the level of management salaries and the close examination of any transactions between the company and its owners. Eventually, valuing a private firm also involves a large degree of negotiation.
This discussion is intended to provide management with a starting point in determining the value of the firm. Any definitive valuation would require a careful review by a qualified appraisal expert. However, some reasonable estimates can be made based upon the fact that in almost all valuation systems, market value is influenced by two key factors:
1. The net value of the assets after paying all debtors.
2. The current value of anticipated future earnings from the business.
These factors can be evaluated either individually or in combination. This report will examine three specific methods of valuation that combine the two factors:
1. Net Asset Value--Focusing exclusively on the asset base of the firm. Typically, this model will produce the lowest valuation.
2. Discounted Future Earnings--Focusing exclusively on the earnings potential of the firm. In most, but not all cases, this approach will produce the highest valuation.
3. Assets and Earnings--Combining the two previous models in an attempt to find some mid-range valuation point.
This template is designed to assist you in placing a specific dollar value on your business. It will do so by using these three most commonly discussed valuation methods. Consequently, it will provide three specific (and very different) values that could be valid under different buy/sell situations.
Note: The selling price of a business is inevitably determined by intensive negotiation between an informed buyer and an informed seller. This template is in no way intended as a replacement for that negotiation activity. It is simply a tool to provide a starting point in your business valuation process. Don't make it a substitute for judgment.
This business tool includes
1 Excel Model
Dr. Albert D. Bates offers you this business tool for free!
download for free
Add to bookmarks
- Ayuni Amir(last updated: 26/11/2018 03:23)
- Julius V Sihombing(last updated: 16/10/2018 03:05)
- JORGE A GARZA, E.A.(last updated: 30/08/2018 20:47)
- Jeremy Tyler(last updated: 26/07/2018 02:17)Great starter tool!
- Herman Hermawan(last updated: 22/06/2018 10:05)
- Kanini Mutooni(last updated: 22/06/2018 09:17)
- Mueez Rahman(last updated: 20/06/2018 12:19)
People using this tool also downloaded
All in One Private Equity ModelUsed by Investment Professionals at Private Equity and IB Firmsfinancevaluationdcfevaprivate equityinvestment bankinglbofinancial statements4,665 remove_red_eye$180.00by John Swan
CEQ Method Valuation ModelValuation by the CEQ Method based on Discrete Scenario Cash Flow Forecastfinancevaluationcash flowsbetaprivate equityentrepreneurpresent valuesceqcertain equivalent1,451 remove_red_eye
Discounted Cash Flow (DCF) ModelA step by step Discounted Cash Flow Analysis Tutorial (DCF model)analysisfinancevaluationdcfprivate equityinvestment bankingdiscounted cash flowvalue of a businessdcf model24,273 remove_red_eye
LBO model - Leveraged Buyout AnalysisA step by step LBO model tutorial. It is easy to use and we provide support if needed. Have fun modeling!financevaluationleveraged buyoutprivate equityinvestment bankinglbom&amergers & acquisition11,319 remove_red_eye
LBO Model - Company Valuation ToolAn LBO Model to learn how to Value all types of Businesses Like a Private Equity Professionalfinancevaluationleveraged buyoutprivate equityfinancial modelinglbolbo analysislbo model2,157 remove_red_eyefreeby Jon Taylor
RADR Method Valuation ModelValuation by the RADR Method based on Discrete Scenario Cash Flow Forecastfinancevaluationcost of capitalcash flowsprivate equityentrepreneurradrrisk adjusted discount ratepresent values1,410 remove_red_eye
Simple LBO Template Excel Model (Leveraged Buyout)This LBO excel model will help you to view the possible opportunity when potentially acquiring a company with debt.acquisitionfinanceleveraged buyoutdebtprivate equityinvestment bankinglbo258 remove_red_eye$9.00by Alexander Jarvis
Dealing with Employee OptionsLearn how to value employee options and inserting this share in the value of your equity per share.financevaluationoptionsequitystock priceemployeeshares185 remove_red_eye
Three-Stage Free Cash Flow for the Firm (FCFF) Discount ModelValue the equity in a firm with three stages of growthfinancevaluationfree cash flow for the firmfcffhigh growthdiscount modelshifting leverage624 remove_red_eye
LBO Financial Model Excel Template (Illustrative)LBO (Leveraged Buyout) financial model for private companies (clean, simple, functional, and reusable template).acquisitionfinancialmodelleveraged buyoutprivate equitypefinancial modelinvestment bankinglboib438 remove_red_eye$100.00by Karl Schopf
Any questions on Business Valuation Template?
The user community and author are here to help. Go ahead!