HomeMy Public PortalAbout09 Other Governmental Funds - Special RevenueCOMPREHENSIVE
ANNUAL
FINANCIAL REPORT
CITY OF RANCHO MIRAGE, CALIFORNIA
I
NONMAJOR SPECIAL REVENUE FUNDS
Special Revenue Funds are used to account for the proceeds of specific revenue
sources that are restricted by law to expenditure for specified purposes.
The LANDSCAPE AND LIGHTING
DISTRICTS FUND is used to account for the
revenues and expenditures associated with the
maintenance of landscaped streets and
medians and the City's street lighting.
The COMMUNITY FACILITIES DISTRICT
FUND is used to account for the revenues from
Community Facilities Districts established to
provide additional funding for police, fire and
library services.
The COMMUNITY SERVICES DISTRICT
FUND is used as a funding conduit for library
and fire services.
The PARKLAND FUND is used to account
for the revenues and expenditures associated
with the City's park and recreation facilities.
The GAS TAX FUND is used to account for
the state gasoline tax revenues which are used
for maintenance and improvement of the City's
streets.
107
The AB 939 RECYCLING PROGRAMS
FUND is used to account for the revenues and
expenditures related to regional solid waste
management programs.
The TRAFFIC SAFETY FUND is used to
account for the revenues and expenditures in
connection with fines and forfeitures received
for state motor vehicle code violations.
The TRANSPORTATION MEASURE A
FUND is used to account for a I /2% sales tax
that is required to be used for the maintenance
and improvement of City streets.
The AIR POLLUTION REDUCTION FUND
is used to account for revenues and
expenditures related to air pollution mitigation
efforts.
The RENT CONTROL FUND is used to
account for funds collected from mobilehome
park owners and used to provide professional
assistance on their behalf.
The STORM WATER OUALITY FUND is
used to account for revenues and expenditures
related to the reduction of water pollution.
Total assets 230,288 83,271 268,148 3,351,200 928,580
Assets
Cash and investments 214,162 64 3,325,499 868,761
Interest receivable 155 1,731 2,264 467
Accounts receivable 11,269
Due from other governments 15,971 81,476 268,148 12,168 59,352
Liabilities and Fund Balances
CITY OF RANCHO MIRAGE
COMBINING BALANCE SHEET
NONMAJOR SPECIAL REVENUE FUNDS
Year ended June 30, 2009
Landscape Community Community
and Lighting Facilities Services Parkland
Districts District District Fund Gas Tax
Liabilities:
Accounts payable 21,740 64 18,527 63,771
Accrued salaries and benefits 4,704
Due to other funds 83,207 268,148
Due to other governments
Deposits payable 3,515
Total liabilities 21,740 83,271 268,148 26,746 63,771
Fund balances:
Reserved for encumbrances 415,186
Reserved for Cancer Survivor's Park 50,000
Reserved for Quimby fees 1,650,046
Unreserved:
Designated for unrealized gains and (losses) 79,096 16,728
Designated for public facilities 88,584
Designated for continuing
appropriations 526,924 432,895
Undesignated 208,548 929,804
Total fund balance (deficit) 208,548 3,324,454 864,809
Total liabilities and fund balances 230,288 83,271 268,148 3,351,200 928,580
108
AB 939 Total Nonmajor
Recycling Traffic Transportation Air Pollution Rent Storm Water Special Revenue
Programs Safety Measure A Reduction Control Ouality Funds
3,146,860 10,204 4,387,302 120,218 11,779 214,778 12,299,627
2,174 48 2,858 84 8 156 9,945
70,000 161,955 5,332 248,556
14,025 164,129 404,173 1,019,442
3.219,034 24,277 4,716,244 125,634 11,787 619,107 13,577,570
10,424
10,424 228,750 2,400 3,303 708,553
15,000 2,484,705
228,750 3,303 346,579
4,704
351,355
2,400 2,400
3,515
74,870 98,852 269,546
88,584
1,903,937 2,863,756
3,118,740 24,277 123,234 11,787 593,804 5,010,194
3,208,610 24,277 4,487,494 123,234 11,787 615,804 12,869,017
3,219,034 24,277 4,716,244 125,634 11,787 619,107 13,577,570
109
22,000
2,936,891
50,000
1,650,046
Revenues:
Taxes
Intergovernmental
Charges for services
Fines and forfeitures
Special assessments
Interest income
Net increase (decrease)
in investment fair value
Miscellaneous
Total revenues
CITY OF RANCHO MIRAGE
COMBINING STATEMENT OF REVENUES, EXPENDITURES
AND CHANGES IN FUND BALANCES
NONMAJOR SPECIAL REVENUE FUNDS
Year ended June 30, 2009
Landscape Community Community
and Lighting Facilities Services
Districts District District Parkland Gas Tax
3,356,651
1,656,214 50,346 421,105
33,739
523,425 2,865,447 1,070,019 401,387
8,969 49,133 137,475 29,377
49,439 10,201
9,021
532,394 2,914,580 6,082,884 681,407 460,683
Expenditures:
Current:
General government 43,537
Public works 677,700
Cultural and recreation 542,695
Capital projects 367,789
Total expenditures 677,700 43,537 542,695 367,789
Excess (deficiency) of revenues
over (under) expenditures (145,306) 2,871,043 6,082,884 138,712 92,894
Other financing sources (uses):
Transfers in 2,714 1,858
Transfers out (2,884,626) (6,082,884)
Total other financing sources (uses) 2,714 (2,884,626) (6,082,884) 1,858
Total change in fund balances (142,592) (13,583) 140,570 92,894
Fund balances, beginning of year, as restated 351,140 13,583 3,183,884 771,915
Fund balances (deficit), end of year 208,548 3,324,454 864,809
110
AB 939 Total Nonmajor
Recycling Traffic Transportation Air Pollution Rent Storm Water Special Revenue
Programs Safety Measure A Reduction Control Oualitv Funds
692,069 4,048,720
481,905 19,681 2,629,251
247,179 2,295 283,213
86,841 86,841
246,173 5,106,451
132,397 1,921 169,643 5,007 452 10,678 545,052
47,460 62,398 169,498
22 9,043
427,058 88,762 1,406,015 24,688 2,747 256,851 12,878,069
175,657 9,314 53 228,561
88,762 60,748 827,210
542,695
937,103 1,304,892
175,657 88,762 937,103 9,314 53 60,748 2,903,358
251,401 468,912 15,374 2,694 196,103 9,974,711
251,401 468,912 15,374 2,694 196,789 1,012,459
2,957,209 24,277 4,018,582 107,860 9,093 419,015 11,856,558
3,208,610 24,277 4,487 494 123,234 11,787 615,804 12,869,017
111
686 5,258
(8,967,510)
686 (8.962,252)
Revenues:
Special assessments
Interest income
Total revenues
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
LANDSCAPE AND LIGHTING DISTRICTS
NONMAJOR SPECIAL REVENUE FUND
Year ended June 30, 2009
517,972 523,425
7,000 8,969
524,972 532,394
Expenditures:
Current:
Public works 680,015 677,700 2,315
Total expenditures 680,015 677,700 2,315
Excess (deficiency)
of revenues over
(under) expenditures (155,043) (145,306) 9,737
Other financing sources (uses):
Transfers in 3,707 2,714 (993)
Total other financing
sources (uses) 3,707 2,714 (993)
Total change in fund balance (151,336) (142,592) 8,744
Fund balances, beginning of year 351,140 351,140
Fund balances (deficit), end of year 199,804 208,548 8,744
112
Final
Budget
Actual
Variance with
Final Budget
Positive
(Neeativel
5,453
1,969
7,422
Revenues:
Special assessments
Interest income
Total revenues
Excess (deficiency)
of revenues over
(under) expenditures
Other financing sources (uses):
Transfers out
Total other financing
sources (uses)
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
COMMUNITY FACILITIES DISTRICT
NONMAJOR SPECIAL REVENUE FUND
Year ended June 30, 2009
113
Final
Budget
Actual
Variance with
Final Budget
Positive
(Negative)
2,811,502 2,865,447 53,945
256,906 49,133 (207,773)
3,068,408 2,914,580 (153,828)
Expenditures:
Current:
General Government 83,933 43,537 40,396
Total expenditures 83,933 43,537 40,396
2,984,475 2,871,043 (113,432)
(3,012,962) (2,884,626) 128,336
(3,012,962) (2,884,626) 128,336
Total change in fund balance (28,487) (13,583) 14,904
Fund balances, beginning of year 13,583 13,583
Fund balances (deficit), end of year (14,904) 14,904
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
COMMUNITY SERVICES DISTRICT
NONMAJOR SPECIAL REVENUE FUND
Year ended June 30, 2009
114
Final
Budget
Actual
Variance with
Final Budget
Positive
(Negative)
Revenues:
Taxes 2,771,900 3,356,651 584,751
Intergovernmental 1,403,880 1,656,214 252,334
Special assessments 1,166,500 1,070,019 (96,481)
Total revenues 5,342,280 6,082,884 740,604
Other financing sources (uses)
Transfers out (6,082,885) (6,082,884) 1
Total other financing
sources (uses) (6,082,885) (6,082,884) 1
Total change in fund balance (740,605) 740,605
Fund balances, beginning of year
Fund balances (deficit), end of year (740,605) 740,605
Revenues:
Intergovernmental
Charges for Services
Special assessments
Developer fees
Interest income
Net increase (decrease) in
investment fair value
Miscellaneous
Total revenues
Expenditures:
Current:
Cultural and recreation
Total expenditures
Excess (deficiency)
of revenues over
(under) expenditures
Other financing sources (uses):
Transfers in
Total other financing
sources (uses)
Total change in fund balance
Fund balances, beginning of year
Fund balances (deficit), end of year
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
PARKLAND
NONMAJOR SPECIAL REVENUE FUND
Year ended June 30, 2009
Final
Budget
43,606
419,700
97,500
57,000
(431,670)
3,183,884
2,752,214
115
617,806
1,051,334
1,051,334
Actual
50,346
33,739
401,387
137,475
49,439
9,021
681,407
542,695
542,695
(433,528) 138,712
1,858 1,858
1,858 1,858
140,570
3,183,884
3,324,454
Variance with
Final Budget
Positive
(Negative)
6,740
33,739
(18,313)
(97,500)
80,475
49,439
9,021
63,601
508,639
508,639
572,240
572,240
572,240
Revenues:
Intergovernmental
Interest income
Net increase (decrease) in
investment fair value
Total revenues
Current:
Capital projects
Total expenditures
Fund balances, beginning of year
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
GAS TAX
NONMAJOR SPECIAL REVENUE FUND
Year ended June 30, 2009
505,619
20,600
116
Final
Budget
526,219
1,376,767
1,376,767
Excess (deficiency)
of revenues over
(under) expenditures (850,548)
771,915
Fund balances (deficit), end of year (78,633)
Actual
421,105
29,377
10,201
460,683
367,789
367,789
Variance with
Final Budget
Positive
(Negative)
(84,514)
8,777
10,201.00
(65,536)
1,008,978
1,008,978
92,894 943,442
771,915
864,809 943,442
Expenditures:
Current:
General government
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
AB 939 RECYCLING PROGRAMS
NONMAJOR SPECIAL REVENUE FUND
Year ended June 30, 2009
Variance with
Final Budget
Final Positive
Budget Actual (Negative)
Revenues:
Charges for services 260,000 247,179 (12,821)
Interest income 135,100 132,397 (2,703)
Net increase (decrease) in investment
fair value 47,460 47,460
Miscellaneous 22 22
Total revenues 395,100 427,058 31,958
331,558
Total expenditures 331,558
175,657 155,901
175,657 155,901
Excess (deficiency)
of' revenues over
(under) expenditures 63,542 251,401 187,859
Fund balances, beginning of year 2,957,209 2,957,209
Fund balances (deficit), end of year 3,020,751 3,208,610 187,859
117
Total expenditures
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
TRAFFIC SAFETY
NONMAJOR SPECIAL REVENUE FUND
Year ended June 30, 2009
Variance with
Final Budget
Final Positive
Budget Actual (Negative)
Revenues:
Fines and forfeitures 51,000 86,841 35,841
Interest income 500 1,921 1,421
Total revenues 51,500 88,762 37,262
Expenditures:
Current:
Public works 88,762 88,762
Excess (deficiency)
of revenues over
(under) expenditures (37,262.00) 37,262
Fund balances, beginning of year 24,277 24,277
Fund balances (deficit), end of year (12,985) 24,277 37,262
118
88,762 88,762
Revenues:
Taxes
Intergovernmental
Interest income
Net increase (decrease) in investment
fair value
Total revenues
Expenditures:
Capital projects
Total expenditures
Fund balances, beginning of year
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
TRANSPORTATION MEASURE A
NONMAJOR SPECIAL REVENUE FUND
Year ended June 30, 2009
Final
Budget
1,058,200
Excess (deficiency)
of revenues over
(under) expenditures (6,349,556)
4,018,582
Fund balances (deficit), end of year (2,330,974)
119
Actual
692,069
481,905
30,000 169,643
62,398
1,088,200 1,406,015
7,437,756 937,103
7,437,756 937,103
468,912
4,018,582
4,487,494
Variance with
Final Budget
Positive
(Negative)
(366,131)
481,905
139,643
62,398
317,815
(6,500,653)
(6,500,653)
6,818,468
6,818,468
Total revenues
Expenditures:
Current:
General government
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
AIR POLLUTION REDUCTION
NONMAJOR SPECIAL REVENUE FUND
Year ended June 30, 2009
Variance with
Final Budget
Final Positive
Budget Actual �Neeativel
Revenues:
Intergovernmental 22,000 19,681 (2,319)
Interest income 5,700 5,007 (693)
Total expenditures 9,833 9,314 519
Excess (deficiency)
of revenues over
(under) expenditures 17,867 15,374
Fund balances, beginning of year 107,860 107,860
Fund balances (deficit), end of year 125,727 123,234 (2,493)
120
27,700 24,688 (3,012)
9,833
9,314 519
(2,493)
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
RENT CONTROL
NONMAJOR SPECIAL REVENUE FUND
Year ended June 30, 2009
Final
Budget
Actual
Revenues:
Charges for services 2,500 2,295
Interest income 452
Total revenues 2,500 2,747
Expenditures:
Current:
General government 6,500 53
Total expenditures 6,500 53
Total change in fund balance (4,000) 2,694
Fund balances, beginning of year 9,093 9,093
Fund balances (deficit), end of year 5,093 11,787
121
Variance with
Final Budget
Positive
Neeativel
(205)
452
247
6,447
6,447
6,694
6,694
CITY OF RANCHO MIRAGE
BUDGETARY COMPARISON SCHEDULE
STORM WATER QUALITY
NONMAJOR SPECIAL REVENUE FUND
Year ended June 30, 2009
Variance with
Final Budget
Final Positive
Budget Actual (Neeativel
Revenues:
Special assessments 89,100 246,173 157,073
Interest income 25,200 10,678 (14,522)
Total revenues
Expenditures:
Current:
Public works 89,100 60,748 28,352
Total expenditures
114,300 256,851 142,551
89,100 60,748 28,352
Excess (deficiency)
of revenues over
(under) expenditures 25,200 196,103 170,903
Other financing sources (uses):
Transfers in 686 686
Total other financing
sources (uses) 686 686
Total change in fund balance 25,886 196,789 170,903
Fund balances, beginning of year 419,015 419,015
Fund balances (deficit), end of year 444,901 615,804 170,903
122