I spent 24hrs putting together a DCF model on a $10 billion business and I documented each step I took. Why?
I want to better understand the airline industry landscape in preparation for the upcoming Virgin IPO. And I want to help candidates in my course sharpen up their modeling skills.
So I pored over 6 years of financials and two industry reports to put together a valuation of Australia's most well known airline.
Documenting every. single. step.
Now, I'm giving it to you for free.
The steps are split up into three buckets:
1️⃣ Industry Reports
2️⃣ Financial Info
3️⃣ DCF Model
This file will help you learn how to:
→ Read Financials
→ Build a DCF Model
→ Format like a banker
And you'll know what to expect when the Virgin IPO takes place in the coming months.
Find the Miro board I have used to help document the process here and download the excel file here: