Financial Modeling

Long-term projects require a thorough analysis, negotiations with investors, lenders, and partners. The financial model in MS Excel is the most important tool for planning, structuring, and analysis of a project. Here you pull up and summarize all available information on your expectations and forecast. Quality of your model defines the precision of your decisions and your ability to convince the other participants of the project

  • The course is related to the online specialization "Quantitative Finance"
  • Flexible Terms
  • 5 weeks (2 credits)
  • Time to completion: 13 hours
  • Online course
  • Certificate
Apply for the specialization

About the course

In this online-course you will learn how to build for your project a financial model with all reports and ratios that used in project finance. We will go through the path from a blank Excel workbook, discuss the best practice for financial modeling, dig into technical and financial aspects of the methods and ratios that we use in the model. Within the course we will work with a typical project finance model, but this model has a wide range of possible applications. The same structure and principles could be used for any project to create a new business, launch a product or for venture investments. You will see that the approach we use is universal and the model we build in the course can be your template for many future projects

Course Objectives


Students will have necessary knowledge and skills to build a fully-fledged financial model for a project or a company. The model can be used to support investment decisions, raise capital or apply for debt financing

Learning Outcomes

1. Learn how to create structure of a financial model and setup common elements of the model

2. Learn about capital project assumptions and the way the are presented in the model

3. Learn how to create three standard financial reports in the financial model

4. Learn how to calculate DCF profitability indicators

Course Syllabus

Week 1. Introduction and general principles

Week 2. Assumptions

Week 3. Reports and financing

Week 4. Analysis and presentation

Week 5. Capstone project


Dmitry Ryabykh
Guest lecturer


General understanding of finance and financial reporting principles. If you didn’t work in Excel – take a crash course before this course

Graduation Document

Earn a Certificate upon completion



Learning Activities



Low-Stakes Assignments


High-Stakes Assignments

Final project

Cost and Conditions

13 000 ₽

Full access to the learning materials + Graduation document

More: публичная оферта