Financial Modeling Fundamentals Course – Josh Aharonoff

Transform Your Finance Career With Practical Modeling Skills

If you’ve ever wanted to master financial modeling and transform your career WITHOUT spending years figuring it out through trial and error, or wasting thousands on degrees that teach theory but not practical skills…

Then this page will show you a proven system that has helped finance professionals work directly with CEOs, investors, and board members by creating professional-grade financial models that drive real business decisions.

All this without requiring advanced Excel knowledge or previous financial modeling experience.

What You’ll Learn In Financial Modeling Fundamentals Course

01 – Introduction to Financial Modeling

A comprehensive introduction to the course structure and what you’ll achieve. We’ll discuss why financial modeling matters for your career and set expectations for your learning journey.

• Course Introduction and Preview
• What Is a Financial Model and Why Do You Need It?

02 – Refresher on Financial Statements

Master the core financial statements that form the foundation of any model.

Understand how P&L, balance sheet, and cash flow statements work individually and—crucially—how they connect together in the real world.

• What Is a Financial Model and Why Do You Need It?
• Introduction to Profit & Loss
• Understanding the Balance Sheet
• Introduction to Statement of Cash Flows
• Cash vs Accrual Accounting
• How the Balance Sheet and Income Statement Are Connected
• Understanding Debits & Credits
• How Financial Statements Are Affected

03 – Building Your First Financial Statements

Roll up your sleeves and create professional P&L and balance sheet templates from scratch. Learn proper formatting, structure, and calculation methods that reflect industry best practices.

• Building a Summary P&L
• Building a Summary Balance Sheet
• Building a Detailed Profit & Loss
• Building a Detailed Balance Sheet

04 – Building a Statement of Cash Flows

Construct the most misunderstood financial statement—the cash flow statement. Learn the indirect method, proper categorization of cash movements, and how to ensure everything balances correctly.

• The Psychology Behind Cash Flows
• Showcasing the Impact on Cash Flows
• The Mathematics Behind Cash Flows
• Financial Statements and Their Connections

05 -Build a Basic 3 Statement Model

Create your first integrated financial model where all three statements connect properly. See how changes in one statement automatically flow through to the others, and verify everything balances with professional validation techniques.

• Connecting the income statement to the balance sheet
• Creating a statement of cash flows – detailed pt I
• Creating a statement of cash flows – detailed pt II
• Creating a summarized 3 statement model

06 – Financial Modeling Fundamentals

Master the essential building blocks of professional models. Learn about drivers tabs, proper organization, version control, and the foundational principles that separate amateur models from professional ones.

• Section Overview
• Financial Model Structure
• Drivers
• Error checks
• Color coding & auditing
• Template tabs
• Presenting (summary financials)
• Section Overview

07 – Optimize Your Model

Transform your model with professional techniques. Implement color coding systems, create robust error checks, build user-friendly instructions, and design summary dashboards that executives can actually understand.

• Create template tabs
• Create a Drivers tab – Income Statement
• Create a Drivers tab – Balance Sheet
• Set color coding
• Add an error check
• Add an Instructions tab
• Connect Summary Financials

08 -Working with Historical Data

Learn to incorporate real financial data into your model. Master the monthly process of updating with actuals and maintaining model integrity through proper version control and verification.

• Why you should include actuals in your financial model
• Actualizing your model

09 -Financial Projections

Develop various projection methodologies for revenue, expenses, and balance sheet accounts. Create forecasts that tell a coherent story and stand up to scrutiny from stakeholders.

• Chapter Overview
• Projecting Revenue
• Projecting Headcount
• Projecting Profit & Loss
• Projecting Balance Sheet

10 – Build a Full 3 Statement Model: Setting up

Apply everything you’ve learned to create a comprehensive model from scratch. Set up proper structure, drivers, and connections following professional best practices.

• Create a drivers for P&L
• Create a drivers for Balance Sheet
• Link Income Statement to Drivers
• Link Balance Sheet to Drivers
• Create a Statement of Cash Flows
• Summary Financials, Instructions

11 – Build a Full 3 Statement Model: Projections & Actualizing

Complete your model with advanced projections and learn the critical process of “rolling forward” with new actuals each month. Create powerful variance analysis that identifies key business insights.

• Chapter overview
• Set projections – Revenue & COGS
• Set projections – Opex
• Set projections – Other Income/Expense
• Set projections – Assets
• Set projections – Liabilities + Owners equity
• Roll forward – Profit & Loss
• Roll forward – Balance Sheet
• Bonus: Budget vs Actuals Dashboard

12 – Course Wrap Up

• Course Recap and Key Takeaways

More courses from the same author: Josh Aharonoff