Buffett said "In the business world, the rearview mirror is always clearer than the windshield."
We can perform financial statement analysis and determine the company quality based on it's pass result. But, what price are you willing to pay for the stock of a good company?
As what Mr. Chong posted on his article, Investment success doesn’t come from “buying good things,” but rather from “buying things well.” Tons of research has shown that investing in good companies is not
necessarily a winning strategy. This is because generally the market has
built into it these expectations. The biggest danger is that the firm
will lose its luster over time and that the premium paid will dissipate.
I have created "CL-P_V" workshet on the Financial Statement Analysis Template in order to checkout what is the relationship between the Stock Price and Company's Value based on it's historical price and financial data. And, this worksheet is a good tool to help us to inspect if there is any price value divergence in a company.
As usual, the "CL-P_V" 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.
You may interest to view the previous release on the template:-
- 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:-
Nicely described. Great job.
ReplyDeleteStartup Models