Advanced Financial Modeling Course
What is Financial modeling?
A powerful business management tool that allows you to forecast the development of your company and evaluate the effectiveness of your decisions. Combines revenue, cost, capital and other growth investments,
and cash flow indicators and reflects their interrelationships
Your future summary
You will get career advancement and start earning more. After completing the program, you can include the following skills
My skills:
Compiled and analyzed various forms of financial statements. Correctly applied IFRS and RAS
Summary Andrei Petrov
Gained skills in professional financial evaluation of companies, stocks, bonds and investment projects
Based on a survey of 1,580 hh.ru vacancies, we highlight the most important skills that clients learn on the course
Built basic (DCF) and advanced financial models for any industry within the framework of the world's best practices, but taking into account Russian realities
Calculated economic indicators and assessed risks. Identified the relationship between the financial model and management accounting. Modeled revenue, cost of sales and expenses
Mastered Excel at an advanced level and began saving hundreds of hours in the workplace
Gathered up-to-date information and minimized the company's tax risks through acquired tax knowledge
Prepared a report and presentation on the valuation of the company
Forecasted 3 scenarios of the company's development based on the collected data for 5 years and built a financial model with revenue and COGS forecasts
Technical Tools. Additional skills
Excel
Who we train in this profession
Investment and credit
analysts
analysts
They come to improve their skills. They want to gain experience in working with financial models, learn different examples of transactions that they can work with in practice
Accountants, economists and other financiers
They come to the training to gain practice working with financial models. They want to increase their area of expertise and start doing more diverse tasks
Further training or retraining
They come to training to learn a related or new skill. They are bored with routine tasks and want to continually expand their area of expertise
Modern educational approach
At the heart of the course is practice
We consolidate the acquired knowledge on practical tasks, where we analyze the management report and on its basis collect and form analytical data of the report for the next month under the condition
of increasing business and preserving the company's growth.
Webinars and online cases
We organize webinars and online case studies almost every week. You can attend an event as part of your own or another course free of charge. Networking with experts is valuable for developing
professional skills
Quick feedback
Core instructors are on the course chat room and are available to answer any questions you may have. You will have a personal tutor who communicates 1-on-1 and helps you with your individual study
plan
Video tutorials
Together with experts, recall and systematize theory while focusing on practical skills. Learn to use tools for data analysis, computation and visualization
Game-based learning
We understand that learning engagement is important, so we incorporate game mechanics into the process. Take courses and earn medals and SF Coin!
SF Coin is an in-game currency that can be spent on bonus lessons, tutor consultations, or turned into a discount on the next course
SF Coin is an in-game currency that can be spent on bonus lessons, tutor consultations, or turned into a discount on the next course
It's easy to start learning!
The assistant we have developed will show you in detail how SF Education online university education works. Get to know our platform and all its mechanics
7
modules in 6 months
25
practical tasks
345+
practicum hours
15
hours per week
- Become familiar with the financial analyst position and its role in the world of finance;
- Find out what the career ladder looks like and what opportunities are in front of you;
- Understand what skills you need to develop first and what knowledge will help you grow faster;
- Learn how and where to look for open positions, what to expect in interviews, and how to prepare for technical interviews.
- Understand how daily transactions affect the financial statements of the entire company;
- Understand the purposes for which different financial reporting forms are needed;
- Learn the differences between IFRS and RAS and understand how each standard is applied;
- Prepare three reporting forms for several companies from different industries based on primary documents.
- You will learn the general principles of the taxation system in the Russian Federation and learn how to apply them;
- Break down the main types of taxes and understand where to look for information on them;
- Learn how to minimize tax risks.
- Examine in detail the concepts of time value of money and portfolio management;
- Understand the key approaches to valuing various companies, their stocks, bonds and investment projects;
- Master global standards in company financing and the average cost of capital raised;
- Learn when and how companies pay dividends and how else a project might interest potential investors.
- At a fundamental level, master the construction of financial models (DCF);
- Understand how to forecast OrEx, SarEx, D&A and Working Capital;
- After training you will be able to calculate WACC and Equity Value with ease;
- Learn how to forecast balance sheet, OFR and ODDS (BS, RL, CFS);
- Build a financial model to evaluate the online store and present the results to the project manager;
- Reinforce the skills you have learned with real cases from different business industries;
- Take a workshop on "Financial Modeling of an Online School";
- Independently build models of LBO and M&A transactions.
- Examine key industry valuation multiples;
- Identify the key differences between a complex financial model and a simple one. Build a complex model from scratch;
- You'll learn best practices and best practices in financial modeling;
- Understand financial modeling in the main areas: Oil & Gas, Financial Sector, Mining, Infrastructure and PPP, Agriculture, TMT, Startups and IT, Real Estate, Logistics, Infrastructure, Energy, Metallurgy, Machinery and other industries.
- Interview with FMI graduate Timur Ali-Zadeh (CFA)
- Special access for SF Education students to Financial Modeling Institute materials
- Understand the economics and success factors for 20 small business industries;
- Build financial models for 20 companies in Google Sheets;
- Test your own business ideas for viability by digitizing them with model templates.
- Learn advanced data manipulation including arrays, cleansing, and smart tables;
- You will begin to professionally visualize data through various types of charts and graphs;
- You will be able to build summary tables of varying levels of complexity.
- Self-assess more than 20 tests taken from the practice of our graduates and partner firms, and "get your hands on" them before the selection process for the dream company.
- Refresh your knowledge of probability theory, mathematical statistics, linear algebra, and calculus;
- Learn to apply your knowledge of math to solve problems in finance and business;
- Learn which math topics to dive into further for professional and general development.
Access to the course, course updates and course chat stays forever !
Effective study format
Reinforce the skill with practice
A format that allows you to master 2-3 related topics within a module. After the significant lessons you take tests, and at the end of the module you solve a practical assignment
Use the end-to-end project
A cross-cutting project allows us to immerse the client in a situation closer to real work. Our projects are shaped by experts from their practice, which they package for our clients
Individual work with each client
We create individual training plans on request. Our expert trainers are ready to answer all questions of our clients, both on the subject of the course and on any other practical issues
Cost of training
Essential Plan
- Access to beginner-level financial modeling lessons
- Pre-designed financial modeling templates
- Certificate of course completion
- Monthly quizzes to test progress
- Access to a student support forum
Advanced Plan
- Everything from the Essential Plan
- Live sessions on complex financial models
- Access to industry-standard Excel models
- Personalized feedback on financial modeling assignments
- Workshops on valuation techniques
- Hands-on exercises for real-world scenarios
- Case studies on M&A and LBO modeling
- Interview preparation for finance roles
- Exclusive webinars with financial experts
- Networking opportunities with peers and alumni
Expert Plan
- Everything from the Advanced Plan
- One-on-one mentoring sessions with financial experts
- Access to advanced financial modeling tools
- Lifetime access to all course materials
- Customized career coaching for financial analysts
- Access to private live workshops
- Guidance on creating a professional financial model portfolio
- Preparation for top-tier financial certifications
- Priority access to industry job postings
- Invitations to exclusive finance networking events
Doing the training accessible
0 - 0 - 24
Installment payment without interest, first installment in one month
13%
Tax deduction for all our courses
up to 70% savings
Beneficial training under our Trade-In program
3 days for free
Access to the entire course for 3 days - free of charge
How we help with employment
SF Education Career Center is about building your individual career track based on your experience, skills, and goals. We will help you build a winning resume and thoroughly prepare you for the tasks that
will be encountered at the job interview
Consultation
We form an individual career profile according to the author's methodology and give recommendations on the following steps
We form an individual career profile according to the author's methodology and give recommendations on the following steps
Preparing for the interview
We deal with all types of potential questions and help you to present yourself in a winning way at the interview stage
We deal with all types of potential questions and help you to present yourself in a winning way at the interview stage
Communicating with partners
We develop a community of our alumni who recruit people to join their teams, as well as exchange experiences and share market specifics
We develop a community of our alumni who recruit people to join their teams, as well as exchange experiences and share market specifics
We'll help you choose
We are ready to evaluate offsets with you and decide on the best offer for your career prospect
We are ready to evaluate offsets with you and decide on the best offer for your career prospect
1
3
2
Working with resumes
We engage HR specialists from our partner companies to adjust your resume
We engage HR specialists from our partner companies to adjust your resume
4
5
Answers FAQs
The course is suitable for beginners, school knowledge and responsible approach to lectures and practical assignments will be enough for you to master the material.
The program is weekend-oriented, with approximately 15 hours per week. You will be able to allocate these hours on your own, taking into account your workload and schedule.
You must pass all course assignments, defend the cross-curricular project (if assigned), and pass the final test with at least 60% correct answers.
Webinar recordings are always posted on the course platform. If you are unable to attend the case studies or practical assignments online, you will be able to complete the assignments yourself
and submit them to the instructor for review, if applicable.
According to the Law on Education No. 273-FZ of 29.12.2012, specialists with secondary vocational and (or) higher education are entitled to receive additional professional education. Persons
who have successfully mastered the relevant additional professional program and passed final certification are issued a certificate of professional development and (or) a diploma of
professional retraining.
To support students, we have created a special course chat in Telegram. There you can ask questions and get help from teachers and experts.
Our career center helps with resumes and cover letters, provides career counseling (where to go, career path options, which offer to choose, etc.). We can conduct a mock interview to simulate
real-world conditions. You will also get access to our closed career channel, where vacancies from partner companies are regularly published.
You can take 3 days of training for free or leave a request for a free consultation. The manager will tell you in detail about the training and answer all your questions.