Udemy - Financial Modeling in Excel - 3-Statement Model and Autom...
Financial Modeling in Excel: 3-Statement Model & Automation
https://WebToolTip.com
Published 10/2026
Created by Rushan Rafiq
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All Levels | Genre: eLearning | Language: English | Duration: 67 Lectures ( 4h 50m ) | Size: 3.4 GB
Build an automated PNL, Balance Sheet and Cash Flow forecast with Power Query, driver-based FP&A and scenario analysis
What you'll learn
⚡ Build a fully integrated three-statement model: Income Statement, Balance Sheet and Cash Flow Statement
⚡ Automate a financial model with Power Query so all three statements update when an input file changes
⚡ Use driver-based forecasting to model revenue, COGS, marketing, store operating costs and G&A
⚡ Model Balance Sheet schedules: inventory, receivables, prepayments, PPE, payables, accruals, loans and equity
⚡ Forecast cash and trigger short-term financing automatically when the business runs low on cash
⚡ Use Power Query to append, merge, unpivot and consolidate a whole folder of input files
⚡ Build and compare best case and worst case scenarios with a single parameter change
⚡ Work like a real analyst: collect, check and challenge assumptions from different departments
Requirements
❗ Comfortable with Excel basics: entering formulas, cell references and simple functions such as SUM
❗ Desktop Excel on Windows with Power Query (the demonstrations use desktop Excel on Windows)
❗ A basic understanding of the three financial statements helps; a short intro first is recommended if they're new to you
❗ No Power Query experience needed: Module 3 covers it from scratch