What is IRR / NPV Calculator and How Do You Calculate It?
NPV = Sum(CashFlow_t / (1 + r)^t) - Initial OutlayThis standardized equation forms the quantitative foundation used by chartered financial analysts (CFA), investment bankers, and corporate treasurers under GAAP and IFRS reporting frameworks.
Formula Components & Operational Definitions
C0Upfront cash investment (Year 0).
rCost of capital or required minimum rate of return.
CtNet cash inflows generated in years 1 through 5.
Step-by-Step Real-World Worked Example
A company evaluates a Rs 10,00,000 equipment purchase expecting annual net cash inflows of Rs 3,00,000 to Rs 4,00,000 over 5 years with a 12% cost of capital.
Strategic Takeaway: Because NPV > 0 and IRR > Hurdle Rate, the project should be approved.
Industry Benchmark Comparison Table
NPV measures absolute wealth added, whereas IRR measures internal rate of efficiency.
Creates positive economic shareholder value.
Fails to meet minimum cost of capital.
Executive Sector Note: When comparing mutually exclusive projects with different scales, NPV is the superior decision metric over IRR.
Analytical Comparison & Critical Limitations
- Assumes interim cash flows can be reinvested at the IRR rate rather than the cost of capital.
Frequently Asked Questions
What is the decision rule for NPV and IRR?
Accept any project with an NPV > 0 and an IRR exceeding the corporate weighted average cost of capital (WACC).