Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
NPV and IRR. NPV(rate, values) discounts cash flows that arrive at the end of periods 1, 2, 3… to today. A cost paid today (period 0) is already in today’s money, so add it outside NPV. IRR(values) takes the whole series, period 0 included, and returns the rate at which the NPV is zero.
=NPV(E1,E3:E6)+E2 a lease buy-out with the deposit in E2
Automated shelving for the West warehouse costs the amount in B3 today (year 0) and saves the amounts in B4:B7 at the end of each of the next four years. Grace Whitfield wants the project’s value at Brightline’s discount rate in B1, and its rate of return.
In B9, calculate the net present value of the project at the rate in B1, rounded to 2 decimals. In B10, calculate the internal rate of return of the cash flows in B3:B7, as a fraction rounded to 4 decimals.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Discount rate | 8.0% | ||||||
| 2 | Year | Cash flow | ||||||
| 3 | 0 | -$24,000 | ||||||
| 4 | 1 | $7,000 | ||||||
| 5 | 2 | $8,000 | ||||||
| 6 | 3 | $9,000 | ||||||
| 7 | 4 | $9,500 | ||||||
| 8 | ||||||||
| 9 | NPV | |||||||
| 10 | IRR | |||||||
| 11 | ||||||||
| 12 | ||||||||
| 13 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe