|
PW Fleet Services -
<br /> Leasing vs. Owning Cash Flow Analysis
<br /> September 9, 2002
<br /> Option 1: Status Quo
<br /> Own All Fire Equi ment; replacing with same s ecialized equipment at end of life
<br /> Period 0 1~ 2 3 4 5 6 7 8 9 10 11 12 13 14 '
<br /> Inflation 0.03 '
<br /> Cash Outflow Expenses : New Purchases FY03 FY04 FY05 FY06 FY07 FY08 FY09 FY10 FY11 FY12 FY13 FY14 FY15 FY16 FY17
<br /> PUMPER - 750 GALLON ES $ 492,300
<br /> PUMPER-750 GALLON E6 $ 492,300
<br /> PUMPER 4WD E3 $ 531,700
<br /> PUMPER 4WD E1D $ 484,900 ~ '
<br /> PUMPER-4X4 ES $ 640,200
<br /> PUMPER E2 $ 640,200 ~
<br /> PUMPER-TRIPLE COMBO-DASH 2000 E7 $ 220,000 $1,022,200
<br />
<br /> TANKTRUCK-WATERTENDER-1250GALLON BR3
<br /> ELLIPTICALTANKER/PUMPER $ 789,800
<br /> ELLIPTICALTANKER/PUMPER $ 789,800 i '
<br />
<br /> TELESQUIRT-SOOGAL TANK E21 $ 330,000
<br /> TELESQUIRT-SOFT E24 $ 450,000
<br /> TELESQUIRT-SOFT ES $ 450,000
<br />
<br /> TELESQUIRT-SOFT E9 $ 422,000 '
<br /> TELESQUIRT-SOFT •E23 ~ $ 422,000 ~ .
<br /> AERIAL PLATFORM - 95FT' T22 $ 650,000
<br /> AERIAL LADDER -105FT Tl ~ $1,114,100
<br /> AERIAL PLATFORM 100' T2 $1,690,000
<br /> WILDLAND FIRE APPARATUS (E-0NE) 810 $ 448,800
<br /> WILDLAND FIRE APPARATUS (E-0NE) BR5 - $ 448,800
<br /> CRASH/RESCUE TRUCK ~ APl $ 785,000
<br /> CRASH RESCUE TRUCK AP2 ~ $ 817,300 I
<br /> TRUCK-AIR/LIGHTSUPPORT ALLS Ai $ 747,900
<br /> Total Purchases $ 1,115,000 $ 650,000 $ 900,000 $1,064,000 $ 1,114,100 $ - $ 1,024,000 $ 1,302,200 $ 492,300 $ 1,280,400 $ $ $ 2,587,600 $1,022,200
<br /> $ 2,327,500
<br /> Cash Outflow: Maint. Rates ~ FY03 FY04 FY05 FY06 FY07 -FY08 FY09 FY10 FY11 FY12 FY13 FY14 FY15 FY16 FY17
<br /> PUMPER-750 GALLON El $ 16,800 $ 17,304 $ 17,823 $ 18,358 $ 18,909 $ 19,478 $ 20,060 $ 20,662 $ 21,282 $ 21,920 $ 22,578 $ .23,255 $ 23,953
<br /> $ 24,671 $ 25,412
<br /> PUMPER-750 GALLON E6 $ 16,800 $ 17,304 $ 17,823 $ 18,358 $ 18,909 $ 19,476 $ 20,060 $ 20,662 $ 21,282 $ 21,920 $ 22,578 $ 23,255 $ 23,953
<br /> $ 24,671 $ 25,412
<br /> PUMPER 4WD E3 $ 16,800 $ 17,304 $ 17,823 $ 18,358 $ 18,909 $ 19,478 $ 20,060 $ 20,662 $ 21,282 $ 21,920 $ 22,578 $ 23,255 $ 23,953
<br /> $ 24,671 $ 25,412
<br /> PUMPER 4WD E10 $ 16,800 $ 17,304 $ 17,823 $ 18,358 $ 18,909 $ 19,476 $ 20,060 $ 20,662 $ 21,282 $ 21,920 $ 22,578 $ 23,255 $ 23,953
<br /> $ 24,671 $ 25,412
<br /> PUMPER-4X4 ES $ 16,800 $ 17,304 $ 17,823 $ 18,358 $ 18,909 $ 19,476 $ 20,060 $ 20,662 $ 21,282 $ 21,920 $ 22,578 $ 23,255 $ 23,953
<br /> $ 24,671 $ 25,412
<br /> PUMPER E2 $ 18,800 $ 17,304 $ 17,823 $ 16,358 $ 18,909 $ 19,476 $ 20,060 $ 20,662 $ 21,282 $ 21,920 $ 22,578 $ 23,255 $ 23,953
<br />$ 24,671 $ 25,412
<br /> PUMPER-TRIPLE COMBO-DASH 2000 E7 $ 16,800 $ 17,304 $ 17,823 $ 18,358' $ 18,909 $ 19,476 $ 20,060 $ 20,662 $ 21,282 $ 21,920 $ 22,578 $ 23,255
<br /> $ 23,953 $ 24,671 $ 25,412
<br /> TANKTRUCK-WATER TENDER-1250 GALLON BR3 $ 6,072 $ 6,254 $ 6,072 $ 6,072 $ 6,072 $ 8,072 $ 6,072 $ 6,072 $ 6,072 $ 8,072 $ 6,072 $
<br /> 6,072 $ 6,072 $ 6,072 $ 6,072
<br /> ELLiPTICALTANKER/PUMPER $ 8,400 $ 8,652 $ 8,400 $ 8,400 $ 8,400 $ 8,400 $ 8,400 $ 8,400 $ 8,400 $ 8,400 $ 8,400 $ 8,400 $
<br /> 8,400 $ 8,400 $ 8,400 '
<br /> ELLIPTICAL TANKER/PUMPER $ 8,400 $ 8,652 $ 8,400 $ 8,400 $ 8,400 $ 8,400 $ 8,400 $ 8,400 $ 8,400 $ 8,400 $ 8,400 $ 8,400 $
<br /> 8,400 $ 8,400 $ 8,400
<br /> TELESQUIRT-500 GAL TANK E21 $ 16,800 $ 17,304 $ 17,823 $ 18,358 $ 18,909 $ 19,476 $ 20,060 $ 20,662 $ 21,282 $ 21,920 $ 22,578 $ 23,255
<br /> $ 23,953 $ 24,671 $ 25,412 '
<br /> TELESQUIRT-SOFT E24 $ 16,800 $ 17,304 $ 17,823 $ 18,358 $ 18,909 $ 19,476 $ 20,060 $ 20,662 $ 21,282 $ 21,920 $ 22,576 $ 23,255 $ 23,953
<br /> $ 24,671 $ 25,412 I
<br /> TELESQUIRT-SOFT ES $ 16,800 $ 17,304 $ 17,823 $ 18,358 $ 18,909 $ 19,478 $ 20,060 $ 20,662 $ 21,282 $ 21,920 $ 22,578 $ 23,255 $ 23,953
<br /> $ 24,671 $ 25,412
<br /> TELESQUIRT-SOFT' E9 $ 16,800 $ 17,304 $ 17,823 $ 18,358 $ 18,909 $ 19,476 $ 20,060 $ 20,862 $ 21,282 $ 21,920 $ 22,578 $ 23,255 $ 23,953
<br /> $ 24;671 $ 25,412 - ~~i
<br /> TELESQUIRT-SOFT E23 $ 16,800 $ 17,304 $ 17,823 $ 18,356 $ 18,909 $ 19,476 $ 20,060 $ 20,662 $ 21,282 $ 21,920 $ 22,578 $ 23,255 $ 23,953
<br /> $ 24,671 $ 25,412 '
<br /> AERIAL PLATFORM -95Fr T22 $ 24,000 $ 24,720 $ 25,462 $ 26,225 $ 27,012 $ 27,823 $ 28,657 $ 29,517 $ 30,402 $ 31,315 $ 32,254 $ 33,222 $
<br /> 34,218 $ 35,245 $ 36,302 ~
<br /> AERIAL LADDER- 105FT T1 $ 24,000 $ 24,720 $ 25,462 $ 26,225 $ 27,012 $ 27,823 $ 28,657 $ 29,517 $ 30,402 $ 31,315 $ 32,254 $ 33,222 $
<br /> 34,218 $ 35,245 $ 36,302 ~
<br /> AERIAL PLATFORM 100' T2 $ 24,000 $ 24,720 $ 25,462 $ 26,225 $ 27,012 $ 27,823 $ 28,657 $ 29,517 $ 30,402 $ 31,315 $ 32,254 $ 33,222 $
<br /> 34,218 $ 35,245 $ 36,302 ~ i '
<br /> WILDLAND FIRE APPARATUS (E-0NE) 810 $ 6,380 $ 6,551 $ 6,747 $ 8,950 $ 7,158 $ 7,373 $ 7,594 $ 7,822 $ 8,057 $ 8,298 $ 8,547 $
<br /> 8,804 $ 9,068 $ 9,340 $ 9,620
<br /> WILDLAND FIRE APPARATUS (E-0NE) _BRS $ 8,360 $ 6,551 $ 8,747 $ 6,950 $ 7,158 $ ~ 7,373 $ 7,594 $ 7,022 $ 8,057 $ 8,298 $ 8,547
<br /> $ 8,804 $ 9,068 $ 9,340 $ 9,620
<br /> CRASH/RESCUE TRUCK APl $ 12,000 $ 12,360 $ 12,731 $ 13,113 $ 13,506 $ 13,911 $ 14,329 $ 14,758 $ 15,201 $ 15,857 $ 16,127 $ 18,611 $
<br /> 17,109 $ 17,622 $ 18,151 .
<br /> CRASH RESCUE TRUCK AP2 $ 12,000 $ 12,360 $ 12,731 $ 13,113 $ 13,506 $ 13,911 $ 14,329 $ 14,758 $ 15,201 $ 15,657 $ 16,127 $ 16,611 $
<br /> 17,109 $ 17,622 $ 18,151
<br /> TRUCK-AIR/LIGHT SUPPORT ALLS Al $ 5,040 $ 5,191 $ 5,347 $ 5,507 $ 5,673 $ 5,843 $ 6,018 $ 6,199 $ 6,385 $ 6,576 $ 6,773 $
<br /> 6,977 $ 7,188 $ 7,401 $ 7,623
<br /> Total Maint. Rates $ 338,232 $ 348,379 $ 357,437 $ 367,474 $ 377,812 $ 388,461 $ 399,428 $ 410,725 $ 422,361 $ 434,345 $ 446,689 $ 459,404 $ 472,500
<br /> $ 485,989 $ 499,882
<br /> Total Cash OutBow $ 1,453,232 $ 998,379 $1,257,437 $1,431,474 $1,491,912 $ 388,461 $1,423,428 $1,712,925 $ 914,661 $1,714,745 $ 446,689 $ 459,404 $ 3,060,100
<br /> $1,508,189 $ 2,827,382
<br /> Discounted Net Cash Flow $ 1,453,232 $ 969,300 $1,185,255 $1,310,002 $1,325,545 $ 335,090 $1,192,099 $1,392,765 $ 722,042 $1,314,209 $ 332,379 $ 331,883
<br />$ 2,146,293 $1,027,003 $1,869,233
<br /> Total Net Flow $ 16,906,329
<br />
<br />
|