Complete Company Valuation – A Long Overdue

I have shared my framework of fundamental analysis (as below) with some people before.



If you ever study my excel thoroughly, you probably notice that I do not publish one part in my analysis. That is projection of future earnings and book value, which is part of Company Valuation.


The main reason I did not publish the projection is because I did not format the worksheet properly, and sometimes I just use calculator and paper to do projection. For reduce administrative overhead, I will attempt to incorporate my projection model for each company (if possible) in my analysis. This is a long term on-going project where I will gradually publish projection model for each company in my portfolio.

BTW, I hope that you can differentiate the difference between Company Valuation and Fair Value Estimation. Please check out the following illustrations.




One thought on “Complete Company Valuation – A Long Overdue

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s