Click here to visit my website at CanyonValuations.com

Thoughts on Business Valuation, Microsoft Excel,

and Where the Two Meet!

Happy New Year, 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

Why Do We Do What We Do? -

Comparative Financial Analysis Edition


Happy New Year!!


As Business Appraisers, we look at a lot of numbers. We examine financial statements and tax returns so we can identify historical trends, and help identify risk drivers, but I have noticed quite a few reports this last year where the appraiser omitted a comparative financial ratio analysis. I thought I’d start off this year’s newsletter with a discussion on this basic analysis.


Revenue 59-60 lists as one of the eight factors we are to consider in the valuation of a privately held business as, “The book value of the stock and the financial condition of the business.” If all we look at is the subject company’s financial data, we are only going to see the part of the picture that the subject company portrays. If we also compare the subject company’s data to industry averages, then we can really see how the Company has been performing amongst its peers. If a business’ ratios indicate that it is underperforming, then we can draw the conclusion that the subject business may have higher operating risk. If the industry ratios are showing the subject business to be performing better than average, then we can use that to support the selection of a higher than average market multiple and also a lower discount rate.


We have several sources where we can pull data from for the ratios. The Risk Management Association (RMA) tracks financial data received by lenders as part of their customers’ banking needs. Bizminer pulls data from a variety of public sources listed on their website and calculates the ratios we use from among those data sources. (https://support.bizminer.com/article/36-where-does-bizminer-get-its-data) There are several other sources, but I am much less familiar with them.

I'm Now On YouTube!


I record a new video on either Excel and/or a Business Valuation related topics every so often. I post the videos on my channel, but I don't highlight each one here in the newsletter. If you don't want to miss anything I have to say about those topics, please "Like" and "Subscribe" to the channel. Each time I post a new video, you will be notified.


Today I am starting to feature just some quick videos on some Excel tips and tricks that I use to help my template move along a bit faster. My goal is to keep each video under 10 minutes in length.


If you feel so inclined, please add comments and/or questions below each video as YouTube uses the quantity of postings in their ranking of each video. The higher the ranking, the more likely the video will be seen by other folks not attached to my newsletter.


Exciting function uses and formulae to modify data in an Excel Template!

Why Do We Do What We Do? -

Comparative Financial Analysis Edition

- Continued...

I have seen a report, where the appraiser presented the analysis of the subject’s financial statements and trends, then stated that because the subject business reported a profit, it was a stronger performing business and used that statement to justify selecting higher market multiples and lower capitalization rates. Just for fun, I pulled a Bizminer report for businesses in that industry and size category, and when I looked at those ratios, I saw that the subject business’ reported profits were much lower than that of the industry average. I am pretty sure that if the appraiser had taken the time to perform a basic comparative analysis, that the value conclusion reached would have been materially different.


Once we have pulled this benchmarking industry data, it is important to compare the subject business to it, so we can see what benchmarks the subject falls short on or is surpassing. I have found that very few businesses that I have been asked to appraise, are either an average or a median business. Which leads me to the conclusion that using an average or a median market multiple may often be the wrong choice for an appraiser.


The rates and multiples we business appraisers use, are dependent on the data we analyze, our analysis of that data, and then our interpretation of what the analysis indicates for the subject. When we provide our opinion of value to the client, it really needs to be our opinion described in that report, and not just what the math said. Remember, business appraisal is both an art as well as a science. Don’t overemphasize one at the expense of the other.


I’m happy to chat about financial ratios, or other valuation topics!  If you have any questions, you can reach out. CanyonValuations@gmail.com


Have a happy and successful new year!

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.