Calculate net present value (NPV) and IRR from cash flows and a discount rate
Inputs
$
Upfront cost or capital outlay (entered as positive, treated as outflow)
%
Annual rate used to discount future cash flows (e.g. cost of capital)
Y1
$
Y2
$
Y3
$
Y4
$
Results
Net Present Value
$18,386.72
Investment is profitable at this rate
Internal Rate of Return (IRR)
Rate at which NPV = 0
Initial Investment-$100,000.00
Total undiscounted cash flows$150,000.00
Total discounted present value$118,386.72
Discounted Cash Flow Table
| Period | Cash Flow | Present Value |
|---|---|---|
| Now | -$100,000.00 | -$100,000.00 |
| Y1 | $30,000.00 | $27,272.73 |
| Y2 | $40,000.00 | $33,057.85 |
| Y3 | $50,000.00 | $37,565.74 |
| Y4 | $30,000.00 | $20,490.40 |
| NPV | $50,000.00 | $18,386.72 |