TOOLBOX







Estimating Fair Value Price Range This is the process I use for determining the Fair Value of the stock. I attempt to estimate a fair value range based on five different criteria. Please note, I do not attempt to estimate intrinsic value. The description is in my article Estimation of Stock’s Fair Value Price Range



Discounted Cash Flow Model [DCF Calculation-v2.xls]

I use this as one of the method for present fair value estimation. The description of this model is in my article Fair Value Estimate – Discounted Cash Flow Method



Estimating Benjamin Graham Number I use this method to determine the fair value. I believe it is classic example of how Graham incorporate’s all three metrics that would be important to a shareholder, i.e. price of each share (what price are we paying to buy that business asset), the book value (what is it value if we liquidate it), and yield (how much it is yielding to the shareholder on continual basis). The description is in my article Estimating Benjamin Graham Number



Beta-Based Expected Return Model [calculating-beta-based-exp-returns-v1.xls]

I use this as a measure of any individual stock’s risk (or movement) relative to the overall stock market risk (or movement). The description of this model is in my article Estimation of Beta-Based Expected Return



TIP-Stock-Tracker [TIP-Stock-Tracker.xls]

I use this excel sheet to keep track of my stock position and calculate XIRR. It is also the measure of my personal rate of return.  The description of this tracker is in my article Measuring Progress – Stock Tracker Excel Sheet



~