HomeMy Public PortalAbout11 Other Governmental Funds - Special RevenueCity of Rancho Mirage
California
Comprehensive Annual Financial Report
YEAR ENDED JUNE 30, 2003 tf
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 GAS TAX FUND is used to account for
the state gasoline tax revenues which are used
for maintenance and improvement ofthe City's
streets.
• The BRIDGE TAX FUND is used to account
for funds received from a special tax on new
construction and used for the maintenance and
improvement of bridges. The tax is tw longer
collected.
• The DEVELOPMENT FEE FUND is used to
account for revenues received from a special
tax on new construction and used to construct
public facilities needed as a result ofthe impact
of growth. This is no longer collected.
• The COMMUNITY SERVICES DISTRICT
FUND is used as a funding conduit for library
and fire services.
• The TIPPING FEE FUND is used to account
for the revenues and expenditures related to
regional solid waste management programs.
89
• 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 '''A% 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 LIBRARY FUND is used to account for
revenues and expenditures associated with the
provision of public library services.
• 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 QUALITY FUND is
used to account for revenues and expenditures
related to the reduction of water pollution.
• The LOW COST HOUSING FUND is used to
account for monies set aside for assistance to
low and moderate income households before
the monies are transferred to the Housing
Authority Fund.
Assets
Cash and investments
Interest receivable
Accounts receivable
Trust receivable
Due from other governments
Due from other funds
Total assets
Liabilities and Fund Balances
Liabilities:
Accounts payable
Accrued salaries and benefits
Due to other governments
Due to other funds
Deferred revenue
Total liabilities
Fund balances:
Reserved for encumbrances
Unreserved:
Designated for unrealized gains and (losses)
Designated for equipment replacement
Designated for continuing
appropriations
Undesignated
Total fund balance (deficit)
Total liabilities and fund
balances
CITY OF RANCHO MIRAGE
NONMAJOR SPECIAL REVENUE FUNDS
COMBINING BALANCE SHEET
JUNE 30, 2003
Landscape
and Lighting
Districts Gas Tax
$ 515,781 876,611 141,594
409 688 117
35,734 10,154
$ 551,924 887,453 141,711
$ 54,551
2,091
56,642
1,224
10,797
483,261 706,163 (6,529) 41,829 - 1,896,789
495,282 887,453 (6,529) 41,829 - 1,935,232
$ 551,924 887,453 141,711 41,829 185,218 1,935,232
90
34,900
19,780
126,610
Community
Bridge Development Services Tipping
Tax Fees District Fee
- 148,240
- 148,240
41,795
- 1,788,069
34 - 1,338
145,825
185,218
41,829 185,218 1,935,232
185,218
185,218
38,443
Total Nonmajor
Traffic Transportation Air Pollution Rent Storm Water Low Cost Special Revenue
Safety Measure A Reduction Library Control Quality Housin Funds
2,074,904 35,203 1,707,350 4,614 71,825 7,257,746
31 1,584 28 1,199 4 61 - 5,493
- - 145,825
9,890 9,890
10,112 4,100 - 249,435 494,753
93,971 269,787 363,758
10,143 2,076,488 39,331 1,812,410 4,618 321,321 269,787 8,277,465
24,274 1,471 80,296
2,949 - - 2,949
148,240
- 269,787 457,096
9,890 9,890
37,113 1,471 269,787 698,471
62,543 31,489 - 130,156
45,521 - 34,458 - - 148,999
1,968,424 22,940 2,117,974
10,143 16,391 1,709,350 4,618 319,850 - 5,181,865
10,143 2,076,488 39,331 1,775,297 4,618 319,850 - 7,578,994
10,143 2,076,488 39,331 1,812,410 4,618 321,321 269,787 8,277,465
91
Revenues:
Taxes $ - 1,543,979 -
Intergovemmental 311,945 - 875,004
Charges for services - 11,034 31 285,553
Fines and forfeitures -
Special Assessments 468,411 947,245 -
Interest income 16,058 27,470 5,143 1,517 - 51,874
Net Increase (decrease) in investment
fair value 3,471 10,330 16,451
Miscellaneous -
Total revenues
Expenditures:
Current:
General government
Public works
Cultural and recreation
Capital projects
Total expenditures
Other financing sources (uses).
Transfers in
Transfers out
CITY OF RANCHO MIRAGE
NONMAJOR SPECIAL REVENUE FUNDS
COMBINING STATEMENT OF REVENUES,
EXPENDITURES AND CHANGES IN FUND BALANCES
YEAR ENDED JUNE 30, 2003
Landscape Community
and Lighting Development Services Tipping
Districts Gas Tax Bridge Tax Fee District Fees
487,940 360,779 5,143 1,548 3,366,228 353,878
479,173 1,276
101,193
479,173 102,469
Excess (deficiency) of revenues
over (under) expenditures 8,767 258,310 5,143 1,548 3,366,228 353,878
2,166
Total other financing sources
(uses) 2,166 - (3,366,228)
Total change in fund balance 10,933 258,310 5,143 1,548 353,878
Fund balances, beginning of year 484,349 629,143 (11,672) 40,281 - 1,581,354
Fund balances (deficit), end of year $ 495,282 887,453 (6,529) 41,829 1,935,232
92
(3,366,228)
Total Nonmajor
Traffic Transportation Air Pollution Rent Storm Water Low Cost Special Revenue
Safety Measure A Reduction Library Control Quality Housing Funds
613,840 - 2,157,819
20,598 190,379 - 1,397,926
6,400 - 2,404 305,422
77,873 31,929 - 109,802
80,000 - 1,495,656
1,444 65,632 1,380 47,469 144 3,093 - 221,224
17,820 9,998 - 58,070
114,188 - - 114,188
79,317 703,692 21,978 393,963 2,548 83,093 - 5,860,107
5,938 516 80,948 87,402
3,960 - 35,680 520,089
- 1,453,972 - 1,453,972
112,686 484,203 22,941 - 721,023
116,646 484,203 28,879 1,453,972 516 35,680 80,948 2,782,486
(37,329) 219,489 (6,901) (1,060,009) 2,032 47,413 (80,948) 3,077,621
1,348,643 384 4,275,551 5,626,744
(243,735) - (4,194,603) (7,804,566)
1,104,908 384 80,948 (2,177,822)
(37,329) 219,489 (6,901) 44,899 2,032 47,797 899,799
47,472 1,856,999 46,232 1,730,398 2,586 272,053 - 6,679,195
10,143 2,076,488 39,331 1,775,297 4,618 319,850 7,578,994
93
Total expenditures
CITY OF RANCHO MIRAGE
NONMAJOR SPECIAL REVENUE FUNDS
LANDSCAPE AND LIGHTING DISTRICTS
BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2003
Variance with
Final Budget
Final Positive
Budget Actual (Negative)
Revenues:
Taxes -
Intergovernmental -
Licenses and permits -
Charges for services -
Fines and forfeitures -
Special assessments 467,273 468,411 1,138
Developer fees -
Interest income 8,450 16,058 7,608
Net increase (decrease) in investment
fair value - 3,471 3,471
Miscellaneous -
Total revenues 475,723 487,940 12,217
Expenditures:
Current:
General government -
Public safety
Public works 650,968 479,173 171,795
Cultural and recreation
Capital projects
650,968 479,173 171,795
Excess (deficiency)
of revenues over
expenditures (175,245) 8,767 184,012
Other financing sources (uses):
Transfers in 2,589 2,166 (423)
Transfers out
Total other financing
sources (uses) 2,589 2,166 (423)
Total change in fund balance (172,656) 10,933 183,589
Fund balances, beginning of year 484,349 484,349
Fund balances (deficit), end of year 311,693 495,282 183,589
94
CITY OF RANCHO MIRAGE
NONMAJOR SPECIAL REVENUE FUNDS
GAS TAX
BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2003
Variance with
Final Budget
Final Positive
Budget Actual 'Negative)
Revenues:
Taxes -
Intergovernmental 224,730 311,945 87,215
Licenses and permits 11,034 11,034
Charges for services -
Fines and forfeitures
Special assessments -
Developer fees
Interest income 7,000 27,470 20,470
Net increase (decrease) in investment
fair value 10,330 10,330
Miscellaneous
Total revenues
231,730 360,779 129,049
Expenditures:
Current:
General government
Public safety
Public works 1,600 1,276 324
Cultural and recreation
Capital projects 693,158 101,193 591,965
Total expenditures 694,758 102,469 592,289
Excess (deficiency)
of revenues over
expenditures (463,028) 258,310 721,338
Other fmancing sources (uses):
Transfers in
Transfers out
Total other financing
sources (uses) -
Total change in fund balance (463,028) 258,310 721,338
Fund balances, beginning of year 629,143 629,143
Fund balances (deficit), end of year 166,115 887,453 721,338
95
Revenues:
Taxes -
Intergovernmental - -
Licenses and permits
Charges for services - -
Fines and forfeitures - -
Special assessments -
Developer fees - -
Interest income 10,000 5,143 (4,857)
Net increase (decrease) in investment
fair value -
Miscellaneous -
Total revenues
CITY OF RANCHO MIRAGE
NONMAJOR SPECIAL REVENUE FUNDS
BRIDGE TAX
BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2003
Variance with
Actual; Final Budget
Final (Budgetary Positive
Budget Basis) (Negative)
10,000 5,143 (4,857)
Expenditures:
Current:
General government
Public safety
Public works -
Cultural and recreation
Capital projects 50,000 50,000
96
Total expenditures 50,000 50,000
Other financing sources (uses):
Transfers in
Transfers out
Excess (deficiency)
of revenues over
expenditures (40,000) (44,857) (4,857)
Total other financing
sources (uses) - -
Total change in fund balance (40,000) (44,857) (4,857)
Fund balances, beginning of year (11,672) (11,672)
Fund balances (deficit), end of year (51,672) (56,529) (4,857)
Revenues:
Taxes
Intergovernmental
Licenses and permits
Charges for services - 31 31
Fines and forfeitures -
Special assessments -
Developer fees -
Interest income 1,517 1,517
Net increase (decrease) in investment
fair value
Miscellaneous
Total revenues
Expenditures:
Current:
General government
Public safety
Public works
Cultural and recreation
Capital projects
Total expenditures
Excess (deficiency)
of revenues over
Other financing sources (uses):
Transfers in
Transfers out
CITY OF RANCHO MIRAGE
NONMAJOR SPECIAL REVENUE FUNDS
DEVELOPMENT FEE
BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2003
Total other financing
sources (uses)
Total change in fund balance 1,548
Fund balances, beginning of year 40,281 40,281
Fund balances (deficit), end of year 40,281 41,829
97
Variance with
Final Budget
Final Positive
Budget Actual (Negative)
1,548 1,548
expenditures 1,548 1,548
1,548
1,548
Developer fees
Interest income
Net increase (decrease) in investment
fair value
Miscellaneous
Expenditures:
Current:
General government
Public safety
Public works
Cultural and recreation
Capital projects
Total expenditures
CITY OF RANCHO MIRAGE
NONMAJOR SPECIAL REVENUE FUNDS
COMMUNITY SERVICES DISTRICT
BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2003
Revenues:
Taxes 1,552,200 1,543,979 (8,221)
Intergovernmental 860,100 875,004 14,904
Licenses and permits
Charges for services
Fines and forfeitures
Special assessments 940,000 947,245 7,245
98
Variance with
Final Budget
Final Positive
Budget Actual {Negative!
Total revenues 3,352,300 3,366,228 13,928
Excess (deficiency)
of revenues over
expenditures 3,352,300 3,366,228 13,928
Other financing sources (uses):
Transfers in
Transfers out (3,367,200) (3,366,228) 972
Total other financing (3,367,200) (3,366,228) 972
sources (uses)
Total change in fund balance (14,900) - 14,900
Fund balances, beginning of year
Fund balances (deficit), end of year (14,900) 14,900
Revenues:
Taxes
Intergovernmental
Licenses and permits
Charges for services
Fines and forfeitures
Special assessments
Developer fees
Interest income
Net increase (decrease) in investment
fair value
Miscellaneous
Total revenues
CITY OF RANCHO MIRAGE
NONMAJOR SPECIAL REVENUE FUNDS
TIPPING FEES
BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2003
Variance with
Final Budget
Final Positive
Budget Actual (Negative)
217,938 285,553 67,615
20,000 51,874 31,874
16,451 16,451
237,938 353,878 115,940
Expenditures:
Current:
General government 140,000 140,000
Public safety -
Public works
Cultural and recreation
Capital projects
Total expenditures 140,000 - 140,000
Excess (deficiency)
of revenues over
expenditures 97,938 353,878 255,940
Other financing sources (uses):
Transfers in
Transfers out
Total other financing
sources (uses)
Total change in fund balance 97,938 353,878 255,940
Fund balances, beginning of year 1,581,354 1,581,354
Fund balances (deficit), end of year 1,679,292 1,935,232 255,940
99
CITY OF RANCHO MIRAGE
NONMAJOR SPECIAL REVENUE FUNDS
TRAFFIC SAFETY
BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2003
Variance with
Final Budget
Final Positive
Budget Actual (Negative)
Revenues:
Taxes - -
Intergovernmental
Licenses and permits
Charges for services -
Fines and forfeitures 50,000 77,873 27,873
Special assessments
Developer fees -
Interest income 8,000 1,444 (6,556)
Net increase (decrease) in investment
fair value -
Miscellaneous -
Total revenues
58,000 79,317 21,317
Expenditures:
Current:
General government - -
Public safety -
Public works - 3,960 (3,960)
Cultural and recreation - -
Capital projects 136,000 112,686 23,314
Total expenditures 136,000 116,646 19,354
Excess (deficiency)
of revenues over
expenditures (78,000) (37,329) 40,671
Other financing sources (uses):
Transfers in
Transfers out
100
Total other financing
sources (uses)
Total change in fund balance (78,000) (37,329)
Fund balances, beginning of year 47,472 47,472
Fund balances (deficit), end of year (30,528) 10,143
40,671
40,671
CITY OF RANCHO MIRAGE
NONMAJOR SPECIAL REVENUE FUNDS
TRANSPORTATION MEASURE A
BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2003
Variance with
Final Budget
Final Positive
Budget Actual (Negative)
Revenues:
Taxes 636,997 613,840 (23,157)
Intergovernmental
Licenses and permits
Charges for services 6,400 6,400
Fines and forfeitures - -
Special assessments
Developer fees
Interest income 90,000 65,632 (24,368)
Net increase (decrease) in investment
fair value 17,820 17,820
Miscellaneous - -
Total revenues 726,997 703,692 (23,305)
Expenditures:
Current:
General government
Public safety - -
Public works - -
Cultural and recreation - -
Capital projects 9,293,946 484,203 8,809,743
Total expenditures 9,293,946 484,203 8,809,743
Excess (deficiency)
of revenues over
expenditures (8,566,949) 219,489 8,786,438
Other financing sources (uses):
Transfers in
Transfers out
101
Total other financing -
sources (uses)
Total change in fund balance (8,566,949) 219,489 8,786,438
Fund balances, beginning of year 1,856,999 1,856,999
Fund balances (deficit), end of year (6,709,950) 2,076,488 8,786,438
CITY OF RANCHO MIRAGE
NONMAJOR SPECIAL REVENUE FUNDS
MR POLLUTION REDUCTION
BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2003
Variance with
Final Budget
Final Positive
Budget Actual (Negative)
Revenues:
Taxes
Intergovernmental 12,000 20,598 8,598
Licenses and permits
Charges for services
Fines and forfeitures
Special assessments
Developer fees
Interest income 1,800 1,380 (420)
Net increase (decrease) in
investment fair value -
Miscellaneous
Total revenues 13,800 21,978 8,178
Expenditures:
Current:
General government 14,000 5,938 8,062
Public safety
Public works
Cultural and recreation -
Capital projects 22,941 22,941
Total expenditures 36,941 28,879 8,062
Excess (deficiency)
of revenues over (23,141) (6,901) 16,240
expenditures
Other financing sources (uses):
Transfers in
Transfers out
Total other financing
sources (uses)
Total change in fund balance (23,141) (6,901) 16,240
Fund balances, beginning of year 46,232 46,232
Fund balances (deficit), end of year 23,091 39,331 16,240
102
Revenues:
Taxes
Intergovernmental 150,000 190,379 40,379
Licenses and permits -
Charges for services -
Fines and forfeitures 28,000 31,929 3,929
Special assessments -
Developer fees -
Interest income 66,000 47,469 (18,531)
Net increase (decrease) in
investment fair value 9,998 9,998
Miscellaneous 98,500 114,188 15,688
Total revenues 342,500 393,963 51,463
Expenditures:
Current:
General government -
Public safety
Public works
Cultural and recreation 1,595,988 1,453,972 142,016
Capital projects
Total expenditures 1,595,988 1,453,972 142,016
Excess (deficiency)
of revenues over (1,253,488) (1,060,009) 193,479
expenditures
Other financing sources (uses):
Transfers in 1,345,720 1,348,643 2,923
Transfers out (243,765) (243,735) 30
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
NONMAJOR SPECIAL REVENUE FUNDS
LIBRARY
BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2003
Final
Budget
Actual
1,101,955 1,104,908
(151,533) 44,899
1,730,398 1,730,398
1,578,865 1,775,297
103
Variance with
Final Budget
Positive
(Negativel
2,953
196,432
196,432
Total revenues
CITY OF RANCHO MIRAGE
NONMAJOR SPECIAL REVENUE FUNDS
RENT CONTROL
BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2003
Variance with
Final Budget
Final Positive
Budget Actual (Negative]
Revenues:
Taxes
Intergovernmental
Licenses and permits
Charges for services 4,200 2,404 (1,796)
Fines and forfeitures
Special assessments
Developer fees
Interest income 144 144
Net increase (decrease) in
investment fair value -
Miscellaneous -
4,200 2,548 (1,652)
Expenditures:
Current:
General government 11,000 516 10,484
Public safety
Public works -
Cultural and recreation -
Capital projects
Total expenditures 11,000 516 10,484
Excess (deficiency)
of revenues over (6,800) 2,032 8,832
expenditures
Other financing sources (uses):
Transfers in 6,800 (6,800)
Transfers out -
Total other financing
sources (uses) 6,800 (6,800)
Total change in fund balance 2,032 2,032
Fund balances, beginning of year 2,586 2,586
Fund balances (deficit), end of year 2,586 4,618 2,032
104
CITY OF RANCHO MIRAGE
NONMAJOR SPECIAL REVENUE FUNDS
STORM WATER QUALITY
BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2003
Variance with
Final Budget
Final Positive
Budget Actual (Negative)
Revenues:
Taxes
Intergovernmental
Licenses and permits
Charges for services -
Fines and forfeitures
Special assessments 80,000 80,000
Developer fees
Interest income 1,500 3,093 1,593
Net increase (decrease) in
investment fair value -
Miscellaneous - -
Total revenues 81,500 83,093 1,593
Expenditures:
Current:
General government
Public safety -
Public works 81,960 35,680 46,280
Cultural and recreation - -
Capital projects - -
Total expenditures 81,960 35,680 46,280
Excess (deficiency)
of revenues over (460) 47,413 47,873
expenditures
Other financing sources (uses):
Transfers in 460 384 (76)
Transfers out -
Total other financing
sources (uses) 460 384
Total change in fund balance 47,797
Fund balances, beginning of year 272,053 272,053
Fund balances (deficit), end of year 272,053 319,850
105
(76)
47,797
47,797
Revenues:
Taxes
Intergovernmental
Licenses and permits
Charges for services
Fines and forfeitures
Special assessments
Developer fees
Interest income
Net increase (decrease) in
investment fair value
Miscellaneous
Total revenues
CITY OF RANCHO MIRAGE
NONMAJOR SPECIAL REVENUE FUNDS
LOW COST HOUSING
BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2003
Variance with
Final Budget
Final Positive
Budget Actual (Negative)
Expenditures:
Current:
General government 77,600 80,948 (3,348)
Public safety -
Public works -
Cultural and recreation -
Capital projects
Total expenditures 77,600 80,948 (3,348)
Excess (deficiency)
of revenues over (77,600) (80,948) (3,348)
expenditures
Other fmancing sources (uses):
Transfers in 4,200,000 4,275,551 75,551
Transfers out (4,197,900) (4,194,603) 3,297
Total other financing
sources (uses) 2,100 80,948 78,848
Total change in fund balance (75,500) - 75,500
Fund balances, beginning of year -
Fund balances (deficit), end of year (75,500) 75,500
106