Evaluate a periodic project without discounting time zero
Your goal: Separate an initial cost, unequal end-period receipts and the yield that makes the complete schedule balance.
Full 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.
Signed initial cost and uneven end-period receiptsPlace the initial cost at time zero
A/B holds the timeline and signed flows. D/E holds the labelled rate controls. Keep physical zero-flow periods. Calculated results appear after your formulas pass.Scroll the worksheet horizontally to inspect later source columns.
| # | ||||
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 |
Step 1 of 4
Place the initial cost at time zero
Rules for this step
Select the first period and its signed cash flow. This cost occurs now, before the equally spaced end-period receipts.