Few days ago, I have posted the Magic Formula Valuation on v1.20 analysis template which built on top on the Financial Statement Analysis Template.

Today, I have created a new worksheet to perform earnings based valuation based on Vitaliy Katsenelson's Absolute PE Valuation Model.  You can click here to access the said template on the One Drive. 

The "V-AbsPE" worksheet is a new valuation worksheet that I created based on the existing Financial Statement Analysis Template and all the required data will be auto picked by the V-AbsPE worksheet after you filled in the purple colour input worksheet as per specified in Financial Statement Analysis Template.


 

You can review the data setup sections in order to confirm all of the inputs. Please refer to Absolute PE Valuation Model writeup if you not sure about the data setup. The input data can be override on the grey color cell. (It is similar to Financial Statement Analysis Template.)


You can refer to supporting data sections in order to review the financial statement and determine the appropriate data input.
 



 



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

• 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

References:-

• The Absolute PE Valuation Model