Intrinsic Value Calculator for stocks

If you truly want to invest like a professional and make outsized returns, you must value stocks based on a discount model of future profits, something like a simple P/E ratio just isn't enough.

And that's exactly why I created this spreadsheet. It's an easy-to-use excel/google sheets template through which you can calculate the value of stocks. All inputs you need to make are: The free cash flow for the last 12 months, the number of shares outstanding, total cash + total debt, the rate of growth at which the FCF will grow, your terminal multiple and finally the return you want.

This allows for way more flexibility in your stock analysis. Want to do a quick check-up where a stock is at to see whether it's even close to a buy-price? Done. Want an outsized return of 15%+? Just type it in the calculator and it'll tell you where to buy a specific stock at.

What your research will be necessary for is what growth numbers you decide to type into the calculator. If you're too uncomfortable doing so, you can always go with analyst estimates. Although I will say that with thorough research and high conviction in your growth assumptions, that's where the disconnect between an average and outstanding investor is made.

I genuinely hope this product will deliver as much value to you as possible. Since I have used this template for a long time to calculate my buy-prices for my stocks, I can tell you that I think the CHF10 (~$11) price point is far under what it's actually worth. I sincerely mean this because I have not only increased the likelihood of me finding great deals but also protected myself from investing in companies that initially looked great but were just way overvalued.

If you can increase your returns just by 1% on a 1'000 dollar investment, you have already made your money back in a year. Now, think about what you can accomplish when your investment returns increase by something like 10% (as they have for me after implementing this calculator) and you let that compound over decades. The difference will literally be millions (yes, plural).

With this note, I genuinely hope that I could convince you to consider this offer as I think will serve you to a higher degree than any shallow course out there ever could.

Sincerely, The Indefatigable Investor :)