HomeMy WebLinkAbout09 - Interfund CITY OF BROOKLYN CENTER
ADMINISTRATIVE SERVICES /ENGINEERING /STORM SEWER TRANSFER
ALL FUNDS - DETAIL
12/31/2008
FUND NAME
ACCOUNT /DESCRIPTION IN OUT
MAJOR FUNDS:
GENERAL FUND:
6471 Administrative Service Transfer 447 -
6472 Engineering Service Transfer 255 -
6473 Storn Sewer Transfer 99 -
TAX INCREMENT DISTRICT NO. 3
6472 Engineering Service Transfer - 628.26
INFRASTRUCTURE CONSTRUCTION FUND:
6472 Engineering Service Transfer - 250,504.62
ENTERPRISE FUNDS:
MUNICIPAL LIQUOR
6471 Administrative Service Transfer - 34
6471 Administrative Service Transfer - 17
GOLF COURSE
6471 Administrative Service Transfer - 6
EARLE BROWN HERITAGE CENTER
6471 Administrative Service Transfer - 67
WATER UTILITY
6471 Administrative Service Transfer - 61
6472 Engineering Service Transfer - 226.02
SANITARY SEWER UTILITY
6471 Administrative Service Transfer - 95
STORM SEWER UTILITY
6471 Administrative Service Transfer - 47
6473 Storn Sewer Transfer - 99
NONMAJOR FUNDS:
SPECIAL REVENUE FUNDS:
ECONOMIC DEVELOPMENT AITHORITY
6471 Administrative Service Transfer - 56
CAPITAL PROJECT FUNDS:
6472 Engineering Service Transfer - 4
ENTERPRISE FUNDS:
RECYCLING AND REFUSE
6471 Administrative Service Transfer - 14
STREET LIGHT UTILITY
6471 Administrative Service Transfer - 14
INTERNAL SERVICE FUNDS:
CENTRAL GARAGE
6471 Administrative Service Transfer - 31
TOTAL ALL FUNDS 802 802,774.99
CITY OF BROOKLYN CENTER
ADMINISTRATIVE SERVICES /ENGINEERING /STORM SEWER TRANSFER
ALL FUNDS - DETAIL
12/31/2008
FUND NAME
ACCOUNT /DESCRIPTION IN OUT
These are not reported as transfers, rather as contra - expenditure in General Fund and expenditures/
expenses in all other funds.
Administrative Service Transfer 447
Storm Sewer Transfer 99
Engineering Service Transfer 255
802, 774.99
CITY OF BROOKLYN CENTER
INTERFUND RECEIVABLES AND PAYABLES
ALL FUNDS - DETAIL
12/31/2008
FUND NAME
ACCOUNT /DESCRIPTION From To
MAJOR FUNDS:
ENTERPRISE FUNDS:
MUNICIPAL LIQUOR
1305 Due from other funds 135 -
STORM DRAINAGE UTILITY
Interfund receivable (for negative cash) 4 -
GOLF COURSE
2610 Advances from Other Funds - 792
NONMAJOR FUNDS:
SPECIAL REVENUE FUNDS:
EDA
Interfund receivable (for negative cash) 11 -
CDBG
Interfund payable (for negative cash) - 11
CAPITAL PROJECTS FUNDS:
CAPITAL IMPROVEMENTS
1550 Advances to Other Funds 792 -
2210 Due to other funds 135
ENTERPRISE FUNDS:
RECYCLING AND REFUSE
Interfund payable (for negative cash) - 4
TOTAL ALL FUNDS 942,957.00 942,957.00
Engineering Service Transfer
Transferred
Project Wages as of 01/13 Remaining
2006 -01 230.71 - - Project closed 12/31/07
2007 -01 1 - 1 Project OPEN
2007 -05 8 8 - Project closed 12/09/08 - posted after
2007 -11 2 - 2 Lift Station #2 Force Main
2008 -01 113,788.22 - 113,788.22 Maranatha
2008 -05 83,528.51 - 83,528.51 Xerxes
2008 -10 4 - 4 Shingle Creek Trail Imps
2008 -11 295.99 - - Centerpoint Fence
2008 -16 275.33 - - Automated Meter Reading
2009 -01 23,104.68 - 23,104.68 Aldrich
2009 -05 17,012.05 - 17,012.05 Shingle Creek
2009 -11 226.02 - 226.02 Centerbrook Watermain
Fiber West Fire 233.96 - - Technology Fund
Fiber East Fire 83.14 - - Technology Fund
GSA /FBI Site 628.26 - 628.26 08464314 - TI F 3
8 247
Engineering Service Transfer 255
Shelley Schwaninger's wages:
Water 16,178.65
Sewer 16,178.65
Storm 21,571.51
53,928.81
Total reimb to General Fund 309,473.56
Mr"F
City of Brooklyn Center
Centerbrook Cash Flows & Debt Payments
2007 through 2016
YEAR 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Notes:
Beginning Cash Balance 81 50 8 27 39 43 45 48 45 39
Annual Operating Cash (7,900) (42,695) 37 38 39 40 41 43 44 45 increases by 3% per year
Interest Income 3 870 371 1 1 1 2 2 2 1 beginning cash earning 4 1/2 % return
Capital Expenses (26,475) (500) (18,500) (27,000) (24,900) (16,000) (15,500) (21,000) (25,000) (10,000) from schedule
Annual Cash Produced - (30,930) (42,325) 19 12 16 26 28 24 21 37
Ending Cash Available 89 50 8 27 39 55 70 74 72 67 76 Beginning Balance plus Annual Cash Produced
Reserve Requirement 81 69 59 59 50 43 45 48 45 39 47 calculated below
Debt Payment 7 (18,930) (51 (32,065) (10 12 24 25 27 28 29 ending cash available less reserve requirement
Debt Balance Owed EOY 792 792 792 792 792 780 755 730 703 675 645,952 amount owed at the end of each year to CIF
Calculation of Reserve Requirement:
Capital Reserve Balance 49 37 26 25 16 8 10 12 8 1 8,600 Beginning CR Balance +17,500 per year - capital expenses
Operating Reserve Requirement 32 32 33 33 34 35 35 36 37 38 38,841 increases 2% per year
81 69 59 59 50 43 45 48 45 39 47
Golf Course payment to CIF
CITY OF BROOKLYN CENTER
TRANSFERS IN AND OUT
ALL FUNDS - DETAIL
12/31/2008
added for
FUND NAME eliminated as capital asset
ACCOUNT /DESCRIPTION IN OUT intra- activity transfers
MAJOR FUNDS:
GENERAL FUND:
6482 Misc Transfers Out - (5,000.00) 5 -
SPECIAL REVENUE FUNDS:
TIF DISTRICT #3
6474 Debt Service Fund Transfer - (462,060.80) 462 -
6482 Misc Transfers Out - (781,122.41) 781 (1,224,308.00) (1,224,308.00) GW -G out
DEBT SERVICE FUNDS:
GO IMPROVEMENT BONDS
4915 -7 Transfers in from Debt Service Fund (310,541.96) -
4915 -7 Transfers in from Debt Service Fund 310541.96 -
CAPITAL PROJECT FUNDS:
INFRASTRUCTURE CONSTRUCTION
4915 Transfers In 781 - (781,122.41) -
4915 Transfers In 50,175.00 - 50 GW -G in
(233,100.00) (233,100.00) GW -G out
ENTERPRISE FUNDS: (329,577.00) (329,577.00) GW -G out
MUNICIPAL LIQUOR
6476 Capital Project Fund Transfer - (135,000.00) (135,000.00) GW -B out
EARLE BROWN HERITAGE CENTER
6476 Capital Project Fund Transfer - (235,000.00) (235,000.00) GW -B out
STORM DRAINAGE UTILITY 326 326 GW -B in
4915 Transfers In - - 1,224,308.00 1,224 GW -B in
233 233,100.00 GW -13 in
CITY OF BROOKLYN CENTER
TRANSFERS IN AND OUT
ALL FUNDS - DETAIL
12/31/2008
added for
FUND NAME eliminated as capital asset
ACCOUNT /DESCRIPTION IN OUT intra- activity transfers
NONMAJOR FUNDS:
SPECIAL REVENUE FUNDS:
HRA FUND
6481 EDA Fund Transfer - (299,857.57) 299 -
ECONOMIC DEVELOPMENT AITHORITY
4915 -3 Transfers In from HRA Fund 299 - (299,857.57) -
6482 Misc Transfers Out - (1,317.00) 1 -
TAX INCREMENT DISTRICT NO. 4
4915 Transfers In 1 - (1,317.00) -
CITY INITIATIVES GRANT
4915 Transfers In 5,000.00 - (5,000.00) -
DEBT SERVICE FUNDS:
GO TIF BONDS
2004B GO TIF REF BONDS
4915 -5 Transfer in from TIF3 462 - (462,060.80) -
CAPITAL PROJECTS FUNDS:
CAPITAL IMPROVEMENTS FUND
4915 -1 Transfers from Liquor Fund 135,000.00 - 135 GW -G in
EBHC CAPITAL PROJECT FUND
4915 Transfers In 235 - 235 GW -G in
(326,415.00) (326,415.00) GW -G out
ENTERPRISE FUNDS:
STREET LIGHT UTILITY 329 329 GW -B in
6482 Misc Transfer Out - (50,175.00) (50,175.00) GW -B out
TOTAL ALL FUNDS 1 (1 -