In the current release (v1.80), I have built 3 sheets - V-DY, V-EY, and V-EY_JG in order to compare the price based on its historical Dividend Yield, ordinary Earning Yield(E/P) and Joel Greenblatt's Earning Yield (Magic Formula) respectively. The worksheet will be auto pick all the required data after you filled in the purple colour input worksheet as per specified in Financial Statement Analysis Template.
Based on normal distribution, the DY and EY should between the Standard Deviation from the Mean. And, we are using this theory to buy a company when it is selling cheap (price near to the high band); sell a company when we can sell it in a high price (price near to the low band).
I get the idea from Emily's Video and present a traffic light alike dashboard in the worksheet in order for us to monitor the share price vs its value:-
- Red - Expensive
- Yellow - Moderate
- Green - Cheap
Happy hunting!
You may interest to view the previous release on the template:-
- Price vs Value on Financial Statement Analysis Template (v1.70)
- Benjamin Graham's Growth Valuation on Financial Statement Analysis Template (v1.60)
- Update V-DDM on Financial Statement Analysis Template (v1.52)
- Update V-Asset and V-DDM on Financial Statement Analysis Template (v1.51)
- Asset Valuation (NCAV, NNWC, RNAV, EV) on Financial Statement Analysis Template (v1.50)
- Dividend Discount Model (DDM) on Financial Statement Analysis Template (v1.40)
- Absolute PE Valuation Model on Financial Statement Analysis Template (v1.30)
- Magic Formula on Financial Statement Analysis Excel Template (v1.20)
- DCF Analysis Excel Template (v1.11) - to include Non Operating Assets
- Discounted Cash Flow (DCF) Analysis Excel Template (v1.10)
- Analysis Template v1.02 and Answer to the Questions
- Financial Statement Analysis Template
References:-
- Buying Good Companies when the price is cheap - A summary from 小資女艾蜜莉 video
- Magic Formula - Joel Greenblatt
- Price and value relationship of stock investing Kcchongnz
- Investing in Bursa: Have the cake and eat it kcchongnz
No comments:
Post a Comment