|
PW Fleet Services I - - ' '
<br /> Leasing vs. Owning Cash Flow Anal sis
<br /> Se temher9,2002 i ~
<br /> I
<br /> Option 2: Owin Standardized Fleet ~ i '
<br /> Own All Fire E ui menl; re lacing um ers with standardized um ers al end of life ~
<br /> Pericd 0 1 2 3 4 5 6' 7 8 9 10 17 12 13 14 i
<br /> In0aQon 0.03 '
<br /> i
<br /> !
<br /> Cash OuNow Ex enses : New Purchases FY03 FY04 FY05 FY06 FY07 FY08 FY09 FY10 FY11 FY12 FY73 FY14 FY15 FY16 FY17
<br /> PUMPER - 750 GALLON El - $ 300,000
<br /> PUMPER - 750 GALLON E6 $ 300,000
<br /> PUMPER 4WD E3 ~ $ 300,000 -
<br /> PUMPER 4WD E10 ~ 300,000 - I
<br /> PUMPER-4X4 ES $ 300,000 -
<br /> PUMPER E2 $ 300,000
<br /> PUMPER-TRIPLE COMBO-DASH 2000 E7 $ 220,000 $ 1,022,200
<br />
<br /> TANK TRUCK-WATER TENDER-1250 GALLON BR3
<br /> ELLIP'RCALTANKER/PUMPER $ 789,800
<br /> ELLIPTICAL TANKER/PUMPER $ 789,800 '
<br />
<br /> TELESQUIRT-SOD GAL TANK E21 $ 330,000
<br />
<br /> TELESQUIRT-SOFT E24 $ 450,000
<br />
<br /> TELESQUIRT-SOFT EB $ 450,000
<br />
<br /> TELESQUIRT-SOFT E9 $ 422,000
<br />
<br /> TELESQUIRT-SOFT E23 $ 422,000
<br />
<br /> AERIAL PLATFORM - 95FT T22 $ 650,000
<br />
<br /> AERIAL LADDER-lOSFT Tl $1,114,100
<br /> AERIAL PLATFORM 100' T2 $ 1,690,000
<br /> WILDLAND FIRE APPARATUS (E-0N 810 $ 448,800
<br /> WILDLAND FIRE APPARATUS E-0NE BRS - $ 448,600
<br /> CRASH/RESCUE TRUCK APl $ 785,000
<br /> CRASH RESCUE TRUCK AP2 $ 817,300
<br />
<br /> TRUCK-AIR/LIGHT SUPPORT AILS Al ~ $ 747,900
<br /> Total Purchases $ 1,115,000 $ 650,000 $ 900,000 $ 1,064,000 $ 7,114,100 $ $ 600,000 $ 1,117,300 $ 300,000 $ 600,000 $ $ $ 2,587,600 $ 1,022,200
<br />$ 2,327,500
<br /> Cash Out0ow. Mainf Rates FY03 FY04 FY05 FY06 FY07 FY06 FY09 FY10 FY71 FY12 FY13 FYt4 FY15 FY16 FY77 '
<br /> PUMPER-750 GALLON El $ 16,800 $ 17,304 $ 17,823 $ 78,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 /> 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 $
<br /> 23,953 $ 24,671 $ 25,412
<br /> PUMPER 4WD E3 $ 16,800 $ 17,304 $ 17,823 $ 18,358 $ 78,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 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 E5 $ 76,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 F2 $ 16,800 $ 17,304 $ 77,823 $ 78,358 $ 78,909 $ 19,478 $ 20,060 $ 20,662 ! $ 27,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 $ 78,909 $ 19,476 $ 20,060 $ 20,662 ! $ 21,282 $ 21,920 $ 22,578 $
<br />23,255 $ 23,953 $ 24,671 $ 25,412 ~ I~,
<br /> TANKTRUCK-WATER TENDER-1250 GALLON BR3 $ 6,072 $ 6,254 $ ~ 6,072 $ 6,072 $ 6,072 $ 6,072 $ 6,Q72 $ 6,072 ! $ 6,072 $ 6,072 $ 6,072 $
<br /> 6,072 $ 6,072 $ 6,072 $ 6,072 ' ! I.
<br /> ELLIPTICAL TANKER/PUMPER $ 8,400 $ 8,652 $ 8,400 $ 6,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 $ 6,400 $
<br /> 8,400 $ 8,400 $ 8,400 '
<br /> TELESQUIRT-500 GAL TANK E21 $ 16,800 $ 17,304 $ 17,823 $ 18,358 $ 16,909 $ 19,478 $ 20,060 $ 20,662 I. $ 21,282 $ 21,920 $ 22,578 $
<br /> 23,255 $ 23,953 $ 24,671 $ 25,412 '
<br />
<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,578 $ 23,255 $
<br /> 23,953 $ 24,671 $ 25,412
<br />
<br /> TELESQUIRT-SOFT E8 $ 16,800 $ 17,304 $ 17,823 $ 18,358 $ 78,909 $ 19,476 $ 20,060 $ 20,662 ~ $ 27,282 $ 21,920 $ 22,578 $ 23,255
<br />$ 23,953 $ 24,671 $ 25,412
<br />
<br /> TELESQUIRT-SOFT E9 $ 16,800 $ 17,304 $ 17,823 $ 18,358 $ 78,909 $ 19,476 $ 20,060 $ 20,662 $ 27,282 $ 21,920 $ 22,578 $ 23,255 $
<br /> 23,953 $ 24,671 $ 25,412 I,
<br />
<br /> TELESQUIRT-SOFT E23 $ 18,800 $ 17,304 $ 17,823 $ 18,356 $ 18,909 $ 19,476 $ 20,060 $ 20,662 i. $ 27,282 $ 21,920 $ 22,578 $ 23,255
<br /> $ 23,953 $ 24,671 $ 25,412 I,
<br />
<br /> AERIAL PLATFORM - 95FT 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 />
<br /> AERIAL LADDER- lOSFI' Tl $ 24,000 $ 24,720 $ 25,462 $ 26,225 $ 27,012 $ 27,823 $ 28,657 $ 29,517 j $ 30,402 $ 31,375 $ 32,254 $ 33,222
<br /> $ 34,278 $ ~ 35,245 $ 36,302
<br />
<br /> AERIAL PLATFORM 100' T2 ~ $ 24,000 $ 24,720 $ 25,462 $ 26,225 $ 27,072 $ 27,823 $ ~ 28,657 $ 29,517 I $ 30,402 $ 31,315 $ 32,254 $ 33,222
<br /> $ 34,218 $ 35,245 $ 36,302 I.
<br /> WILDLAND FIRE APPARATUS EONE 810 $ 6,360 $ 6,551 $ 6,747 $ 6,950 $ 7,158 $ 7,373 $ 7,594 $ 7,822 ~ $ 8,057 $ 8,298 $ 8,547 $ 8,804
<br /> $ 9,068 $ 9,340 $ 9,620
<br />
<br /> WILDLANDFIRE APPARATUS E-ONE) BR5 $ 6,360 $ 6,551 $ 6,747 $ -6,950 $ 7,158 $ 7,373 $ 7,594 $ 7,822'$ 8,057 $ 8,298 $ 8,547 $ 8,804
<br /> $ 9,068 $ 9,340 $ 9,620
<br /> CRASH/RFSCUETRUCK APS $ 12,000 $ 12,360 $ 12,731 $ 13,113 $ 13,506 $ 13,911 $ 14,329 $ 14,758 $ 75,201 $ 15,657 $ 16,127 $ 16,611 $
<br /> 17,109 $ 17,622 $ 18,151
<br /> CRASH RESCUE TRUCK AP2 $ 12,000 $ 12,360 $ 12,731 $ 13,113 $ 13,506 $ 13,971 $ 14,329 $ 14,758 $ 15,201 $ 15,657 $ 16,127 $ 16,611
<br />$ 17,709 $ 17,622 $ 18,151
<br />
<br /> TRUCK-AIR/LiGHT SUPPORT ALLS Al $ 5,040 $ 5,197 $ 5,347 $ 5,507 $ 5,673 $ 5,843 $ 6,018 $ 6,199' $ 6,385 $ 6,576 $ 6,773 $ 6,977
<br /> $ 7,186 $ 7,401 $ 7,623
<br />
<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 Out0ow $ 1,453,232 $ 998,379 $ 1,257,437 $ 1,431,474 $ 1,491,912 $ 388,461 $ 999,428 $ 1,528,025 $ 722,361 $ 1,034,345 $ 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 $ 837,005 $ 1,242,424: $ 570,238 $ 792,740 $ 332,379 $ 331,883
<br /> $ 2,146,293 $ 1,027,003 $ 1,869,233
<br />
<br /> Total Net Flow $ 15,727,622
<br />
<br />
|