ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Pool and pump factors
Chlorine demand
Baseline: chlorinating liquid source and volume
3
Pool volume
20,420gallons
Peak period FC per day
4.00ppm FCStrength10.00%
FC per jug (lbs)
0.95
4
Normal summer pump run time
14hours
Peak period duration
4.0months
Price per jug
$5.38
FC per year (lbs)
109
5
Normal summer pump wattage
135watts
Annual average FC per day
1.75ppm FC
Ounces per jug
128
Jugs per year
114
6
Other liquid cost factors
2
minutes per jug to buy and pour liquid
$0
per hour value
driving8.2
miles per jug
$0.15per mile
7
8
9
Salt Water Chlorine Generator
Electricity per kWh
$0.100
10
10.00%liquidcompared withSelf
Universal 40
ModelUniversal 4040,000size rating
Salt cost per 40 lbs
$7.58
11
$6.93per lb$2.24per lbBrandSelf2.00lbs/day
Acid, $ / SWG-hr
$0.015
12
SWCG salt level
3,500ppm
CYA cost per lb
$5.00
13
14
Timer and/or installation
$0
Annual splashout/backwash
5%
15
Salt already in pool (ppm)
800
SWC reduction of FC demand
40%
16
17
De-rate or up-rate from manufacturer's output rating
0%
18
19
Enter your values in the white boxes
Allow for a future repair, costing
$150
20
occurring during year
12
21
22
Cell replacement years
1121314152
23
24
Extra pump run time for SWCG to keep up during peak period
0.0hrs/day
25
26
27
SWCG chlorine costSelf
Universal 40
28
Annual repair allowance
$8
Annual out-of-pocket costs
29
Power supply and cell$1,178$2.61
per lb FC
Electricity
$25
30
Timer and installation$0
Annual cell wear
$63
(if abandoned after one cell is used up)
Annual salt & CYA replacement
$7
31
Salt and CYA$117
Cell life (years)
10.2
Extra acid per year
$12
32
Initial cost$1,295
Cell replacement
$643$2.24
per lb FC
Extra pump run time
$0
33
(if abandoned after two cells are used up)
Total$51
34
35
Chlorinating liquid10.00%$5.38per128
ounce jug
36
37
Buy
Handling
Travel
Total cost
38
114jugs2
minutes per jug
8
miles per jug
39
109lbs FC$0per hour$0.15per mile
40
$616per year$0per year$138per year$753per year
41
$5.67
per lb of FC
$0.00
per lb of FC
$1.27per lb$6.93
per lb FC
42
43
44
45
Define your own SWCGs hereChoose one of these in drop down list abovegrams per hourlbs per 24 hoursSalt level (ppm)Size rating (gallons)Lifespan (hrs)PriceReplace-ment cell costlbs per 24 hours
46
Universal 40
Universal 40
23,50040,00010,000$1,178$6432.00
47
RJ 45+RJ 45+2.003,50045,00015,000$1,638$7512.00
48
RJ 60+RJ 60+3.103,50060,00015,000$1,855$8603.10
49
ignores 'g/hr' whenperperper
50
'lbs/day' is enteredman'f'rman'f'rman'f'r
51
52
53
54
55
56
57
58
Cumulative sanitizer cost (cash flow for chart above)
59
Year1234567891011121314151617181920
60
Calendar year20222023202420252026202720282029203020312032203320342035203620372038203920402041
61
Liquid$753$1,506$2,259$3,013$3,766$4,519$5,272$6,025$6,778$7,532$8,285$9,038$9,791$10,544$11,297$12,051$12,804$13,557$14,310$15,063
62
SWCG startup$1,295
63
SWCG cell replacement
$0$0$0$0$0$0$0$0$0$0$643$0$0$0$0$0$0$0$0$0
64
Repair allowance$0$0$0$0$0$0$0$0$0$0$0$150$0$0$0$0$0$0$0$0
65
SWCG other costs$44$44$44$44$44$44$44$44$44$44$44$44$44$44$44$44$44$44$44$44
66
SWCG$1,338$1,382$1,426$1,469$1,513$1,557$1,600$1,644$1,687$1,731$2,418$2,611$2,655$2,699$2,742$2,786$2,830$2,873$2,917$2,960
67
68
Switch cash flow-$585$710$710$710$710$710$710$710$710$710$67$560$710$710$710$710$710$710$710$710
69
Discount rate6%
what capital is worth to you, per year
70
Net present value$6,503
once installed your total capital value, including this investment, is expected to change by this amount based on the forecast
71
Internal rate of return121%
the switch creates or destroys capital at this annual rate
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100