Loading...
HomeMy Public PortalAbout11 Other Governmental Funds- Special RevenueCOMPREHENSIVE a_ -ANNUAL FiNANciAL REPoRT 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 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 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 no longer collected. 111 • The TIPPING FEE 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 %% sales tax that is required to be used for the maintenance and improvement of City streets. The AIR POLL UTION RED UCTION FUND is used to account for revenues and expenditures related to airpollution 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 QUALITY FUND is used to account for revenues and expenditures related to the reduction of water pollution. CITY OF RANCHO MIRAGE COMBINING BALANCE SHEET NONMAJOR SPECIAL REVENUE FUNDS JUNE 30, 2005 Landscape Community and Lighting Services Parkland Bridge Districts District Fund Gas Tax Tax Assets Cash and investments $ 424,411 - 2,871,191 867,274 45,496 Cash and investments with fiscal agent - - - - - Interest receivable 241 - 1,797 641 30 Accounts receivable _ _ _ _ _ Due from other governments 16,316 209,567 19,921 46,154 - Due from other funds - - _ _ _ Loans receivable - - - - - Total assets $ 440,968 209,567 2,892,909 914,069 45,526 Liabilities and Fund Balances Liabilities: - - 57,392 Accounts payable $ 9,541 - 16,974 - - Accrued salaries and benefits - - 2,031 - - Due to other governments - - - - 48,240 Due to other funds - 209,567 - - - Advances from other funds - - 625,593 - - Deposits payable - - 82,835 - - Total liabilities 9,541 209,567 727,433 - 48,240 Fund balances: Reserved for encumbrances - - 57,392 27,423 - Reserved for loans receivable - - _ _ _ Reserved for Cancer Survivor's Park - - 50,000 - - Reserved for Quimby fees - - 1,275,649 - - Unreserved: Designated for unrealized gains and (losses) - - (8,720) - - Designated for equipment replacement _ _ _ - - Designated for public facilities - - 74,372 - - Designated for continuing appropriations - - 22,747 186,300 - Undesignated 431,427 - 694,036 700,346 (2,714) Total fund balance (deficit) 431,427 - 2,165,476 914,069 (2,714) Total liabilities and fund balances $ 440,968 209,567 2,,892,909 914,069 45,526 112 Assets Cash and investments Cash and investments with fiscal agent Interest receivable Accounts receivable Due from other governments Due from other funds Loans receivable Total assets CITY OF RANCHO MIRAGE COMBINING BALANCE SHEET NONMAJOR SPECIAL REVENUE FUNDS Liabilities and Fund Balances Liabilities: Accounts payable Accrued salaries and benefits Due to other governments Due to other funds Advances from other funds Deposits payable Total liabilities Fund balances: Reserved for encumbrances Reserved for loans receivable Reserved for Cancer Survivor's Park Reserved for Quimby fees Unreserved: Designated for unrealized gains and (losses) Designated for equipment replacement Designated for public facilities Designated for continuing appropriations Undesignated Total fund balance (deficit) Total liabilities and fund balances JUNE 30, 2005 Landscape Community and Lighting Services Districts District Parkland Bridge Fund Gas Tax Tax $ 424,411 - 2,871,191 867,274 45,496 241 - 1,797 641 30 16,316 209,567 19,921 46,154 - $ 440,968 209,567 2,892,909 914,069 45,526 914,069 45,526 $ 440,968 209,567 2,892,909 $ 9,541 - 16,974 - - - 2,031 - - - - - - 48,240 209,567 - - - - 625,593 - - - - 82,835 - - 9,541 209,567 727,433 - 48,240 57,392 27,423 - - - 50,000 - - - - 1,275,649 - - - - 74,372 - - - - 22,747 186,300 - 431,427 - 685,316 700,346 (2,714) 431,427 - 2,165,476 914,069 (2,714) $ 440,968 209,567 2,892,909 914,069 45,526 5,229 - 565,596 - 2,317 5,229 - 565,596 2,317 943 9,556 607,839 - - 2,031 50,557 209,567 - - 625,593 82,835 943 9,556 1,578,422 23,068 - 3,139,898 - - 12,058 3,259,839 - - - - - 50,000 - - - - - - 1,275,649 - - - - - - 74,372 - - - - - - 209,047 2,486,724 10,730 (1,064,921) 65,844 4,147 256,626 3,573,525 Total Nonmajor Tipping Traffic Transportation Air Pollution Rent Storm Water Special Revenue Fee Safety Measure A Reduction Control Quality Funds 2,343,906 - 2,340,504 62,966 5,087 120,162 9,080,997 - - 50,450 - - - 50,450 1,523 33 1,598 47 3 78 5,991 169,592 - - - - - 169,592 - 10,697 248,021 5,148 - 158,000 713,824 2,640,573 68,161 2,515,021 10,730 5,090 278,240 10,020,854 5,229 - 565,596 - 2,317 5,229 - 565,596 2,317 943 9,556 607,839 - - 2,031 50,557 209,567 - - 625,593 82,835 943 9,556 1,578,422 23,068 - 3,139,898 - - 12,058 3,259,839 - - - - - 50,000 - - - - - - 1,275,649 - - - - - - 74,372 - - - - - - 209,047 2,486,724 10,730 (1,064,921) 65,844 4,147 256,626 3,573,525 2,509,792 10,730 2,074,977 65,844 4,147 268,684 8,442,432 2,515,021 10,730 2,640,573 68,161 5,090 278,240 10,020,854 5,229 - 565,596 - 943 9,556 607,839 - Total Nonmajor Tipping Traffic Transportation Air Pollution Rent Storm Water Special Revenue Fee Safety Measure A Reduction Control Oualit Funds 2,343,906 - 2,340,504 62,966 5,087 120,162 9,080,997 - - 50,450 - - - 50,450 1,523 33 1,598 47 3 78 5,991 169,592 - - - - - 169,592 - 10,697 248,021 5,148 - 158,000 713,824 - 1,275,649 2,640,573 68,161 - - (23,861) 2,515,021 10,730 5,090 278,240 10,020,854 5,229 - 565,596 - 943 9,556 607,839 - - - - - - 2,031 - - 2,317 - - 50,557 - - - - - - 209,567 - - - - - - 625,593 - - - - - - 82,835 5,229 - 565,596 2,317 943 9,556 1,578,422 23,068 - 3,139,898 - - 12,058 3,259,839 - - - - - - 50,000 - - - - - 1,275,649 (7,389) - (7,752) - - - (23,861) - - - - - - 74,372 - - 2,987,517 - - - 3,196,564 2,494,113 10,730 (4,044,686) 65,844 4,147 256,626 609,869 2,509,792 10,730 2,074,977 65,844 4,147 268,684 8,442,432 2,515,021 10,730 2,640,573 68,161 5,090 278,240 10,020,854 113 CITY OF RANCHO MIRAGE COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES NONMAJOR SPECIAL REVENUE FUNDS Year ended June 30, 2005 Expenditures: Current: General government Public safety Public works Cultural and recreation Capital projects Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources (uses) Total change in fund balances Fund balances, beginning of year, as restated Fund balances (deficit), end of year 519,147 - - - - - - 451,343 - - - - - 565,841 - 519,147 - 451,343 565,841 - (22,760) 4,148,420 108,9422( 17,431) 1,283 2,589 - Landscape Community - - - 2,589 (4,148,420) 1,858 - - and Lighting Services 451,598 - 2,054,676 1,131,500 (3,997) $ 431,427 - Districts District Parkland Gas Tax Bridge Tax Revenues: Taxes $ - 2,045,130 - - - Intergovernmental - 1,099,914 - 317,347 - Licenses and permits - _ _ _ _ Charges for services - - 61,683 - - Fines and forfeitures - - - - - Special Assessments 485,460 1,003,376 330,808 - - Developer fees - - 99,704 - - Interest income 10,927 - 76,810 31,063 1,283 Net increase (decrease) in investment fair value - - (8,720) - - Miscellaneous - - - - - Total revenues 496,387 4,148,420 560,285 348,410 1,283 Expenditures: Current: General government Public safety Public works Cultural and recreation Capital projects Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources (uses) Total change in fund balances Fund balances, beginning of year, as restated Fund balances (deficit), end of year 519,147 - - - - - - 451,343 - - - - - 565,841 - 519,147 - 451,343 565,841 - (22,760) 4,148,420 108,9422( 17,431) 1,283 2,589 - 1,858 - - (4,148,420) - - - 2,589 (4,148,420) 1,858 - - (20,171) - 110,800 (217,431) 1,283 451,598 - 2,054,676 1,131,500 (3,997) $ 431,427 - 2,165,476 914,069 (2,714) 114 CITY OF RANCHO MIRAGE COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES NONMAJOR SPECIAL REVENUE FUNDS 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 Expenditures: Current: General government Public safety Public works Cultural and recreation Capital projects Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources (uses) Total change in fund balances Fund balances, beginning of year, as restated Fund balances (deficit), end of year Year ended June 30, 2005 Landscape Community - (4,148,420) - - - and Lighting Services (20,171) - 110,800 (217,431) 1,283 Districts District Parkland Gas Tax Bridge Tax $ - 2,045,130 - - - - 1,099,914 - 317,347 - - - 61,683 - 485,460 1,003,376 330,808 - - - - 99,704 - - 10,927 - 76,810 31,063 1,283 - - (8,720) - - 496,387 4,148,420 560,285 348,410 1,283 519,147 - - - - - - 451,343 - - - - - 565,841 - 519,147 - 451,343 565,841 (22,760) 4,148,420 108,942 (217,431) 1,283 2,589 - 1,858 - - - (4,148,420) - - - 2,589 (4,148,420) 1,858 - - (20,171) - 110,800 (217,431) 1,283 451,598 - 2,054,676 1,131,500 (3,997) $ 431,427 - 2,165,476 914,069 (2,714) 101,396 - - 18,494 6,962 - 126,852 53,438 - - 44,539 617,124 - - - - - - 451,343 - 3,627,376 - - - 4,193,217 101,396 53,438 3,627,376 18,494 6,962 44,539 5,388,536 272,742 10,387 (308,505) 11,088 (1,475) (40,737) Total Nonmajor Tipping Traffic Transportation Air Pollution Rent Storm Water Special Revenue Fees Safety Measure A Reduction Control Ouality Funds - - - 880,844 - - - 2,925,974 - - 2,387,690 27,901 - - 3,832,852 316,954 - - - 4,270 - 382,907 - 63,093 - - - - 63,093 - - - - 1,819,644 - - - - - - 99,704 64,573 732 58,089 1,681 1.52 3,802 249,112 (7,389) - (7,752) - - - (23,861) - - - - 1,065 - 1,065 374,138 63,825 3,318,871 29,582 5,487 3,802 9,350,490 101,396 - - 18,494 6,962 - 126,852 53,438 - - 44,539 617,124 - - - - - - 451,343 - 3,627,376 - - - 4,193,217 101,396 53,438 3,627,376 18,494 6,962 44,539 5,388,536 272,742 10,387 (308,505) 11,088 (1,475) (40,737) 3,961,954 - - - - 460 4,907 - - - - - - (4,148,420) - - - - - 460 (4,143,513) 272,742 10,387 (308,505) 11,088 (1,475) (40,277) (181,559) 2,237,050 343 2,383,482 54,756 5,622 308,961 8,623,991 2,509,792 10,730 2,074,977 65,844 4,147 268,684 8,442,432 101,396 - - 18,494 6,962 - 126,852 53,438 - - - 44,539 617,124 - - - - - 451,343 - 3,627,376 - - - 4,193,217 101,396 53,438 3,627,376 18,494 6,962 44,539 5,388,536 272,742 10,387 (308,505) 11,088 (1,475) (40,737) Total Nonmajor Tipping Traffic Transportation Air Pollution Rent Storm Water Special Revenue Fees Safety Measure A Reduction Control Oualit Funds - - - 880,844 - - - 2,925,974 - - 2,387,690 27,901 - - 3,832,852 316,954 - - - 4,270 - 382,907 - 63,093 - - - - 63,093 - - - - - - 1,819,644 - - - - - - 99,704 64,573 732 58,089 1,681 152 3,802 249,112 (7,389) - (7,752) - - - (23,861) - - - - 1,065 - 1,065 374,138 63,825 3,318,871 29,582 5,487 3,802 9,350,490 101,396 - - 18,494 6,962 - 126,852 53,438 - - - 44,539 617,124 - - - - - 451,343 - 3,627,376 - - - 4,193,217 101,396 53,438 3,627,376 18,494 6,962 44,539 5,388,536 272,742 10,387 (308,505) 11,088 (1,475) (40,737) 3,961,954 - - - - - 460 4,907 - - - - (4,148,420) - - - - 460 (4,143,513) 272,742 10,387 (308,505) 11,088 (1,475) (40,277) (181,559) 2,237,050 343 2,383,482 54,756 5,622 308,961 8,623,991 2,509,792 10,730 2,074,977 65,844 4,147 268,684 8,442,432 115 CITY OF RANCHO MIRAGE BUDGETARY COMPARISON SCHEDULE LANDSCAPE AND LIGHTING DISTRICTS NONMAJOR SPECIAL REVENUE FUND Year ended June 30, 2005 Revenues: Special assessments Interest income Total revenues Expenditures: Current: Public works Total expenditures Excess (deficiency) of revenues over expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources (uses) Total change in fund balance Fund balances, beginning of year Fund balances (deficit), end of year 116 Variance with Final Budget Final Positive Budget Actual Ne ative $ 488,924 485,460 (3,464) 6,550 10,927 4,377 495,474 496,387 913 636,566 519,147 117,419 636,566 519,147 117,419 (141,092) (22,760) 118,332 3,022 2,589 (433) 3,022 2,589 (433) (138,070) (20,171) 117,899 451,598 451,598 - $ 313,528 431,427 117,899 CITY OF RANCHO MIRAGE BUDGETARY COMPARISON SCHEDULE COMMUNITY SERVICES DISTRICT NONMAJOR SPECIAL REVENUE FUND Year ended June 30, 2005 Revenues: Taxes Intergovernmental Special assessments Total revenues Excess (deficiency) of revenues over expenditures Other financing sources (uses): Transfers out Total other financing sources (uses) Total change in fund balance Fund balances, beginning of year Fund balances (deficit), end of year Final Budget Actual $ 1,.856,900 2,045,130 1,036,001 1,099,914 942,000 1,003,376 3,834,901 4,148,420 3,834,901 4,148,420 (4,148,421) (4,148,420) (4,148,421) (4,148,420) (313,520) - $ (313,520) 117 Variance with Final Budget Positive Ne ative 188,230 63,913 61,376 313,519 313,519 1 1 313,520 313,520 CITY OF RANCHO MIRAGE BUDGETARY COMPARISON SCHEDULE PARKLAND NONMAJOR SPECIAL REVENUE FUND Year ended June 30, 2005 Other financing sources (uses): Transfers in 1,858 1,858 - Proceeds from land sale 625,593 - (625,593) Total other financing sources (uses) 627,451 1,858 (625,593) Total change in fund balance (269,713) 110,800 380,513 Fund balances, beginning of year 2,054,676 2,054,676 - Fund balances (deficit), end of year $ 1,784,963 2,165,476 380,513 W Variance with Final Budget Final Positive Budget Actual Ne ative Revenues: Charges for Services $ 42,416 61,683 19,267 Special assessments 390,230 330,808 (59,422) Developer fees 75,000 99,704 Interest income 57,000 76,810 19,810 Net increase (decrease) in investment fair value - (8,720) (8,720) Total revenues 564,646 560,285 (29,065) Expenditures: Current: Cultural and recreation 1,461,810 451,343 1,010,467 Total expenditures 1,461,810 451,343 1,010,467 Excess (deficiency) of revenues over expenditures (897,164) 108,942 1,006,106 Other financing sources (uses): Transfers in 1,858 1,858 - Proceeds from land sale 625,593 - (625,593) Total other financing sources (uses) 627,451 1,858 (625,593) Total change in fund balance (269,713) 110,800 380,513 Fund balances, beginning of year 2,054,676 2,054,676 - Fund balances (deficit), end of year $ 1,784,963 2,165,476 380,513 W CITY OF RANCHO MIRAGE BUDGETARY COMPARISON SCHEDULE GAS TAX NONMAJOR SPECIAL REVENUE FUND Year ended June 30, 2005 Revenues: Intergovernmental Interest income Total revenues Expenditures: Current: Capital projects Total expenditures Excess (deficiency) of revenues over expenditures Fund balances, beginning of year Fund balances (deficit), end of year 119 Final Budget Actual Variance with Final Budget Positive Ne ative $ 285,300 317,347 32,047 10,000 31,063 21,063 295,300 348,410 53,110 880,489 565,841 314,648 880,489 565,841 314,648 (585,189) (217,431) 1,131,500 1,131,500 367,758 $ 546,311 914,069 367,758 CITY OF RANCHO MIRAGE BUDGETARY COMPARISON SCHEDULE BRIDGE TAX NONMAJOR SPECIAL REVENUE FUND Year ended June 30, 2005 Revenues: Interest income Total revenues Expenditures: Current: Capital projects Total expenditures Excess (deficiency) of revenues over expenditures Fund balances, beginning of year Fund balances (deficit), end of year 120 Final Budget Actual Variance with Final Budget Positive Ne ative $ 2,700 1,283 (1,417) 2,700 1,283 (1,417) 50,000 - 50,000 50,000 - 50,000 (47,300) 1,283 48,583 (3,997) (3,997) $ (51,297) (2,714) 48,583 CITY OF RANCHO MIRAGE BUDGETARY COMPARISON SCHEDULE TIPPING FEES NONMAJOR SPECIAL REVENUE FUND Year ended June 30, 2005 Revenues: Charges for services Interest income Net increase (decrease) in investment fair value Total revenues Expenditures: Current: General government Total expenditures Excess (deficiency) of revenues over expenditures Fund balances, beginning of year Fund balances (deficit), end of year 121 262,475 262,475 101,396 161,079 101,396 161,079 23,967 272,742 248,775 2,237,050 2,237,050 $ 2,261,017 2,509,792 248,775 Variance with Final Budget Final Positive Budeet Actual Ne ative $ 221,442 316,954 95,512 65,000 64,573 (427) - (7,389) (7,389) 286,442 374,138 87,696 121 262,475 262,475 101,396 161,079 101,396 161,079 23,967 272,742 248,775 2,237,050 2,237,050 $ 2,261,017 2,509,792 248,775 CITY OF RANCHO MIRAGE BUDGETARY COMPARISON SCHEDULE TRAFFIC SAFETY NONMAJOR SPECIAL REVENUE FUND Year ended June 30, 2005 Revenues: Fines and forfeitures Interest income Total revenues Expenditures: Current: Public works Total expenditures Excess (deficiency) of revenues over expenditures Fund balances, beginning of year Fund balances (deficit), end of year 122 Final Budget $ 80,000 800 80,800 53,438 27,362 80,800 53,438 27,362 - 10,387 10,387 343 343 - $ 343 10,730 10,387 Variance with Final Budget Positive Actual Ne ative 63,093 (16,907) 732 (68) 63,825 (16,975) 80,800 53,438 27,362 80,800 53,438 27,362 - 10,387 10,387 343 343 - $ 343 10,730 10,387 CITY OF RANCHO MIRAGE BUDGETARY COMPARISON SCHEDULE TRANSPORTATION MEASURE A NONMAJOR SPECIAL REVENUE FUND Year ended June 30, 2005 Revenues: Taxes Intergovernmental Interest income Net increase (decrease) in investment fair value Total revenues Expenditures: Capital projects Total expenditures Excess (deficiency) of revenues over expenditures Fund balances, beginning of year Fund balances (deficit), end of year Variance with 123 Final Budget Final Positive Bud et Actual Ne ative $ 680,000 880,844 200,844 6,200,000 2,387,690 (3,812,310) 45,000 58,089 13,089 - (7,752) (7,752) 6,925,000 3,318,871 (3,606,129) 9,084,119 3,627,376 5,456,743 9,084,119 3,627,376 5,456,743 (2,159,119) (308,505) 1,850,614 2,383,482 2,383,482 - $ 224,363 2,074,977 1,850,614 123 CITY OF RANCHO MIRAGE BUDGETARY COMPARISON SCHEDULE AIR POLLUTION REDUCTION NONMAJOR SPECIAL REVENUE FUND Year ended June 30, 2005 Revenues: Intergovernmental Interest income Total revenues Expenditures: Current: General government Total expenditures Excess (deficiency) of revenues over expenditures Fund balances, beginning of year (as restated) Fund balances (deficit), end of year Final Budeet $ 15,000 Actual 27,901 1,681 Variance with Final Budget Positive Ne ative 12,901 381 29,582 13,282 62,940 18,494 44,446 62,940 18,494 44,446 (46,640) 11,088 54,756 54,756 $ 8,116 65,844 124 57,728 57,728 CITY OF RANCHO MIRAGE BUDGETARY COMPARISON SCHEDULE RENT CONTROL NONMAJOR SPECIAL REVENUE FUND Year ended June 30, 2005 Revenues: Charges for services Interest income Miscellaneous Total revenues Expenditures: Current: General government Total expenditures Excess (deficiency) of revenues over 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 125 Variance with Final Budget Final Positive Budeet Actual Ne ative $ 4,000 4,270 270 152 152 - 1,065 1,065 4,000 5,487 1,487 7,700 6,962 738 7,700 6,962 738 (3,700) (1,475) 2,225 3,700 - (3,700) 3,700 - (3,700) - (1,475) (1,475) 5,622 5,622 - $ 5,622 4,147 (1,475) 125 CITY OF RANCHO MIRAGE BUDGETARY COMPARISON SCHEDULE STORM WATER QUALITY NONMAJOR SPECIAL REVENUE FUND Year ended June 30, 2005 Revenues: Special assessments Interest income Total revenues Expenditures: Current: Public works Total expenditures Excess (deficiency) of revenues over 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 Variance with 94,573 44,539 50,034 94,573 44,539 50,034 (7,473) (40,737) (33,264) 460 460 a.1 (7,013) Final Budget Final Positive Budget Actual Ne ative $ 84,500 - (84,500) 2,600 3,802 1,202 87,100 3,802 (83,298) 94,573 44,539 50,034 94,573 44,539 50,034 (7,473) (40,737) (33,264) 460 460 a.1 (7,013) (40,277) (33,264) 308,961 308,961 - $ 301,948 268,684 (33,264) 126