A quantitative approach to commercial damages : applying statistics to the measurement of lost profits /

• Κύριος συγγραφέας: DiGabriele, James A., 1962-
• Άλλοι συγγραφείς: Filler, Mark, 1942-
• Μορφή: Ηλ. βιβλίο
• Γλώσσα: English
• Έκδοση: Hoboken, N.J. : Wiley, 2013.
• Θέματα: Business.; BUSINESS & ECONOMICS > Accounting > General.; Electronic books.

 How-to guidance for measuring lost profits due to business interruption damages. "A Quantitative Approach to Commercial Damages" explains the complicated process of measuring business interruption damages, whether they are losses are from natural or man-made disasters, or whether the performance of one company adversely affects the performance of another. Using a methodology built around case studies integrated with solution tools, this book is presented step by step from the analysis damages perspective to aid in preparing a damage claim. Over 250 screen shots are included and key cell formulas that show how to construct a formula and lay it out on the spreadsheet. Includes Excel spreadsheet applications and key cell formulas for those who wish to construct their own spreadsheets. Offers a step-by-step approach to computing damages using case studies and over 250 screen shots. Often in the course of business, a firm will be damaged by the actions of another individual or company, such as a fire that shuts down a restaurant for two months. Often, this results in the filing of a business interruption claim. Discover how to measure business losses with the proven guidance found in "Quantitative Approach to Commercial Damages." 

 Machine generated contents note: INTRODUCTION The Application of Statistics to the Measurement of Damages for Lost Profits -- The Three Big Statistical Ideas -- Variation -- Correlation -- Rejection Region or Area -- Introduction to the Idea of Lost Profits -- Stage 1 Calculating the Difference Between Those Revenues That Should Have Been Earned and What Was Actually Earned During the Period of Interruption -- Stage 2 Analyzing Costs and Expenses to Separate Continuing from Noncontinuing -- Stage 3 Examining Continuing Expenses Patterns for Extra Expense -- Stage 4 Computing the Actual Loss Sustained or Lost Profits -- Choosing a Forecasting Model -- Type of Interruption -- Length of Period of Interruption -- Availability of Historical Data -- Regularity of Sales Trends and Patterns -- Ease of Explanation -- Conventional Forecasting Models -- Simple Arithmetic Models -- More Complex Arithmetic Models -- Trendline and Curve-Fitting Models -- Seasonal Factor Models -- Smoothing Methods -- Multiple Regression Models -- Other Applications of Statistical Models -- Conclusion -- Notes -- ch. 1 Case Study 1 -- Uses of the Standard Deviation -- The Steps of Data Analysis -- Shape -- Spread -- Conclusion -- Notes -- ch. 2 Case Study 2 -- Trend and Seasonality Analysis -- Claim Submitted -- Claim Review -- Occupancy Percentages -- Trend, Seasonality, and Noise -- Trendline Test -- Cycle Testing -- Conclusion -- Note -- ch. 3 Case Study 3 -- An Introduction to Regression Analysis and Its Application to the Measurement of Economic Damages -- What Is Regression Analysis and Where Have I Seen It Before? -- A Brief Introduction to Simple Linear Regression -- I Get Good Results with Average or Median Ratios -- Why Should I Switch to Regression Analysis? -- How Does One Perform a Regression Analysis Using Microsoft Excel? -- Why Does Simple Linear Regression Rarely Give Us the Right Answer, and What Can We Do about It? -- Should We Treat the Value Driver Annual Revenue in the Same Manner as We Have Seller's Discretionary Earnings? -- What Are the Meaning and Function of the Regression Tool's Summary Output? -- Regression Statistics -- Tests and Analysis of Residuals -- Testing the Linearity Assumption -- Testing the Normality Assumption -- Testing the Constant Variance Assumption -- Testing the Independence Assumption -- Testing the No Errors-in-Variables Assumption -- Testing the No Multicollinearity Assumption -- Conclusion -- Note -- ch. 4 Case Study 4 -- Choosing a Sales Forecasting Model: A Trial and Error Process -- Correlation with Industry Sales -- Conversion to Quarterly Data -- Quadratic Regression Model -- Problems with the Quarterly Quadratic Model -- Substituting a Monthly Quadratic Model -- Conclusion -- Note -- ch. 5 Case Study 5 -- Time Series Analysis with Seasonal Adjustment -- Exploratory Data Analysis -- Seasonal Indexes versus Dummy Variables -- Creation of the Optimized Seasonal Indexes -- Creation of the Monthly Time Series Model -- Creation of the Composite Model -- Conclusion -- Notes -- ch. 6 Case Study 6 -- Cross-Sectional Regression Combined with Seasonal Indexes to Determine Lost Profits -- Outline of the Case -- Testing for Noise in the Data -- Converting to Quarterly Data -- Optimizing Seasonal Indexes -- Exogenous Predictor Variable -- Interrupted Time Series Analysis -- "But For" Sales Forecast -- Transforming the Dependent Variable -- Dealing with Mitigation -- Computing Saved Costs and Expenses -- Conclusion -- Note -- ch. 7 Case Study 7 -- Measuring Differences in Pre- and Postincident Sales Using Two Sample t-Tests versus Regression Models -- Preliminary Tests of the Data -- Using the t-Test Two Sample Assuming Unequal Variances Tool -- Regression Approach to the Problem -- A New Data Set -- Different Results -- Selecting the Appropriate Regression Model -- Finding the Facts Behind the Figures -- Conclusion -- Notes -- ch. 8 Case Study 8 -- Interrupted Time Series Analysis, Holdback Forecasting, and Variable Transformation -- Graph Your Data -- Industry Comparisons -- Accounting for Seasonality -- Accounting for Trend -- Accounting for Interventions -- Forecasting "Should Be" Sales -- Testing the Model -- Final Sales Forecast -- Conclusion -- ch. 9 Case Study 9 -- An Exercise in Cost Estimation to Determine Saved Expenses -- Classifying Cost Behavior -- An Arbitrary Classification -- Graph Your Data -- Testing the Assumption of Significance -- Expense Drivers -- Conclusion -- ch. 10 Case Study 10 -- Saved Expenses, Bivariate Model Inadequacy, and Multiple Regression Models -- Graph Your Data -- Regression Summary Output of the First Model -- Search for Other Independent Variables -- Regression Summary Output of the Second Model -- Conclusion -- ch. 11 Case Study 11 -- Analysis of and Modification to Opposing Experts' Reports -- Background Information -- Stipulated Facts and Data -- The Flaw Common to Both Experts -- Defendant's Expert's Report -- Plaintiff's Expert's Report -- The Modified-Exponential Growth Curve -- Four Damages Models -- Conclusion -- ch. 12 Case Study 12 -- Further Considerations in the Determination of Lost Profits -- A Review of Methods of Loss Calculation -- A Case Study: Dunlap Drive-in Diner -- Skeptical Analysis Using the Fraud Theory Approach -- Revenue Adjustment -- Officer's Compensation Adjustment -- Continuing Salaries and Wages (Payroll) Adjustment -- Rent Adjustment -- Employee Bonus -- Discussion -- Conclusion -- ch. 13 Case Study 13 -- A Simple Approach to Forecasting Sales -- Month Length Adjustment -- Graph Your Data -- Worksheet Setup -- First Forecasting Method -- Second Forecasting Method -- Selection of Length of Prior Period -- Reasonableness Test -- Conclusion -- ch. 14 Case Study 14 -- Data Analysis Tools for Forecasting Sales -- Need for Analytical Tests -- Graph Your Data -- Statistical Procedures -- Tests for Randomness -- Tests for Trend and Seasonality -- Testing for Seasonality and Trend with a Regression Model -- Conclusion -- Notes -- ch. 15 Case Study 15 -- Determining Lost Sales with Stationary Time Series Data -- Prediction Errors and Their Measurement -- Moving Averages -- Array Formulas -- Weighted Moving Averages -- Simple Exponential Smoothing -- Seasonality with Additive Effects -- Seasonality with Multiplicative Effects -- Conclusion -- ch. 16 Case Study 16 -- Determining Lost Sales Using Nonregression Trend Models -- When Averaging Techniques Are Not Appropriate -- Double Moving Average -- Double Exponential Smoothing (Holt's Method) -- Triple Exponential Smoothing (Holt-Winter's Method) for Additive Seasonal Effects -- Triple Exponential Smoothing (Holt-Winter's Method) for Multiplicative Seasonal Effects -- Conclusion -- APPENDIX The Next Frontier in the Application of Statistics -- The Technology -- EViews -- Minitab -- NCSS -- The R Project for Statistical Computing -- SAS -- SPSS -- Stata -- WINKS SDA 7 Professional -- Conclusion.