Skip to main content

Modeling of Forecasting Financial Statement

  • Conference paper
  • First Online:
Comprehensible Science (ICCS 2021)

Abstract

The article investigates the modeling of forecasting financial statement, which will facilitate the procedure of assessing the risks and prospects for improving the financial activity of the enterprise in the digital age. The views of world famous scientists on the essence of forecasting the activity of companies using Excel are reflected. The procedure of modeling the methodology of forecasting the financial report of the company is proposed. According to the yearly financial report of the National Joint Stock Company «Naftogaz of Ukraine» shows an example of the implementation of the proposed procedure for modeling steps for forecasting financial reports for the coming year. The considered forms of forecasting tables will promote unification of analytical calculations and will increase clearness and informativeness of forecast indicators in the conditions of digital technologies. The results of the study are useful for users in order to make the right management decisions about the provision of financial resources to the entity.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 149.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 199.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Kontseptual’na osnova finansovoyi zvitnosti (Conceptual Framework for the Financial Reporting). https://zakon.rada.gov.ua/laws/show/929_009#Text

  2. Natsionalne polozhennia (standart) buchgalterskoho obliku 1 “Zahalni vymohy do finansovoi zvitnosti”: zatverdzheno nakazom Ministerstva finansiv Ukrainy № 73 vid 07.02.2013 r. (National Accounting Standard 1 “General Requirements for Financial Statements”: approved by the Decree of the Ministry of Finance of Ukraine № 73 of 07.02.2013. http://www.minfin.gov.ua. Accessed 09 Feb 2020

  3. Liam, B.: Introduction to Financial Modelling. How to Excel at Being a Lazy (That Means Efficient!) Modeller. Holy Macro, Chicago (2020)

    Google Scholar 

  4. Fairhurst, D.S.: Financial Modeling in Excel For Dummies (For Dummies (Lifestyle)). Wiley, New York (2017)

    Google Scholar 

  5. Othmane, K., Adil, R.: Financial Models in Production. Springer , New York (2020). https://doi.org/10.1007/978-3-030-57496-3

    Book  MATH  Google Scholar 

  6. Amir, E., Ghitti, M.: Financial Analysis of Mergers and Acquisitions. Understanding Financial Statements and Accounting Rules with Case Studies. Springer, Palgrave Macmillan, Cham (2020)

    Google Scholar 

  7. Oluwa, S.: Hands-on financial modeling with microsoft excel 2019. Build practical models for forecasting, valuation, trading, and growth analysis using Excel 2019. Packt, Birmingham, Great Britain (2019)

    Google Scholar 

  8. Green, J., Henneman, M., Antov, D.: Optimizing Growth: Predictive and Profitable Strategies to Understand Demand and Outsmart Your Competitors. Wiley, New York (2018)

    Google Scholar 

  9. Brigkhem, Yu.F., Erkhardt, M.S.: Finansovyy menedzhment: per. s angl./pod red. Ye. A. Dorofeyeva (Financial management). Piter, Sankt-Peterburg (2009)

    Google Scholar 

  10. Brigham, E.F., Ehrhardt, M.C.: Financial Management: Theory & Practice, 15th edn. Cengage Learning, Boston (2016)

    Google Scholar 

  11. Brigham, E,F., Ehrhardt, M.C.: Financial Management: Theory & Practice (MindTap Course List), 16th Edn. Cengage Learning. Boston (2019)

    Google Scholar 

  12. Khelfert, E.: Tekhnika finansovogo analiza: per. s angl./pod red. L.P.Belykh (Technique of financial analysis). Audit, UNITI, Moscow (1996)

    Google Scholar 

  13. Erich, A.: Helfert: Techniques of Financial Analysis: A Practical Guide to Measuring Business Performance, 9th edn. McGraw-Hill, New York (1996)

    Google Scholar 

  14. Erich, A.: Helfert: Financial Analysis: Tools and Techniques. A Guide for Managers. McGraw-Hill, New York (2001)

    Google Scholar 

  15. Helfert, E.A.: Techniques of Financial Analysis (11th Ed.). A Guide to Value Creation. The Mcgraw-Hill/Irwin Series in Finance, Insurance, and Real Estate. Mcgraw-Hill, Texas (2003)

    Google Scholar 

  16. Erich, A.: Helfert: Techniques of Financial Analysis: A Practical Guide to Applied Managerial Finance, Updated Jaico Publishing House, Mumbai (2005)

    Google Scholar 

  17. Grant, R.: Sovremennyy strategicheskiy analiz (Modern strategic analysis) Izd-vo «Piter», Sankt-Peterburg (2008)

    Google Scholar 

  18. Chayed, S., Alamry, M.: Overview of financial statements analysis. In: Analysis of Financial Statements, Al-Alalamia for printing and Designs Sammawa, Iraq (2019)

    Google Scholar 

  19. Grewal, T.S., Grewal, H.S., Grewal, G.S., Khosla, R.K.: Analysis of Financial Statements. Sultan Chand & Sons Private Limited, New Delhi (2019)

    Google Scholar 

  20. Sheremet, A.D., Kotheltceva, E.A.: Finansovy analiz (Financial Analysis). Ekonomicheskiy fakul’tet MGU imeni M.V. Lomonosova, Moscow (2020)

    Google Scholar 

  21. Yefimova, O.V.: Finansovyy analiz: sovremennyy instrumentariy dlya prinyatiya ekonomicheskikh resheniy (Financial analysis: modern tools for making economic ). Izd-vo Omega-L, Moscow (2014)

    Google Scholar 

  22. Efimova, O., Rozhnova, O.: The corporate reporting development in the digital economy. In: Antipova, T., Rocha, A. (eds.) DSIC18 2018. AISC, vol. 850, pp. 71–80. Springer, Cham (2019). https://doi.org/10.1007/978-3-030-02351-5_10

    Chapter  Google Scholar 

  23. Efimova, O., Rozhnova, O., Gorodetskaya, O.: XBRL as a tool for integrating financial and non-financial reporting. In: Antipova, T., Rocha, Á. (eds.) DSIC 2019. AISC, vol. 1114, pp. 135–147. Springer, Cham (2020). https://doi.org/10.1007/978-3-030-37737-3_13

    Chapter  Google Scholar 

  24. Nazarova, Z.M.: Finansovyy menedzhment (Financial management) (2020). https://be5.biz/ekonomika/f024/index.html. Accessed 10 Apr 2020

  25. Barashyan, V.U., Bdzhola, V.D., Zhuravleva, O.G.; pod red. Zolotareva, V.S., Barashyan, V.Yu.: Finansovyy menedzhment (Financial management). KNORUS, Moscow (2017)

    Google Scholar 

  26. Andreyev, V.I.: Finansovyy menedzhment (Financial management). Saratovskiy GAU, Saratov (2017)

    Google Scholar 

  27. Kuznetsova, E.U., Krylatkov, P.P., Mineyeva, T.A., Podolyak, O.O.: Sovremennyy strategicheskiy analiz (Modern strategic analysis). Izd-vo Ural. un-ta, Yekaterinburg (2016)

    Google Scholar 

  28. Mulenko, O.V.: Sovremennyy strategicheskiy analiz (Modern strategic analysis). FGBOU VO RGUPS. – Rostov-na-Donu (2017)

    Google Scholar 

  29. Basovskiy, L.E.: Sovremennyy strategicheskiy analiz (Modern strategic analysis). INFRA-M, Moscow (2019)

    Google Scholar 

  30. Savitskaya, G.V.: Kompleksnyy analiz khozyaystvennoy deyatel’nosti predpriyatiya (Comprehensive analysis of the company’s economic activities). INFRA-M, Moscow (2017)

    Google Scholar 

  31. Tovarystvo, A.: Natsional’na aktsionerna kompaniya “NAFTOHAZ UKRAYINY”. Okrema finansova zvitnist’ stanom na ta za rik, shcho zakinchyvsya 31 hrudnya 2018 roku (Joint stock company National Joint Stock Company company "NAFTOGAS Of UKRAINE”. Separate financial statementsas of and for the year that has ended December 31, 2018). https://www.naftogaz.com/files/Zvity/2018-Naftogaz-separate-financial-statements-UKR-with-AR.pdf

  32. Tovarystvo, A.: Natsionalʹna aktsionerna kompaniya “NAFTOHAZ UKRAYINY”. Okrema finansova zvitnist’ stanom na ta za rik, shcho zakinchyvsya 31 hrudnya 2019 roku (Joint stock company National Joint Stock Company company “NAFTOGAS Of UKRAINE”. Separate financial statements as of and for the year that has ended December 31, 2019). https://www.naftogaz.com/files/Zvity/Naftogaz-19fs-standalone-FS-UKR.pdf

  33. Lakhtionova, L., Muranova, N., Bugaiov, O., Ozeran, A., Kalabukhova, S.: Balance sheet (statement of financial position) transformation in the light of new digital technology: ukrainian experience. In: Antipova, T. (ed.) ICIS 2020. LNNS, vol. 136, pp. 25–41. Springer, Cham (2021). https://doi.org/10.1007/978-3-030-49264-9_3

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Liudmyla Lakhtionova .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2022 The Author(s), under exclusive license to Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Lakhtionova, L., But, V., Kalabukhova, S., Hnylytska, L. (2022). Modeling of Forecasting Financial Statement. In: Antipova, T. (eds) Comprehensible Science. ICCS 2021. Lecture Notes in Networks and Systems, vol 315. Springer, Cham. https://doi.org/10.1007/978-3-030-85799-8_13

Download citation

Publish with us

Policies and ethics