Monday 7 July 2014

Benjamin Graham's Growth Valuation on Financial Statement Analysis Template (v1.60)

I have created Benjamin Graham's Growth Valuation sheet on the Financial Statement Analysis Template. You can click here to access the said template on the One Drive

As usual, the "V-BGG" 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

First and foremost, you will need to review the data setup sections, and then the worksheet will calculate intrinsic value based on different version of the benjamin graham's growth valuation:-
  1. The original version
  2. Required Rate of Return version
  3. Jae Jun's modificatiokn
  4. Self Defined Version
 and summarize it on the "Summary of Intrinsic value" sections.

 

Do review the Calculation Detail section in order to check out the how the excel calculate the intrinsic value. You can override the default value in the grey color cell.
 

 
Happy hunting!


You may interest to view the previous release on the template:-

No comments:

Post a Comment