Prospective Financial Modeling With Excel

BVResearch Pro
Training Event Transcripts
August 29, 2018
Mark Shirley, CPA/ABV/CFF,CVA,MAFF,CFE
methodology

Summary

Getting started: Define the modeling objectives Developing the assumptions Sufficient relevant data Sample size Evaluate data integrity and reliability Building the model Designing the model to address the objectives or stated problem Continuity with historic data Integrated progressive submodels Movable and scalable models Evaluating precision Precision vs. reasonable certainty Establishing a baseline Minimizing forecasting errors Identifying issues Data-based errors Calculation Errors Outlier values Anomalies and random events Common sense and professional judgment ...
Prospective Financial Modeling with Excel
PDF, Size: 537 KB