Faculty of Financial Analytics - course 127,500 rubles. from GeekBrains, training 12 months, Date: June 10, 2023.
Miscellaneous / / December 03, 2023
A financial analyst is a specialist who knows how to evaluate financial results. He always knows the real sources of profit and sees new niches for growth. His task is to ensure that the company is always in the black.
Who is the course suitable for?
For beginners
For those who want to master a profession from scratch and help companies always stay in the black.
Project managers
For those who want to look at business processes from a financial point of view, learn to identify growth points, build financial models and get acquainted with the cases of large companies.
Economists and accountants
For those who want to learn how to analyze a company’s financial performance, change their profile and earn more.
Preparation for the Faculty of Financial Analytics.
Duration 2 weeks
1. Video course on Excel
2. The most important thing about business presentations
I Quarter → Introduction to financial accounting and analysis
Duration 2 months
Learn what a financial analyst does and what the goals of financial reporting are. Get acquainted with the main regulatory documents and accounting policies of the enterprise. You will learn about the general principles of working with SAP, 1C, Excel, Google Docs programs. Learn basic Excel formulas: SUM and variations, pivot table, VLOOKUP, index.
1. The role of the financial analyst and financial reporting
- Financial analyst and his tasks
- Financial statements
2. Fundamentals of Financial Accounting
- Elements of financial statements
- Principles of financial accounting
- Features of accounting under IFRS and RAS and legislation
- IT financial assistants
- Fundamentals of financial accounting
3. Coursework after the first quarter
- Briefing
- First consultation
- Second consultation
- Analysis of projects
II Quarter → Financial accounting and analysis part 1
Duration 3 months
Learn to analyze the structure, movement and condition of accounts receivable. Learn how to analyze accounts receivable by age. Understand the concept of expenses and the process of recognizing profits and losses. Learn what retained earnings and dividends are. Learn to conduct equity analysis. Get to know the main liabilities and assets of the company.
1. Revenue (PL) and Accounts Receivable (BS)
- Income
- Revenue analysis
- Accounts receivable
- Accounts receivable analysis
- Practice on revenue and accounts receivable
2. Expenses (PL) and Accounts Payable (BS)
- Expenses
- Accounting for costs and production costs
- Modern methods of calculating product costs
- Cost analysis
- Obligations
- Analysis of accounts payable
3. Capital and financial liabilities (BS)
- Capital
- Financial instruments
- Analysis of financial investments and liabilities
4. Assets and Liabilities (BS)
- Fixed assets
- Intangible assets
- Renting and leasing
- Stocks
5. Coursework after the second quarter
- Briefing
- Consultation
- Analysis of work
III Quarter → Financial accounting and analysis part 2
Duration 2.5 months
Get acquainted with the concept of “net profit” and learn how to calculate it. Master horizontal, vertical and trend analysis of financial results, income and expenses. Learn what working capital, operating and financial cycles are. Learn to manage cash and accounts receivable. You will analyze the cash flow statement and analyze trends in the development of the enterprise. Learn to calculate liquidity, management, debt management, profitability and market value ratios.
1. PL or Statement of Income and Expenses
- P&L report
- Preparation of P&L report
- Analysis of individual PL indicators. Profit in P&L types and differences. Calculation and reflection of income tax expenses.
- P&L analysis
2. BS or Balance Sheet
- Statement of Financial Position (BS)
- Preparation of Statement of Financial Position (BS)
- Working capital management
- Estimated liabilities and VAT
- Analysis of BS indicators. Lesson 1
- Analysis of BS indicators. Lesson 2
3. CF or ODDS
- Statement of cash flows (DDS/CF). Lesson 1
- Statement of cash flows (DDS/CF). Lesson 2
- Fundamentals of consolidation
4. Analysis of financial indicators
- Analysis of financial statements
- Analysis of financial ratios. Lesson 1
- Analysis of financial ratios. Lesson 2
- Analysis of financial ratios. Lesson 3
5. Coursework after the third quarter
- Briefing
- Consultation
- Analysis of work
IV Quarter → Financial modeling
Duration 3.5 months
In practice, draw up a company budget according to given plans and analyze key budget indicators. Make a forecast of the company's activities and perform a horizontal forecast-fact analysis. Learn to conduct investment analysis and select appropriate investment solutions that will increase the company's competitiveness. At the end, you will receive a thesis in which you will build an investment model for the company.
1. Budgeting and Forecasting
- Budgeting and forecasting financial reporting data
- Drawing up a company budget
- Unit-economy
- Analysis of Budget Indicators
- Drawing up a forecast and analyzing forecast indicators
2. Company investment model or business valuation
- Analysis and assessment of non-financial factors of the investment project. Theory
- Analysis and assessment of non-financial factors of the investment project. Practice
- Analysis and assessment of financial indicators of the investment project. Theory
- Analysis and assessment of financial indicators of the investment project. Practice
- Investment analysis
- Drawing up a DCF investment model. Theory
- Drawing up a DCF investment model. Practice
- Unit economics. Model analysis using DCF. Theory
- Unit economics. Model analysis using DCF. Practice
- Financial markets. Theory
- Valuation of public companies. Practice
- Financial modeling of public companies. Practice
3. Graduation project
- Briefing
- First consultation
- Second consultation
- Third consultation
- Analysis of work
Courses outside the quarter
1. Legal individual entrepreneurship and freelancing
- How to become a successful freelancer
- Legislative subtleties when working with currency
- Registration and taxes