Constructing Consistent Financial Planning Models for Valuation

IIMS Journal of Management of Science, Vol. 1, January-June 2010 (Inaugural Issue)

29 Pages Posted: 19 Aug 2009 Last revised: 24 Jun 2012

Ignacio Velez-Pareja

Grupo Consultor CAV Capital Advisory & Valuation

Date Written: August 15, 2009

Abstract

In this work we show a simplified financial planning model. In reality, financial planning models are huge and cumbersome. This is a very simplified model compared with what is found in practice. We present some basic principles for constructing the financial statements needed for valuation. We show in detail all the items of the financial model and show the formulas to be used for constructing the financial planning model. The relevant financial statements are: the Balance Sheet (BS), the Income statement (IS) and the Cash Budget (CB). The construction of the financial statements starts from input data and policies and/or targets (i.e. accounts receivable policy or target). With these targets or policies we can construct the financial statements. The contribution of this work is double: one is to show that we can construct financial statements without the use of plugs and circularity and the second is that we can use a very simple approach to construct cash flows and to value them. The model shown has two parts. One is the proper financial statements forecast. The second one is a simple cash flow calculation and valuation exercise using the Capital Cash Flow and assuming the risk of the tax savings equal to Ku, the cost of unlevered equity.

Keywords: Accounting, Forecasting Financial Statements, Decision Making, plugs, Planning and control, double entry principle, unbalancing problem, cash flows, firm valuation, cost of unlevered equity

JEL Classification: D60, E47, G31, H43

Suggested Citation

Velez-Pareja, Ignacio, Constructing Consistent Financial Planning Models for Valuation (August 15, 2009). IIMS Journal of Management of Science, Vol. 1, January-June 2010 (Inaugural Issue). Available at SSRN: https://ssrn.com/abstract=1455304

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

Paper statistics

Downloads
1,328
Rank
10,567
Abstract Views
5,078