Exercises / Finance and business maths · 12 of 14
Return on investments made on irregular dates
IRR assumes the cash flows are exactly one period apart. Real investments are not. XIRR(values, dates) uses the actual dates and returns an annual rate.
Your taskIn E2, use XIRR to work out the annual return of the cash flows in B2:B7, which happened on the dates in A2:A7.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Date | Cash flow | Measure | Value | |
| 2 | 15 Jan 2025 | -$10,000.00 | XIRR | ||
| 3 | 2 Apr 2025 | -$2,500.00 | |||
| 4 | 30 Sep 2025 | $1,200.00 | |||
| 5 | 14 Feb 2026 | -$1,500.00 | |||
| 6 | 30 Jun 2026 | $1,800.00 | |||
| 7 | 1 Nov 2026 | $14,500.00 |