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:-
- The original version
- Required Rate of Return version
- Jae Jun's modificatiokn
- Self Defined Version
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:-
- 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
ccs999
Hi II, how to get the excel form? or can you email me chunsiong_85@yahoo.com
2014-07-08 07:48