Excel practice · Finance Functions

XNPV & XIRR practice exercises

5 graded problems with realistic data, all medium.

NPV and IRR's versions for cash flows that don't arrive on neat, evenly-spaced periods: each one paired with its own actual date. The 5 exercises below come from LearnExcel's practice library. Each one gives you a realistic table, a cell to fill, and a hint if you get stuck. Read them here, then solve them in the interactive grid, where your formula is checked the moment you press Enter.

New to the function? Read the XNPV & XIRR guide first: syntax, a worked example and the mistakes people make.

In this set

  1. Find the present value of cash flows on irregular dates
  2. Compare present value when a payment arrives earlier
  3. Value a schedule of roughly-quarterly but uneven payments
  4. Find the annualized return on a startup investment
  5. Find the annualized return on a property flip

The exercises

1. Find the present value of cash flows on irregular dates Medium

An investment pays out on the irregular dates below, not evenly spaced months or years apart. Find its net present value at a 9% annual discount rate.

AB
1DateCash flow
22026-01-01-5000
32026-05-151800
42026-11-022200
52027-08-202600
6Rate0.09
7XNPV?

Enter a formula in B7.

Show a hint

XNPV(rate, values, dates) discounts each cash flow by the actual number of days since the first date, not by assuming even periods: =XNPV(B6,B2:B5,A2:A5).

Plain NPV assumes every cash flow is exactly one period apart. The moment payments land on real, unevenly spaced calendar dates, XNPV is the correct tool, not NPV.

2. Compare present value when a payment arrives earlier Medium

Same total cash flows as a typical deal, but this buyer's second payment arrives earlier than usual. Find the deal's XNPV at a 7% discount rate to see how that timing affects it.

AB
1DateCash flow
22026-02-01-12000
32026-04-016000
42026-09-017500
5Rate0.07
6?

Enter a formula in A6.

Show a hint

Same formula shape as any other XNPV: =XNPV(B5,B2:B4,A2:A4).

Because XNPV discounts by actual days, moving a payment even a few weeks earlier or later changes the result; timing is not just a detail, it is part of the valuation.

3. Value a schedule of roughly-quarterly but uneven payments Medium

A royalty deal pays out four times over about a year, but not on exactly even quarter dates. Find its XNPV at a 6% discount rate.

AB
1DateCash flow
22026-01-10-20000
32026-04-225200
42026-07-305600
52026-10-055100
62027-01-185400
7Rate0.06
8XNPV?

Enter a formula in B8.

Show a hint

The dates do not need to be evenly spaced at all for XNPV to work: =XNPV(B7,B2:B6,A2:A6).

Royalties, milestone payments, and most real-world deals rarely land on clean quarterly dates: XNPV is built for exactly this kind of irregular schedule.

4. Find the annualized return on a startup investment Medium

An investor put money into a startup and received two distributions on the irregular dates below. Find the investment's annualized return (XIRR).

AB
1DateCash flow
22024-06-01-50000
32025-09-1520000
42026-10-0148000
5XIRR?

Enter a formula in B5.

Show a hint

XIRR(values, dates) finds the annualized rate that makes the XNPV of these exact dates equal zero: =XIRR(B2:B4,A2:A4).

IRR assumes evenly spaced periods; XIRR is the version built for real investments, where money goes in and comes back out on whatever dates actually happen.

5. Find the annualized return on a property flip Medium

An investor bought a property, spent money on renovations in two phases, then sold it on the dates below. Find the annualized return on the whole deal.

AB
1DateCash flow
22026-01-15-180000
32026-03-20-25000
42026-06-01-5000
52026-11-10245000
6XIRR?

Enter a formula in B6.

Show a hint

Every cash flow counts, including both renovation-spend dates, each on its own real date: =XIRR(B2:B5,A2:A5).

A flip's return depends on exactly when money went out and came back, not just the totals; XIRR is the tool real estate investors actually use to compare deals like this.

Solve these in a real grid

Type your formula, get graded instantly. Your first 10 exercises are free, no signup.

Start the XNPV & XIRR exercises →

More finance functions practice

All Excel practice exercises · Excel test prep