Business Analytics
Intermediate
Executive Financial Modeling & Analysis
Build three-statement financial models, forecast cash flows, and analyze unit economics.
Course Overview
Master revenue forecasting, CAC/LTV sensitivity analysis, scenario planning, and executive presentation of key financial health metrics.
What You Will Learn
Build dynamic three-statement financial models (Income Statement, Balance Sheet, Cash Flow)
Calculate key unit economic metrics: CAC, LTV, Magic Number, and Net Revenue Retention
Perform multi-scenario sensitivity analyses and Monte Carlo cash flow simulations
Structure debt amortization schedules and cap tables
Present financial forecasts cleanly to board members and venture investors
Tools & Technologies Used
Excel
Google Sheets
Python 3.11
OpenPyXL
Structured Curriculum
2 Modules · 4 Lessons · 190 Minutes Total
Module 1
Module 1: Three-Statement Modeling & Unit Economics
2 lessons
Module 1: Three-Statement Modeling & Unit Economics
Link core financial statements and calculate SaaS unit economics.
-
Linking Income Statement, Balance Sheet & Cash Flow
Connect dynamic working capital, depreciation, and net income lines seamlessly.
-
SaaS Unit Economics & LTV/CAC Modeling
Calculate gross margin adjusted LTV, CAC payback periods, and net expansion churn.
Module 2
Module 2: Sensitivity Analysis & Executive Reporting
2 lessons
Module 2: Sensitivity Analysis & Executive Reporting
Perform stress testing under optimistic, baseline, and pessimistic scenarios.
-
Scenario Planning & Data Table Sensitivity
Build two-way Excel data tables to model cash runway under varying churn rates.
-
Executive Financial Dashboarding
Format financial metrics into clean, executive-ready charts and summary tables.
Practical Project & Capstone Outcome
🚀 Capstone Project
Series-A SaaS Company 3-Year Financial Model
Construct a fully dynamic 36-month financial model for a growing SaaS business featuring 3-statement linking, sensitivity tables, and investor deck summary charts.
Prerequisites
- Proficiency in Microsoft Excel or Google Sheets
- Basic accounting concepts
Intended Audience
- Finance Managers, Operations Leads, and Founders managing company financial strategy
- Business Analysts building corporate financial forecasts
Instructor Information
R
Richard Sterling
Course Author & Industry Expert
Richard Sterling is a former Tech CFO and Investment Banker with 20+ years of corporate finance and valuation experience.
Frequently Asked Questions
Do I need complex macro programming (VBA) skills?
No. Models rely on clean, dynamic spreadsheet formulas and optional Python openpyxl scripts.