|
- _
<br /> I
<br /> PW Fleet Services
<br /> Leasing vs. Owning Cash Flow Analysis ~
<br /> September 9, 2002
<br /> I
<br /> Option 3a: Turn-in Lease
<br /> Sell all Pumpers; lease new pumpers on a turn-in option lease (all other equipment the same)
<br /> Period 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14
<br /> Inflation 0.03
<br /> Cash Inflow (Revenue): Liquidation of Pumpers FY03 FY04 FY05 FY06 FY07 FY08 FY09 FY10 FY11 FY12 FY13 FY14 FY15 FY16 FY17
<br /> PUMPER - 750 GALLON El $ 160,000
<br /> PUMPER - 750 GALLON E6 $ 160,000
<br /> PUMPER 4WD E3 $ 160,000
<br /> PUMPER 4WD E10 $ 160,000
<br /> PUMPER-4X4 ES $ 160,000
<br /> PUMPER E2 $ 160,000
<br />
<br /> Total Cash Inflow $ 960,000
<br /> Cash Outflow (Expenses): New Purchases FY03 FY04 FY05 FY06 FY07 FY08 FY09 FY10 FY11 FY12 FY13 FY14 FY15 FY16 FY17 .
<br />
<br /> TANK TRUCK-WATERTENDER-1250GALLON BR3
<br /> ELLIPTICALTANKER/PUMPER $ 789,800 I
<br /> ELLIPTICALTANKER/PUMPER $ 789,800 '
<br /> TELESQUIRT-SOOGAL TANK E21 $ 330,000
<br /> TELESQUIRT-SOFT E24 $ 450,000
<br /> TELESQUIRT -SOFT E8 $ 450,000
<br /> TELESQUIRT-SOFT E9 $ 422,000
<br /> TELESQUIRT-SOFT E23, $ 422,000 ~
<br /> AERIAL PLATFORM - 95Ff T22 $ 650,000
<br /> AERIAL LADDER - lOSFT Tl $ 1,114,100
<br /> AERIAL PLATFORM 100' TZ $1,690,000
<br /> WILDLAND FIRE APPARATUS (E-ONE) 810 $ 448,800
<br /> WILDLAND FIRE APPARATUS (E-ONE) BRS $ 448,800
<br /> CRASH/RESCUE TRUCK APl $ 785,000
<br /> CRASH RESCUE TRUCK AP2 $ 817,300 I
<br /> TRUCK - AIR/LIGHT SUPPORT (ALES) Al $ 747,900
<br /> Total Purchases $ 1,115,000 $ 650,000 $ 900,000 $ 844,000 $ 1,114,100 $ - $ $ 817,300 $ - $ $ - $ $ 2,587,600 $ - $
<br />2,327,500 Iii
<br /> Cash Outflow: MaintRates FY03 FY04 FY05 FY06 FY07 FY08 FY09 FY10 FY11 FY12' FY13 FY14 FY15 FY16 FY17
<br /> PUMPER-750GALLON El $ 16,800 $ 34,145 $ 34,145 $ 34,145 $ 34;145 $ 34,145 $ 40,409 $ 40,409 $ 40,409 $ 40,409 $ 40,409 $ 49,080
<br /> $ 49,080 $ 49,080 $ 49,080 '
<br /> PUMPER-750 GALLON E6 $ 16,800 $ 34,145 $ 34,145 $ 34,145 $ 34,145 $ 34,145 $ 40,409 $ 40,409 $ 40,409 $ 40,409 $ 40,409 $ 49,080
<br /> $ 49,080 $ 49,080 $ 49,060
<br /> PUMPER 4WD E3 $ 16,800 $ 34,145 $ 34,145 $ 34,145 $ 34,145 $ 34,145 $ 40,409 $ 40,409 $ 40,409 $ 40,409 $ 40,409 $ 49,080 $ 49,080
<br /> $ 49,080 $ 49,080
<br /> PUMPER 4WD E10 $ 16,800 $ 34,145 $ 34,145 $ 34,145 $ 34,145 $ 34,145 $ 40,409 $ 40,409 $ 40,409 $ 40,409 $ 40,409 $ 49,080 $ 49,080
<br /> $ 49,080 $ 49,080
<br /> PUMPER-4X4 ES $ 16,800 $ 34,145 $ 34,145 $ 34,145 $ 34,145 $ 34,145 $ 40,409 $ 40,409 $ 40,409 $ 40,409 $ 40,409 $ 49,080 $ 49,080
<br /> $ 49,080 $ 49,080
<br /> PUMPER E2 $ 16,800 $ 34,145 $ 34,145 $ 34,145 $ 34,145 $ 34,145 $ 40,409 $ 40,409 $ 40,409 $ 40,409 $ 40,409 $ 49,080 $ 49,080
<br /> $ 49,080 $ 49,080
<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
<br />$ 23,255 $ 23,953 $1,046,871 $ 25,412
<br /> TANK TRUCK-WATERTENDER-1250GALLON BR3 $ 6,072 $ 6,254 $ 6,072 $ 6,072 $ 6,072 $ 6,072 $ 6,072 $ 6,072 $ 6,072 $ 6,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 /> 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 /> 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,578 $ 23,255
<br />$ 23,953 $ 24,671 $ 25,412
<br /> TELESQUIRT-SOFT E8 $ 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 E9 $ 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 E23 $ 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 /> 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 /> AERIAL LADDER- lOSFT Ti $ 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
<br /> WILDLAND FIRE APPARATUS (E-ONE) 610 $ 6,360 $ 6,551 $ 6,747 $ 6,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-ONE) BRS $ 6,360 $ 6,551 $ 6,747 $ 6,950 $ 7,158 $ 7,373 $ 7,594 $ 7,822 S 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,657 $ 16,127 $ 16,611
<br /> $ 17,109 $ 17,622 $ 18,151
<br /> CRASH RESCUE TRUCK APZ $ 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/LIGHTSUPPORT(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,186 $ 7,401 $ 7,623
<br /> Insurance for Pumpers $ $ 16,720 $ 17,222 $ 17,738 $ 18,270 $ 18,819 $ 19,383 $ 19,965 $ 20,563 $ 21,180 $ 21,816 $ 22,470 $ 23,144
<br /> $ 23,839 $ 24,554
<br /> Overhead Costs for Pumpers $ 3,000 $ 3,090 $ 3,183 $ 3,278 $ 3,377 $ 3,478 $ 3,582 $ 3,690 $ 3,800 $ 3,914 $ 4,032 $ 4,153
<br /> $ 4,277 $ 4,406 I
<br /> Gas Purchases for Pum ers $ 20,700 $ 21,321 $ 21,961 $ 22,619 $ 23,298 $ 23,997 $ 24,717 $ 25,458 $ 26,222 $ 27,009 $ 27,819 $ 28,654
<br /> $ 29,513 $ 30,399
<br /> i
<br /> I
<br />
<br />
|