Intrinsic Value Calculator Excel

Understanding the intrinsic value of a stock is crucial for investors seeking to make informed decisions in the dynamic world of finance. This Intrinsic Value Calculator Excel tool simplifies the calculation process, making it accessible to all.

Formula: The intrinsic value is calculated using the formula: Intrinsic Value = EPS * (1 + Growth Rate) / (Discount Rate – Growth Rate).

How to Use:

  1. Enter the Earnings Per Share (EPS) of the stock.
  2. Input the Growth Rate (%).
  3. Provide the Discount Rate (%).
  4. Click the “Calculate” button to get the intrinsic value.

Example: Let’s consider a stock with an EPS of $5, a growth rate of 8%, and a discount rate of 10%. After plugging in these values, the calculator reveals the intrinsic value.


  1. What is the significance of intrinsic value in stock valuation?
    • Intrinsic value helps investors determine whether a stock is undervalued or overvalued.
  2. Can I use this calculator for any stock?
    • Yes, as long as you have the required financial data.
  3. Is the growth rate annualized?
    • Yes, the growth rate should be entered on an annual basis.
  4. Why is the discount rate important?
    • The discount rate accounts for the time value of money, reflecting the opportunity cost of investing elsewhere.
  5. What if I don’t know the growth rate?
    • Make an informed estimate based on historical data or analyst predictions.

Conclusion: This Intrinsic Value Calculator Excel tool empowers investors with a quick and efficient means of evaluating the true worth of a stock. By considering key financial metrics, users can make more informed investment decisions in the complex landscape of the stock market.

Leave a Comment