Thanks for your response Cameron. I will take it as constructive
Firstly, thanks for the challenge on the cash flow numbers. It is easy to get number-blind, so I always appreciate someone casting their eyes on the details.
The negative $1-2 billion FCF mentioned in the earnings deck reflects managementās adjusted free cash flow outlook. The numbers in the model are for unlevered free cash flow, which is a different free cash flow calculation. However, you have forced me to run through the numbers again as I still get positive FCF when using the operating free cash flow ā CAPEX formula for FCF.
Working my way backwards - my CAPEX numbers pretty much align with projections; therefore, my operating cash flow must be higher. Looking at the base case scenario as an example, I have revenue growth of -4%, gross margin of 53% and an operating margin of 25%.
Guidance and analystsā revenue projections are around $76b. I have revenue in 2022 at $75.9b, so that seems to align ok. Management guided 52% for gross margin, so I am 1% higher. Q1 gross margin was 53.1%. I have the operating margin at 25%, which I reduced vs previous years. Last yearās operating margin was 28%, and the 5-year average is 32%. However, the operating margin in Q1 was around 23.5% (depending on GAAP or non-GAAP), so I could have gone lower.
If I change the model so that the gross margin is 52% rather than 53%, and change the operating margin to 23% from 25%, I get negative free cash flow (operating cash flow ā CAPEX), but I still get positive unlevered free cash flow for 2022, albeit lower at Ā£286m. If I replicate this change for the forecasts over the next five years but add in some progression towards the management goals of gross margins of 54%-58% and operating margins of 30% (2026 = gross margin of 55%, and operating margin of 27% - so still conservative); I end up with an intrinsic value per share of $43.78 rather than $49.38. I will review the progress in the subsequent earnings to see how the actuals are falling and refresh the model again.
Also, thank you for the advice relating to the video. It is interesting as others have said they like to see the calculations. I suppose it is a personal preference.
I get what you are saying about wanting more information on when and how margins will change rather than seeing model inputs and outputs. I also enjoy reading these views from others, and I used to write about this. Many people do this already, and far better than I would. Therefore, I am focusing on sharing models, as many people still like to see this element to complement their other reading. But again, I suppose it is a personal preference.
Thanks again for the challenge and feedback. I look forward to more in the future . Good luck with your investments; I hope they are being kind to you!