A step by step guide to construct a finacial model without plugs and circularity for valuation purposes

Ignacio Velez-Pareja ()

No 4709, Proyecciones Financieras y Valoración from Master Consultores

Abstract: In this teaching note the reader finds a simplified financial model. In reality, financial models are huge and cumbersome. What we present is very simplified model in comparison to what is found in practice. We indicate the formulas that have to be utilized in the construction of the financial model. We have constructed the formulas in such a way that they can be used to construct part of or the complete model. In the first line and in the first column the reader finds the letters and numbers corresponding to the Excel® spreadsheet in order to make it easier the localization and the construction of the different formulas. In the last two columns we havewritten those formulas. Usually the formulas correspond to the year 0 and/or year 1. When necessary, we show the formulas for other years and we indicate it. Shaded cells are for the input data. The contribution of this work is double: one is to show that we can construct financialstatements 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 principal; cash flows; firm valuation; cost of unlevered equity (search for similar items in EconPapers)
JEL-codes: D6 E47 G31 H43 (search for similar items in EconPapers)
Pages: 21
Date: 2008-06-04
References: Add references at CitEc
Citations:

Downloads: (external link)
http://ssrn.com/abstract=1138428

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:col:000463:004709

Access Statistics for this paper

More papers in Proyecciones Financieras y Valoración from Master Consultores
Bibliographic data for series maintained by Ignacio Velez ().