HomeMy WebLinkAbout09 - Interfund CITY OF BROOKLYN CENTER
ADMINISTRATIVE SERVICES /ENGINEERING /STORM SEWER TRANSFER
ALL FUNDS - DETAIL
12/31/2007
FUND NAME
ACCOUNT /DESCRIPTION IN OUT
MAJOR FUNDS:
GENERAL FUND:
6471 Administrative Service Transfer 442 -
6472 Engineering Service Transfer 202 -
6473 Storn Sewer Transfer 99 -
TAX INCREMENT DISTRICT NO. 3
6472 Engineering Service Transfer - 7
INFRASTRUCTURE CONSTRUCTION FUND:
6472 Engineering Service Transfer - 194
ENTERPRISE FUNDS:
MUNICIPAL LIQUOR
6471 Administrative Service Transfer - 28
6471 Administrative Service Transfer - 12
GOLF COURSE
6471 Administrative Service Transfer - 6
EARLE BROWN HERITAGE CENTER
6471 Administrative Service Transfer - 86
WATER UTILITY
6471 Administrative Service Transfer - 76
SANITARY SEWER UTILITY
6471 Administrative Service Transfer - 133
STORM SEWER UTILITY
6471 Administrative Service Transfer - 48
6473 Storn Sewer Transfer - 99
NONMAJOR FUNDS:
SPECIAL REVENUE FUNDS:
ECONOMIC DEVELOPMENT AITHORITY
6471 Administrative Service Transfer - 16
CAPITAL PROJECT FUNDS:
6472 Engineering Service Transfer - 194.85
ENTERPRISE FUNDS:
RECYCLING AND REFUSE
6471 Administrative Service Transfer - 10
STREET LIGHT UTILITY
6471 Administrative Service Transfer - 4
INTERNAL SERVICE FUNDS:
CENTRAL GARAGE
6471 Administrative Service Transfer - 19
TOTAL ALL FUNDS 744,589.81 744,589.81
These are not reported as transfers, rather as contra - expenditure in General Fund and expenditures/
expenses in all other funds.
CITY OF BROOKLYN CENTER
INTERFUND RECEIVABLES AND PAYABLES
ALL FUNDS - DETAIL
12/31/2007
FUND NAME
ACCOUNT /DESCRIPTION From To
MAJOR FUNDS:
GOVERNMENTAL FUNDS:
INFRASTRUCTURE CONSTRUCTION
Interfund payable (for negative cash) - 1 1 054 1 563.00
ENTERPRISE FUNDS:
GOLF COURSE
2610 Advances from Other Funds - 792
NONMAJOR FUNDS:
CAPITAL PROJECTS FUNDS:
STREET RECONSTRUCTION
nterfu nd receivable (for negative cash) 1, 054, 563.00 -
CAPITAL IMPROVEMENTS
1550 Advances to Other Funds 792 -
TOTAL ALL FUNDS 1,847,051.00 1,847,051.00
Personnel Costs by Project
Posted to General Fund
2007 Allocation
Project Wages TI F3 Cap Imp Infra Constr Str Recon Water San Sewer Storm
Freeway Blvd /Shingle
2007 -01 Creek Street $ 41,229.39 $ - $ - $ - $39.,502.74 $ 1,029.65 $ 1,029.65 $ 2,574.12
Freeway Blvd /Shingle
2007 -04 Creek Sanitary 2,906.77
2007 -05 Riverwood Area Street 103,699.51 - - - 56,960.15 16,778.23 9,587.56 20,373.57
TIF 3 Regional Storm
2007 -15 Improvements -Regal 7,816.09 7,816.09 - - - - - -
2007 -17 Kylawn Park Building 194.85 - 194.85 - - - - -
2008 -01 Maranatha Street 30,295.76 - - 30,295.76 - - - -
Xerxes Ave & Northway
2008 -05 Drive Street 16,204.64 - - 16,204.64 - - - -
$ 202,347.01 $ 7,816.09 $ 194.85 $46.,500.40 $96.,462.89 $17,807.88 $10,617.21 $22.,947.69
E7 City of Brooklyn Center
Centerbrook Cash Flows & Debt Payments
2007 through 2016
YEAR 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016
Beginning Cash Balance 81 51 59 59 50 43 45 48 45 39
Annual Operating Cash (6 36 37 38 39 40 41 43 44 45
Interest Income 3 3 2 2 2 1 2 2,192 2 1
Capital Expenses (26,475) (28 (18 (27,000) (24,900) (16 (15 (21,000) (25,000) (10
Annual Cash Produced - (29 11 21 13 16 26 28 24 21 37
Ending Cash Available 89 51 62 80 73 67 70 74 72 67 76
Reserve Requirement 81 69 59 59 50 43 45 48 45 39 47
Debt Payment 7,512 (17 3 21 22 23 24 25 27 28 29
Debt Balance Owed EOY 792 792 789,367 767,714 744 721 697 671 644,511 616 587,186
Calculation of Reserve Requirement:
Capital Reserve Balance 49 37 26 25 16 8 10 12 8 1 8
Operating Reserve Requirement 32 32 33 33 34 35 35 36 37 38 38
81 69 59 59 50489 43 45 48 45, 932 39 47
Golf Course payment to CIF
CITY OF BROOKLYN CENTER
TRANSFERS IN AND OUT
ALL FUNDS - DETAIL
12/31/2007
FUND NAME
ACCOUNT /DESCRIPTION IN OUT
MAJOR FUNDS:
GENERAL FUND:
6482 Misc Transfers Out - (531
SPECIAL REVENUE FUNDS:
TIF DISTRICT #3
6474 Debt Service Fund Transfer - (1, 898, 501.47)
6482 Misc Transfers Out - (2
- (4
CAPITAL PROJECT FUNDS:
INFRASTRUCTURE CONSTRUCTION
4915 Transfers In 760 -
ENTERPRISE FUNDS:
MUNICIPAL LIQUOR
6476 Capital Project Fund Transfer - (125
EARLE BROWN HERITAGE CENTER
6476 Capital Project Fund Transfer - (230
SANITARY SEWER UTILITY
4915 Transfers In 461, 723.00 -
STORM DRAINAGE UTILITY
CITY OF BROOKLYN CENTER
TRANSFERS IN AND OUT
ALL FUNDS - DETAIL
12/31/2007
FUND NAME
ACCOUNT /DESCRIPTION IN OUT
NONMAJOR FUNDS:
SPECIAL REVENUE FUNDS:
HRA FUND
6481 EDA Fund Transfer - (262
ECONOMIC DEVELOPMENT AITHORITY
4915 -3 Transfers In from HRA Fund 262 -
4915 -6 Transfers in from CDBG Fund 0.66 -
262 -
COMMUNITY DEVELOPMENT BLOCK GRANT
6481 EDA Fund Transfer - (0.66)
CITY INITIATIVES GRANT
6482 Misc Transfer Out - (57
GO TIF BONDS
2004B GO TIF REF BONDS
4915 -5 Transfer in from TIF3 495 -
2004D GO TIF BONDS
4915 -5 Transfer in from TIF3 3 -
4,433,310.47 -
CAPITAL PROJECTS FUNDS:
CAPITAL IMPROVEMENTS FUND
4915 -1 Transfers from Liquor Fund 125,000.00 -
MUNICIPAL STATE AUD FOR CONSTRUCTION
6476 Capital Project Fund Transfer - (734,097.02)
EBHC CAPITAL PROJECT FUND
4915 Transfers In 230,000.00 -
TECHNOLOGY FUND
4915 Transfers In 70,000.00 -
ENTERPRISE FUNDS:
STREET LIGHT UTILITY
4915 Transfers In - (26,810.00)
INTERNAL SERVICE FUNDS
CENTRAL GARAGE FUND
4915 Transfers In 57,459.15 -
TOTAL ALL FUNDS 6,400,439.71 (6,400,439.71)