Calculation Desk Project controls Open full desk

Project Selection & Finance / analysis brief

NPV, IRR and payback: three views of one investment

Enter the hurdle rate, initial investment and ordered cash flows to discount the project and read NPV, IRR, benefit–cost ratio and payback together. The guide covers timing, sign changes, reinvestment assumptions and the limits of a simple payback period.

Live reading

Calculator workspace

Enter a current project reading to update this decision signal.

1 — NPV · IRR · Payback

Discounted cash-flow appraisal

The rigorous way to value a project: every future cash flow is discounted back to today because money later is worth less than money now. NPV is the value created in today’s money; IRR is the discount rate at which the project merely breaks even; payback tells you how long capital is at risk. When choosing between projects, pick the higher NPV.

Full analysis

NPV = −Investment + Σ  CFₜ ÷ (1 + r)ᵗ
IRR: the r where NPV = 0
Payback: periods until cumulative cash flow ≥ 0

Parameters

Discount rate (%)
Cost of capital or required return per period — the hurdle the project must beat.
e.g. 10
Initial investment
Cash out at period 0, entered as a positive number.
e.g. 1000
Cash flows (comma-separated)
Net cash in (or out, negative) for each following period, in order: period 1, 2, 3…
e.g. 500, 500, 500

Results

Net Present Value
Value created in today’s money after paying back capital and the required return.
Internal Rate of Return
The project’s intrinsic return per period. Compare it to the discount rate. Reliable only for conventional flows — one outlay followed by inflows. If the signs change more than once, IRR can have several answers or none, and NPV is the measure to trust.
Benefit–Cost Ratio
Present value of the future net cash flows per unit invested — net, so a negative period nets off rather than counting as a benefit. Above 1 means benefits outweigh costs.
Payback period
Periods until the undiscounted cash recovers the investment — a measure of capital risk, not profitability.

Charts

Cumulative cash flow
Discounted against undiscounted — where the project actually breaks even.

What nPV · IRR · Payback actually answers

+

NPV, IRR, and payback answer different questions about an investment.

Start with a clean definition. State the unit, time window, and whether each figure is planned, actual, or forecast. A result can be mathematically correct and still be operationally wrong when a team mixes calendar days with working days, approved budget with total cost, or a current snapshot with a period-to-date value. The calculator is transparent: change an input and watch the output move, then explain why it moved.

For a worked reading, enter the example values above and write down the intermediate meaning before interpreting the verdict. First identify the baseline. Next identify the observed performance, probability, or variation. Then calculate the derived measure. Finally ask whether the direction and size of the result justify an action. This order keeps arithmetic from becoming a substitute for project judgment.

Use the result as a signal in a control loop. If the reading is favorable, confirm that scope and quality have not been reduced to create a better number. If it is unfavorable, investigate the cause before prescribing a generic recovery action. A late schedule may reflect changed scope, a poor dependency, or a bad estimate. A risk score may reflect disagreement about scales rather than a change in exposure.

Uncertainty deserves an explicit sentence. Forecasts are conditional on their assumptions, and rankings are relative to the set of items being compared. Add a range where inputs are estimates, show sensitivity where one assumption dominates, and agree what evidence will cause the team to revise the reading. This makes the page useful for governance rather than just for producing a polished percentage.

Common mistakes are classification mistakes. People use a ratio as a percentage, add probabilities that belong to different branches, treat a reserve as a forecast, or compare values calculated with different boundaries. Another frequent error is false precision: reporting several decimal places when inputs were rough workshop estimates. Round for the audience, but keep the full browser calculation for traceability.

On a real project, pair the result with an owner and a next action. A metric without a response path is decoration. Decide who validates the inputs, who discusses the implication, and when the number is checked again. If the result crosses a threshold, define escalation before pressure arrives. If it remains stable, say what stable means and how long that conclusion may stand.

For exams and formal methods, use the stated formula and assumptions. For practice, add context the question leaves out: baseline changes, data quality, dependencies, stakeholder tolerance, and the cost of waiting. The best professional answer can be more cautious than the best multiple-choice answer. That is not indecision; it is disciplined interpretation.

Keep a small decision record with input values, date, source, result, interpretation, and action. When the project changes, do not overwrite history. Compare the new reading with the old one and explain the movement. This turns a one-time calculation into evidence about the system and gives a future project manager enough context to learn from the forecast instead of repeating its assumptions.

For a worked reading, enter the example values above and write down the intermediate meaning before interpreting the verdict. First identify the baseline. Next identify the observed performance, probability, or variation. Then calculate the derived measure. Finally ask whether the direction and size of the result justify an action. This order keeps arithmetic from becoming a substitute for project judgment.

For a worked reading, enter the example values above and write down the intermediate meaning before interpreting the verdict. First identify the baseline. Next identify the observed performance, probability, or variation. Then calculate the derived measure. Finally ask whether the direction and size of the result justify an action. This order keeps arithmetic from becoming a substitute for project judgment.

For a worked reading, enter the example values above and write down the intermediate meaning before interpreting the verdict. First identify the baseline. Next identify the observed performance, probability, or variation. Then calculate the derived measure. Finally ask whether the direction and size of the result justify an action. This order keeps arithmetic from becoming a substitute for project judgment.

For a worked reading, enter the example values above and write down the intermediate meaning before interpreting the verdict. First identify the baseline. Next identify the observed performance, probability, or variation. Then calculate the derived measure. Finally ask whether the direction and size of the result justify an action. This order keeps arithmetic from becoming a substitute for project judgment.

For a worked reading, enter the example values above and write down the intermediate meaning before interpreting the verdict. First identify the baseline. Next identify the observed performance, probability, or variation. Then calculate the derived measure. Finally ask whether the direction and size of the result justify an action. This order keeps arithmetic from becoming a substitute for project judgment.

For a worked reading, enter the example values above and write down the intermediate meaning before interpreting the verdict. First identify the baseline. Next identify the observed performance, probability, or variation. Then calculate the derived measure. Finally ask whether the direction and size of the result justify an action. This order keeps arithmetic from becoming a substitute for project judgment.

For a worked reading, enter the example values above and write down the intermediate meaning before interpreting the verdict. First identify the baseline. Next identify the observed performance, probability, or variation. Then calculate the derived measure. Finally ask whether the direction and size of the result justify an action. This order keeps arithmetic from becoming a substitute for project judgment.

For a worked reading, enter the example values above and write down the intermediate meaning before interpreting the verdict. First identify the baseline. Next identify the observed performance, probability, or variation. Then calculate the derived measure. Finally ask whether the direction and size of the result justify an action. This order keeps arithmetic from becoming a substitute for project judgment.

For a worked reading, enter the example values above and write down the intermediate meaning before interpreting the verdict. First identify the baseline. Next identify the observed performance, probability, or variation. Then calculate the derived measure. Finally ask whether the direction and size of the result justify an action. This order keeps arithmetic from becoming a substitute for project judgment.

For a worked reading, enter the example values above and write down the intermediate meaning before interpreting the verdict. First identify the baseline. Next identify the observed performance, probability, or variation. Then calculate the derived measure. Finally ask whether the direction and size of the result justify an action. This order keeps arithmetic from becoming a substitute for project judgment.

Worked through end to end

Enter the example values shown in the instrument, note the baseline, and read each output in the unit displayed. The point is to make the calculation reproducible, not to imply that one example predicts every project.

Step 1

Validate the inputs, read the derived result, and record the action it supports.

How to read the result

Interpret the verdict alongside scope, data quality, dependencies, and the date of the reading. The metric stops being useful when those boundaries are hidden or when a team treats a signal as a guarantee.

Mistakes that survive into real reporting

The most damaging mistakes are mixed units, stale baselines, false precision, and decisions made without an owner or review date. Keep the inputs and assumptions visible.

On the exam and on a real project

Use the formal method for a consistent answer, then add practitioner context: assumptions, uncertainty, stakeholder tolerance, and the cost of waiting.