Simplest DCF possible

Published: 01 March 2024
on channel: The Finance Storyteller
13,334
764

If you want to do a DCF analysis, you are going to need a complicated Excel file, right? Not necessarily! If you keep it simple, you and a calculator can easily do the job.

In the case of a mature company that generates stable cash flows, like telecom company Verizon, you can easily find estimates of free cash flow as well as WACC on the internet.

What if this free cash flow is a perpetuity? A constant stream of identical cash flows with no end. The same number each and every year until the end of time.

In that case, you can divide $21B by 0.07 to get to an enterprise value of $300B. Enterprise value plus cash minus debt gets you to equity value. Equity value divided by the number of shares is the DCF target share price of $36.

Philip de Vroe (The Finance Storyteller) aims to make accounting, finance and investing enjoyable and easier to understand. Learn the business and accounting vocabulary to join the conversation with your CEO at your company. Understand how financial statements work in order to make better investing decisions. Philip delivers #financetraining in various formats: YouTube videos, livestreams, classroom sessions, and webinars. Connect with me through Linked In!

Want to get access to bonus content, and/or express your gratitude by buying me a cup of tea? Join my channel as a member through    / @thefinancestoryteller  


Watch video Simplest DCF possible online without registration, duration hours minute second in high quality. This video was added by user The Finance Storyteller 01 March 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 13,334 once and liked it 764 people.