XLSDeal Logo XLSDeal Smart office solutions
IRRInternal Rate of Return (IRR) & NPV ← Back

Project Cash Flows

Capital Outlay & Inflows
₹
%
1%30%

Annual Inflows

Investment Feasibility

Calculating...
Internal Rate of Return (IRR)
0.0%
vs 10% Hurdle Rate
Net Present Value (NPV)
₹ 0
Net dollar wealth created
Profitability Index (PI)
0.00
PV Inflows / Outlay
Payback Period
0.0 Yrs
Break-even horizon

Discounted Cash Flow (DCF) Schedule

Yearly nominal flows, discount factors, present values, and cumulative recovery
Period Nominal Cash Flow Discount Factor Present Value (PV) Cumulative Flow
Capital Budgeting Rules: IRR vs NPV & Decision Criteria ▼

Internal Rate of Return (IRR) is the annual discount rate at which the Net Present Value (NPV) of all cash flows (both positive and negative) equals exactly zero.

NPV = CF_0 + [ CF_1 / (1 + r)^1 ] + [ CF_2 / (1 + r)^2 ] + ... + [ CF_n / (1 + r)^n ] = 0 (at IRR)
Profitability Index (PI) = Total PV of Future Inflows / Initial Outlay
  • Decision Rule: If IRR > Hurdle Rate (Cost of Capital), accept the project. If NPV > 0, the project adds financial value to the firm.
  • Profitability Index (PI): A PI greater than 1.0 indicates that the present value of returns exceeds the initial investment.
  • Payback Period: Measures how many years it will take to recover the original cash investment without discounting.