Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Financial Modelling 101: Build a DCF model from scratch
Rating: 4.4 out of 5(5 ratings)
12 students

Financial Modelling 101: Build a DCF model from scratch

Master the fundamentals of financial modelling with expert instruction and course content by the industry leaders.
Created byOperis Academy
Last updated 5/2022
English

What you'll learn

  • Step-by-step guide to constructing a model to perform a discounted cash flow analysis
  • Understand how to reduce the risk of modelling errors
  • Understand and apply fundamental techniques and concepts which will prove invaluable in future modelling assignments
  • Master how to adjust a model in a robust and manageable way when new historical data needs to be incorporated on a regular basis
  • Credibility with the leading financial instutions such as Goldman Sachs, PWC and Credit Suisse who have all used Operis for their financial modelling training.

Course content

11 sections • 21 lectures • 3h 3m total length

  • Getting started7:26

    Learn standard best-practice financial modeling and how to build a model from scratch using a structured inputs, workings, and outputs approach, with range names and quality-control audit checks.

  • What is Financial Modelling?4:54

    Master financial modelling by combining finance, accounting, and Excel to build robust project-finance models; learn how definitions vary, align with regulators, and prepare spreadsheets for investment decisions.

  • Case study12:56

    Use discounted cash flow to compare base and expansion oil projects, evaluating revenue, capex, taxes, depreciation, and debt versus equity in an SPV, with outputs-first modeling and oil price sensitivity.

Requirements

  • Have a copy of Microsoft Excel
  • Basic understanding of Excel - basic formulas
  • Basic understanding of Accounting principals and financial statements
  • A desire to learn how to build a quality financial model for your business

Description

This course will transform your financial modelling skill set and confidence.

Operis is a globally recognised provider of financial modelling training with a long list of clients from Government institutions, Global Banks and Accountancy firms. As such a certification of training from us will open doors for you as you apply for jobs, helping you beat out the competition.


This course is designed so that:


  • You can work at your own pace and start and stop whenever you need;

  • It takes less than a day to complete and hence can easily fit around your existing schedule;

  • It serves as a useful introduction to modelling but can also be used as a refresher for those with some prior experience;

Why choose Operis?

  • Trusted by financial institutions such as ING, Barclays, Department for Transport and The World Bank, Operis delivers top of the range financial modelling training.

  • You will be taught by Jonathan Swan who has been delivering modelling training for over 30 years since our courses were first incorporated into the graduate induction programmes of a number of the City’s investment banks.

  • As a global leader in financial modelling training, a certification from Operis carries weight within the industry and gives you a leg up on your competitors.

Jonathan has extensive teaching experience having specialised in financial modelling knowledge and skills transfer almost since the first spreadsheet applications appeared.


Testimonials

Jiaquing Lin - PWC - 5 *

Simple examples upfront before diving deeper which does not scare people away that easily and also makes complicated concepts or scary techniques much easier to grasp.  Very structured and logical agenda throughout. The exercise tabs provided for each topic is massively useful for actual practising rather than just listening to the lectures; short courses for each topic which helps with user concentration and also less stressful for full-time workers who are using their own spare time to pick up modelling skills.

Magda Stephenson - The Institute of Risk Management - 5*

I really enjoyed the Operis course Financial Modelling Essentials. All the materials were presented in a clear and concise way. I was able to start and stop at any time and that gave me great flexibility.

Video instructions are just the right length so it is easy to concentrate on them without drifting off.  Written instructions are clear and easy to follow.  The layout of the exercise sheets is great. I really enjoyed the fact that if the exercise was completed correctly the colour of the cells was changing.

I would recommend the course to my colleagues.

Who this course is for:

  • Someone interested in learning best practice financial modelling and gaining the knowledge to perform a DCF model.
  • People wanting to secure their first job on Wall Street or leading international financial markets. As a globally renowned institution a certification from Operis has credibility across the world.

Report abuse