Finxora Logo
Sign In
IRR and NPV: A Practical Guide to Project Selection
Back to Blog

IRR and NPV: A Practical Guide to Project Selection

FINXORA
6 min read
finance
project management
investment analysis
NPV
IRR

Compare investment projects using NPV and IRR, understand conflicting rankings, and separate value creation from the ability to repay a bank loan on time.

Two measures, two different questions

Net present value, or NPV, measures the value of expected project cash flows after discounting them at a required return. Internal rate of return, or IRR, expresses a discount rate at which those cash flows have zero NPV. Both can help an Indian business compare investments, but neither should be read without checking cash-flow assumptions, timing and financing constraints.

A machine purchase can show an attractive percentage return while adding less total value than a larger alternative. A project can also have a positive NPV while lacking cash for an early loan instalment. Separate investment value, percentage return and debt repayment capacity. They are related assessments, but they do not measure the same thing.

Prepare the cash flows before calculating

Start with the initial investment and incremental operating cash flows. Include expenditure on installation and the working capital needed to begin operations. Reflect later replacement spending, changes in working capital and a supportable terminal recovery. Use cash flows attributable to the proposed project rather than total company receipts that would arise even without the investment.

Keep the valuation perspective consistent. Cash flows available to all capital providers require an appropriate project discount rate. Equity cash flows after borrowing and debt service require an equity return assumption. Mixing a project-level discount rate with equity-level cash flows can produce a misleading result. Document tax treatment, inflation and the timing convention used.

  • Separate cash flow from accounting profit and non-cash depreciation.
  • Include opportunity costs where existing resources have an alternative use.
  • Exclude costs already irreversibly incurred from the forward decision.
  • Include incremental effects on existing products or operations.
  • Support residual asset values and working capital recovery assumptions.
  • Use consistent units and periods throughout the calculation.

How NPV works

For annual cash flows, a common expression is NPV = C0 + C1/(1+r) + C2/(1+r)^2 + further discounted cash flows. Here C0 is normally the negative initial investment, Ct is the net cash flow in period t and r is the discount rate per period. If additional investments occur later, those outflows also belong in the calculation.

A positive NPV means the forecast exceeds the required return on the assumptions used. A negative NPV means it falls short. This is an estimate rather than a promise of future receipts. The discount rate should reflect an appropriate required return and risk assessment, not simply the lowest loan rate available to the borrower.

For mutually exclusive investments with comparable evaluation horizons and consistent assumptions, NPV is generally the principal measure of value creation. Different useful lives, replacement needs or capital constraints may require additional analysis. A larger positive number should still be examined for funding feasibility, implementation capacity and the credibility of terminal cash flows.

How IRR works

IRR is the rate that sets NPV equal to zero. With a conventional pattern consisting of an initial outflow followed by inflows, a unique economically meaningful IRR can often be calculated. Comparing that rate with the appropriate required return gives another view of the project's attractiveness. The rate must match the period of the cash flows.

An IRR reported as 20% is not a guarantee that the business will earn that return on every rupee in every year. It summarises the projected cash-flow pattern. A small project can have a higher IRR while generating less value in rupees than a larger project. The size and timing of cash flows must remain visible beside the percentage.

A checked example of conflicting rankings

Consider two independent one-year investment estimates, both with the entire inflow received at the end of year one. Assume a 10% annual required return. Ignore tax, financing effects and additional working capital for this illustration. The simplified period makes the calculations transparent; an actual bank-loan project will normally require a much longer cash-flow schedule.

MeasureProject AProject B
Initial outflowRs 1,00,000Rs 2,50,000
Year-one inflowRs 1,20,000Rs 2,90,000
IRR20%16%
NPV at 10%Rs 9,090.91Rs 13,636.36

Project A's NPV is Rs 1,20,000 divided by 1.10, less Rs 1,00,000. Project B's NPV is Rs 2,90,000 divided by 1.10, less Rs 2,50,000. For a single initial outflow and one inflow after one year, IRR is the inflow divided by the outflow, less one. These calculations produce different rankings because the projects have different investment sizes.

If only one project can be selected and the business can fund either on comparable terms, B adds more forecast value at the assumed discount rate. A has the higher percentage return. If capital is constrained, selecting the highest NPV project in isolation may not be feasible: the business must compare the available combinations and the value of other uses for the remaining capital.

Recognise situations where IRR becomes difficult

Cash flows with several sign changes, such as an initial investment, operating inflows and a later decommissioning outflow, can produce multiple IRRs or no meaningful IRR. A spreadsheet displaying one result does not prove there is only one relevant root. Examine the cash-flow pattern and the NPV at plausible discount rates before relying on the percentage.

Timing also matters. Standard periodic calculations assume equal intervals, while dated cash flows require a method that uses the actual dates. Monthly rates and annual rates should not be compared directly. Check whether the result is a periodic rate or an annualised rate and label it clearly in the appraisal working.

Test the assumptions that drive the result

Prepare lower-volume, lower-price and higher-cost cases where those risks are material. Test delays in commissioning and collections, as well as reductions in the terminal recovery. Change related assumptions coherently: lower production might reduce variable costs while fixed costs continue. A sensitivity exercise should explain the business effect rather than change every input by the same percentage mechanically.

Consider a range of discount rates and identify which assumptions cause NPV to become negative. Avoid double counting the same risk through both heavily reduced cash flows and an unexplained rate premium. Present the baseline and adverse cases with their underlying assumptions so decision-makers can assess the reason for the change.

Connect investment appraisal with bank appraisal

An Indian lender also examines funding sources, promoter contribution, repayment schedules, security and the credibility of projected statements. DSCR compares defined repayment resources with debt service under the appraisal convention used. It measures a different question from NPV and IRR. A favourable investment return does not establish that principal and interest can be paid on their due dates.

Finxora project report software prepares documented DPR sections including projected statements, repayment schedules, DSCR and break-even analysis. This article does not claim that Finxora calculates NPV or IRR. Maintain the investment-appraisal working separately and reconcile its assumptions with the DPR. Review sample reports for the bank-report structure.

Make the decision reviewable

Retain the source cash flows, discount-rate rationale, calculation method, scenario results and funding constraints. State which investment is proposed and why it is feasible. Record uncertainties that require quotations, customer evidence or lender clarification. A defensible project-selection decision combines a correct calculation with realistic operations, adequate funding and a transparent explanation of risk.

Frequently Asked Questions

Published on February 14, 2026

Updated on July 20, 2026

Back to Blog

Need bank-ready financials? Create a CMA report or a project report with Finxora in minutes.