Discounted Cash Flow (DCF) Model | Company Valuation Analysis | Financial Modeling Full Course

Financial Modeling and Valuation Analysis FREE COURSE - Discounted Cash Flow (DCF) Model | Company Valuation Analysis | Financial Modeling Full Course

Master Financial Modeling: Your Complete 2024 Guide to Excel, Valuation & Analysis!

4.0 (1)

33 learners

What you'll learn

Develop proficiency in building 3-statement financial models using Excel.
Master the concepts of discounted cash flow models and company valuation analysis.
Gain skills in automating accounting processes and preparing financial statements in Excel.
Learn to create dynamic financial models that automatically update with changes.

This course includes

33.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

financial modeling company valuation DCF Discounted Cash Flow Analysis Excel #exceltips accounting enterprise value equity value finance

Full Transcript

In this video, you will learn how to build a Discounted Cash Flow (DCF) Financial model from scratch. Specifically, you would learn how to: 1. Forecast unlevered free cash flows 2. Forecast the Terminal value using both the EBITDA Multiple and the Perpetuity Method 3. Calculate the Enterprise Value and Equity Value; and 4. Determine the price per share of a company. We considered Amazon as our case study. PLEASE NOTE: Your EBITDA will be different from mine if you obtain the right EBITDA figure (EBIT plus Depreciation and Amortization). I made a mistake by picking the NOPAT instead of the Depreciation and Amortization amount. Sorry for any inconvenience this might have caused. Watch the introductory video here: https://youtu.be/kvMSxBjhtHs Also access all the videos in the Playlist here: https://youtube.com/playlist?list=PL29wUpOZK1p_TTcTh9Bb8pcmFXYr-PMDT&si=Oa99N9dyCqN0SyOX #financialmodel #valuation #excel #finance #financialmodeling