Schedule 9A: Cash Funds Reports
<br />Department of: Natural Resources
<br />FY 2012 -13 Budget Request
<br />Fund 424 - Water Conservation Board Construction Fund
<br />37-60-102,106,109, and 121.1, C.R.S. (2011)
<br />Available Liquid Cash Fund Balance
<br />Actual
<br />Actual
<br />Estimated
<br />Requested
<br />Projected
<br />FY 2009 -10
<br />FY 2010 -11
<br />FY 2011 -12
<br />FY 2012 -13
<br />FY 2013 -14
<br />Cash in Beginning Fund Balance'
<br />$36,698,245
<br />$84,337,196
<br />$107,444,926
<br />$130,773,545
<br />$158,209,980
<br />Non Cash Assets fShort temn
<br />$56 846
<br />$59,635
<br />$58,074
<br />$58,185
<br />$58,631
<br />Warrants and Accounts Payable 630 -09
<br />$2,959,992
<br />($2,233,935i
<br />$2 837 483 i
<br />($2,677,137i
<br />($2 582 852
<br />Cash Available for Current Fiscal Year - Beginning 7 -01 -10
<br />$33,795,099
<br />$82,162,896
<br />$104,665,517
<br />$128,154,593
<br />$155,685,760
<br />Actual / anticipated FML distribution
<br />$11,724,295
<br />$14,722,345
<br />$15,672,410
<br />$16,378,020
<br />$16,378,020
<br />Actual / anticipated Interest from Loans
<br />$7,586,140
<br />$8,571,387
<br />$7,927,489
<br />$8,194,185
<br />7,994,185
<br />Actual / anticipated Interest from Treasury Construction Fund interest
<br />$2,157,430
<br />$1,555,355
<br />$1,821,369
<br />$2,168,721
<br />$2,556,823
<br />Actual / anticipated Principal from Loans
<br />$5,594,063
<br />$5,461,920
<br />$5,662,504
<br />$6,030,701
<br />6,030,701
<br />Actual / anticipated other noncash assets converted to cash Z
<br />$226,225
<br />$196,571
<br />$211,398
<br />$211,398
<br />$206,456
<br />Actual WSRA Revenues
<br />$5,775,000
<br />$6,000,000
<br />$7,000,000.
<br />$10,000,000.
<br />$10,000,000
<br />Actual Wildlife Cash Transfer
<br />$296,027
<br />$296,027
<br />$291,587
<br />$291.587
<br />$291.587
<br />Actual Fish & Wildlife Transfer
<br />$182,351
<br />$159,982
<br />$243.984
<br />$243 984
<br />$243 984
<br />Actual Donations from Public
<br />$242,991
<br />$184,431
<br />$`140,652
<br />$140,652
<br />$140,652
<br />Actual Service Fees
<br />$805,388
<br />$252,717
<br />$252,717
<br />$252,717
<br />$252,717
<br />Actual Federal Reimbursement
<br />$2,203,963
<br />$1,423,035
<br />$1,813,499
<br />$1,618,267
<br />$1,715,883
<br />Actual STOA
<br />$1,249,037
<br />$1,256,402
<br />$1,275,500
<br />$1,275,500
<br />$1,275,500
<br />Severance Tax Transfer for Animas La Plata
<br />$0
<br />$12,000,000
<br />$12,000,000
<br />$12,000,000
<br />$0
<br />Other Lonq Bill STOA revenues
<br />$60.920
<br />$29,597
<br />$45.258
<br />$37,428
<br />$41,343
<br />Other Revenue
<br />$45,450
<br />$29.914
<br />$37,682
<br />$33,798
<br />$35,740
<br />"One Day" General Fund Transfer Replenished in FY09 -10
<br />$60,000,000
<br />$0
<br />$0
<br />$0
<br />$0
<br />Actual I Anticipated Cash Inflow During Fiscal Year
<br />$98,149,281
<br />$52,139,683
<br />$64,396,050
<br />$58,876,958
<br />$47,163,592
<br />Actual I Anticipated Cash Available for Fiscal Year
<br />$131,944,380
<br />$134,302,579
<br />$159,061,567
<br />$187,031,551
<br />$202,849,352
<br />Actual / appropriated / projected cash expenditures All Long Bill Items )
<br />($9,929,785)
<br />($9 467 800 )
<br />($10,271,179)
<br />($10 271 179
<br />($10,271,179)
<br />Actual/Anticipated Loan Disbursements (Existing Loans only)
<br />$29 959 935 )
<br />($9,084,266)
<br />($10 000 000
<br />$10 000 000
<br />$10 000 000
<br />Actual NRI Expenditures
<br />($5,622,814)
<br />($6 630 310 )
<br />($6,126,562)
<br />($6 378 436 )
<br />($6,252,499
<br />Actual WSRA Expenditures
<br />($4,135,346)
<br />($4 883 119 )
<br />($4,509,233)
<br />($4 696 176 )
<br />($4,602,704
<br />Actual I Appropriated Cash Outnow During Fiscal Year
<br />($49,647,880)
<br />($30 065 495 )
<br />($30,906,974)
<br />($31 345 791
<br />($31,126,383)
<br />Variance Adjustment
<br />$133,605
<br />$428,433
<br />$0
<br />$0
<br />$0
<br />Adual Cash Balance Prior to authored amounts
<br />$82,162,896.
<br />$104,665,517
<br />$128,154,593
<br />$155,685,760
<br />$17l,722,969
<br />Actual Loan Appropriations at year end
<br />($28,766,197)
<br />($34 413 615 )
<br />($30,184,876)
<br />($27 012 739 )
<br />($37,012,739
<br />Actual NRI Appropriations at year end
<br />($19,407,017)
<br />($27 052 454 )
<br />($23,747,815)
<br />($22 994 378 )
<br />($22,241,879
<br />Actual WSRA Appropriations at year end
<br />($8,779,570)
<br />($15 671 451 )
<br />($13,962,218)
<br />($19 266 042 )
<br />($24,663,338
<br />Appropriated Projects reducing cash availabifit y
<br />($56,952,784)
<br />($77 137 520 )
<br />($67,894,909)
<br />($69 273 159 i
<br />($83,917,956
<br />Available Liquid Fund Balance Prior to New Requests
<br />$25,210,112
<br />$27,527,998
<br />$60,259,684
<br />$86,412,600
<br />$87,805.013
<br />Projects Bill appropriated but not booked until new year
<br />$0
<br />$0
<br />($5,625,000)
<br />Authorized Loans not booked during the year
<br />$0
<br />$0
<br />($13,172,137)
<br />$0
<br />Anticipated loan issuances loan pre qualified r CWCB Board action
<br />$0
<br />$0
<br />($9,101,525)
<br />$30 000 000
<br />Antici ated maximum amount available for loans from CWCB Marketin List "
<br />$0
<br />$0
<br />($32,000,000)
<br />($50,000,000)
<br />Actual / antici ated other uses of cash 3
<br />$0
<br />$0
<br />$0
<br />$0
<br />Actual / A ro riated Cash Outflow Durin Fiscal Year
<br />$0
<br />$0
<br />$59 898 662
<br />$85 500 000
<br />Available Liquid Fund Balance Prior to New Requests
<br />$25,210,112
<br />$27,527,998
<br />$361,022
<br />$912.600
<br />1 $306013
<br />Notes:
<br />MCR01 FY09 Per 13 Cash + Cash Equivilants
<br />Prepaid Expenses MCR01
<br />MCR01 FY09 Per 13 Vouchers & Accounts Pay
<br />MCR02
<br />MCR02 lrtckdas $7,204,496 + $381,644.12 int accured from SCO Wherehouse
<br />MCR02 state Treasurer Int 5900 01 Col D, E. F calculates interest base
<br />FDW BS 1762 Principal Payments
<br />MCR02 state Treasurer Int 5900
<br />MCR02 state Treasurer EAWC
<br />MCR02 state Treasurer EBPK
<br />MCR02 AAPV
<br />MCR02 state Treasurer 6700
<br />MCR02 state Treasurer 4400 (C21)
<br />MCR02 7400,7514,AYPB
<br />MCR02 AAWB Sev TAX OP EXP
<br />MCR02 EAWC Sev TAX PBA
<br />MCR02 AAWB Sev TAX OP EXP
<br />MCR02 8300,6400,4300,6100
<br />MCR02 EFWA
<br />HB10 -1326 has revenue expectatic
<br />SCO Financial Data Warehouse Long Bill Line Item Report
<br />SCO Financial Data Warehouse Long Bill Line Item Report
<br />SCO Financial Data Warehouse Long Bill Line Item Report
<br />SCO Financial Data Warehouse Long Bill Line Item Report
<br />SCO Financial Data Warehouse Long Big Line hem Report
<br />SCO Financial Data Warehouse Long Bill Line Item Report
<br />SCO Financial Data Warehouse Long Bill Line Item Report
<br />Projects Bills Requests /Actual D54 number is needed for formula i
<br />Loans approved to date (ssb Loan Approval Summary from Board Memos and A
<br />Prequagfied CWCB Loans
<br />CWCB Marketing Prospects
<br />
|