Home Intrinsic Value Calculator

Sponsored Links

User Rating: / 4
PoorBest 

This is a Intrinsic value calculator which I have programmed. You may use it to calculate the intrinsic value of any stock.

Note: Please refer to the Discounted Cash flow section if you are unsure of how this works.

Discounted Cash Flow Calculator
Initial Cash Flow (Unit: Million dollar) E.g. 500 millions input 500
Cash Flow Growth Rate (Unit: decimal) E.g. for 10% input 0.1
Inflation Rate (Unit: decimal) E.g. for 5% input 0.05
Projected No. of Years (Unit: Year)
Number of Common Shares Outstanding (Unit: Million Shares) E.g. 100 millions share input 100
Sum of Discounted Cash Flow (Unit: Million Dollar)
Stock Intrinsic Value (Unit: Dollar)

Where to get the Value for Initial Cash Flow?

The Initial Cash Flow of the company can be found in the Cash Flow Statement of the annual report. It is actually the Operating Cash Flow/ Cash From Operating Activities for the Current Fiscal Year.

Below is an example of where to get this value from the POEMS Brokerage Account. From this example, the initial Cash Flow for BreadTalk is $42.60 mil. Note that all the figure is in Million unless specify.

  • The Time Period Must be Annual
  • Look at the Current Year
  • Look at the Cash From Operating Activities

image

Another Example is to get it from Finance Google. Go to the Financial Section and Click on Cash Flow. Remember to select Annual Data and look under the Cash From Operating Activities Section.

image

How to get the Cash Flow Growth Rate?

Well, this is a tricky question! Note that if the company has inconsistent growth, meaning it has a lot of negative cash flow for some of the year, you cannot use Discounted Cash Flow method! There is no way you can get a reasonable Cash Flow growth rate from a inconsistent growth company.

So you have to make sure that their Cash Flow is consistently increasing every year!

One simple method to get the growth of a good company is :

Growth Rate = ( Cash Flow at Year N / Cash Flow at Year N-5 ) ^ { 1/ (N-5-1) }  - 1

Another Method is to get the average growth of the cash flow for every year.

How to determine the Inflation Rate?

Inflation rate is the inflation rate for the country. This is usually around 5-7%. You can try google for an exact amount for it.

How to determine “Projected No. of Years”?

It should be reasonably a big number. Usually 5-10 years will be good enough.

How to get the value “Number of Common Shares Outstanding”?

You can get this figure easily from the Annual Report under the Balance Sheet section.

Look for “Total Common Shares Outstanding”. That value is also usually represented in million.

image


Add your comment

Your name:
Subject:
Comment:
  The word for verification. Lowercase letters only with no spaces.
Word verification:
Comments (3)
Re:
3Monday, 26 March 2012 16:38
OdomMargo24
That's cool that we can get the personal loans and that opens new opportunities.
Re:
2Thursday, 30 June 2011 10:24
KaraBullock31
Make your life time easier get the mortgage loans and everything you want.
query
1Thursday, 21 October 2010 02:45
instrinsix
Is it a MUST for the operating cash flow to be increasing every year? what if the op cash flow is always positive but not really increasing?
RE: @query isit a must for operating cash flow to increase?
Friday, 22 October 2010 10:43
LollyMotion
I personally feel it should be increasing. This is due to inflation. The company sale income will increase. Let me give you an example McDonald's meal is about $4 in Singapore 10 yr ago. But now, it is about $6. They increase their price to protect against the inflation. When Price increase, income increase, earning increase, thus cash flow increase. So Cash Flow should increase.

However, if the Company is expanding slowly, then the cash flow might not increase that much or stay about the same. This expansion can be observed from the "Changes in working Capital" in "Cash Flow statement" and the asset column of the balance sheet.

Hope this answer helps you =)

Recommended Book

Search