Intermediate Contact Pricing (CON 204) NPV Analysis Template
A template to calculate NPV for up to 36 years.
Data is entered in the blue shaded areas.
9
ENTER ANNUAL RATE AS A PERCENTAGE: -------->.0000%
CALCULATED NET PRESENT VALUE $64
ENTER CASH FLOWS BELOW: PV Discounted
YR Reason for Cash Flow Inflow Outflow Factor Cash Flows
0 10 $0 $2,800 1.0000 ($2,800)
1 Energy Savings $400 $0 0.9174 $367
2 Energy Savings $400 $0 0.8417 $337
3 Energy Savings $400 $0 0.7722 $309
4 Energy Savings $400 $0 0.7084 $283
5 Energy Savings $400 $0 0.6499 $260
6 Energy Savings $400 $0 0.5963 $239
7 Energy Savings $400 $0 0.5470 $219
8 Energy Savings $400 $0 0.5019 $201
9 Energy Savings $400 $0 0.4604 $184
10 Energy Savings $400 $0 0.4224 $169
11 Energy Savings $400 $0 0.3875 $155
12 Energy Savings $400 $0 0.3555 $142
13 CASH FLOW TYPE? $0 $0
14 CASH FLOW TYPE? $0 $0
15 CASH FLOW TYPE? $0 $0
16 CASH FLOW TYPE? $0 $0
17 CASH FLOW TYPE? $0 $0
18 CASH FLOW TYPE? $0 $0
19 CASH FLOW TYPE? $0 $0
20 CASH FLOW TYPE? $0 $0
21 CASH FLOW TYPE? $0 $0
22 CASH FLOW TYPE? $0 $0
23 CASH FLOW TYPE? $0 $0
24 CASH FLOW TYPE? $0 $0
25 CASH FLOW TYPE? $0 $0
26 CASH FLOW TYPE? $0 $0
27 CASH FLOW TYPE? $0 $0
28 CASH FLOW TYPE? $0 $0
29 CASH FLOW TYPE? $0 $0
30 CASH FLOW TYPE? $0 $0
31 CASH FLOW TYPE? $0 $0
32 CASH FLOW TYPE? $0 $0
33 CASH FLOW TYPE? $0 $0
34 CASH FLOW TYPE? $0 $0
35 CASH FLOW TYPE? $0 $0
36 CASH FLOW TYPE? $0 $0
1
TOTAL NET PRESENT VALUE $64
2
Discounted
Cash Flows
3