Prospective analysis: Guidelines for forecasting financial statements

In this chapter, we discuss some ideas that might be useful in forecasting financial statements based on historical data.1 The approaches and suggestions presented in this chapter assume that the analyst has access to some company information that is not usually found in publicly available financial...

Full description

Autores:
Tipo de recurso:
Fecha de publicación:
2009
Institución:
Universidad Tecnológica de Bolívar
Repositorio:
Repositorio Institucional UTB
Idioma:
eng
OAI Identifier:
oai:repositorio.utb.edu.co:20.500.12585/9123
Acceso en línea:
https://hdl.handle.net/20.500.12585/9123
Palabra clave:
Rights
restrictedAccess
License
http://creativecommons.org/licenses/by-nc-nd/4.0/
id UTB2_770ef58572f98c7c41f945174bcd12ac
oai_identifier_str oai:repositorio.utb.edu.co:20.500.12585/9123
network_acronym_str UTB2
network_name_str Repositorio Institucional UTB
repository_id_str
dc.title.none.fl_str_mv Prospective analysis: Guidelines for forecasting financial statements
title Prospective analysis: Guidelines for forecasting financial statements
spellingShingle Prospective analysis: Guidelines for forecasting financial statements
title_short Prospective analysis: Guidelines for forecasting financial statements
title_full Prospective analysis: Guidelines for forecasting financial statements
title_fullStr Prospective analysis: Guidelines for forecasting financial statements
title_full_unstemmed Prospective analysis: Guidelines for forecasting financial statements
title_sort Prospective analysis: Guidelines for forecasting financial statements
description In this chapter, we discuss some ideas that might be useful in forecasting financial statements based on historical data.1 The approaches and suggestions presented in this chapter assume that the analyst has access to some company information that is not usually found in publicly available financial statements. In forecasting financial statements, we start with the historical financial statements and from them we identify the patterns and relationships of different items, the implicit policies, growth rates, and so on. The usual practice is to examine historical financial statements to derive information from them that can be used to forecast financial statements. As all information needed cannot be obtained from historical statements, we assume that the information is available from the company's management. We show how we can find information not found in the statements. Finally, we develop a detailed example of a hypothetical firm to explain the procedure to forecast financial statements. We also critically examine the usual practice of using plugs in forecasting financial statements. The chapter is organized as follows: first, we present comments in a general form about the relevance of prospective analysis to nontraded firms. Specifically, we highlight the importance for these firms of having a financial model with which they can assess the value creation in the firm. In the second section, we review concepts in accounting and economics that are used in forecasting financial statements. We stress upon a financial statement that shows the detailed inflows and outflows of cash in the firm: the cash budget (CB). This is an important tool for managing a firm. We also review topics like Pareto law and Fisher equation. Fisher equation is the key to forecasting variables linked to inflation rate. We also review the indexes used to measure inflation. The chapter uses the Fisher equation to forecast interest rates and increases in prices. Special mention is devoted to a usual practice when forecasting: the plug. This is a practice that we do not recommend and show an alternate approach. The approach we propose in this chapter follows an accounting principle that is the basis of any accounting procedure: the Double Entry Principle. This principle guarantees consistent and error-free financial statements. We show with a simple example how the plug works and its limitations. Next, the reader will find what information is needed for forecasting financial statements and where and how to find it. We identify the procedure to identify policies that govern the working of a firm such as accounts receivable and payable (AR and AP), inventories, dividend payout, payments in advance, and the like. We also deal with the real-life problem of a firm with multiple products and/or services. Finally, we show some tools to perform sensitivity analysis for financial management and analysis. We also use this tool to check the consistency of the financial model. In the next two sections, we deal with the relevance of several accounting concepts. In particular, we briefly describe the CB. © 2009 Springer-Verlag Berlin Heidelberg.
publishDate 2009
dc.date.issued.none.fl_str_mv 2009
dc.date.accessioned.none.fl_str_mv 2020-03-26T16:33:00Z
dc.date.available.none.fl_str_mv 2020-03-26T16:33:00Z
dc.type.coarversion.fl_str_mv http://purl.org/coar/version/c_970fb48d4fbd8a85
dc.type.coar.fl_str_mv http://purl.org/coar/resource_type/c_3248
dc.type.driver.none.fl_str_mv info:eu-repo/semantics/bookPart
dc.type.hasVersion.none.fl_str_mv info:eu-repo/semantics/publishedVersion
dc.type.spa.none.fl_str_mv Capítulo de Libro
status_str publishedVersion
dc.identifier.citation.none.fl_str_mv Investment Management: A Modern Guide to Security Analysis and Stock Selection; pp. 155-223
dc.identifier.isbn.none.fl_str_mv 9783540888017
dc.identifier.uri.none.fl_str_mv https://hdl.handle.net/20.500.12585/9123
dc.identifier.doi.none.fl_str_mv 10.1007/978-3-540-88802-4_8
dc.identifier.instname.none.fl_str_mv Universidad Tecnológica de Bolívar
dc.identifier.reponame.none.fl_str_mv Repositorio UTB
dc.identifier.orcid.none.fl_str_mv 6503847935
7003570680
identifier_str_mv Investment Management: A Modern Guide to Security Analysis and Stock Selection; pp. 155-223
9783540888017
10.1007/978-3-540-88802-4_8
Universidad Tecnológica de Bolívar
Repositorio UTB
6503847935
7003570680
url https://hdl.handle.net/20.500.12585/9123
dc.language.iso.none.fl_str_mv eng
language eng
dc.rights.coar.fl_str_mv http://purl.org/coar/access_right/c_16ec
dc.rights.uri.none.fl_str_mv http://creativecommons.org/licenses/by-nc-nd/4.0/
dc.rights.accessRights.none.fl_str_mv info:eu-repo/semantics/restrictedAccess
dc.rights.cc.none.fl_str_mv Atribución-NoComercial 4.0 Internacional
rights_invalid_str_mv http://creativecommons.org/licenses/by-nc-nd/4.0/
Atribución-NoComercial 4.0 Internacional
http://purl.org/coar/access_right/c_16ec
eu_rights_str_mv restrictedAccess
dc.format.medium.none.fl_str_mv Recurso electrónico
dc.format.mimetype.none.fl_str_mv application/pdf
dc.publisher.none.fl_str_mv Springer Berlin Heidelberg
publisher.none.fl_str_mv Springer Berlin Heidelberg
dc.source.none.fl_str_mv https://www.scopus.com/inward/record.uri?eid=2-s2.0-84892337362&doi=10.1007%2f978-3-540-88802-4_8&partnerID=40&md5=9d8ab5cdd9885d2cbe07aa20d26f9f46
institution Universidad Tecnológica de Bolívar
bitstream.url.fl_str_mv https://repositorio.utb.edu.co/bitstream/20.500.12585/9123/1/MiniProdInv.png
bitstream.checksum.fl_str_mv 0cb0f101a8d16897fb46fc914d3d7043
bitstream.checksumAlgorithm.fl_str_mv MD5
repository.name.fl_str_mv Repositorio Institucional UTB
repository.mail.fl_str_mv repositorioutb@utb.edu.co
_version_ 1808397568436076544
spelling 2020-03-26T16:33:00Z2020-03-26T16:33:00Z2009Investment Management: A Modern Guide to Security Analysis and Stock Selection; pp. 155-2239783540888017https://hdl.handle.net/20.500.12585/912310.1007/978-3-540-88802-4_8Universidad Tecnológica de BolívarRepositorio UTB65038479357003570680In this chapter, we discuss some ideas that might be useful in forecasting financial statements based on historical data.1 The approaches and suggestions presented in this chapter assume that the analyst has access to some company information that is not usually found in publicly available financial statements. In forecasting financial statements, we start with the historical financial statements and from them we identify the patterns and relationships of different items, the implicit policies, growth rates, and so on. The usual practice is to examine historical financial statements to derive information from them that can be used to forecast financial statements. As all information needed cannot be obtained from historical statements, we assume that the information is available from the company's management. We show how we can find information not found in the statements. Finally, we develop a detailed example of a hypothetical firm to explain the procedure to forecast financial statements. We also critically examine the usual practice of using plugs in forecasting financial statements. The chapter is organized as follows: first, we present comments in a general form about the relevance of prospective analysis to nontraded firms. Specifically, we highlight the importance for these firms of having a financial model with which they can assess the value creation in the firm. In the second section, we review concepts in accounting and economics that are used in forecasting financial statements. We stress upon a financial statement that shows the detailed inflows and outflows of cash in the firm: the cash budget (CB). This is an important tool for managing a firm. We also review topics like Pareto law and Fisher equation. Fisher equation is the key to forecasting variables linked to inflation rate. We also review the indexes used to measure inflation. The chapter uses the Fisher equation to forecast interest rates and increases in prices. Special mention is devoted to a usual practice when forecasting: the plug. This is a practice that we do not recommend and show an alternate approach. The approach we propose in this chapter follows an accounting principle that is the basis of any accounting procedure: the Double Entry Principle. This principle guarantees consistent and error-free financial statements. We show with a simple example how the plug works and its limitations. Next, the reader will find what information is needed for forecasting financial statements and where and how to find it. We identify the procedure to identify policies that govern the working of a firm such as accounts receivable and payable (AR and AP), inventories, dividend payout, payments in advance, and the like. We also deal with the real-life problem of a firm with multiple products and/or services. Finally, we show some tools to perform sensitivity analysis for financial management and analysis. We also use this tool to check the consistency of the financial model. In the next two sections, we deal with the relevance of several accounting concepts. In particular, we briefly describe the CB. © 2009 Springer-Verlag Berlin Heidelberg.Recurso electrónicoapplication/pdfengSpringer Berlin Heidelberghttp://creativecommons.org/licenses/by-nc-nd/4.0/info:eu-repo/semantics/restrictedAccessAtribución-NoComercial 4.0 Internacionalhttp://purl.org/coar/access_right/c_16echttps://www.scopus.com/inward/record.uri?eid=2-s2.0-84892337362&doi=10.1007%2f978-3-540-88802-4_8&partnerID=40&md5=9d8ab5cdd9885d2cbe07aa20d26f9f46Prospective analysis: Guidelines for forecasting financial statementsinfo:eu-repo/semantics/bookPartinfo:eu-repo/semantics/publishedVersionCapítulo de Librohttp://purl.org/coar/version/c_970fb48d4fbd8a85http://purl.org/coar/resource_type/c_3248Vélez-Pareja I.Tham J.Arnold, T.M., Peter, C.E., (2007) Debt financing does not create a circularity within pro forma analysis (February 26, , http://ssrn.com/abstract=965547, Available at SSRNBenninga, S., (2006) Principles of finance with excel., , Oxford, LondonBenninga, S., Conference: Teaching of finance with excel (2007) Guest Speaker in 4th National and 1st International Symposium for the Teaching in Finance, , Cartagena, June 20. ISSN 1900-3218Brealey, R.A., Stewart, C.M., Alan, J.M., (1995) Fundamentals of corporate finance., , McGraw-Hill, NYDaves, P.R., Michael, C.E., Ronald, E.S., (2004) Corporate Valuation: A Guide For Managers And Investors., , Thomson, OHDay, A.L., (2001) Mastering Financial Modeling. A Practitioner's Guide To Applied Corporate Finance, , Prentice Hall, LondonGallagher, T.J., Joseph Jr., D.A., (2000) Financial management, , 2nd ed. Prentice Hall, Londonplug forecasting financial statementsHiggins, R.C., (2001) Analysis for Financial Management, , 6th ed. Irwin- McGraw-Hill, NYHorngren, C.T., Gary, L.S., John, A.E., Donna, P., (2005) Introduction to Financial Accounting, , 9th ed. Prentice-Hall, LondonJensen, M.C., Agency cost of free cash flow, corporate finance, and takeovers (1986) Am Econ Rev, 76 (2), pp. 323-329. , http://ssrn.com/abstract=99580, Available at SSRN: DOI: 10.2139/ ssrn.99580Kester, G.W., A note on solving the balancing problem (1987) Financ Manag, 16 (1), pp. 52-54Palepu, K.G., Paul, M.H., Victor, L.B., (2004) Business analysis & valuation, , Using financial statements, Thomson, OHPenman, S.H., (2001) Financial statement analysis & security valuation, , Irwin-McGraw-Hill, NYPinkowitz, L., Rohan, W., René, M.S., Cash holdings, dividend policy, and corporate governance: A cross-country analysis (2007) J Appl Corp Finance, 19, p. 1Polimeni, R.S., Frank, J.F., Adelberg, A., (1991) Cost accounting concepts and applications for managerial decision making., , McGraw-Hill, New YorkRoss, S.A., Randolph, W.W., Jeffrey, J., (1999) Corporate Finance, , 5th ed. Irwin-McGraw-Hill, NYRuback, R.S., Capital cash flows: A simple approach to valuing cash flows (2002) Financ Manag Summer, pp. 85-103Tham, J., Vélez Pareja, I., (2004) Principles Of Cash Flow Valuation. An Integrated Market Based Approach., , Academic Press, London(2007), http://happyaccountant.wordpress.com/2007/07/03/advantages-of-double- entry-bookkeeping, The Happy Accountant. / (Visited on July 23Tjia, J.S., (2004) Building Financial Models. A Guide To Creating And Interpreting Financial Statements., , McGraw-Hill, New YorkVan Horne, J.C., (1998) Financial management and policy, , 11th ed. Prentice Hall, Englewood Cliffs, New JerseyVan Horne, J.C., (2001) Financial Management and Policy, , 12th ed. Prentice Hall, Englewood Cliffs, New JerseyVelez-Pareja, I., (2002) Use of inflation as the basis to estimate nominal increases in prices, , http://ssrn.com/abstract=319940, Available in SSRN: (July 8). Working Paper No. 15. DOI:10.2139/ssrn. 319940Velez-Pareja, I., (2005) Why we subtract the change in working capital when defining free cash flows? A pedagogical note (May 11, , http://ssrn.com/abstract=718741, Available at SSRNVélez Pareja, I., (2007) Decisiones de inversión, , Para la valoración de proyectos y de empresas, Universidad Javeriana, Politécnico Grancolombiano. Bogot́Velez-Pareja, I., (2007) Guidelines for forecasting financial statements from historical financial statements for valuation purposes (Updated) (, , http://ssrn.com/abstract=872474, July 13). Available at SSRNVelez-Pareja, I., (2007) Which cost of debt should be used in forecasting cash flows? (, , http://ssrn.com/abstract=101148, Sept. 2). Available at SSRNVelez-Pareja, I., Carlo, A.M., (2008) Potential dividends and actual cash flows - theoretical and empirical reasons for using actual and dismissing potential, or how not to pull potential rabbits out of actual hats (March 10, , http://ssrn.com/abstract=1095068, Available at SSRNVelez-Pareja, I., Mariano, M., David, A.L., Julio, S., Carlo, A.M., (2008) Dividends paid, potential dividends in five latin american countries, , (Preliminary Report, in presshttp://purl.org/coar/resource_type/c_3248THUMBNAILMiniProdInv.pngMiniProdInv.pngimage/png23941https://repositorio.utb.edu.co/bitstream/20.500.12585/9123/1/MiniProdInv.png0cb0f101a8d16897fb46fc914d3d7043MD5120.500.12585/9123oai:repositorio.utb.edu.co:20.500.12585/91232021-02-02 14:40:47.929Repositorio Institucional UTBrepositorioutb@utb.edu.co