Financial modeling - course RUB 32,844. from Eduson Academy, training 1 month, date November 29, 2023.
Miscellaneous / / December 02, 2023
A properly constructed financial model helps to assess the state of the business and control its development:
-A properly constructed financial model helps to assess the state of the business and control its development:
-Forecast revenue, profit and cash flow
-Identify company growth factors
-Assess the current value of the business and draw up an investment plan
-Develop company development scenarios depending on internal and external factors
-Calculate the break-even point for the business
Master financial modeling in practice. You will be able to move into a related profession or apply for a promotion, solve ambitious problems and influence the company's strategy.
Master financial modeling at an advanced level and understand the specifics of various industries. You will be able to help businesses achieve financial goals and make a career breakthrough.
Learn to build financial models yourself from scratch. You will be able to evaluate financial results and make forecasts. Find growth points and ways to increase profits for your business.
1. Build 2 financial models for manufacturing companies
Prepare initial data, make a forecast of revenue and costs, and calculate working capital. Fill out Balance, P&L and Cash Flow. You will conduct a sensitivity analysis and predict the need for financing for various scenarios. What kind of practical experience will you get on the course?
2. Assess the financial condition of the company taking into account changing inputs
You will adjust the company’s financial statements for the effect of the loan, calculate WACC, and assess the company’s specific risk.
3. Build a financial model for a car dealer using the DCF method
Prepare initial data, make a forecast of revenue and operating expenses. Prepare forecast financial statements. You will evaluate the company using the DCF method.
Specializations: corporate finance, analysis of investment projects, business assessment
Experience:
- JSC "Natsimbio" (investment analysis)
- PJSC MegaFon (investment analysis)
- KPMG (audit)
Education: Moscow State University named after M.V. Lomonosov
Achievements:
- To transition from Big-4 audit to investment analysis of real sector companies, I independently mastered corporate finance from scratch;
- In the process of working in investment analysis, MegaFon PJSC developed its own template for financial modeling of investment projects in the digital sphere, adopted as the company standard;
- During my studies at Moscow State University. M.V. Lomonosov became the winner of a personal scholarship named after. I.I. Shuvalova;
- Combines work in the investment analysis of a subsidiary of the Rostec State Corporation and activities as an independent career consultant;
- He is a visiting teacher at Moscow State University. M.V. Lomonosov.
see also
Experience in consulting and auditing (in Big Four companies), finance teacher since 2012 (expert in the field of CFA, ACCA, CIMA qualifications). Holder of CFA and FCCA qualifications.
Heads the financial department at Maximum Education. More than 13 years of experience in finance, 6 of which were in top banks on the Russian market.
22 practical lessons and 4 business cases
1. Fundamentals of Financial Modeling
2. Financial Model Standards (FAST)
3. Excel functions for financial modeling: MIN/MAX, logical operators, data validation, VLOOKUP function, Developer tab
4. Excel Practice: Excel Functions for Financial Modeling
5. Business case: developing a comprehensive model for a manufacturing company
6. How to create a sensitivity table
7. How to calculate income tax
8. Common mistakes when drawing up a financial model
9. Financial Modeling Business Case
10. Fundamentals of Financial Modeling for Business
11. Forecasting operational indicators: revenue and OPEX, calculating CAGR, setting up scenarios
and SELECT function
12. Analysis and construction of financial statements: forecast ODDS, profit and loss and balance sheet
13. Capital Expenditure Forecast (CAPEX)
14. Cost of Capital Calculation (WACC)
15. Business valuation within the discounted approach (DCF method) and sensitivity analysis
16. Business valuation within the framework of the comparative approach: the method of analogue companies, the transaction method, the method of industry coefficients
17. Business valuation using the cost method: cost approach, net asset method, replacement method
18. How to calculate the final value of a company
19. Practical task in Excel: how to adapt a financial model for loans and subsidies
20. Business case: financial model for a car dealer using the DCF method
21. Evaluation of investment projects using IRR, XIRR, NPV and XNPV
22. Plan-actual analysis
23. CVP analysis: how to find the break-even point
24. How to conduct scenario analysis
25. How to prepare model data for import into an analytical system
26. Strategic financial model for managing company finances
Diploma of completion of the course
After completing all the lessons and practical cases of the course, you will receive an official diploma, which you can indicate on your resume.