Intelligent Investor's Notes

Price vs Value on Financial Statement Analysis Template (v1.70)

Intelligent Investor
Publish date: Wed, 09 Jul 2014, 11:52 PM
Intelligent Investor
0 47
http://intelligentinvestor8.blogspot.com
Following Message
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 can click here to access the said template on the One Drive. 

Happy hunting!
 
You may interest to view the previous release on the template:-
 
 
 
References:-
Posted by at  
 
Labels: ,
More articles on Intelligent Investor's Notes
IPO Analysis

Created by Intelligent Investor | Nov 02, 2015

KLSE - Financial Data (Free)

Created by Intelligent Investor | Nov 02, 2015

Company with Continuously Improvement in Adjusted EPS for Pass 10 FY

Created by Intelligent Investor | May 07, 2015

Cold Eye’s 5 yardsticks for investment

Created by Intelligent Investor | Jan 31, 2015

Buying Good Companies when the price is cheap - A summary from 小資女艾蜜莉 video

Created by Intelligent Investor | Jan 27, 2015

Five Habits of Highly Successful Investors - #5: Understand risk

Created by Intelligent Investor | Jan 14, 2015

Five Habits of Highly Successful Investors - #4: Mind your behaviour

Created by Intelligent Investor | Jan 14, 2015

Five Habits of Highly Successful Investors -#3: Read…read…read

Created by Intelligent Investor | Jan 14, 2015

Five Habits of Highly Successful Investors - #2: Know basic accounting

Created by Intelligent Investor | Jan 14, 2015

Five Habits of Highly Successful Investors - #1: Set a goal, and work towards it

Created by Intelligent Investor | Jan 14, 2015

Discussions
3 people like this. Showing 8 of 8 comments

AyamTua

spending my precious time reading and learning this ... :-) thank you, bro!

2014-07-10 02:01

AyamTua

one cannot punt forever lah must also learn and study ..baru cun cun sui sui bo ... kikiikiiii

2014-07-10 03:13

Intelligent Investor

AT, you are welcome

2014-07-10 10:05

Chief

Dear II,

First of all thank you for sharing the worksheets, I can see lots of effort put into doing it.

Reg, the "CL-P_V" worksheet, I have a suggestion that you include the price CAGR into the normalised chart, With this we can easily point out if there is a price to value divergence.

Thank you once again.

Rgds,
Chief

2014-07-11 20:43

Intelligent Investor

Hi Chief,

It have been included in Business Performance vs Price - Normalized graph at bottom left.

2014-07-11 21:20

Chief

Thanks II,

Noted! Any way that we can share the analysis that we have made using your template?

2014-07-12 15:54

Intelligent Investor

Hi Chief,

It will be great. You may want to consider to post it here for sharing.

You can refer to http://klse.i3investor.com/blogs/kianweiaritcles/36923.jsp for the step.

2014-07-12 20:15

Ray Vasri

Great article. Thanks for the info, you made it easy to understand. BTW, if anyone needs to fill out a financial statement, I found a blank form here http://pdf.ac/6LD56.

2015-04-01 11:10

Post a Comment