Details

<p><b>Preface xvii</b></p> <p>Is This a Course in Statistics? xvii</p> <p>How This Book is Set Up xviii</p> <p>The Job of the Testifying Expert xix</p> <p>About the Companion Web Site—Spreadsheet Availability xix</p> <p>Note xx</p> <p>Acknowledgments xxi</p> <p><b>Introduction </b><b>The Application of Statistics to the Measurement of Damages for Lost Profits 1</b></p> <p>The Three Big Statistical Ideas 1</p> <p>Variation 1</p> <p>Correlation 2</p> <p>Rejection Region or Area 4</p> <p>Introduction to the Idea of Lost Profits 6</p> <p>Stage 1. Calculating the Difference Between Those Revenues That Should Have Been Earned and What Was Actually Earned During the Period of Interruption 7</p> <p>Stage 2. Analyzing Costs and Expenses to Separate Continuing from Noncontinuing 8</p> <p>Stage 3. Examining Continuing Expenses Patterns for Extra Expense 8</p> <p>Stage 4. Computing the Actual Loss Sustained or Lost Profits 8</p> <p>Choosing a Forecasting Model 9</p> <p>Type of Interruption 9</p> <p>Length of Period of Interruption 10</p> <p>Availability of Historical Data 10</p> <p>Regularity of Sales Trends and Patterns 10</p> <p>Ease of Explanation 10</p> <p>Conventional Forecasting Models 11</p> <p>Simple Arithmetic Models 11</p> <p>More Complex Arithmetic Models 11</p> <p>Trendline and Curve-Fitting Models 12</p> <p>Seasonal Factor Models 12</p> <p>Smoothing Methods 12</p> <p>Multiple Regression Models 13</p> <p>Other Applications of Statistical Models 14</p> <p>Conclusion 14</p> <p>Notes 15</p> <p><b>Chapter 1 </b><b>Case Study 1—Uses of the Standard Deviation 17</b></p> <p>The Steps of Data Analysis 17</p> <p>Shape 18</p> <p>Spread 19</p> <p>Conclusion 23</p> <p>Notes 23</p> <p><b>Chapter 2 </b><b>Case Study 2—Trend and Seasonality Analysis 25</b></p> <p>Claim Submitted 25</p> <p>Claim Review 26</p> <p>Occupancy Percentages 26</p> <p>Trend, Seasonality, and Noise 28</p> <p>Trendline Test 33</p> <p>Cycle Testing 33</p> <p>Conclusion 34</p> <p>Note 36</p> <p><b>Chapter 3 </b><b>Case Study 3—An Introduction to Regression Analysis and Its Application to the Measurement of Economic Damages 37</b></p> <p>What is Regression Analysis and Where Have I Seen It Before? 37</p> <p>A Brief Introduction to Simple Linear Regression 38</p> <p>I Get Good Results with Average or Median Ratios—Why Should I Switch to Regression Analysis? 40</p> <p>How Does One Perform a Regression Analysis Using Microsoft Excel? 43</p> <p>Why Does Simple Linear Regression Rarely Give Us the Right Answer, and What Can We Do about It? 51</p> <p>Should We Treat the Value Driver Annual Revenue in the Same Manner as We Have Seller’s Discretionary Earnings? 60</p> <p>What are the Meaning and Function of the Regression Tool’s Summary Output? 68</p> <p>Regression Statistics 69</p> <p>Tests and Analysis of Residuals 75</p> <p>Testing the Linearity Assumption 77</p> <p>Testing the Normality Assumption 78</p> <p>Testing the Constant Variance Assumption 80</p> <p>Testing the Independence Assumption 83</p> <p>Testing the No Errors-in-Variables Assumption 84</p> <p>Testing the No Multicollinearity Assumption 84</p> <p>Conclusion 87</p> <p>Note 87</p> <p><b>Chapter 4 </b><b>Case Study 4—Choosing a Sales Forecasting Model: A Trial and Error Process 89</b></p> <p>Correlation with Industry Sales 89</p> <p>Conversion to Quarterly Data 89</p> <p>Quadratic Regression Model 92</p> <p>Problems with the Quarterly Quadratic Model 92</p> <p>Substituting a Monthly Quadratic Model 94</p> <p>Conclusion 95</p> <p>Note 99</p> <p><b>Chapter 5 </b><b>Case Study 5—Time Series Analysis with Seasonal Adjustment 101</b></p> <p>Exploratory Data Analysis 101</p> <p>Seasonal Indexes versus Dummy Variables 102</p> <p>Creation of the Optimized Seasonal Indexes 103</p> <p>Creation of the Monthly Time Series Model 108</p> <p>Creation of the Composite Model 108</p> <p>Conclusion 115</p> <p>Notes 115</p> <p><b>Chapter 6 </b><b>Case Study 6—Cross-Sectional Regression Combined with Seasonal Indexes to Determine Lost Profits 117</b></p> <p>Outline of the Case 117</p> <p>Testing for Noise in the Data 119</p> <p>Converting to Quarterly Data 119</p> <p>Optimizing Seasonal Indexes 119</p> <p>Exogenous Predictor Variable 124</p> <p>Interrupted Time Series Analysis 124</p> <p> “But For” Sales Forecast 126</p> <p>Transforming the Dependent Variable 130</p> <p>Dealing with Mitigation 130</p> <p>Computing Saved Costs and Expenses 133</p> <p>Conclusion 137</p> <p>Note 138</p> <p><b>Chapter 7 </b><b>Case Study 7—Measuring Differences in Pre- and Postincident Sales Using Two Sample t-Tests versus Regression Models 139</b></p> <p>Preliminary Tests of the Data 139</p> <p>Using the t-Test Two Sample Assuming Unequal Variances Tool 141</p> <p>Regression Approach to the Problem 141</p> <p>A New Data Set—Different Results 143</p> <p>Selecting the Appropriate Regression Model 143</p> <p>Finding the Facts Behind the Figures 148</p> <p>Conclusion 151</p> <p>Notes 153</p> <p><b>Chapter 8 </b><b>Case Study 8—Interrupted Time Series Analysis, Holdback Forecasting, and Variable Transformation 155</b></p> <p>Graph Your Data 155</p> <p>Industry Comparisons 155</p> <p>Accounting for Seasonality 157</p> <p>Accounting for Trend 161</p> <p>Accounting for Interventions 161</p> <p>Forecasting “Should Be” Sales 164</p> <p>Testing the Model 167</p> <p>Final Sales Forecast 169</p> <p>Conclusion 169</p> <p><b>Chapter 9 </b><b>Case Study 9—An Exercise in Cost Estimation to Determine Saved Expenses 171</b></p> <p>Classifying Cost Behavior 171</p> <p>An Arbitrary Classification 172</p> <p>Graph Your Data 172</p> <p>Testing the Assumption of Significance 174</p> <p>Expense Drivers 174</p> <p>Conclusion 177</p> <p><b>Chapter 10 </b><b>Case Study 10—Saved Expenses, Bivariate Model Inadequacy, and Multiple Regression Models 179</b></p> <p>Graph Your Data 179</p> <p>Regression Summary Output of the First Model 181</p> <p>Search for Other Independent Variables 183</p> <p>Regression Summary Output of the Second Model 185</p> <p>Conclusion 188</p> <p><b>Chapter 11 </b><b>Case Study 11—Analysis of and Modification to Opposing Experts’ Reports 189</b></p> <p>Background Information 189</p> <p>Stipulated Facts and Data 190</p> <p>The Flaw Common to Both Experts 194</p> <p>Defendant’s Expert’s Report 196</p> <p>Plaintiff’s Expert’s Report 199</p> <p>The Modified-Exponential Growth Curve 201</p> <p>Four Damages Models 208</p> <p>Conclusion 208</p> <p><b>Chapter 12 </b><b>Case Study 12—Further Considerations in the Determination of Lost Profits 209</b></p> <p>A Review of Methods of Loss Calculation 210</p> <p>A Case Study: Dunlap Drive-In Diner 211</p> <p>Skeptical Analysis Using the Fraud Theory Approach 212</p> <p>Revenue Adjustment 212</p> <p>Officer’s Compensation Adjustment 214</p> <p>Continuing Salaries and Wages (Payroll) Adjustment 215</p> <p>Rent Adjustment 215</p> <p>Employee Bonus 216</p> <p>Discussion 216</p> <p>Conclusion 217</p> <p><b>Chapter 13 </b><b>Case Study 13—A Simple Approach to Forecasting Sales 221</b></p> <p>Month Length Adjustment 221</p> <p>Graph Your Data 221</p> <p>Worksheet Setup 222</p> <p>First Forecasting Method 227</p> <p>Second Forecasting Method 227</p> <p>Selection of Length of Prior Period 228</p> <p>Reasonableness Test 228</p> <p>Conclusion 229</p> <p><b>Chapter 14 </b><b>Case Study 14—Data Analysis Tools for Forecasting Sales 231</b></p> <p>Need for Analytical Tests 231</p> <p>Graph Your Data 231</p> <p>Statistical Procedures 233</p> <p>Tests for Randomness 235</p> <p>Tests for Trend and Seasonality 240</p> <p>Testing for Seasonality and Trend with a Regression Model 246</p> <p>Conclusion 249</p> <p>Notes 249</p> <p><b>Chapter 15 </b><b>Case Study 15—Determining Lost Sales with Stationary Time Series Data 251</b></p> <p>Prediction Errors and Their Measurement 251</p> <p>Moving Averages 252</p> <p>Array Formulas 254</p> <p>Weighted Moving Averages 256</p> <p>Simple Exponential Smoothing 260</p> <p>Seasonality with Additive Effects 263</p> <p>Seasonality with Multiplicative Effects 268</p> <p>Conclusion 272</p> <p><b>Chapter 16 </b><b>Case Study 16—Determining Lost Sales Using Nonregression Trend Models 273</b></p> <p>When Averaging Techniques are Not Appropriate 273</p> <p>Double Moving Average 275</p> <p>Double Exponential Smoothing (Holt’s Method) 277</p> <p>Triple Exponential Smoothing (Holt-Winter’s Method) for Additive Seasonal Effects 279</p> <p>Triple Exponential Smoothing (Holt-Winter’s Method) for Multiplicative Seasonal Effects 285</p> <p>Conclusion 288</p> <p><b>Appendix </b><b>The Next Frontier in the Application of Statistics 291</b></p> <p>The Technology 291</p> <p>EViews 291</p> <p>Minitab 292</p> <p>NCSS 292</p> <p>The R Project for Statistical Computing 293</p> <p>SAS 294</p> <p>SPSS 295</p> <p>Stata 296</p> <p>WINKS SDA 7 Professional 298</p> <p>Conclusion 299</p> <p>Bibliography of Suggested Statistics Textbooks 301</p> <p>Glossary of Statistical Terms 303</p> <p>About the Authors 317</p> <p>Index 319</p>

<p><b>MARK G. FILLER</b>, <b>CPA/ABV, CBA, AM, CVA,</b> is President of Filler & Associates, a valuation and litigation support practice. He recently was also chair of the editorial board of NACVA's <i>The Valuation Examiner</i> and coauthor of NACVA's quarterly marketing newsletter <i>Insights on Valuation</i>. Filler has published various articles and is recognized as a qualified expert witness, testifying frequently on business valuation, commercial damages, and personal injury matters at depositions and in state and federal courts. <p><b>JAMES A. D<small>I</small>GABRIELE, P<small>H</small>D/DPS, CPA/ABV, CFF, CFE, CFSA, CR.FA, CVA,</b> is a professor of accounting at Montclair State University and has been published in various journals, including <i>Journal of</i> <i>Forensic Accounting, Journal of Business Valuation and Economic Loss Analysis,</i> and <i>The Value Examiner.</i> Dr. DiGabriele is also Managing Director of DiGabriele, McNulty, Campanella & Co., LLC, an accounting firm specializing in forensic/investigative accounting and litigation support.

<p><b>A Quantitative Approach to Commercial Damages</b></br> <i>Applying Statistics to theMeasurement of Lost Profits</i> <p>There was a fire. The damages are extensive, and the restaurant will be closed for at least two months. It's your job to calculate the recoverable economic losses, whether stream of lost profits or lost value of the business. The problem is you're not entirely up to speed on the most sophisticated and flexible statistical techniques and tools currently available. Written for practitioners who have some experience in the field of calculating economic damages but who need new tools, <i>A Quantitative Approach to Commercial Damages</i> provides an introduction and a "how to" of some basic statistical techniques to help you establish a precise lost profits analysis. <p>Demonstrating the application of the various statistical forecasting and analytical models, authors Mark Filler and James DiGabriele—leading forensic and valuation experts—present selected statistical techniques you can apply in lost profits cases. You'll discover new ways to integrate computing power and spreadsheets—especially in Excel and its add-in statistical tools—to quickly simplify complex financial calculations in preparing cases. <p>Sixteen real-world case studies show you how to: <ul> <li>Use the standard deviation to determine if a number falls within an expected range based on past performance</li> <li>Test the sales history of the XYZ Motel to determine if there is an upward trend in the data</li> <li>Forecast expected sales during the period of restoration using a time series regression model</li> <li>Compare pre- and post-incident sales and demonstrate techniques</li> <li>Determine saved expenses and the issue of statistical significance vs. practical significance</li> <li>Apply forensic accounting principles to a lost profits case</li> <li>Analyze historical sales data searching for trend and seasonality</li> </ul> <p>A companion website contains all the spreadsheets for the case studies. You can either create the spreadsheets from scratch, following the instructions contained in each chapter and using the website spreadsheets as guidelines, or simply download them from the website and start your own analysis immediately. <p>Don't underestimate the value of your business loss. Get the tools to compute precise lost profits with <i>A Quantitative Approach to Commercial Damages</i>.

US