HomeMy Public PortalAboutExhibit MSD 18A4 Summary of CIRP Costs Cash Flow vs AppropriationExhibit MSD 18A4
Summary of CIRP Costs
Cash Fl ow vs Appr opriation
Fiscal Year Endi ng Ju ne 30,
2013
$
Major Capital Improvements Cash Flow (2010 dollars)
Planning 10,730,000
Design 38,369,000
Con struction 149,075,200
Total 2010 Cash Expenses (a)
In flation Allowance (3%/Year)
Planning
Design
Construction
Total Inflation Allowance
Inflated Major Capital Improvements
Plan nin g
Design
Constru ction
2014 2015
$ $
4,330,000
32,500,000
178,155,800
4,330,000
33,120,000
174,118,500
2016 2017
$ $
4,330,000
18,388,000
201,572,750
198,174,200 214,985,800 211,568,500 224,290,750
995,000 543,500 689,700 840,200
3,557,800 4,079,000 5,275,200 3,568,200
13,823,300 22,360,100 27,732,600 39,115,650
18,376,100 26,982,600 33,697,500 43,524,050
11,725,000 4,873,500 5,019,700 5,170,200
41,926,800 36,579,000 38,395,200 21,956,200
162,898,500 200,515,900 201,8.51,1 .00 240,688,400
Total In flated Cash Expenses 216,550,300 241,968,400 245,266,000 267,814,800
Total CIR P Appropriation s (b) 273,807,000 237,428,000 261,630,000 234,013,000
35,719,000
35,719,000
0
0
8,210,900
8,210,900
0
0
43,929,900
43,929,900
Total
23,720,000
122,377,000
738,641,250
884,738,250
3,068,400
16,480,200
111,242,550
130,791,150
26,788,400
138,857,200
849,883,800
1,015,529,400
0 1,006,878,000
Difference (57,256,700) 4,540,400 (16,364,000) 33,801,800 43,929,900
(a) Estimated costs based on cash flo ws provided in Exhibit 18V.
(b) Based on scheduled appropriations. See Table 3-9 of Exhibit MSD 1.
A ssumptio ns: Planning costs are appropriated and spent in the same year.
Construction appropriatio ns are assumed to be spent based on the followin g criteria:
Projects less than $3 million are assumed to be spent in the sane year as the appropri ation.
Projects between $3 and $5 mullion are assu med to be spent over an 18 month period.
Pro jects over $5 are assumed to be spent over a 24 month period.
Projects ov er 12 mon ths are assumed to have 60 percent of the costs ex pended in the first
fiscal year with the remaining 40 percent spent in the hollowing fiscal yea r.
8,651,400