Some Frequent Mistakes and Solutions When Forecasting Financial Statements (In Spanish)
15 Pages Posted: 19 Aug 2008 Last revised: 5 Jul 2013
Date Written: November 20, 2008
When forecasting financial statements care has to be taken to construct a consistent and correct model. This is not an easy task. Even the most experienced expert in modeling make mistakes. This is especially relevant when we construct a financial model without plugs and without circularity.
In this teaching note we list some common mistakes made while constructing financial models. This list comes from our experience teaching and coaching students in the process of constructing the model and from the professional practice and consulting in finance, especially in firm valuation.
The purpose of this work is to help future students and practitioners when doing the job of forecasting financial statements. After the mistakes have been detected and corrected, they might look like silly mistakes, however, everybody knows that it is easy to be very smart after things have happened. When the mismatching appeared they were real huge problems. After many headaches and lots of work they were found and corrected. Today even after we have worked hard in finding out where the mistakes were, we might consider them as ridiculous or even silly mistakes.
An additional thought is to consider that the exercise to forecast the financial statements of a firm from the outside is a futile one. A fruitful forecasting work is done when the analyst is an insider or is a consultant with full access to the relevant information.
We expect that these thoughts be useful to our students and colleagues and that they avoid mistakes in their academic and professional work
Note: Downloadable document is in Spanish.
Keywords: Accounting, Forecasting Financial Statements, Decision Making, plugs, Planning and control, double entry principle, unbalancing problem
JEL Classification: G31, G29, M41
Suggested Citation: Suggested Citation