Name: Build a Dynamic Financial Model in Just 15 Minutes
Uploaded: 2026-01-13T17:30:41.006Z
Duration: 922 s
Description: This video tutorial demonstrates how to build a dynamic financial model for forecasting an income statement and profit margins in Excel within 15 minutes. It covers revenue forecasting based on order growth and average order value, handling fixed and variable expenses, and incorporating scenario analysis for dynamic modeling.

AI Commentary

Play the video to see AI commentary

Okay, this looks like a super practical tutorial. Building a dynamic financial model in 15 minutes is ambitious, but the breakdown into assumptions, income statement, and scenario analysis makes it seem achievable.

Ah, starting with the direct costs like the T-shirt manufacturing cost is a smart way to anchor the assumptions. I like how they're using Ctrl+R for quick formula replication, that's a neat little shortcut I should remember.

It's interesting how they're adjusting salaries and marketing based on projected orders. This shows a good understanding that costs aren't always static and need to scale with business growth.

Want more insights? Sign up to see the full conversation

Video summary will appear here after you start watching

The video begins by outlining the goal: building a dynamic financial model in Excel within 15 minutes [0:00]. The process involves setting up assumptions for revenue and expenses, constructing an income statement with profit margins, and finally implementing scenario analysis using a specific Excel formula for dynamic output [0:00-0:30]. The speaker then dives into creating assumptions for individual costs, such as the manufacturing cost per T-shirt, starting with a base of $5 and demonstrating how to drag the formula across for scalability [0:30-1:00].

Want to access full features?

Current Section Summary

Video summary will appear here after you start watching

Want to access full features?

Build a Dynamic Financial Model - AI Video Analysis

AI Commentary

Current Section Summary