NOTE II – RECONCILIATION OF GOVERNMENT-WIDE AND FUND FINANCIAL STATEMENTS (CONTINUED)
B. Explanation of certain differences between the governmental fund statement of revenues, expenditures, and changes in fund balances and the government-wide statement of activities
The governmental fund statement of revenues, expenditures, and changes in fund balances includes a reconciliation between net changes in fund balances - total governmental funds and changes in net assets of governmental activities as reported in the government-wide statement of activities. One element of that reconciliation explains that “Governmental funds report capital outlays as expenditures. However, in the statement of activities, the cost of those assets is allocated over their estimated useful lives and reported as depreciation expense”. The details of this $5,636,879 difference are as follows:
Capital outlay $ 9,266,002
Depreciation expense (3,629,123)
Net adjustment to increase net changes in fund balances - total governmental funds to arrive at changes in net assets of governmental
activities $ 5,636,879
Another element of the reconciliation states that “the issuance of long-term debt (e.g. bonds, leases) provides current financial resources to governmental funds, while the repayment of the principal of long-term debt consumes the current financial resources of governmental funds. Neither transaction, however, has any effect on net assets.” The details of this $105,851 difference are as follows:
Debt issued or incurred:
Capital leases $ (650,450)
Principal repayments:
Revenue bonds 591,000
Capital leases 165,301
Net adjustment to increase net changes in fund balances – total governmental funds to arrive at changes in net assets of
governmental activities $ 105,851
Another element of the reconciliation states that “some expenses reported in the statement of activities do not require the use of current financial resources and, therefore, are not reported as expenditures in governmental funds”. The details of this $(139,465) difference are as follows:
Amortization of issuance costs $ (7,488)
Amortization of bond discount (8,699)
Net change in compensated absences (123,278)
CITY OF COCOA, FLORIDA
Notes to Financial Statements September 30, 2009
NOTE III – DETAILED NOTES ON ALL FUNDS A. Deposits and investments
At September 30, 2009, the City’s carrying amount of cash deposits was $26,648,742 and the bank balance was
$25,370,303. In addition, the City holds $1,930 of petty cash. The agency fund’s carrying amount of deposits with banks was $924,852 and the bank balance was $924,852. The component units’ carrying amount of deposits with banks was $1,227,651 and the bank balance was $1,227,651. As of September 30, 2009, $250,000 of the City, agency fund and component units’ bank balances are covered by federal depository insurance (FDIC) through December 31, 2013 at which time it will revert back to $100,000. Monies invested in amounts greater than the insurance coverage are secured by the qualified public depositories pledging securities with the State Treasurer in such amounts required by the Florida Security for Public Depositories Act. In the event of a default or insolvency of a qualified public depositor, the State Treasurer will implement procedures for payment of losses according to the validated claims of the City pursuant to Section 280.08, Florida Statutes.
Credit risk
The City’s investment policy, and the investment policies for the City’s General Employees, Police and Fire Pension Funds limit investments to securities with specific ranking criteria.
Interest rate risk
The City’s investment policy limits interest rate risk by requiring that investment maturities shall not be greater than two years, except reserve funds, for which the related maturities shall not be greater than 10 years. The City’s General Employee, Police and Fire Pension Funds do not address interest rate risk.
Concentration of credit risk
The City’s Police and Fire Pension Funds do not allow for an investment in any one issuer that is in excess of five percent of the respective funds’ total investments, except for securities issued by the U.S. Government or its agencies, which may be held without limitation. The City’s investment policy and the investment policy of the City’s General Employees Pension Fund do not address concentration of credit risk.
CITY OF COCOA, FLORIDA
Notes to Financial Statements September 30, 2009
NOTE III – DETAILED NOTES ON ALL FUNDS (CONTINUED) A. Deposits and investments (continued)
At September 30, 2009, the City had the following investments:
Investment Maturities (in years)
More
Investment type Fair Value Less than 1 1 - 5 6 - 10 than 10 Rating Agency
Primary government:
SBA (Florida Prime) $ 40,661 $ 40,661 $ - $ - $ - AAAm S&P
SBA Fund B 638,616 - - 638,616 - Not rated
-Certificates of deposit 1,200,552 600,276 600,276 - - Not rated
-Money market fund 455,634 455,634 - - - AAA Moody's
Money market fund 3,118,178 3,118,178 - - - Not rated
-Corporate stock 1,647 1,647 - - - -
-U.S. Treasuries 25,458,254 2,411,715 20,714,152 2,007,545 324,842 AAA S&P
U.S. Agencies 6,282,856 - 4,241,297 2,041,559 - AAA S&P
37,196,398
$ $ 6,628,111 $ 25,555,725 $ 4,687,720 $ 324,842
Pension trust funds:
Money market fund $ 1,655,846 $ 1,655,846 $ - $ - $ - Not rated
-Corporate stock 11,899,655 11,899,655 - - - -
-Stock mutual fund 10,551,298 10,551,298 - - - -
-Foreign stock mutual fund 3,122,380 3,122,380 - - - -
-Corporate bonds 210,237 - - - 210,237 AAA S&P
Corporate bonds 48,167 - 48,167 - - AA+ S&P
Corporate bonds 28,200 - - 28,200 - AA S&P
Corporate bonds 64,037 - 27,007 - 37,030 A+ S&P
Corporate bonds 469,923 - 210,658 139,157 120,108 A S&P
Corporate bonds 250,921 30,629 126,482 69,888 23,922 A- S&P
Corporate bonds 77,581 - - 48,216 29,365 AA- S&P
Corporate bonds 36,464 - 15,456 21,008 - BBB+ S&P
Bond mutual fund 8,031,735 - - 8,031,735 - Not rated
-Bond mutual fund 759,497 759,497 - - - AAA S&P
U.S. Treasuries 90,990 - - 74,254 16,736 AAA S&P
U.S. Agencies 761,424 - 29,632 197,017 534,775 Not rated
-Annuity contract 55,664 55,664 - - - -
-38,114,019
$ $ 28,074,969 $ 457,402 $ 8,609,475 $ 972,173
CITY OF COCOA, FLORIDA
Notes to Financial Statements September 30, 2009
NOTE III – DETAILED NOTES ON ALL FUNDS (CONTINUED) B. Receivables
Receivables as of yearend for the government’s individual major funds and nonmajor, internal service, and fiduciary funds in the aggregate, including applicable allowances for uncollectible accounts, are as follows:
Water and Nonmajor
General Sewer And Other
Fund System Fund Funds Total
Accounts $ 587,743 $ 4,691,226 $ 179,307 $ 5,458,276
Tax 585,250 - - 585,250
Gross receivables 1,172,993 4,691,226 179,307 6,043,526
Less: allowance for
uncollectible accounts (36,913) (50,962) - (87,875)
Total net receivables $ 1,136,080 $ 4,640,264 $ 179,307 $ 5,955,651 C. Restricted assets
The balance of the restricted assets account at September 30, 2009, in the enterprise funds are as follows:
Customer and developer deposits $ 2,586,203
Debt service – revenue bonds 3,378,350
Debt service – State revolving loans 1,745,529
Renewal and replacement 5,724,109
Construction 7,742,564
Other 1,481,724
Total restricted assets $ 22,658,479
CITY OF COCOA, FLORIDA
Notes to Financial Statements September 30, 2009
NOTE III – DETAILED NOTES ON ALL FUNDS (CONTINUED) D. Capital assets
Capital asset activity for the year ended September 30, 2009 was as follows:
Primary Government
Beginning Balance
Additions/
Transfers
Deletions/
Transfers
Ending Balance Governmental activities:
Capital assets, not being depreciated:
Land $ 4,944,158 $ - $ - $ 4,944,158
Construction in progress 4,610,310 6,675,368 (10,529,918) 755,760
Total capital assets, not being
Depreciated 9,554,468 6,675,368 (10,529,918) 5,699,918
Capital assets, being depreciated:
Buildings 7,204,814 8,417,923 - 15,622,737
Equipment 9,390,384 2,844,196 (417,030) 11,817,550
Infrastructure 57,425,108 1,902,401 - 59,327,509
Total capital assets being depreciated 74,020,306 * 13,164,520 (417,030) 86,767,796 Less accumulated depreciation for:
Buildings (2,625,644) (484,422) - (3,110,066)
Equipment (6,413,890) (1,339,197) 414,495 (7,338,592)
Infrastructure (41,070,398) (1,808,354) - (42,878,752)
Total accumulated depreciation (50,109,932) ** (3,631,973) 414,495 (53,327,410)
Total capital assets being depreciated, net 23,910,374 9,532,547 (2,535) 33,440,386 Governmental activities capital assets, net $ 33,464,842 $ 16,207,915 $ (10,532,453) $ 39,140,304
* Includes $41,118 of confiscated capital assets not recorded as capital outlay. Also includes $2,850 of fully depreciated capital assets transferred from the Water and Sewer enterprise fund, that were not recorded as capital outlay.
** Includes $2,850 of accumulated depreciation related to capital assets transferred from the Water and Sewer enterprise fund.
CITY OF COCOA, FLORIDA
Notes to Financial Statements September 30, 2009
NOTE III – DETAILED NOTES ON ALL FUNDS (CONTINUED) D. Capital assets (continued)
Beginning Balance
Additions/
Transfers
Deletions/
Transfers
Ending Balance Business-type activities:
Capital assets, not being depreciated:
Land $ 1,968,904 $ 306,652 $ - $ 2,275,556
Construction in progress 15,185,575 20,358,409 (2,058,311) 33,485,673
Total capital assets, not being depreciated 17,154,479 20,665,061 (2,058,311) 35,761,229 Capital assets, being depreciated:
Buildings 4,645,937 43,576 - 4,689,513
Improvements other than buildings 235,436,753 3,569,182 - 239,005,935
Equipment 22,212,156 834,715 (426,162) 22,620,709
Total capital assets being depreciated 262,294,846 4,447,473 (426,162) 266,316,157
Less accumulated depreciation for:
Buildings (3,135,110) (81,718) - (3,216,828)
Improvements other than buildings (109,557,589) (6,650,966) - (116,208,555)
Equipment (17,708,780) (952,636) 426,162 (18,235,254)
Total accumulated depreciation (130,401,479) (7,685,320) 426,162 (137,660,637)
Total capital assets, being depreciated, net 131,893,367 (3,237,847) - 128,655,520
Business-like activities capital assets, net $ 149,047,846 $ 17,427,214 $ (2,058,311) $ 164,416,749 Depreciation expense was charged to functions/programs of the City as follows:
Governmental activities:
General government $ 1,234,873
Public safety 678,265
Recreation 46,169
Physical environment 700
Economic development 69,163
Unallocated 1,599,953
Total depreciation expense – governmental activities $ 3,629,123
Business-type activities:
Water and Sewer $ 7,550,957
Stormwater Utility 134,363
Total depreciation expense – business-type activities $ 7,685,320
CITY OF COCOA, FLORIDA
Notes to Financial Statements September 30, 2009
NOTE III – DETAILED NOTES ON ALL FUNDS (CONTINUED) D. Capital assets (continued)
Discretely presented component units
Activity for the Diamond Square Redevelopment Agency for the year ended September 30, 2009, was as follows:
Beginning Balance
Additions/
Transfers
Deletions/
Transfers
Ending Balance Capital assets, not being depreciated:
Land $ 179,427 $ - $ - $ 179,427
Capital assets, being depreciated:
Improvements other than buildings 97,216 448 - 97,664
Less accumulated depreciation for:
Improvements other than buildings (9,844) (3,205) - (13,049)
Total capital assets, being depreciated, net 87,372 (2,757) - 84,615 Diamond Square Agency capital
assets, net $ 266,799 $ (2,757) $ - $ 264,042
Activity for the U.S. 1 Corridor Agency for the year ended September 30, 2009, was as follows:
Beginning Balance
Additions/
Transfers
Deletions/
Transfers
Ending Balance Capital assets, not being depreciated:
Land $ 381,904 $ 286,391 $ - $ 668,295
Construction in progress 27,495 54,805 - 82,300
Total capital assets, not being depreciated 409,399 341,196 - 750,595 Capital assets, being depreciated:
Improvements other than buildings 23,134 - - 23,134
Less accumulated depreciation for:
Improvements other than buildings (5,216) (758) - (5,974)
Total capital assets, being depreciated, net 17,918 (758) - 17,160 U.S. 1 Corridor Agency capital assets, net $ 427,317 $ 340,438 $ - $ 767,755
CITY OF COCOA, FLORIDA
Notes to Financial Statements September 30, 2009
NOTE III – DETAILED NOTES ON ALL FUNDS (CONTINUED) D. Capital assets (continued)
Construction commitments
The City has active construction projects as of September 30, 2009. The projects include the water reclamation facility improvement project, repair and replacement projects related to the utility system, construction of the new City Hall building, and certain other design and renovation projects. At year end the City’s commitments with contracts are as follows:
Primary Government:
Remaining
Project Spent-to-date Commitment
Design School Street compound building $ 388,765 $ 78,985
US 1 widening – utility replacement 423,534 275,875
Citywide Street Paving 80,090 84,970
S. Mainland 42” water main construction 16,671,670 2,541,952
S. Gateway traffic circle 91,148 152,452
Maryland & Delannoy streetscape - 804,783
Paving and drainage improvements - 68,717
New City Hall building – construction and materials 6,039,336 519,149
Totals $ 23,694,543 $ 4,526,883
Discretely Presented Component Unit (Diamond Square):
Remaining
Project Spent-to-date Commitment
Paving and drainage improvements $ - $ 99,820
The above remaining commitment balances include accounts and retainages payable recorded in the City’s financial statements as of September 30, 2009.
CITY OF COCOA, FLORIDA
Notes to Financial Statements September 30, 2009
NOTE III – DETAILED NOTES ON ALL FUNDS (CONTINUED) E. Interfund receivables, payable and transfers
The composition of interfund balances as of September 30, 2009, is as follows:
Due to/from other funds:
Receivable Fund Payable Fund Amount
General Non Major – Governmental Funds $ 18,501
Cocoa Redevelopment Agency 181,853
200,354
Capital Projects Fund Cocoa Redevelopment Agency 41,591
Total $ 241,945
Advance to/from other funds:
Receivable Fund Payable Fund Amount
General Cocoa Redevelopment Agency $ 1,575,494
Capital Projects Fund Cocoa Redevelopment Agency 1,080,580
Total $ 2,656,074
The balances due to the General fund by the Cocoa Redevelopment Agency represent loans to the Special Revenue fund to pay for a portion of Whitley Bay boardwalk and promenade, and a loan to pay for the purchase of certain real property within the boundaries of the redevelopment area. The balance due to the Capital Projects fund by the Cocoa Redevelopment Agency represents a loan to the Special Revenue fund to pay for certain capital improvement projects within the boundaries of the redevelopment area. All remaining interfund receivables and payables within the primary government represent cash transfers for operating and capital purposes.
Interfund transfers:
Transfers in: Transfers out: Amount
General Cocoa Redevelopment Agency $ 14,837
Non Major – Enterprise Fund 21,701
Water and Sewer 4,083,582
4,120,120
Capital Projects Cocoa Redevelopment Agency 51,845
Non Major – Governmental Funds General 1,200,000
Total $ 5,371,965
CITY OF COCOA, FLORIDA
Notes to Financial Statements September 30, 2009
NOTE III – DETAILED NOTES ON ALL FUNDS (CONTINUED) E. Interfund receivables, payable and transfers
Significant transfers included $3,321,363 from the Water and Sewer System fund to the General fund for operations, $762,219 from the Water and Sewer System fund to the General fund for payments in lieu of taxes, and $1,200,000 from the General fund to a non-major governmental fund for debt service requirements.
Transfers from the Water and Sewer System fund to the General fund for operations are allowable under the City’s revenue bond debt covenants. The City makes actual transfers during the year based on the original budgeted amount approved by City Council. Total allowable transfers are calculated based on the net revenues of the water and sewer system. For the year ended September 30, 2009 total actual transfers exceeded allowable transfers by approximately $512,000. The City intends to reduce the transfer from the Water and Sewer fund to the General fund by this amount in 2010.