SHARE:  
Click here to visit my website at CanyonValuations.com

Thoughts on Business Valuation, Microsoft Excel,

and Where the Two Meet!

Hello Shawn,


Welcome to this newsletter sent "From the Desk of Shawn Hyde"! I hope the ideas on business valuation and Excel related topics I share with you here every so often are useful for you!


If at anytime you decide you no longer want to hear from me, please click the 'Unsubscribe' link near the bottom of this email:

Who is Shawn Hyde?


Shawn Hyde, CBA, CVA, CMEA, BCA has over 20 years of valuation and appraisal experience in numerous industries. He served as the executive director of the International Society of Business Appraisers (ISBA) from July 2018 through June 2022.  He is a Certified Business Appraiser, Certified Valuation Analyst, Certified Machinery & Equipment Appraiser, and a Business Certified Appraiser.  He has written and taught courses for the Institute of Business Appraisers (IBA), the National Association of Certified Valuators and Analysts (NACVA), and the International Society of Business Appraisers (ISBA).  He has served on the IBA’s Education Board, and the IBA’s Board of Governors, and is a past Editor in Chief of the IBA’s professional journal, Business Appraisal Practice.

Click Here to See Shawn's CV

Rules of Thumb Are Useful Tools, But…


Rules of thumb have been around almost as long as there have been thumbs. People enjoy using a measurement that is always at hand, as it were, without having to do a lot of complicated research and analysis. Unfortunately, there is no standard thumb size so each measurement performed by each individual with their own thumb will be different than any other’s measurement of the same thing. That sort of confusion has spawned a multitude of different rules of thumb that different experts have formulated to help themselves perform various measurements. One example would be a measurement of the length of a specific piece of wood. Depending on the size of the individual, a rule of thumb of “three handspans in length” might be equal to another’s “4.5 handspans in length”. It doesn’t mean that the length of that board changed, it just means that one individual has smaller hands than the other. The next set of carpenters to come by and measure that same piece of wood, remembering the easy rules of thumb mentioned by those before, will be expecting to see a length of wood of between 3 and 4.5 times the width of their hands, but it will actually be a slightly different multiple of handspans for each carpenter. 


When it comes to business valuation, pricing a business for sale, or simply checking to see what it might cost to buy out a partner, rules of thumb are an easy option; but there are so many variables affecting that answer, that the best answer one can get with a series of rules of thumb is really a range of values, and that range will be different for each thumb used to measure it. Not to mention that rules of thumb are also always changing and growing over time as market conditions and businesses evolve. 


Let’s explore that concept about rules of thumb changing over time. I own a copy of a book first published in 1987, but my copy is the third edition and was published in 1993. It is the Handbook of Small Business Valuation Formulas and Rules of Thumb by Glenn Desmond, published by Valuation Press. In it there is a rule of thumb for Automobile Dealerships that says the following:


Use a stabilized Owner’s Cash Flow (OCF).

OCF multiplier typical range: 0.0x – 1.25x OCF

 

Formula assets included in the indicated value:

  • Lease
  • Intangibles

 

Add fixed assets at market value to formula assets.


Please note that the above ‘rule’ can be summarized by saying, “Apply a multiple to earnings, then add fixed assets.” What also needs to be pointed out is that the multiple range varies from zero to 1.25 times, and the selected multiple depends on a variety of other factors described in the book, such as the type of dealership, trends in the national economy, the location of the facility and the terms of the lease. 


Let’s use the following simplified sample data for pricing an auto dealership owned back in the early 1990s:


·        Owner’s Cash Flow - $100,000

·        Fixed Assets at Market Value - $250,000

·        Annual Sales - $1,000,000

I'm Now On YouTube!


I plan on recording videos on Excel and Business Valuation related topics and posting them on my new channel. If anyone is interested in what I have to say about those topics, I guess you are supposed to "Like" and "Subscribe"? I'll learn more about those things as I continue playing with these new toys. :-)


The DCF Method, and a bit more...


I planned on presenting a discussion on the application of the Discounted Cash Flow (DCF) Method for the ISBA for their July 2022 webinar.  That won't happen now, so instead, I recorded myself running through the materials and am making it available for you to view. It's not quite as good as being able to hear and answer your questions in the moment, but feel free to reach out and ask me any questions you may have, anyway!

Rules of Thumb Are Useful Tools, But…

- continued


(Please note that most rules of thumb for business pricing like this one, do NOT include the value of any real property the owner may actually have.)


The range of indicated pricing for our hypothetical 1990s auto dealership is shown below:

I am going to compare that rule of thumb, to those described in the current version (2022) of the Business Reference Guide, published by Business Brokerage Press and compiled by Tom West for Auto Dealerships – New Cars that shows two completely different rules of thumb. The new terminology of ‘Seller’s Discretionary Earnings’, is equivalent to the older style phrasing of ‘Owner’s Cash Flow’, so I am going to use those same sample numbers described above.


4 x Seller’s Discretionary Earnings (SDE)

 

Or

 

30% of Annual Sales

Please note, these modern multiples do not add back the market value of any fixed assets the business owns, because the value of those items required by the operations, are included in the use of the selected (larger) multiple. Just like the book I cited above published in 1993, if one reads further, there are directions explaining what factors need to be analyzed that will affect the size of the selected multiple used by the rules of thumb. The overall price of a specific business will depend on the market value of the operating inventory, the furniture, fixtures, and equipment, and other factors. That means an analysis of the subject dealership could indicate that the selected SDE multiple should be smaller or larger than 4, and a similar adjustment may be appropriate for a revenue multiplier. 


(It also means that if the subject business owns certain assets that are not necessary for operations, those assets are not included in the indication of value determined.)


One of the most significant challenges we all face as professionals determining a value for a business, regardless of the purpose requiring that valuation, is to make sure that we are always using the correct variables for whatever formula we are attempting to use. Imagine what would happen to an expert who conflated several rules of thumb, and used parts from one and parts from another and combined them to make up their own rule of thumb, without ever having actually personally measured that one board the original rules of thumb were based on? An example is illustrated below:

The above example is double counting the value of the fixed assets held by the business. The selected multiple of 4x, includes the assets that are required by the operation to generate those cash flows. If the business did not have those assets, then it would also not have that level of earnings. A conflated rule of thumb will typically return an inflated value, as most people tend to pick and choose the larger variables from any ‘rule of thumb’ they happen to remember having read once upon a time. 


Just because the math works in the example above, doesn’t mean a deal will close under those terms. Remember that length of wood we talked about at first? Using this conflated example, a professional is basically attempting to sell a 32-inch board by telling interested parties that it is actually 48 inches long. As soon as one of those interested parties brings out their own tape measure and runs through their own due diligence, they will know that the board’s length had been grossly overestimated. Logic, reasonableness, and basic valuation theory must be a part of the process, or the numbers that we end up determining for the Companies we service, simply won’t be realistic.  


If you have any questions you’d like to bounce off of a third-party, you can reach me at CanyonValuations@gmail.com.



Your friendly neighborhood business appraiser,


Shawn Hyde, CBA, CVA, CMEA, BCA

Click Here to Read My Blog for My Thoughts on Other Topics!

Canyon Valuations, LLC

P.O. Box 5197

Twin Falls, ID 83303

Phone: (208) 749-3116

Email: CanyonValuations@gmail.com

Click Here to Contact Me

Find me on LinkedIn here!

Please forward this email to anyone who is interested in these topics! If you wish to be added to my email list, let me know by clicking the "Contact Me" button above.