Explain a modified return with finance and reinvestment rates
Enter separate formulas in E6:E8. Eight signed numeric flows B2:B9 occur at fixed periods 0 through 7 in A2:A9. E2 is the finance rate per period; E3 is the reinvestment rate per period. E6 is the unrounded MIRR over seven intervals. E7 is the positive magnitude of all negative flows discounted to period zero at E2. E8 is all positive flows compounded to period seven at E3. Numeric zero rows, including a terminal zero, still count as periods.
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:E8. Eight signed numeric flows B2:B9 occur at fixed periods 0 through 7 in A2:A9. E2 is the finance rate per period; E3 is the reinvestment rate per period. E6 is the unrounded MIRR over seven intervals. E7 is the positive magnitude of all negative flows discounted to period zero at E2. E8 is all positive flows compounded to period seven at E3. Numeric zero rows, including a terminal zero, still count as periods.
No account. No upload. Just try it.