Description
Book SynopsisDemystifies regression-based valuation through simple explanations, easy-to-understand charts, and time-saving bonus resources
Current methodologies using median, quartiles, or standard deviations to calculate revenue multipliers and cash flow multipliers often produce values that are wildly divergent. This forces the appraiser to choose between a very high or a very low value or consider averaging the values, opening the possibility for the appraiser to be challenged. On the surface, regression analysis appears to be the more complex, mathematical model, so many professionals shy away from using it out of fear that readers will be confused and reject the results of the appraisal. Valuing Businesses Using Regression Analysis solves this issue by breaking down regression to its simplest terms and providing easy-to-read charts and explanations that can be understood by all.
Since regression analysis does not come pre-installed in Excel, this book will show
Table of Contents
Foreword
Preface i
CHAPTER 1: Current Methodologies 1
CHAPTER 2: The Solution 15
CHAPTER 3: Identifying Outliers Using Re-gression 26
CHAPTER 4: Cash Flow Multiplier Regression 31
CHAPTER 5: Enterprise Multiplier 41
CHAPTER 6: Polynomial Regressions 45
CHAPTER 7: Multiple Variable Regression 50
CHAPTER 8: Selection of Transactions in the Sample 62
CHAPTER 9: Regression 2.0 92
CHAPTER 10: Using Excel’s Regression Utility 107
CHAPTER 11: Excel Valuation Template 125
CHAPTER 12: Conclusion
Acknowledgments 142
