Stock Value Calculator

Β£450.00
Processing ...

You’re IMM (In The Money) πŸ’Έ

The crux of value investing is to buy a stock for less than it’s worth, and make money from the market correction to its true value. But let’s get practical, you can’t work this out in your head. You need a net present value, discounted cash flow model that doesn’t rely on CAPM. I’ve spent about six months building one that’s beginner-friendly, and now it’s like my third arm. Β£450 gets you the calculator, evergreen and updated annually, with a 30-minute on-boarding call via Skype/Instagram Call if you’d like help with anything. This lesson I demonstrate how to use the model with Facebook as an example. Let’s get cracking!


Quick Instructions πŸ“œ

Fill out the green boxes.
Click on the little red triangles for help.
Use a discount rate higher than 10% for young companies.
Use instructions in Lesson 7 to estimate ROIC.
Use avg. GDP growth as your terminal growth rate (3% in US).
Use Ctrl-F to search for keywords in 10Q/K documentation.

Quick Wisdom πŸ™Œ

Apply a 20% margin of safety to your final valuation.
Be conservative where possible.
Garbage in, garbage out.
Ignore three-blind-mice debates about CAPM and WACC.
Bother working out maintenance capital expenditures and net working capital (lesson 7).
If you’re new to the course, go back and watch it from lesson 5 for context.

Enter the Company Name ✍️

You’re a natural!


Enter the Industry ✍️

Is it an automotive company? A social media company? A steel manufacturer? A textile mill? Sometimes, it’s hard to pin it down. Use the GICS classifications for help if needed.


Fetch the Effective Tax Rate for The Industry πŸ”

Click on the blue hyperlink and pull the average effective tax rate for your industry (or a close industry) from the table provided. Better yet, download the company’s 10K here and press ctrl+F to search for the keyword ‘tax,’ finding it specifically for your company. Be careful not to mistake the marginal tax rate for the effective tax rate!


Fetch the Long-term Debt πŸ”

This website has all the company documents for free. The 10K is a yearly report about how business is going and it includes three key financial statements. Go to ‘Financial Statements and Supplementary Data’ and then ‘Consolidated Balance Sheet.’ The first half are assets, and the second half are liabilities (debts). Take the total liabilities figure, whether it’s big or small. Type it in to the green box in your model exactly as is!


Fetch the Cost of Debt πŸ”

Click on the blue hyperlink and lookup the average cost of debt for your industry. Enter it into the green box in the model. Nice work!


Pick Your Discount Rate πŸ€”

This is your first big input! It doubles up as both risk in the business (one half of your risk/reward matrix), and the annual return you’ll get from the stock.

RiskDesired Annual Return
In this cutthroat capitalist world, there’s always a risk to profits predicted by investors. The risk of permanently losing money needs to be accounted for. Your has it covered and reflects it into your valuation of the company.
If you set the discount rate at 5%, the calculator will spit out the stock price you need to buy at to get a 5% yearly return, on average, over the long-term. At only 5%, most businesses will look undervalued to you as you won’t need to buy very low to secure that value for money. However, if you’re discount rate goes up to 20%, you’re going to need to buy very low to earn that yearly return, on average, over the long-term. In that case, most stocks will look too expensive for you.

Don’t set a discount rate below the annual return you’re willing to accept. That should be your floor. On top of that, go up as high necessary to feel compensated for real risk in the business.Β 

The stock market goes up 10% per year on average. If we’re picking stocks, it makes sense to want to beat that. Set your discount rate at a minimum floor of 10%.

Then, look to the business. Is it young? Profitable? Led by conservative managers? Fearsome competitors out there? There are a million and one factors to consider. For some perspective, start-ups looking for a first round of funding from venture capitalists have discount rates of around 25% attached to them. A steady-Eddie freight railroad with reliable profits and 100-year business prospects sits only at a 4-5% discount rate.

Make the call. There’s no right or wrong answer, and you can change this after the stock value is calculated.


“What’s This?”

It’s your table to project the company’s profit into the future. This is the reward side of your risk/reward matrix.

YR-2 was two years ago. YR-1 was one year ago. YR+1 is next year. YR+2 is the year after that.

Keep your eyes on the green πŸ’Έ. Our job is to fill out operating profit going forward. It’s also great to work out and enter the company’s maintenance capex and net working capital as well. Read the previous lesson‘s transcript to learn how.

Tax and interest obligations for the company are worked out for you. Net income and free cash flow are also calculated automatically based on the numbers you punch in.


Start With This Year’s Operating Profit ℹ️

You need this year’s 10K and financial statements again, but this time look at the income statement. Find operating profit and enter it into the model.

It’s smarter to download the last four quarterly reports (10Qs). If you add the operating profit figures together from the latest four quarters, you have a more accurate overall number.


Then, Estimate Its Growth Rate for 8 Years 🌱

All your hard work and sacrifice to research the business (taught in lesson 9) will pay dividends here. You work out the profits in the future by working out the growth rate of the current year’s profits. There are three components of that growth rate. First, the company’s “reinvestment rate.” Then this year’s “return on invested capital” (ROIC), and next year’s ROIC as well.


Reinvestment Rate

The reinvestment rate is the percentage of annual profit reinvested back into the business. This is done instead of paying out directly to owners through a dividend. Why? Because companies want to grow and they need investment for new projects!

The formula: 1 – Payout Rate.

Payout rate is worked out this way:

  1. (1 – Dividends per share) / Free cash flow per share
  2. Free cash flow per share = Free cash flow / Shares outstanding

If you struggle to work out the payout rate, please watch lesson 7.

This Year's ROIC

ROIC means return on invested capital. It’s the most important concept you will work with as an investor. It refers to the return a business can make on money reinvested back into itself.

The formula: NOPAT Γ· invested capital.

NOPAT (Net Operating Profit After Tax)

  1. Operating profit x (1-business tax rate) (operating profit is on the income statement and the tax rate you have a table for, or, can find in the 10K by pressing ctrl-F and typing “tax.”)
  2. A 20% tax rate implies (1-0.20), which would come out as operating profit x 0.80.
  3. Done, that’s NOPAT!

Invested Capital

  1. Current liabilities that aren’t related to debt – current assets (Usually only accounts payable are liabilities not related to debt. Google line items you’re not sure about just in case there are any more. You’re looking for liabilities that have nothing to do with debt or ongoing interest payments of any sort!)
  2. Then + PPE (property, plant, and equipment is an asset on the balance sheet)
  3. + 2-5% of revenue (this strips out excess cash. Find revenue/sales on the income statement. Add 2% if a steady, established business, and 5% if it’s a new growth company)
  4. Goodwill is the amount of money the business has paid to buy other companies over and above what the equity added up to in those companies. The rules have it that sometimes, the business will need to write-off some of its goodwill figure. By doing that, it admits it overpaid by some amount. Decide if the business will probably buy more companies in the future, and if not, don’t + goodwill. If you think yes, + goodwill. Stay afloat of the news because if write-offs are announced, you’ll need to – from the goodwill you’re +’ing.
  5. + other assets on the balance sheet that you think are directly needed for the business to make money immediately.
  6. Done!

Then, divide NOPAT by invested capital to reach the real ROIC. Well done! 🏁

Next Year's ROIC

Click on the button for ‘average ROICs’ along the side of the calculator. Find the figure for companies in your industry, and compare it to the current ROIC of your business. If it’s below, your business is at a competitive disadvantage. If it’s above, your business is at a competitive advantage. Competitive positions change all the time. As an investor, it’s your job to research the business, its environment, and exercise rational judgement over how its competitive position will change relative to peers.

There’s no right or wrong answer to what ROIC will be next year, or the year after, or the year after that. It’s your choice. I recommend you work out ROICs through history of the best and worst companies in your industry so that you have some perspective on how ROIC changes as real life events play out.


Armed with all three components, put it all together in this formula:

Next year’s ROIC x Reinvestment Rate + (Next year’s ROIC – This year’s ROIC) Γ· This year’s ROIC.

The result will be the percentage change in operating profit from this year to the next, i.e. for the YR+1 box. To fill out the rest of the boxes, either work out a new percentage change after every year and keep filling them out one-by-one, or apply that original growth rate to every box.


And Then Forever After That ∞

It’s hard enough to predict the future in 8 years time, let alone into infinity. That’s why we set a very conservative ‘terminal growth rate’ ensure we’re including perpetual growth in our valuation, but fairly. If the company is growing its profits, set this to average GDP growth. In the US, that’s 3%. If the business is not growing its profits year-to-year, it may need to be negative. I roll my eyes when I see investors set this number at 5% or 6%. To be rewarded with that kind of terminal growth, a company needs very strong and durable competitive advantages.

No-one can escape fate, which in commercial terms is to live around 40 years before becoming obsolete. Bear in mind that your company will need a negative growth rate in its old age, which usually comes sooner than most investors realise. We’re on the home stretch now!


Include The Value of Marketable Securities πŸŽ—

We’re polishing off loose ends now, such as what investments the business itself holds. Minority ownerships are common, so open the balance sheet again on the 10K. In the assets section, take the value of ‘marketable securities.’ Enter it into the green box in our model.


Include The Value of Dormant Assets πŸ—³

Dormant assets aren’t creating any value for us today, but at some point they’ll be put to work or sold. That’s value for us. To find the dormant assets figure, open the 10K, type ctrl-F on your keyboard, and search for the word ‘dormant.’ Mentions of potential dormant assets will appear. The number is likely to be very small in any case.


Plug in The Total Number of Shares Outstanding πŸ’΅

You now have the value of the business as a whole. To get from here to the value per share, you need to enter the total number of shares out there. You can find that information in the 10K.


You Did It! πŸŽ‰

Of all the stocks you value, buy those which trade at the biggest discounts to their true values. If your inputs to the model have been reasonable, the stock will eventually correct and you’ll make money on the way up. You may need to wait for a moment to pounce, and update your valuation every few months.

Chris Morrissey

Chris started in financial advisory, assembling client portfolios with pension companies and investment banks. Following that, he worked at an agricultural commodities trader in London and now various "fintech" start-ups. He's also studying business full-time at Lancaster University. Feel bewildered by the stock market? Chris will help you get things under control.

View all posts

Add comment

Your email address will not be published. Required fields are marked *