Three Statement Modeling with Iterations
Introducing the basics and building best-practice financial modeling skills from the start. These key components are part of The Modeler and now available for less.
£79 (Inc Tax)
5
Hours
2
Topics
28
Practical exercises
Direct instructor help
Completion Certificate
Lifetime access
Rating
5 STARS
Included courses
THREE STATEMENT MODELING WITH ITERATIONS
ABOUT
Learn how to integrate and model the three major financial statements using real accounts.
5 STARS
Completion time
5 Hours
Level
Completion Certificate
Video Minutes (63) — Excel Exercises (13)
- 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
Video Minutes (59) — Excel Exercises (15)
- 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
Get a Wall Street Recognized Certification
UPGRADE YOUR RÉSUMÉ WITH THE SAME CERTIFICATION WE USE AT THE WORLD’S TOP 4 INVESTMENT BANKS.
Our exams are similar to assessments at the top firms. This means they are going to challenge you. Our online courses will teach you everything you need to know to succeed.
The Investment Banker is made up of 4 skills certificates. Pass each one to unlock your micro- degree. Certification can easily be added to LinkedIn, demonstrating your achievement which will be recognized by the most prestigious firms on Wall Street.
Our Alumni
DEMONSTRATE YOU'RE AS GOOD AS THE BEST
By completing this course, 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.
TESTIMONIALS
What Our Students Say
Frequently Asked Questions
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.
This online program reflects the training new analysts receive at the leading investment banks. It’s challenging, but if you want to demonstrate you are as good as the best in the industry then this is the course for you. The top investment banks will recognize our certification, making this perfect for graduates looking to land a job in investment banking or a professional preparing for a new role. We also reserve the right to introduce our best students to recruiters at the top 4 investment banks.
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.
Absolutely. Develop practical skills your can use to impress at interviews, whether you’re looking to break into finance or change roles. Take advantage of our recruiter service to boost your chances.
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.
No. Everything you need to earn your micro-degree is included, from instructor-led videos and Excel exercises to the exam.