I’ve tried to calculate and plot the Price to Cash Flow chart for Amazon but it seems didn’t go well.
Based on what you have shared in the live webinar, the P/CF average is 29.25 yet what I get was 1.58. Not sure where goes wrong, could you enlighten me?
I cannot see your data points from the image. You may want to send the excel file to firstname.lastname@example.org for me to take a look.
I managed to find your issue. Amazon recently did a share split. Hence, the share price you have collected is a post-split price. The problem lies in your number of shares; it is not adjusted for splits. To solve the issue, you must multiply the yearly shares by 20. Once done, you can re-input the cash flow per share, and the problem will be solved.
Hope this helps :)
Please login or Register to submit your answer