The Modeler includes

Introduction to Modeling

4.8 STARS

Star Rating
Accordion White Arrow Icon

About

Get to grips with the fundamentals of financial modeling in this essential module.

 

Completion time

2.5 Hours

Level

Completion Certificate

About

Get to grips with the fundamentals of financial modeling in this essential module.

 

Completion time

2.5 Hours

Level

Completion Certificate

Module

Video Minutes

Excel Exercises

Introduction to Modeling

66

13

Accordion Arrow Icon

Video minutes66

Excel Exercises13

  • Key settings
  • Formatting and layout standards
  • Building a simple income statement and balance sheet model, on one sheet, then across sheets
  • Balancing the balance sheet using the cash flow statement
  • Preparing the model for handover
  • Key formatting and putting the output into a pitch book

Three Statement Modeling with Iterations

4.4 STARS

Star Rating
Accordion White Arrow Icon

About

Learn how to integrate and model the three major financial statements using real accounts.

Completion time

2 Hours

Level

Completion Certificate

About

Learn how to integrate and model the three major financial statements using real accounts.

Completion time

2 Hours

Level

Completion Certificate

Module

Video Minutes

Excel Exercises

Three Statement Modeling with Iterations

77

10

Accordion Arrow Icon

Video minutes77

Excel Exercises10

  • Income statement construction and highlighting key numbers
  • Calculation schedules (PP&E, retained earnings, operating working capital, and debt)
  • Balancing the balance sheet with a cash sweep
  • Calculating interest using average balances
  • Circular references and iterations
  • Working with a circular reference switch
  • Preparing the model for handover
  • Key formatting and putting the output into a pitch book

Three Statement Model Editing

4.4 STARS

Star Rating
Accordion White Arrow Icon

About

Discover how to edit a financial model, as well as learn timesaving shortcuts.

Completion time

1 hour

Level

Completion Certificate

About

Discover how to edit a financial model, as well as learn timesaving shortcuts.

Completion time

1 hour

Level

Completion Certificate

Module

Video Minutes

Excel Exercises

Three Statement Model Editing

35

5

Accordion Arrow Icon

Video minutes35

Excel Exercises5

  • Steps before editing
  • Inserting a new item
  • Removing an old item
  • After editing
  • Relevant keyboard shortcut keys

Three Statement Model with Estimates

Accordion White Arrow Icon

About

Learn how to clean up the income statement and balance sheet and get accurate estimates for revenues and EBIT

Completion time

2

Level

Completion Certificate

About

Learn how to clean up the income statement and balance sheet and get accurate estimates for revenues and EBIT

Completion time

2

Level

Completion Certificate

Module

Video Minutes

Excel Exercises

Three Statement Model with Estimates

70

12

Accordion Arrow Icon

Video minutes70

Excel Exercises12

  • Cleaning up the income statement and balance sheet and simplifying the line items
  • Getting estimates for revenues and EBIT
  • Building multiple scenarios into a model’s assumption
  • Modeling a forecast debt repayment schedule from the notes
  • Key ratios
  • Checking the model for reasonableness
  • Formatting and putting the output into a pitch book

Building a Model With Cash Sweep

Accordion White Arrow Icon

About

Covering historic data, debt and interest calculations, cash sweeps, revolvers, circularities and more.

Completion time

3 Hours

Level

Completion Certificate

About

Covering historic data, debt and interest calculations, cash sweeps, revolvers, circularities and more.

Completion time

3 Hours

Level

Completion Certificate

Module

Video Minutes

Excel Exercises

Building a Model With Cash Sweep

71

19

Accordion Arrow Icon

Video minutes71

Excel Exercises19

  • Why banks want to be repaid early
  • Cash sweep mechanisms
  • How to model cash sweeps
  • Building a three statement model with a cash sweep

Checking a Model for Integrity and Errors

Accordion White Arrow Icon

About

Error checking fundamentals, techniques, keyboard shortcuts, prevention methods and more.

Completion time

1 Hour

Level

Completion Certificate

About

Error checking fundamentals, techniques, keyboard shortcuts, prevention methods and more.

Completion time

1 Hour

Level

Completion Certificate

Module

Video Minutes

Excel Exercises

Checking a Model for Integrity and Errors

36

11

Accordion Arrow Icon

Video minutes36

Excel Exercises11

  • Top ten errors
  • Auditing and error checking toolkit
  • Checking your own model
  • Checking someone else’s model

From Skills Certificate to Recognized Micro-Degree

Upgrade your résumé with the same certification we use at the world’s top 4 investment banks.

Pass the exam and demonstrate your new financial modeling capabilities on LinkedIn with The Modeler Skills Certificate.

Take the next step, challenge yourself to join the best financial analysts by earning an investment banking micro-degree recognized on Wall St.

testimonials

what our students say

Individuals

Tzu-Chieh Lin

The Modeler

This is the right practical training which you cannot learn from professors in the university.

Corporate clients

Summer Intern 2020

The Modeler

The Modeler by Financial Edge gives the student an opportunity to learn hands-on experience in financial modeling. From short cuts and revision techniques to Three Model Statement creation. Certainly an insightful experience.

View more

Frequently Asked Questions

What tech do I need?

Accordion Arrow Icon

Access your course across desktop, laptop, tablet or phone; either via our web portal or the dedicated mobile app. While we have optimized our video quality and size, we recommend a broadband connection to enable uninterrupted video playback. A PDF reader and spreadsheet application are required to open the supporting resources.

Is it right for me?

Accordion Arrow Icon

Learn the core financial modeling skills required for numerous roles across investment banking, private equity, trading and sales, equity research and more. Perfect for graduates looking to bridge the gap between academia and industry, or professionals preparing for a new role. Enhance your career by mastering the practical skills you need to know.

Are Financial Edge's courses credible?

Accordion Arrow Icon

The 4 leading investment banks, as rated by the FT, hire us to train their incoming analysts. If you are looking to join the best analysts in the world, why not challenge yourself with the same content and certification with the same Wall Street instructors ready to answer your questions.

Will this course help me get a job at an investment bank?

Accordion Arrow Icon

Absolutely. Develop practical skills you can use to impress at interviews, whether you’re looking to break into investment banking or corporate finance roles in other industries.

How long do I have to complete the courses?

Accordion Arrow Icon

We are delighted to announce that we now offer lifetime access on all online courses! Fit studying around your schedule. Learn at your own pace with on-demand video, practical examples to download and expert instructor support.

Are there any hidden costs?

Accordion Arrow Icon

No. Everything you need to earn your skill certificate is included, from instructor-led videos and Excel exercises to the exam.

How do I join Financial Edge's alumni?

Accordion Arrow Icon

Join our world-class alumni on LinkedIn by upgrading your skill certification to any one of our micro-degree’s. To unlock all alumni benefits, you will need to verify you have successfully passed all courses within the online program.

What is CPD?

Accordion Arrow Icon

All Financial Edge online courses are CPD accredited. CPD stands for Continuing Professional Development and makes demonstrating your commitment to learning easy. Your institution or accrediting body may track CDP points through activities, units or hours. Check with the relevant party to find out how you should be monitoring your progress.

Want to Join Our Prestigious Alumni?

JOIN THE BEST

By completing any one of our micro-degree’s, you will be able to join our prestigious alumni on LinkedIn alongside hires at the top 4 investment banks. After becoming a member of this elite community, you can unlock exclusive benefits such as course discounts and more.