My previous analysis tempalte (v1.10) have left out the non operating assets from the final DCF value. I have make the correction and include the non operating asset value to the DCF valuation on v 1.11 analysis template. Click here to download the v1.11 template. You can refer to the DCF valuation writeup to check out what is the non operating assets.
The non operating asset will be auto populated from the financial data in the finance input worksheet. And, users can determine to take in how many percentage of the non operating asset to DCF valuation. As valuation is is more of an art than science, there is no fixed guideline how many percentage of non operating asset that we should include. If we are confidence that the underlying assets is worth as what it stated, we can put in 100% of the value. Otherwise, we can take half of the value in order to be convervatise
You may interest to read:-
- Discounted Cash Flow (DCF) Analysis Excel Template (v1.10)
- Financial Statement Analysis Template
- Analysis Template v1.02 and Answer to the Questions
- Cash Flow Statement Analysis
- Discounted Cash Flow Analysis & Reverse Discounted Cash Flow
- Time Value Money
- How to value a stock?
- To be a Hunter or a Farmer?
No comments:
Post a Comment