Evaluate dated cash flows using actual day intervals
Enter separate formulas in E6 and E7 using all aligned pairs A2:B9, including the initial negative flow at the earliest date A2. E2 is an annual effective discount expressed per 365 days. E6 is the dated present value at A2; E7 is the unrounded XIRR per 365 days. Discount each flow by its actual whole-day difference from A2 divided by 365. Use XNPV for nonnegative discount rates; for negative discount rates the pinned browser engine requires explicit per-flow discounting with SUMPRODUCT. Keep duplicate-date receipts and reorder later rows only as complete date-value pairs.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Enter separate formulas in E6 and E7 using all aligned pairs A2:B9, including the initial negative flow at the earliest date A2. E2 is an annual effective discount expressed per 365 days. E6 is the dated present value at A2; E7 is the unrounded XIRR per 365 days. Discount each flow by its actual whole-day difference from A2 divided by 365. Use XNPV for nonnegative discount rates; for negative discount rates the pinned browser engine requires explicit per-flow discounting with SUMPRODUCT. Keep duplicate-date receipts and reorder later rows only as complete date-value pairs.
No account. No upload. Just try it.