IRR & NPV Calculator

Evaluate the profitability of an investment by calculating its IRR and NPV.

Investment Details
$
%
Future Cash Flows (End of Year)

About the IRR & NPV Calculator

Net Present Value (NPV) and Internal Rate of Return (IRR) are two of the most important metrics used in financial analysis to evaluate the profitability of an investment or project. This calculator allows you to compute both values based on an initial investment and a series of projected future cash flows, providing a clear picture of a project's potential returns and viability.

Understanding the Calculations

  • Net Present Value (NPV): NPV measures the value of an investment in today's dollars. It calculates the sum of all future cash flows, discounted back to the present, and subtracts the initial investment. A positive NPV indicates a profitable investment, while a negative NPV suggests it will result in a net loss. The formula is:
    $ NPV = \sum_{t=1}^{n} \frac{CF_t}{(1+r)^t} - C_0 $
    Where $CF_t$ is the cash flow at time $t$, $r$ is the discount rate, and $C_0$ is the initial investment.
  • Internal Rate of Return (IRR): IRR is the discount rate at which the Net Present Value of all cash flows (both positive and negative) from an investment equals zero. It represents the expected annualized rate of return for the investment. Generally, if the IRR is greater than the company's required rate of return (or discount rate), the project is considered acceptable.

Frequently Asked Questions (FAQ)

What is a "discount rate"?

The discount rate is the rate of return used to discount future cash flows back to their present value. It's often set to a company's Weighted Average Cost of Capital (WACC) or a required rate of return. It represents the minimum return an investor expects to earn from an investment, given its risk profile.

How should I interpret the results?

A standard decision rule is: Accept the project if the NPV is greater than $0 and the IRR is greater than the discount rate. Reject the project if the NPV is less than $0 and the IRR is less than the discount rate. If the metrics give conflicting signals, NPV is generally considered the more reliable indicator.

Can IRR be misleading?

Yes, in some situations. IRR can be unreliable when comparing mutually exclusive projects of different scales or when a project has unconventional cash flows (e.g., multiple negative cash flows after the initial investment). In these cases, NPV is the superior metric because it provides a direct measure of the value added to the firm in absolute dollar terms.