1Yr·

Excel template for the article

Hello dear Getquin community,


as there was a lot of interest in the Excel template for the article, here is the link to the template for you:


https://bit.ly/FCF_FairValue


Cheers,

Michael Scott

previw image
115
30 Comments

profile image
4
profile image
1
profile image
👏👏👏
1
profile image
1
profile image
Clean, many Dank🙏🏻
1
profile image
Thanks @RealMichaelScott, there should be more posts like this posted on gq and less insta-posts 🙏🏼💪🏼♥️
1
profile image
@Doe you can earn money with Instagram 🤷‍♂️ if you like, it's not worth it for me to write such posts here. It would be better to make Instaposts according to the motto "5 SHARES FROM 5 SECTORS".
1
profile image
Wow! You are the best! Thank you so much!
1
profile image
Many thanks for that.
1
profile image
@RealMichaelScott Danke dir beseter man
1
profile image
@RealMichaelScott what kind of company did you take as an example? are you trying to break it down and can't quite figure it out?
1
profile image
1
profile image
@RealMichaelScott Super thanks to you. Then I should be able to do it slowly😅
1
profile image
👍🏻
1
profile image
Question: What is the price of a Rolex? :)
1
profile image
@SwissKnife what it says on the price tag 😉
profile image
@RealMichaelScott that's not true ;-)
profile image
@SwissKnife You could just ask your question a little more specifically, then I could answer it more specifically.
profile image
@RealMichaelScott Why are the Rolex watches trading higher than the price tag?
profile image
@SwissKnife Scarcity 🤷‍♂️

I don't understand what you're getting at. I understand that you can't use it to calculate the price of a Rolex or a sneaker, but that was never the claim.
profile image
@RealMichaelScott can a company run out of shares? :-)
profile image
@SwissKnife sorry but my time is too precious for your question and answer game ✌️
profile image
1
profile image
Can you share a template of your Excel with us? That would be a dream
1
profile image
Question is there a small instruction to fill out
profile image
@Nick_Nick The article should make it easy to understand, or do you have specific questions?
profile image
Hi Michael
Going through the calculation again .I am stuck how the market capitalization in 10 years is calculated as USD 307,842 million. Considering the given growth rate of 7% and initial market capitalization of 145,040 million

Sorry I have a very little knowledge of finance

Thsnks
profile image
@First_inning the market capitalization I calculate there is based on the FCF (in 10y) of the company in 10 years. Therefore FCF itself depends on revenue growth, EBITDA margin, taxes, capex and stock based compensation. The final market capitalization then is based on how valuable the market values the FCF in 10 years. Hence there is the return distribution for different free cashflow yields at the bottom.
profile image
Thank you very much, comes just in time 👌
profile image
You can find it on my profile in a post afterwards.
Join the conversation