I just discovered some great valuation calculators at the Financial Times website. In the Lex section of the site, there are four tools that you might find useful. These calculators include the following:
- Discounted Cash Flow Model – This calculator lets you input 5 years of free cash flows based on EBIT, plus depreciation, less Capex, and taxes. You also need to input the weighted average cost of capital and the perpetual growth rate. Finally, to adjust the enterprise value by adding in net cash, minority interests, pensions and other liabilities, taxes, and associate investments. Anyone know what “Associate Investments” are?
- Dividend Discount – This is the classic Gordon’s growth model. All you need to enter is the annual dividend amount, the dividend growth rate, and the cost of equity (i.e., the discount rate).
- Weighted Average Cost of Capital – This calculator takes the ratio of debt to equity to get a weighted average cost of capital. I don’t really typically calculate my discount rates this way, but I know many of you likely do.
- Buy to Let – If real estate prices keep declining, I might start using this calculator to determine whether purchasing an investment property might generate enough rent to provide a value investment opportunity. Just replace the word “Let” with “Rent” and substitute £ with $.
I really like the way the Discounted Cash Flow Model calculator lays out the way you take the net present value (NPV) of the enterprise value from the DCF model and adjust it to get to the value of each share. The only thing that stumped me was the “Associate Investments” line. Anyone know what “Associate Investments” are? Is this a British term for something I might easily recognize?
While you are exploring the valuation tools, I also recommend that you explore the other content at FT.com. If you like what you see, I recommend getting a subscription to The Financial Times (affiliate link).