The Buffett - Stock Price Target Calculator

This calculator is based on the past five years of compound annual growth of earnings per share, dividend percentage payout ratio, and price-to-earnings ratio. With these figures, the spreadsheet calculates a theoretical price target five years into the future. It is using a discount rate of ten percent as default. This can be modified to your liking.

Growth can however only be calculated from positive numbers, which means that if a company reported negative earnings five years ago, the calculator can't present a target price. It also retrieves data from several databases, sometimes it takes a while for the data to load. During this time, the calculator will act if as the company reports negative earnings. Please wait until the data is populated.

Please note: The spreadsheet is free to download, just insert "zero" as the price you are willing to pay - but if you want to pay a higher amount, the proceeds will help me develop new and more advanced spreadsheets (that also will have the option to download for free).

The link to your own copy of the spreadsheet will be delivered in a PDF document immediately after the purchase is completed.

If you have any questions or suggestions on a spreadsheet I should develop, please contact me at Garpstocks@gmail.com or leave a comment on my Youtube channel, GARP Stocks.