Importance The article considers modeling the company performance on the basis of published information. Objectives The purpose of the study is to develop a methodology for financial modeling based on consolidated financial statements and other published information. Methods The article presents algorithms for prospective financial analysis and calculations based on Excel 2016 forecasting tools that allow modeling and evaluating the company's future performance and financial results using the published information. Results The developed methodology includes five stages. At the first stage of the analysis, the company's strategy is determined using the space analysis based on quantitative assessments of external and internal environment. At the second stage, the algorithm for revenue forecasting and other financial results is underpinned based on exponential smoothing and trend model building. At the third stage, regression models of current and capital expenditures are built and other indicators are justified that are needed to calculate projected financial results. At the fourth stage, parameters of the realistic, pessimistic and optimistic scenarios of company's development are substantiated. At the final stage, projected financial results and the fundamental value of the company are calculated and the likelihood of achieving the results. The proposed methodology is tested on the data of a Russian strategic company. Conclusions and Relevance The presented methodology may be useful for analysts evaluating the company's activities on the basis of consolidated financial statements.
Keywords: predictive financial analysis, space analysis, trend model, exponential smoothing, regression model
Plaskova N.S. Teoriya i praktika strategicheskogo ekonomicheskogo analiza rezul'tativnosti biznesa: monografiya [Theory and practice of strategic economic analysis of business performance: a monograph]. Moscow, MAKS Press Publ., 2007, 363 p.
Helfert E. Tekhnika finansovogo analiza [Techniques of Financial Analysis: A Practical Guide to Measuring Business Performance]. St. Petersburg, Piter Publ., 2003, 640 p.
Ivanov V.V., Tsytovich N.N. [Corporate finance: Methodological aspects of strategic planning]. Vestnik Sankt-Peterburgskogo universiteta. Ser. 5. Ekonomika = Vestnik of Saint-Petersburg University. Series 5. Economics, 2012, iss. 3, pp. 108–115. (In Russ.)
Cherkasova V.A., Fradkina M.M. [Introduction of a scenario approach in the development of the company's strategy]. Korporativnye finansy, 2010, no. 2, pp. 68–75. (In Russ.) URL: Link
Mescon M., Albert M. Khedouri F. Osnovy menedzhmenta [Management]. Moscow, Delo Publ., 2004, 493 p.
Pike R., Neale B. Korporativnye finansy i investirovanie [Corporate Finance and Investment: Decisions and Strategies]. St. Petersburg, Piter Publ., 2006, 784 p.
Copeland T., Koller T., Murrin J. Stoimost' kompanii: otsenka i upravlenie [Valuation: Measuring and Managing the Value of Companies]. Moscow, Olimp-Biznes Publ., 2005, 575 p.
Brealey R., Myers S.C. Printsipy korporativnykh finansov [Principles of Corporate Finance]. Moscow, Olimp-Biznes Publ., 2015, 1008 p.
Radder L., Louw L. The SPACE Matrix: A Tool for Calibrating Competition. Long Range Planning, 1998, vol. 31, iss. 4, pp. 549–559. doi: 10.1016/S0024-6301(98)80048-4
Damodaran A. Investitsionnaya otsenka. Instrumenty i metody otsenki lyubykh aktivov [Investment Valuation: Tools and Techniques for Determining the Value of Any Asset]. Moscow, Al'pina Pablisher Publ., 2017, 1316 p.
Ivashkovskaya I.V. Finansovye izmereniya korporativnykh strategii. Steikkholderskii podkhod: monografiya [Financial measurement of corporate strategies. A stakeholder approach: a monograph]. Moscow, INFRA-M Publ., 2013, 319 p.
Ivashkovskaya I.V., Grigor'eva S.A., Kokoreva M.S., Stepanova A.N. et al. Korporativnye finansovye resheniya. Empiricheskii analiz rossiiskikh kompanii (korporativnye finansovye resheniya na razvivayushchikhsya rynkakh kapitala): monografiya [Corporate financial decisions. The empirical analysis of Russian companies (corporate financial decisions in emerging capital markets): a monograph]. Moscow, INFRA-M Publ., 2012, 281 p.
Gilad B. Konkurentnaya razvedka. Kak raspoznat' vneshnie riski i upravlyat' situatsiei [Early Warning: Using Competitive Intelligence to Anticipate Market Shifts, Control Risk, and Create Powerful Strategies]. St. Petersburg, Piter Publ., 2010, 320 p.
Smirnov G.N., Smirnov A.N., Golovina Yu.S. [Stages of implementing the Talnakh concentrating mill reconstruction project]. Obogashchenie rud = Mineral Processing, 2016, no. 5, pp. 75–87. (In Russ.)
Teplova T.V., Krylova M.S. [The empirical research of the factors determining the investment activity of Russian companies]. Korporativnye finansy, 2007, no. 1, pp. 22–44. (In Russ.) URL: Link
Rodionov I.I., Protasov V.S. [Including of sectoral factors in the analysis of companies investment behaviour (on example of the oil & gas industry)]. Korporativnye finansy, 2010, no. 4, pp. 41–51. (In Russ.) URL: Link
Antill N., Lee K. Otsenka kompanii: analiz i prognozirovanie s ispol'zovaniem otchetnosti po MSFO [Company Valuation Under IFRS: Interpreting and Forecasting Accounts Using International Financial Reporting Standards]. Moscow, Al'pina Pablisher Publ., 2013, 440 p.
Charaeva M.V. [Formation of the investment program of the electronetwork company, taking into account possibilities of using the sources of financing of investment activity]. Korporativnye finansy,2011, no. 1, pp. 40–48. (In Russ.) URL: Link
Cherkasova V.A., Mochalov D.S. [Influence of the stock market uncertainty on investment activity of Russian companies through the underlying asset pricing]. Korporativnye finansy,2012, no. 4, pp. 46–57. (In Russ.) URL: Link
Cherkasova V.A., Teplova O.Yu. [Research of impact of financial constraints on investment decisions of companies in emerging capital markets]. Korporativnye finansy,2013, no. 2, pp. 4–18. (In Russ.) URL: Link