×

zbMATH — the first resource for mathematics

The art of company financial modelling. (English) Zbl 1392.90072
Summary: In corporate finance, the term financial modelling denotes a widely used technique of comprehensive customised quantification of a company’s entire operations. Even though not mathematically strict, such models exhibit descriptive, explanatory and predictive qualities. The paper elaborates on the main steps and principles for building financial models of companies. It also identifies required assumptions and certain statistical properties of well-constructed models. Furthermore, it describes the use of such models for decision support purposes, supplemented by an illustrative example. Finally, it discusses general characteristics and concerns associated with appropriate model construction and use.
MSC:
90B50 Management decision making, including multiple objectives
90C08 Special problems of linear programming (transportation, multi-index, data envelopment analysis, etc.)
91G80 Financial applications of other theories
91B38 Production theory, theory of the firm
Software:
CrystallBall
PDF BibTeX XML Cite
Full Text: Link
References:
[1] Ackert, L. F. and Hunter, W. C. (1995). Rational expectations and security analysts’ earnings forecasts. Financial Review, 30(3), 427-443.
[2] Aljinović, Z., Marasović, B. and Šego, B. (2011). Financijsko modeliranje (2nd ed.). Split: Ekonomski fakultet Sveučilišta u Splitu.
[3] Ascoli, E. (2013). Modeling (4th ed.). London: Adkins, Matchett & Toy.
[4] Avon, J. (2013). The Handbook of Financial Modeling: A Practical Approach to Creating and Implementing Valuation Projection Models. New York: Apress.
[5] Barber, B., Lehavy, R., McNichols, M. and Trueman, B. (2001). Can investors profit from the prophets? Security analyst recommendations and stock returns. The Journal of Finance, 56(2), 531-563.
[6] Benninga, S. (2014). Financial Modeling (4th ed.). Cambridge, MA: MIT Press.
[7] Bonini, S., Zanetti, L., Bianchini, R. and Salvi, A. (2010). Target price accuracy in equity research. Journal of Business Finance & Accounting, 37(910), 1177-1217.
[8] Bradshaw, M. T. (2011). Analysts’ forecasts: what do we know after decades of work? Available at SSRN: http://ssrn.com/abstract=1880339 [Accessed 18/09/16].
[9] Brav, A. and Lehavy, R. (2003). An empirical analysis of analysts’ target prices: Short-term informativeness and long-term dynamics. The Journal of Finance, 58(5), 1933-1968.
[10] Brown, L. D., Hagerman, R. L., Griffin, P. A. and Zmijewski, M. E. (1987). Security analyst superiority relative to univariate time-series models in forecasting quarterly earnings. Journal of Accounting and Economics, 9(1), 61-87. The art of company financial modelling 425
[11] Brown, L. D. and Rozeff, M. S. (1978). The superiority of analyst forecasts as measures of expectations: evidence from earnings. The Journal of Finance, 33(1), 1-16.
[12] Call, A. C., Chen, S. and Tong, Y. H. (2013). Are analysts’ cash flow forecasts naïve extensions of their own earnings forecasts? Contemporary Accounting Research, 30(2), 438-465.
[13] CFA Institute (2014). Standards of Practice Handbook (11th ed.). Charlottesville, VA: CFA Institute.
[14] Charnes, J. M. (2012). Financial modeling with Crystal Ball and Excel (2nd ed.). Hoboken, N.J.: John Wiley & Sons. · Zbl 1251.91006
[15] Cheng, Y., Liu, M. H. and Qian, J. (2006). Buy-Side Analysts, Sell-Side Analysts, and Investment Decisions of Money Managers. Journal of Financial and Quantitative Analysis, Vol. 41 No. 1, 51-83.
[16] Clements, M. P. and Hendry, D. F. (2002). An Overview of Economic Forecasting. In Clements, M. P. and Hendry, D. F. (Eds.). A companion to economic forecasting (pp. 1-18). Malden, MA: Blackwell Publishing.
[17] Damodaran, A. Probabilistic Approaches to Risk: Scenario Analysis, Decision Trees and Simulations. Available at: http://people.stern.nyu.edu/adamodar /pdfiles/papers/probabilistic.pdf [Accessed 18/09/16].
[18] Derman, E. and Wilmott, P. (2009). The financial modelers’ manifesto. Available at SSRN: http://ssrn.com/abstract=1324878 [Accessed 24/09/16].
[19] Dym, C. L. (2004). Principles of Mathematical Modeling (2nd ed.). Amsterdam; Boston: Elsevier Academic Press. · Zbl 1057.00008
[20] Frazier, G. D. (1969). A Corporate Long Range Planning Model. Business Economics Vol. 4, No. 4, 62-65.
[21] Garthwaite, P. H., Jolliffe, I. T. and Jones, B. (2002). Statistical Inference (2nd ed.). New York: Oxford University Press. · Zbl 1029.62003
[22] Gleason, C. A., Bruce Johnson, W. and Li, H. (2013). Valuation model use and the price target performance of sell-side equity analysts. Contemporary Accounting Research, 30(1), 80-115.
[23] Graham, B. and Dodd, D. L. (2008). Security Analysis: Principles and Technique (6th ed.). New York: McGraw-Hill.
[24] Groysberg, B., Healy, P. and Chapman, C. (2008). Buy-side vs. sell-side analysts’ earnings forecasts. Financial Analysts Journal, Vol. 64.4, 25-39.
[25] Hobbs, J. and Singh, V. (2015). A comparison of buy-side and sell-side analysts. Review of Financial Economics, Vol. 24, 42-51.
[26] Koop, G., Poirier, D. J. and Tobias, J. L. (2007). Bayesian Econometric Methods (Econometric Exercises vol. 7). New York: Cambridge University Press. · Zbl 1136.62087
[27] Kosy, D. W. and Wise, B. P. (1984). Self-Explanatory Financial Planning Models. In Proceedings of the 4th National Conference on Artificial Intelli426 Zoran Lukić gence, AAAI-84 (pp. 176-181). Austin, TX: Association for the Advancement of Artificial Intelligence.
[28] Levy, R. A. (1966). Conceptual Foundations of Technical Analysis. Financial Analysts Journal, Vol. 22.4, 83-89.
[29] Li, W. and McDowell, E. A. (2011). Investor affect, investor status and the influence of analyst reports. Journal of Finance and Accountancy, 8, 1.
[30] Loh, R. K. and Stulz, R. M. (2011). When are analyst recommendation changes influential? Review of Financial Studies, 24(2), 593-627.
[31] McKinsey & Company, Koller, T., Goedhart, M. and Wessels, D. (2010). Valuation: Measuring and Managing the Value of Companies (5th ed.). Hoboken, N.J.: John Wiley & Sons.
[32] Merton, R. C. (1995). Influence of mathematical models in finance on practice: past, present and future. In Howison, S. D., Kelly, F. P. and Wilmot, P. (Eds.). Mathematical Models in Finance (pp. 1-14). London: Chapman & Hall for The Royal Society.
[33] Michaely, R. and Womack, K. L. (1999). Conflict of interest and the credibility of underwriter analyst recommendations. Review of financial studies, 12(4), 653-686.
[34] Mills, T. C. and Markellos R. N. (2008). The Econometric Modelling of Financial Time Series (3rd ed.). Cambridge: Cambridge University Press. · Zbl 1151.62082
[35] Minch, R. P. (1989). Logic Programming as a Paradigm for Financial Modeling. MIS Quarterly, Vol. 13 No. 1, 65-84.
[36] Naylor, T. H. and Gattis, D. R. (1976). Corporate planning models. California Management Review, 18(4), 69-78.
[37] Naylor, T. H. and Schauland, H. (1976). A survey of users of corporate planning models. Management Science, 22(9), 927-937.
[38] Newton, J. K. (1985). The Decision Support Role of Operational Research in Corporate Planning. In Rand, G. K. and Eglese, R. W. (Eds.). Further Developments in Operational Research. Oxford: Operational Research Society, Pergamon Press.
[39] O’Brien, P. C. (1988). Analysts’ forecasts as earnings expectations. Journal of accounting and Economics, 10(1), 53-83.
[40] Ramnath, S., Rock, S. and Shane, P. B. (2008). Financial Analysts’ Forecasts and Stock Recommendations: A Review of the Research. Hanover, MA: Now Publishers.
[41] Ramnath, S., Rock, S. and Shane, P. (2008a). The financial analyst forecasting literature: A taxonomy with suggestions for further research. International Journal of Forecasting, 24(1), 34-75.
[42] Richardson, S., Teoh, S. H. and Wysocki, P. D. (2004). The walk-down to beatable analyst forecasts: The role of equity issuance and insider trading incentives. Contemporary accounting research, 21(4), 885-924. The art of company financial modelling 427
[43] Robert, C. and Casella, G. (1999). Monte Carlo Statistical Methods. New York: Springer Science & Business Media. · Zbl 0935.62005
[44] Sarapa, N. (1992). Teorija vjerojatnosti (2nd ed.). Zagreb: Školska knjiga.
[45] Sengupta, C. (2004). Financial Modeling using Excel and VBA. Hoboken, N.J.: John Wiley & Sons.
[46] Shim, J. K. and McGlade, R. (1984). The use of corporate planning models: past, present and future. Journal of the Operational Research Society, 35(10), 885-893.
[47] Shim, J. K. and Siegel, J. G. (2007). Handbook of Financial Analysis, Forecasting, and Modeling (3rd ed.). Chicago: CCH.
[48] Siegel, J. G. and Shim, J. K. (2000). Accounting Handbook (3rd ed.). New York: Barron’s Educational Series.
[49] Stabile, D. R. (2005). Forerunners of Modern Financial Economics: A Random Walk in the History of Economic Thought. Cheltenham: Edward Elgar Publishing.
[50] Stein Fairhurst, D. (2012). Using Excel for Business Analysis: a Guide to Financial Modelling Fundamentals. Singapore: John Wiley & Sons.
[51] Thomsett, M. C. (1998). Mastering Fundamental Analysis. Chicago: Dearborn Financial Publishing.
[52] Vondraček, Z. (2008). Financijsko modeliranje – predavanja. Available at: https://web.math.pmf.unizg.hr/ vondra/2013-14.html [Accessed 06/09/16].
[53] Wild, J. J. (2011). Measurement of a financial model of the firm: A field study. Journal of Applied Business Research (JABR), 9(4), 83-92.
[54] Zekić, M. (1996). Neural networks for time-series predictions in finance and investing. In Hunjak, T., Martić, Lj. and Neralić, L. (Eds.). Proceedings: 6th International Conference on Operational Research. Zagreb: Croatian Operational Research Society.
[55] Zitzewitz, E. (2001). Measuring herding and exaggeration by equity analysts and other opinion sellers.
This reference list is based on information provided by the publisher or from digital mathematics libraries. Its items are heuristically matched to zbMATH identifiers and may contain data conversion errors. It attempts to reflect the references listed in the original paper as accurately as possible without claiming the completeness or perfect precision of the matching.