XIRR practice

XIRR returns the internal rate of return of cash flows on specific dates. Below are the 2 financial modeling exercises on Modeldrill that use it, each checked instantly in your browser.

Syntax

XIRR(cash_flows, dates, [guess])

What people get wrong

Use it when the flows are not evenly spaced; IRR assumes equal intervals.

financial modeling exercises that use XIRR

• Dated cash flows with XNPV and XIRRLevel 4Pro
• Return on an investment with irregular datesLevel 4Pro

Often used together with: SUM, SUMIF, XNPV