| Using Regression Analysis in the Market Approach (GCTM) (1439Q)
Course CPE: 2 hour(s)
Field(s) of Study: Computer Software and Applications–1 hr; Production–1 hr
Program Level: Intermediate
Prerequisites: Previous training or research on subject matter being taught. Such persons are often at a mid-level within the organization, with operational and/or supervisory responsibilities.
Advanced Preparation: None
Delivery Method: QAS Self-Study
Shipping Weight: 0lbs. 0oz.
|Recording Date: June 19, 2020
Presenter: C Fred Hall
The attendees will learn how to use Excel's regression analysis and to apply it to Market Approach methodologies. Learn how regression analysis can filter a sample of comparables to statistically identify outliers that are skewing one's data significantly. Attendees will be shown how to use regression to statistically predict the proper revenue multiplier and cash flow multiplier for the subject, thus, eliminating the messy subjective selection process. Learn why every appraiser makes a critical error when he or she selects the upper or lower quartile or standard deviation of the multipliers to apply to his subject company.
After completing this course, attendees will be able to:
- Identify statistical tools to eliminate the embarrassingly huge differences in values that typically occur when using current methodologies to calculate the revenue and cash flow multipliers
- Identify the basic data from DealStats (formerly Pratt's Stats) or Bizcomps to statistically predict the appropriate multipliers for the subject company
- Identify how regression analysis will put one's GCTM Market Approach on a scientifically sound footing
- Select the challenges to your selection process for multipliers will be eliminated and no more huge gaps between multiplier values
For more information regarding refund or concerns, please contact our offices at (800) 677-2009.
The Consultants’ Training Institute (CTI) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.