ROI and IRR are not the same measure
Return on investment (ROI) is the plainest of the project metrics: the net gain from a project divided by what it cost, usually expressed as a percentage. If a project costs ₹20 lakh and returns ₹5 lakh over its life after all costs, the ROI is 25%. The number is easy to understand and easy to compare, which is exactly why it appears in one-page summaries.
Its weakness is that it ignores timing. ₹5 lakh received in year one and ₹5 lakh received in year five give the same ROI, even though the earlier money can be reinvested and the later money carries more risk. IRR exists to put the timing back into the comparison.
What IRR actually means
The internal rate of return is the discount rate at which the net present value of a project's cash flows equals zero. In plain terms it is the annual rate the project earns on the money still tied up in it. To find it, you write down the cash flows year by year, with the initial outflow as a negative figure and each year's net inflow beside its year, then solve for the rate that makes their present value add up to the initial cost.
You do not solve that by hand. In a spreadsheet, =IRR(range) returns the periodic rate, and =XIRR(values, dates) handles flows that do not fall on even year-ends. A project with an IRR of 18% earns, on those assumptions, roughly 18% a year on the funds it keeps employed.
Build the cash flow table before touching the formula
Almost every IRR mistake is a cash flow mistake rather than a formula mistake. Four rules keep the table honest:
- Put year 0 in year 0. The capital outlay belongs at the start as a negative figure. Leaving it out produces an IRR that looks impossibly good.
- Keep one basis. Use post-tax cash flows throughout or pre-tax cash flows throughout, and say which basis you used in the notes. Mixing the two makes the result meaningless.
- Include the working capital and its release. Money locked in stock and debtors is a real outflow, and its release at the end of the project is a real inflow.
- Add a terminal value only if you can defend it. If the project has a residual value, or the business continues beyond the projection period, state the assumption and show the working.
The cash flow statement prepared for a project report is the natural source for these lines: operating inflows, capital outflows, interest and principal on the loan, and drawings. Rebuild the IRR table from that statement rather than from a separate set of numbers, or the two will disagree.
NPV, hurdle rate and payback
IRR answers a question about the project. The hurdle rate answers a question about the money: what return the business needs from any project of this risk. If the IRR is above the hurdle rate, the project clears the cost of capital; if it is below, it does not, however attractive the turnover looks.
Net present value (NPV) is the companion measure. It discounts the same cash flows at the hurdle rate and shows the surplus in rupees. IRR and NPV usually agree when you test one project against the hurdle rate, and they can disagree when you rank competing projects, because IRR is a percentage and ignores scale. A small project with a 40% IRR may add less value than a large project with 22%. Where the two conflict, NPV is the safer ranking tool.
Payback is the simplest check of all: how many years until the cumulative cash flow turns positive. Discounted payback applies the same idea to present values. Neither tells you anything about returns after the payback date, so use them beside IRR and NPV rather than in place of them.
IRR when the project is part-loan-funded
Two rates often appear in the same file, and both are valid. The project IRR uses the whole outlay and the cash flows before financing, which shows whether the investment itself is worth making. The equity IRR uses only the promoter's own contribution and the cash flows left after loan instalments, which shows the return on the money the promoter actually puts in. If the loan is cheaper than the project's return, the equity IRR comes out higher than the project IRR; that gap is the effect of leverage rather than extra profit. Label which rate you are quoting, because a credit team reading a 20% figure will want to know which of the two it is.
Where IRR misleads
- Multiple answers. If the cash flow changes sign more than once, for example with a mid-life overhaul, the formula can return more than one rate. Check the pattern before trusting a single number.
- Reinvestment assumption. IRR assumes the interim cash flows are reinvested at the IRR itself, which is rarely true. NPV lets you set that rate yourself.
- Scale blindness. A high percentage on a small outlay can be worth less than a modest percentage on a large one.
- Assumption drift. The IRR is only as good as the sales, margin and collection assumptions behind the cash flows. Test them.
Present the number in the report
In a project report for a bank loan, IRR sits beside the measures the lender actually appraises. The debt service coverage ratio shows whether the yearly cash flow covers the instalments, and break-even shows how much of the capacity must be sold to stay above cost. An IRR of 20% is useful context, but a DSCR that falls below 1 in a lean year is the figure a credit team will question first.
So present them together. State the cash flow assumptions, the discount basis and any terminal value in a short note under the table, quote the IRR to one decimal place, and add a sensitivity table showing the IRR if sales come in 10% lower or costs 10% higher. That page does more for credibility than a single headline percentage, because it shows the reader what happens when the plan slips.
Tools and where Finxora fits
Finxora's project report software builds the project cost, means of finance, projected profit and loss, balance sheet, cash flow, EMI schedule, DSCR, break-even and ratio analysis from one set of inputs, and exports the report as PDF, Word or Excel for the bank. The IRR working sits in your own model, fed by the cash flow statement the report produces, so the assumptions in the appraisal document and the return calculation stay on the same figures. The sample project report shows the statements and schedules in the order a bank reads them, and the financial tools page covers the calculators that handle simpler repayment and interest sums.
