Some Frequent Mistakes and Solutions When Forecasting Financial Statements

14 Pages Posted: 20 Oct 2008 Last revised: 14 Dec 2008

See all articles by Ignacio Velez-Pareja

Ignacio Velez-Pareja

Grupo Consultor CAV Capital Advisory & Valuation

Dary Luz Hurtado-Carrasquilla

Universidad Tecnologica de Bolivar

Date Written: November 20, 2008

Abstract

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 makes mistakes. This is especially relevant when we construct a financial model without plugs and without circularity.

In this work 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.

Keywords: Accounting, Forecasting Financial Statements, Decision Making, plugs, Planning and control, double entry principle, unbalancing problem

JEL Classification: G31, G29, M41

Suggested Citation

Velez-Pareja, Ignacio and Hurtado-Carrasquilla, Dary Luz, Some Frequent Mistakes and Solutions When Forecasting Financial Statements (November 20, 2008). Available at SSRN: https://ssrn.com/abstract=1286782 or http://dx.doi.org/10.2139/ssrn.1286782

Ignacio Velez-Pareja (Contact Author)

Grupo Consultor CAV Capital Advisory & Valuation ( email )

Ave Miramar # 18-93 Apt 6A
Cartagena
Colombia
+573112333074 (Phone)

HOME PAGE: http://cashflow88.com/decisiones/decisiones.html

Dary Luz Hurtado-Carrasquilla

Universidad Tecnologica de Bolivar ( email )

Campus de Ternera, Parque Industrial y Tecnológico
Colombia
6536960 (Phone)

Do you have negative results from your research you’d like to share?

Paper statistics

Downloads
990
Abstract Views
6,316
Rank
42,679
PlumX Metrics