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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Kontseptual’na osnova finansovoyi zvitnosti (Conceptual Framework for the Financial Reporting). https://zakon.rada.gov.ua/laws/show/929_009#Text
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
Liam, B.: Introduction to Financial Modelling. How to Excel at Being a Lazy (That Means Efficient!) Modeller. Holy Macro, Chicago (2020)
Fairhurst, D.S.: Financial Modeling in Excel For Dummies (For Dummies (Lifestyle)). Wiley, New York (2017)
Othmane, K., Adil, R.: Financial Models in Production. Springer , New York (2020). https://doi.org/10.1007/978-3-030-57496-3
Amir, E., Ghitti, M.: Financial Analysis of Mergers and Acquisitions. Understanding Financial Statements and Accounting Rules with Case Studies. Springer, Palgrave Macmillan, Cham (2020)
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)
Green, J., Henneman, M., Antov, D.: Optimizing Growth: Predictive and Profitable Strategies to Understand Demand and Outsmart Your Competitors. Wiley, New York (2018)
Brigkhem, Yu.F., Erkhardt, M.S.: Finansovyy menedzhment: per. s angl./pod red. Ye. A. Dorofeyeva (Financial management). Piter, Sankt-Peterburg (2009)
Brigham, E.F., Ehrhardt, M.C.: Financial Management: Theory & Practice, 15th edn. Cengage Learning, Boston (2016)
Brigham, E,F., Ehrhardt, M.C.: Financial Management: Theory & Practice (MindTap Course List), 16th Edn. Cengage Learning. Boston (2019)
Khelfert, E.: Tekhnika finansovogo analiza: per. s angl./pod red. L.P.Belykh (Technique of financial analysis). Audit, UNITI, Moscow (1996)
Erich, A.: Helfert: Techniques of Financial Analysis: A Practical Guide to Measuring Business Performance, 9th edn. McGraw-Hill, New York (1996)
Erich, A.: Helfert: Financial Analysis: Tools and Techniques. A Guide for Managers. McGraw-Hill, New York (2001)
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)
Erich, A.: Helfert: Techniques of Financial Analysis: A Practical Guide to Applied Managerial Finance, Updated Jaico Publishing House, Mumbai (2005)
Grant, R.: Sovremennyy strategicheskiy analiz (Modern strategic analysis) Izd-vo «Piter», Sankt-Peterburg (2008)
Chayed, S., Alamry, M.: Overview of financial statements analysis. In: Analysis of Financial Statements, Al-Alalamia for printing and Designs Sammawa, Iraq (2019)
Grewal, T.S., Grewal, H.S., Grewal, G.S., Khosla, R.K.: Analysis of Financial Statements. Sultan Chand & Sons Private Limited, New Delhi (2019)
Sheremet, A.D., Kotheltceva, E.A.: Finansovy analiz (Financial Analysis). Ekonomicheskiy fakul’tet MGU imeni M.V. Lomonosova, Moscow (2020)
Yefimova, O.V.: Finansovyy analiz: sovremennyy instrumentariy dlya prinyatiya ekonomicheskikh resheniy (Financial analysis: modern tools for making economic ). Izd-vo Omega-L, Moscow (2014)
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
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
Nazarova, Z.M.: Finansovyy menedzhment (Financial management) (2020). https://be5.biz/ekonomika/f024/index.html. Accessed 10 Apr 2020
Barashyan, V.U., Bdzhola, V.D., Zhuravleva, O.G.; pod red. Zolotareva, V.S., Barashyan, V.Yu.: Finansovyy menedzhment (Financial management). KNORUS, Moscow (2017)
Andreyev, V.I.: Finansovyy menedzhment (Financial management). Saratovskiy GAU, Saratov (2017)
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)
Mulenko, O.V.: Sovremennyy strategicheskiy analiz (Modern strategic analysis). FGBOU VO RGUPS. – Rostov-na-Donu (2017)
Basovskiy, L.E.: Sovremennyy strategicheskiy analiz (Modern strategic analysis). INFRA-M, Moscow (2019)
Savitskaya, G.V.: Kompleksnyy analiz khozyaystvennoy deyatel’nosti predpriyatiya (Comprehensive analysis of the company’s economic activities). INFRA-M, Moscow (2017)
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
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
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
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2022 The Author(s), under exclusive license to Springer Nature Switzerland AG
About this paper
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
DOI: https://doi.org/10.1007/978-3-030-85799-8_13
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-85798-1
Online ISBN: 978-3-030-85799-8
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)