In this video, I build a DCF valuation model for Microsoft ($MSFT) stock. If interested, you can download free models and/or buy the Microsoft model I built in this video here: https://rareliquidcareers.com/models'>https://rareliquidcareers.com/models
Wall Street Prep
► Use code RARELIQUID for 20% OFF on any course!
► https://gv142.isrefer.com/go/rliquid/...
Sign up for my courses
► How to get into investment banking: https://forms.gle/wt4cZrezbxVgNzGUA
► How to get into MBA programs: https://forms.gle/9yEyycuP7NnQBjue8
Related Videos
DCF Beginner's Tutorial: • How to Build a Discounted Cash Flow (...
Excel Shortcuts for Finance and Modeling: • Top Excel Shortcuts For Finance and M...
A Beginner's Guide to Portfolio Management: • The BEST Beginner's Guide to Portfoli...
How Interest Rates and Inflation Affect the Markets: • Explaining Why Interest Rates and Inf...
Google DCF Model: • Google DCF Valuation Model (Built Fro...
⏱Timestamps⏱
0:00 Agenda
1:00 Microsoft's Situation
6:15 Wall Street Prep
8:01 Setting Up the DCF
11:18 Revenue Build
49:10 Income Statement Line Items
51:30 Cash Flow Line Items
58:50 Building the DCF
1:18:30 Calculating WACC
1:32:17 Discounting Cash Flow to Present Value
1:33:15 Calculating Terminal Value
1:34:22 Calculating Implied Share Price
1:36:00 Discussing Model Findings
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Interact With Me
► Instagram: / rareliquid
► Twitter: / rareliquid
► TikTok: / rareliquid
► LinkedIn: / benchon8b0ba34a
► Business Inquiries: [email protected]
Career Resources
► Buy my resume and cover letter: https://rareliquidcareers.com/
► Books I recommend: https://amzn.to/3gy28xv
► My filming equipment: https://a.co/cf97WjW
Disclaimer
All content in this video is for entertainment purposes only. I am not a professional financial advisor and my statements are not to be taken as instructions or directions. In addition, some of the links above are affiliate links, meaning that at no additional cost to you, I may earn a commission if you click through and make a purchase.
#microsoft #msft #valuation #dcf