Evaluate a periodic project without discounting time zero
Enter separate formulas in E6 and E7. B2 is the signed cost at time zero; B3:B9 are seven equally spaced end-period flows, including numeric zero periods. E2 is the discount per period. E6 is the project NPV at time zero. E7 is the unrounded IRR per period of the complete B2:B9 schedule. Retain signs and numeric zero periods; do not discount the initial cost or annualize an unspecified period.
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. B2 is the signed cost at time zero; B3:B9 are seven equally spaced end-period flows, including numeric zero periods. E2 is the discount per period. E6 is the project NPV at time zero. E7 is the unrounded IRR per period of the complete B2:B9 schedule. Retain signs and numeric zero periods; do not discount the initial cost or annualize an unspecified period.
No account. No upload. Just try it.