Update V-DDM on Financial Statement Analysis Template (v1.52)

I have performed some minor updates on V-DDM's sheet Financial Statement Analysis Template (v1.51) and update it to v1.52.

[1] Update  "V-DDM" sheet - formula for Scenario (3) : Growth on Y1-Y5 and then Constant Growth Dividend & Scenario (4) : Growth on Y1-Y5, Y-6-Y10 and then Constant Growth Dividend

Previously, I have discount the Perpetuity value by using 6 and 11 year, and it is a mistake. The value should be  disoucnt by 5 and 10 years. Thanks Mr. Chong for pointed it out.
 

 

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:-

• 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