IDEAS home Printed from https://ideas.repec.org/p/col/000463/005747.html
   My bibliography  Save this paper

Constructing Consistent Financial Planning Models for Valuation

Author

Listed:
  • Ignacio Velez-Pareja

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.

Suggested Citation

  • Ignacio Velez-Pareja, 2009. "Constructing Consistent Financial Planning Models for Valuation," Proyecciones Financieras y Valoración 5747, Master Consultores.
  • Handle: RePEc:col:000463:005747
    as

    Download full text from publisher

    File URL: http://ssrn.com/abstract=1455304
    Download Restriction: no
    ---><---

    More about this item

    Keywords

    Accounting; Forecasting Financial Statements; Decision Making; plugs; Planning and control; double entry principle; unbalancing problem; cash flows; firm valuation; cost of unlevered equity;
    All these keywords.

    JEL classification:

    • D6 - Microeconomics - - Welfare Economics
    • E47 - Macroeconomics and Monetary Economics - - Money and Interest Rates - - - Forecasting and Simulation: Models and Applications
    • G31 - Financial Economics - - Corporate Finance and Governance - - - Capital Budgeting; Fixed Investment and Inventory Studies
    • H43 - Public Economics - - Publicly Provided Goods - - - Project Evaluation; Social Discount Rate

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:col:000463:005747. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Ignacio Velez (email available below). General contact details of provider: .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.