NPV Model Parameters
B2
Discount Rate
10%
B3
Annual Cash Flow
$3,500
B4
Initial Cost
$14,000
B5
Duration (Yrs)
5
B6
Base NPV
$12,718
10
$=B6$
$10,000
$12,000
$14,000
$16,000
$18,000
11
8%
$14,256
$12,256
$10,256
$8,256
$6,256
12
9%
$13,468
$11,468
$9,468
$7,468
$5,468
13
10%
$12,718
$10,718
$8,718
$6,718
$4,718
14
11%
$12,004
$10,004
$8,004
$6,004
$4,004
15
12%
$11,324
$9,324
$7,324
$5,324
$3,324
Data Table
✕
$B$2
⊞