|
PW Fleet Services
<br /> General Fund Fleet Reserve Analysis
<br /> March 16, 2004 by Ilr
<br /> Option 1 Actuals Actuals Actuals EE Budget Projected Projected Projected Projected Projected
<br /> No Change to Existing Transfer FY-01 FY-02 FY-03 FY-04 FY-05 FY-06 FY-07 FY-08 FY-09 FY-10
<br /> Beginning Balance $1,870,045 $1,949,884 $2,010,762 $2,747,729 $2,599,422 $958,756 ($218,271) ($1,560,707) ($2,008,613) ($1,623,960)
<br /> Current Year Transfer $793,603 $793,603 $813,000 $975,600 $830,000 $845,189 ~ $862,769 $880,887 $899,386 $920,521
<br /> Interest Eamings $100,131 $31,232 $65,173 $41,946 $82,411 $46,499 $0 $0 $0 $0
<br /> Sale ofASSets $38,401 $25,608 $74,038 $65,000 $55,000 $56,007 $57,171 $58,372 $59,598 $60,998
<br /> Equipment Expenditures ($852,296) ($789,565) ($215,244) ($1,230,853) ($2,608,077) ($2,124,722) ($2,262,376) ($1,387,165) ($574,331) ($632,841)
<br /> Ending Balance $1,949,884 $2,010,762 $2,747,729 $2,599,422 $958,756 ($218,271) ($1,560,707) ($2,008,613) ($1,623,960) ($1,275,282)
<br /> Option 2
<br /> Transfer Set to Recover Current Yr Expenditures + $100,000 Contingency + 10% Reserve Balance
<br /> Actuals Actuals Actuals EE Budget Projected Projected Projected Projected Projected
<br /> FY-01 FY-02 FY-03 FY-04 FY-05 FY-06 FY-07 FY-08 FY-09 FY-10
<br /> Beginning Balance $1,870,045 $1,949,884 $2,010,762 $2,747,729 $2,599,422 $958,756 $1,200,585 $1,200,143 $1,200,228 $1,200,608
<br /> Current Year Transfer $793,603 $793,603 $813,000 $975,600 $830,000 $2,327,000 $2,201,000 $1,338,000 $543,000 $597,000
<br /> Interest Eamings $100,131 $31,232 $65,173 $41,946 $82,411 $83,544 $103,763 $90,878 $72,113 $74,344
<br /> Sale of Assets $38,401 $25,608 $74,038 $65,000 $55,000 $56,007 $57,171 $58,372 $59,598 $60,998
<br /> Equipment Expenditures+Contingency ($852,296) ($789,565) ($215,244) ($1,230,853) ($2,606,077) ($2,224,722) ($2,362,376) ($1,487,165) ($674,331)
<br /> ($732,841)
<br /> Ending Balance $1,949,884 $2,010,762 $2,747,729 $2,599,422 $958,756 $1,200,585 $1,200,143 $1,200,228 $1,200,608 $1,200,110
<br /> Option 3
<br /> Transfer Set to Recover Current Yr Expenditures + $100,000 Contingency + 5% Reserve Balance
<br /> Actuals Actuals Actuals EE Budget Projected Projected Projected Projected Projected
<br /> FY-01 FY-02 FY-03 FY-04 FY-05 FY-06 FY-07 FY-08 FY-09 FY-10
<br /> Beginning Balance $1,870,045 $1,949,884 $2,010,762 $2,747,729 $2,599,422 $958,756 $600,960 $600,039 $600,856 $600,141
<br /> Current Year Transfer $793,603 $793,603 $873,000 $975,600 $830,000 $1,742,000 $2,218,000 $1,359,000 $565,000 $621,000
<br /> Interest Eamings $100,131 $31,232 $65,173 $41,946 $82,411 $68,919 $86,284 $70,609 $49,018 $51,286
<br /> Sale of Assets $38,401 $25,608 $74,038 $65,000 $55,000 $56,007 $57,171 $58,372 $59,598 $60,998
<br /> Equipment Expenditures+Contingency ($852,296) ($789,565) ($215,244) ($1,230,853) ($2,608,077) ($2,224,722) ($2,362,376) ($1,487,165) ($674,331)
<br /> ($732,841)
<br /> Ending Balance $1,949,884 $2,010,762 $2,747,729 $2,599,422 $958,756 $600,960 $600,039 $600,856 $600,141 $600,584
<br /> Option 4
<br /> Transfer Set to Recover Current Yr Expenditures + $100,000 Contingency Only
<br /> Actuals Actuals Actuals EE Budget Projected Projected Projected Projected Projected
<br /> FY-01 FY-02 FY-03 FY-04 FY-05 FY-06 FY-07 FY-08 FY-09 FY-10
<br /> Beginning Balance $1,870,045 $1,949,884 $2,010,762 $2,747,729 $2,599,422 ??5875g As1n ga40 $556 $789
<br /> Current Year Transfer $793,603 $793,603 $813,000 $975,600 $830,000 51,15s.o00 52,23',000 51,376.100~~ $589,000 $643,000
<br /> Interest Eamings $100,131 $31,232 $65,173 $41,946 $82,411 y54,269 y68,834 $5U,'3Uy $25,966 $28,192
<br /> Sale of Assets $38,401 $25,608 $74,038 $65,000 $55,000 $56,007 $57,171 $58,372 $59,598 $60,998
<br /> Equipment Expenditures+Contingency ($852,296) ($789,565) ($215,244) ($1,230,853) ($2,608,077) _ ($2,224,722) ($2,362,376) ($1,487,165) ($674,331)
<br /> ($732,841)
<br /> Ending Balance $1,949,884 $2,010,762 $2,747,729 $2,599,422 $958,756 $310 $940 $556 $789 $138
<br /> Option 5 Actuals Actuals Actuals EE Budget Projected Projected Projected Projected Projected
<br /> Transfer Set to Match Depreciation Schedule FY-01 FY-02 FY-03 FY-04 FY-05 FY-06 FY-07 FY-08 FY-09 FY-10
<br /> Beginning Balance $1,870,045 $1,949,884 $2,010,762 $2,747,729 $2,599,422 $1,478,756 $857,482 $125,115 $285,659 $1,306,107
<br /> Current Year Transfer $793,603 $793,603 $813,000 $975,600 $1,350,000 $1,374,705 $1,403,299 $1,432,768 $1,462,856 $1,497,233
<br /> Interest Eamings $100,131 $31,232 $65,173 $41,946 $82,411 $72,737 $69,539 $56,569 $72,325 $114,574
<br /> Sale ofASSets $38,401 $25,608 $74,038 $65,000 $55,000 $56,007 $57,171 $58,372 $59,598 $60,998
<br /> Equipment Expenditures ($652,296) ($789,565) ($215,244) ($1,230,853) ($2,608,077) __.($2,124,722) ($2,262,376) ($1,387,165) ($574,331) ($632,841)
<br /> Ending Balance $1,949,884 $2,010,762 $2,747,729 $2,599,422 $1,478,756 $857,482 $125,115 $285,659 $1,306,107 $2,346,071
<br />
<br /> Assumptions:
<br /> 1. Interest on Investments 2.00% 2.00 % 2.50% 3.00 % 3.50 % 4.00 % 4.00
<br /> 2.CPI-U 120% 1.85% 1.83% 2.08% 2.10% 2.10% 2.35%
<br /> 3. Additional Transfer Monies Calculated as outlined in Fleet Board Draft Memo
<br />
<br />
|