Three Statement Modeling with Iterations includes

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

5 Hours

Level

Completion Certificate

About

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

Completion time

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

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

Take the Next Step, Earn a Recognized Skills Certificate

Demonstrate to top employers you have the practical skills needed to excel in finance.

This course will give you a fundamental understanding of three statement modeling best practices.

Go one step further, challenge yourself to earn a financial modeling skills certificate 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

Knowing how to build models quickly and error free is critical for the decisions and recommendations that they underpin. 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 in finance?

Accordion Arrow Icon

Absolutely. Develop practical skills you can use to impress at interviews, whether you’re looking to break into 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.

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.