Intrinsic Value Calculator
This spreadsheet tool provides you with an easy way to calculate the Intrinsic Value of a listed company. Based on the values you input an Intrinsic Value result will be provided. Also, an indicative forecast of the future performance is provided, along with the predicted returns you might expect.
The input values and results for Apple Inc (AAPL) have been provided as an example. Please overwrite the input values for the company you wish to analyse.
Please explore what happens to the Intrinsic Value when you adjust some of the input variables. For example, what would happen if the company paid out less in dividends, or what is the effect of raising or lowering your Margin of Safety (MOS), etc?
We hope you find this tool of value.