Projectitude

How to Calculate NPV and IRR for a Finance Assignment (2026 Guide)

To calculate NPV, discount each year's cash flow back to today using your required rate of return, sum them, and subtract the initial investment — a positive result means the project adds value. To calculate IRR, find the discount rate that makes NPV equal zero — usually by trial and interpolation. The technique most students get wrong is not the maths; it is knowing which result to trust when NPV and IRR disagree.
Discount
Core Concept
NPV > 0
Accept Rule
IRR > r
Accept Rule
NPV
Wins Conflicts

NPV and IRR are the two investment appraisal techniques that show up in almost every finance assignment, and they are the two students most often get marked down on. Not because the formulas are difficult — they are not — but because the question is rarely just "calculate the NPV". It is "calculate, interpret, and recommend", and the recommendation is where things unravel, especially when NPV and IRR point in different directions.

This guide takes you through both calculations on the same project, side by side, with full working. It shows you the rules markers expect you to apply, what to do when the two techniques disagree (which they sometimes will), and the interpretation moves that separate a competent answer from a top one.

What NPV and IRR Actually Measure

NPV and IRR both belong to the family of discounted cash flow techniques. They both recognise the time value of money — that £1 received in three years is worth less than £1 today — but they answer slightly different questions.

  • Net Present Value (NPV) tells you, in today's money, how much value a project adds. A positive NPV means the project's discounted cash inflows exceed the initial outflow at your required rate of return. A negative NPV means it destroys value.
  • Internal Rate of Return (IRR) tells you the return rate at which the project breaks even — the discount rate at which NPV equals zero. You compare IRR against your cost of capital: if IRR is higher, the project clears the hurdle.

Most assignments expect both. The combination is powerful: NPV tells you how much value the project creates, IRR tells you how strong the percentage return is. Together they give a fuller answer than either alone — which is why understanding both, and the difference between them, is essential.

Where the discount rate comes from: The rate you discount at is the company's required rate of return, usually its Weighted Average Cost of Capital (WACC). If the brief gives you a "cost of capital" or "required return", use it directly. If it asks you to derive it, that is a separate calculation — see our WACC guide linked below.

How to Calculate NPV — Step by Step

The NPV formula looks intimidating in textbook form but is straightforward in practice:

📐 NPV Formula
NPV = Σ [CFt ÷ (1 + r)t] − Initial Investment

Where: CFt = cash flow in year t · r = discount rate · t = year number

In plain English: for each year of the project, take that year's cash flow, divide it by (1 + the discount rate) raised to the power of the year number, sum all those discounted figures, and subtract the initial investment.

In an assignment, the cleanest way to show this is in a table — markers can follow the working at a glance, and you can pull each line into a discount factor column rather than rebuilding the exponent for every year.

A Worked Example — NPV and IRR Side by Side

Consider Project Aurora, a four-year capital investment. The figures below are constructed for demonstration; the method is identical to what you would apply to real assignment data.

Project Aurora — Cash Flows (£000s)
Initial investment (Year 0): −500
Year 1 cash flow: +180
Year 2 cash flow: +200
Year 3 cash flow: +220
Year 4 cash flow: +150
Discount rate (cost of capital): 10%

Step 1 — Calculate NPV at 10%

Year Cash Flow (£000s) Discount Factor (10%) Present Value (£000s)
0−5001.000−500.00
1+1800.909+163.64
2+2000.826+165.29
3+2200.751+165.29
4+1500.683+102.45
NPV+96.66

Discount factors come from 1 ÷ (1 + r)t. For example, Year 3 at 10%: 1 ÷ (1.10)3 = 1 ÷ 1.331 = 0.751. Multiply each year's cash flow by its factor to get present value, sum the column, and you have NPV.

✅ NPV Result & Interpretation

NPV = +£96,660. A positive NPV at the 10% cost of capital means Project Aurora creates value of £96,660 in today's money over and above the required return. The decision rule says accept the project.

Step 2 — Calculate IRR by Interpolation

IRR is the discount rate at which NPV equals zero. There is no clean algebraic shortcut for a multi-year project, so the standard assignment method is linear interpolation: find one rate that gives a positive NPV and another that gives a negative NPV, then interpolate between them.

We already know NPV at 10% is +£96.66 (thousand). Try a higher rate — say 20% — which should pull NPV below zero:

Year Cash Flow (£000s) Discount Factor (20%) Present Value (£000s)
0−5001.000−500.00
1+1800.833+150.00
2+2000.694+138.89
3+2200.579+127.31
4+1500.482+72.34
NPV at 20%−11.46

NPV has crossed zero between 10% and 20%, so IRR lies in that range. Apply the interpolation formula:

📐 IRR by Interpolation
IRR ≈ rL + [ NPVL ÷ (NPVL − NPVH) ] × (rH − rL)

Substitution: 10% + [ 96.66 ÷ (96.66 − (−11.46)) ] × (20% − 10%)
= 10% + (96.66 ÷ 108.12) × 10%
Result: ≈ 18.94%

Interpretation: Project Aurora's IRR of approximately 18.94% is well above the 10% cost of capital. The decision rule says accept. Both techniques agree.

Note on accuracy: Interpolation gives an approximation, not an exact answer. The closer your two trial rates are to the true IRR, the more accurate the estimate. A spreadsheet's IRR function gives the precise figure (in this case approximately 18.77%), but interpolation is the standard method markers expect in a written assignment — show the working.

Decision Rules and Why NPV Wins Conflicts

In a finance assignment, the decision rules are straightforward:

  • NPV rule: Accept the project if NPV > 0; reject if NPV < 0.
  • IRR rule: Accept the project if IRR > cost of capital; reject if IRR < cost of capital.

Most of the time both rules give the same answer — as they did for Project Aurora. But for mutually exclusive projects (where you must pick one of several), or for projects with unusual cash flow patterns, they can disagree. When NPV and IRR conflict, NPV is the preferred decision criterion in finance theory.

Three reasons your assignment should give for preferring NPV:

  • NPV measures absolute value added — a project with a smaller percentage return but a much larger NPV creates more wealth than a smaller, higher-IRR project.
  • NPV uses a more realistic reinvestment assumption — it assumes intermediate cash flows are reinvested at the cost of capital, while IRR implicitly assumes reinvestment at the project's own IRR, which is often unrealistic.
  • IRR can give multiple results for projects with non-conventional cash flows (sign changes during the project), or no result at all. NPV does not have this problem.

Stuck on the discounting, the interpolation, or the recommendation?

Our finance specialists run the full NPV and IRR analysis, interpret the results, and write the recommendation — to your university's marking criteria and your deadline.

Get Expert Help →

2:2 vs First: The Recommendation Paragraph

After the calculations, almost every NPV/IRR assignment asks for a recommendation. The gap between a 2:2 and a First sits in that paragraph — same numbers, very different analytical work.

🔴 2:2 Level
"The project has an NPV of £96,660 and an IRR of 18.94%. Both are positive, so the project should be accepted. This is a good investment for the company."
Applies the rule mechanically. No reference to risk, sensitivity, or non-financial factors. Conclusion asserted, not argued.
🟢 First Class Level
"Project Aurora generates positive NPV of £96,660 and an IRR of 18.94%, comfortably above the 10% cost of capital — on financial grounds, acceptance is justified. The recommendation should, however, be qualified: the result is sensitive to assumptions about Year 3 and 4 cash flows, which carry the most forecasting uncertainty. A sensitivity analysis on the discount rate and terminal cash flows would strengthen the case before final commitment.
Applies the rule, then qualifies with sensitivity and forecasting risk. Demonstrates critical judgement.

The first-class version is not adding decoration. It is doing the analytical work the technique itself does not do — recognising that NPV and IRR rest on forecast cash flows that may be wrong, and that a sensitivity check belongs alongside the headline number. That habit of qualification is rewarded in every finance rubric.

Five Mistakes That Cost Students Marks

Forgetting the initial investment is at Year 0. Some students discount the initial outflow as if it occurred in Year 1, which understates costs and inflates NPV.Fix: The initial investment uses a discount factor of 1.000 (it is already in today's money). Treat any outflow stated as Year 0 the same way.

Calculating discount factors wrong. The most common slip is using 1 + rt instead of (1 + r)t. They look similar; they are very different.Fix: Always use (1 + r)t — compound, not simple. Year 3 at 10% is 1 ÷ 1.331, not 1 ÷ 1.30.

Choosing trial rates too close together for IRR. If both trial rates give positive NPVs, interpolation gives a meaningless result.Fix: Pick one rate that produces a positive NPV and another that produces a negative NPV. Interpolation only works across the zero line.

Choosing IRR over NPV in a conflict without justifying it. When the two techniques disagree, finance theory says NPV wins — and your assignment should say so.Fix: If NPV and IRR conflict, state which one you are following and give the reinvestment-assumption / absolute-value reason.

Ignoring forecast risk in the recommendation. Both techniques are only as good as the cash flow forecasts that feed them, and strong assignments acknowledge that.Fix: Add a sensitivity comment to your recommendation — what happens if the discount rate is 2% higher, or if Year 3–4 cash flows are 20% lower?

Frequently Asked Questions

What is the difference between NPV and IRR?
NPV measures the absolute monetary value a project adds in today's money, while IRR measures the percentage return at which the project breaks even. NPV uses your chosen discount rate as an input; IRR solves for the discount rate as an output. They usually agree on accept/reject decisions, but for mutually exclusive projects or unusual cash flow patterns they can disagree — in which case NPV is the preferred criterion.
What discount rate should I use for NPV?
Use the company's required rate of return, which is most commonly its Weighted Average Cost of Capital (WACC). If the brief gives you a "cost of capital" or "required rate", use that figure directly. If the brief asks you to derive it, you will need to calculate WACC separately before discounting. In some assignments a risk-adjusted rate is used to reflect higher uncertainty in a specific project — apply whatever the brief specifies.
How do I calculate IRR without a spreadsheet?
Use linear interpolation. Calculate NPV at two trial discount rates — one that gives a positive NPV and one that gives a negative NPV. Then apply: IRR ≈ rL + [NPVL ÷ (NPVL − NPVH)] × (rH − rL). The closer your trial rates straddle the true IRR, the more accurate your estimate. Show both trial NPV calculations in full — markers reward visible method, not just the final percentage.
What does it mean if NPV is positive but IRR is below the cost of capital?
If you have calculated correctly with conventional cash flows (one initial outflow followed by positive inflows), this should not happen — a positive NPV at the cost of capital means IRR is above it. If you are seeing this combination, double-check your discount factors and your IRR interpolation. The only legitimate cases involve unconventional cash flows with multiple sign changes, where IRR may have multiple solutions or no real solution at all. In that case, rely on NPV.
When NPV and IRR conflict, which should I recommend?
NPV. Finance theory prefers NPV in conflict cases for three reasons: it measures the absolute value added rather than a percentage, so a larger project with a lower IRR but higher NPV creates more wealth; it assumes intermediate cash flows are reinvested at the cost of capital, which is more realistic than IRR's assumption of reinvestment at the project's own IRR; and unlike IRR, it does not produce multiple or undefined results for unconventional cash flows. State this reasoning in your assignment — do not just pick one.
My deadline is close — what should I prioritise on an NPV and IRR question?
Get the cash flow table and discount factors right first — every other number depends on them. Then calculate NPV (the easier of the two), then IRR by interpolation. Show every formula and substitution so you earn method marks even if a final figure is slightly off. Save time for the recommendation paragraph — it carries more weight than students think, especially the sensitivity comment. If the deadline is unworkable, our finance writers can deliver a complete worked appraisal with recommendation to your deadline. Get expert help here.

Need Your NPV and IRR Analysis Done Right?

Our expert writers deliver fully worked investment appraisals — accurate calculations, clear interpretation, and the qualified recommendation that wins marks — written to your university's marking criteria and your exact deadline.

Get Expert Help Today →

Please fill this data