Three-Statement Models! Excel Solve: AFM Enterprises (Financial Modeling World Cup 2025)

If you're looking for a short video, you're at the wrong place.

Advanced Fabricating Machinery (AFM, a fictional company) has asked us to create a forecast for the upcoming five years. Our model will include three statements: the Profit and Loss Statement, the Balance Sheet, and the Cash Flow Statement. That's the premise for "AFM Enterprises" by Andrew Grigolyunovich, which was the third case of Stage 1 of the 2025 Financial Modeling World Cup.

Interested in trying it on your own? Purchase and download the case here: https://fmworldcup.com/product/stage-...
Compete in the 2025 Financial Modeling World Cup! https://fmworldcup.com/product/open-s...
Under 25? You can purchase a discounted ticket here: https://fmworldcup.com/product/u-25-s...

Watch other solves by:
Diarmuid Early (‪@DimEarly‬):    • Building a three-statement model - FMWC 20...  
See any more? Let me know in the comments!

00:00 Introduction
02:25 Model Set-Up
03:02 Sales Modeling
09:17 Costs Modeling
12:40 Working Capital
16:06 CAPEX and Depreciation
21:07 Debt Modeling
27:50 Equity Modeling
31:10 Taxes
32:57 Completing the Balance Sheet
35:15 Completing the Cash Flow Statement
36:13 Answering Questions 1–20
45:06 Cash Flow Statement (cont.)
57:54 Growth/Worst Case Scenarios
1:08:32 End/Closing