Loading...
HomeMy WebLinkAbout08C General Fund Financial Report (Feb)CITY OF PALM DESERT General Fund Financial Report to February 28, 2021 (Vear to date) (YTD Budge t ba se d on prior year percentage or actual to budget) 2020-21 2020-21 2020-21 Prior Annual VTD VTD 2020-21 % VTD Budget Budget Actual to VTD Budget Actual Reve nues Sa les Tax 15,750,000 8,610,394 9,660,061 112% 10.417,210 Transient Occupancy Tax 8,514,5 17 4,351,749 4,136,106 95% 8,341,521 License, Permits, & Charges 3,104,847 1,645,106 1,643 ,546 100% 1,749,038 Property Tax 7,395,702 3,366,230 3,702,119 110% 3,572,267 Franchise Fees 3,125,550 888,755 771,174 87% 881,490 Interest In come a nd Rent 641,000 977,760 490,440 50% 1,854,847 State Subvention 4,501,600 2,363,990 2,276,405 96% 2,198,254 All Other s 3,084,111 3,465,237 3,840,149 111% 3 ,59 3,762 lnterFund Transfers In 2,526,010 980,253 1,98 5,740 203 % 950,000 TOTAL REVENUES 48,643,337 26,649,474 28,505,740 107% 33,558,389 rtor Annual VTD VTD 2020-21 % VTD Budget Budget Actual Enc umb. to VTD Budget Actual Expe nditures Police Serv ices 19,510,810 6,107,527 8,153,929 11 ,356,8 81 134% 6,973 ,194 General Government+ Contrib 13,800,550 8,522,342 9,383,021 1,400,466 110% 8,965,122 Public Works 6,514,205 3,608,074 3,413,122 847,590 95% 3,729,832 Parks 4,371,278 2,315,878 2,253,273 1,309.448 97% 2,384,306 Building and Safety 1,468,010 875,116 959,319 47,842 110% 1,09 0,892 Commu ni ty Deve lopment 3,028,2 14 1,740,913 1,598,588 440,488 92% 1,743.492 Econo mi c De velopment 3,375,709 1,960,384 1,338,935 1,175,159 68% 2.433,995 lnt er Fund Transfers Out 7,011,508 2,480,026 1,070,000 43% 3,400,000 TOTAL GEN FUND EXP 59,080,284 27,610,260 28,170,187 161577,874 102% 30,7201833 Total GF Exp and Encumb 44,748,061 Fire Protection Services 15,719,500 8,646,503 8,380,602 7,338,898 97% 7,081,887 Notes: 1. Interest earnings are allocated to al/funds that have cash balance at year end. 2. Sa les Tax is paid in estimated monthly payments and adjusted for each quarter: 1st -Feb. -May, 2nd -June -Aug, 3rd-Sept-Nov, 4th-Nov -Feb. 3. TOT is received on monthly basis for exa mple January co ll ection is paid in February. 4. Property Taxes are co ll ected from property owners in December and April bi annually and paid to the City in January and June . S. Department of Motor Vehicle fees are paid twice a year by the State on February and June. 6. Franchise Fees are paid throug h property tax co llection from Burtec and are paid in April for Time Warner. Edison and Gas Co. 7. Gen eral Gov. includes: City Co un cil, City Cle rk, City Attorney, City Manager, Finance, Audit, Human Resources, Info rmation Te ch., In surance 8. Economic Development includes: Community Promotions, Market, Visitor Information, Eco nomic Dev. ! ! ! t ! ! t t t t t ! ! ! ! ! ! Ex planation Includ es sa les tax reve nu e rece iv ed for July & Fe bruary for each year. Includ es payments received through Fe bruary 28, 2021 for July-Jan ua ry 2021 Lowe r reimbursments fr om government to date , BL f-$98,914 (13%)), Permits f +29,945 f 4%)) from prior year Rece iv e in lanuary and May of each Fi sca l Year. Lower waste franchise fees recogn ize d during the curre nt fiscal year. Current average Yield is 0.6173%; Prior YTD Yield was 1.95% Various diffe r e n ces; COV ID re imburse m e nts to date $663,425, various other fees lower, resu lting in net change. Fu nd 243 transfer for public safety costs. Exp lanation Includes July-Dece mber Police Service Con tracts Payments for thi s year; the prior years shows lu\y-November 2019 payments Includes payment of$3.464M to PERS for the City's a nnual required payment, in creased insura nce costs of$84,529 Landscape Co ntracts and Medi a ns pay ments Reduction in person el costs from vacat positi o n Promotion & Marketing costs decreased by $1,067,210; special eve nts ceased do to CO VIO a nd less marketing costs. $1.4M transferto IHUB from General Fund . Variance result of timi ng difference ofFire Billing, from Riverside County Fire Department. 9. The Informatio n (unaudited) derived from actual reven ues and expenditures received by the City during the respective month-to-date reported and are accurate as of the date of the repo rt Changes to the revenue and expenditures could result from th e fiscal year end audit, changes in estimates by payer agency's i.e. Ca. Dept of Fe e and Tax . Any changes will be reflected at next earliest reporting period. CITY COUNCIL ACTION APPROVED_.....,. ____ DENTED _____ _ RECEIVED 1:: 6 l:ed OTHER ____ _ ~s~~~,;:;'~:.,~nnk~$;;k;ae,~,iombilla,:{ keJ I t1 NOES: NOhe. J ABSENT: _NO_n .... e~----------- ABSTAIN: NO~ VERIFIED_B __ Y:...a;::i;~:L,:,e.:::/..;::5:_· r:s:-:_-:_-:_:::::::::::1£W.fllBM6L Original on File with City Clerk's Office 2-YEAR COMPARISON CITY OF PALM DESERT General Fund Financial Report - Two Year Comparison for the two years ended 2020-21 YTD Actual Prior YTD Actual Variance % Comparison of Prior Year Actual RevenuesSales Tax 2 9,660,061 10,417,210 (757,149) 92.73%↓Includes sales tax revenue received for July & February for each year. Transient Occupancy Tax 4,136,106 8,341,521 (4,205,415) 49.58%↓Includes payments received through February 28, 2021 for July - January 2021 License, Permits, & Charges 1,643,546 1,749,038 (105,492) 93.97%↓Lower reimbursments from government to date, BL (-$98,914 {13%}), Permits (+29,945 {4%}) from prior yearProperty Tax 3,702,119 3,572,267 129,852 103.64%↑ Receive in January and May of each Fiscal Year. Franchise Fees 771,174 881,490 (110,316) 87.49%Lower waste franchise fees recognized during the current fiscal year. Interest Income and Rent 1 490,440 1,854,847 (1,364,407) 26.44%↓Current average Yield is 0.6173%; Prior YTD Yield was 1.95%State Subvention 2,276,405 2,198,254 78,151 103.56%↑ All Others 3,840,149 3,593,762 246,387 106.86%↑ Various differences; COVID reimbursements to date $663,425, various other fees lower, resulting in net change.InterFund Transfers In 1,985,740 950,000 1,035,740 209.03%Fund 243 transfer for public safety costs. TOTAL REVENUES 28,505,740 33,558,389 (5,052,649) 84.94% 2020-21 YTD Actual Prior YTD Actual Variance % Comparison of Prior Year Actual ExpendituresPolice Services 8,153,929 6,973,194 1,180,735 116.93%↑ Includes July-December Police Service Contracts Payments for this year; the prior years shows July- b General Government + Contrib 9,383,021 8,965,122 417,899 104.66%↑ Includes payment of $3.464M to PERS for the City's annual required payment, increased insurance costs of $84,529Public Works 3,413,122 3,729,832 (316,710) 91.51%↓Parks 2,253,273 2,384,306 (131,033) 94.50%↓Landscape Contracts and Medians paymentsBuilding and Safety 959,319 1,090,892 (131,573) 87.94%↓Community Development 1,598,588 1,743,492 (144,904) 91.69%↓Reduction in personel costs from vacat positionEconomic Development 1,338,935 2,433,995 (1,095,060) 55.01%↓Promotion & Marketing costs decreased by $1,067,210; special events ceased do to COVID and less InterFund Transfers Out 1,070,000 3,400,000 (2,330,000) 31.47%↓$1.4M transfer to IHUB from General Fund. TOTAL GEN FUND EXP 28,170,187 30,720,833 (2,550,646) 91.70% Fire Protection Services 8,380,602 7,081,887 1,298,715 118.34%Variance result of timing difference of Fire Billing, from Riverside County Fire Department. February 28, 2021, and February 29, 2020 Explanation Explanation Actual to Actual - 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 Sales Tax Transient Occupancy Tax License, Permits, & Charges Property Tax Franchise Fees Interest Income and Rent State Subvention All Others InterFund Transfers In Fy 2020-21 FY 2019-20 ORIGINAL FORMAT CITY OF PALM DESERT General Fund Financial Report TO 67%of the year complete 2020-21 Annual Budget 2020-21 YTD Budget 2020-21 YTD Actual 21 % to YTD Prior YTD Actual RevenuesSales Tax 15,750,000 10,500,000 9,660,061 92%10,417,210 ↓Includes sales tax revenue received for July & February for each year. Transient Occupancy Tax 8,514,517 5,676,345 4,136,106 73%8,341,521 ↓Includes payments received through February 28, 2021 for July - January 2021 License, Permits, & Charges 3,104,847 2,069,898 1,643,546 79%1,749,038 ↓Lower reimbursments from government to date, BL (-$98,914 {13%}), Permits (+29,945 {4%}) from prior yearProperty Tax 7,395,702 4,930,468 3,702,119 75%3,572,267 ↑ Receive in January and May of each Fiscal Year. Franchise Fees 3,125,550 2,083,700 771,174 37%881,490 ↓Lower waste franchise fees recognized during the current fiscal year. Interest Income and Rent 641,000 427,333 490,440 115%1,854,847 ↓Current average Yield is 0.6173%; Prior YTD Yield was 1.95%State Subvention 4,501,600 3,001,067 2,276,405 76%2,198,254 ↑ All Others 3,084,111 2,056,074 3,840,149 187%3,593,762 ↑ Various differences; COVID reimbursements to date $663,425, various other fees lower, resulting in net change.InterFund Transfers In 2,526,010 1,684,007 1,985,740 118%950,000 Fund 243 transfer for public safety costs.TOTAL REVENUES 48,643,337 32,428,892 28,505,740 88%33,558,389 2020-21 Annual Budget 2020-21 YTD Budget 2020-21 YTD Actual Encumb. 21 % to YTD Prior YTD Actual ExpendituresPolice Services 19,510,810 13,007,207 8,153,929 11,356,881 63%6,973,194 ↑ Includes July-December Police Service Contracts Payments for this year; the prior years shows July- November 2019 payments General Government + Contrib 13,800,550 9,200,367 9,383,021 1,400,466 102%8,965,122 ↑ Includes payment of $3.464M to PERS for the City's annual required payment, increased insurance costs of $84,529Public Works 6,514,205 4,342,803 3,413,122 847,590 79%3,729,832 ↓Parks 4,371,278 2,914,185 2,253,273 1,309,448 77%2,384,306 ↓Landscape Contracts and Medians paymentsBuilding and Safety 1,468,010 978,673 959,319 47,842 98%1,090,892 ↓Community Development 3,028,214 2,018,809 1,598,588 440,488 79%1,743,492 ↓Reduction in personel costs from vacat positionEconomic Development 3,375,709 2,250,473 1,338,935 1,175,159 59%2,433,995 ↓Promotion & Marketing costs decreased by $1,067,210; special events ceased do to COVID and less marketing costs.InterFund Transfers Out 7,011,508 4,674,339 1,070,000 23%3,400,000 $1.4M transfer to IHUB from General Fund. TOTAL GEN FUND EXP 59,080,284 39,386,856 28,170,187 16,577,874 72%30,720,833 Total GF Exp and Encumb 44,748,061 Fire Protection Services 15,719,500 10,479,667 8,380,602 7,338,898 80%7,081,887 Variance result of timing difference of Fire Billing, from Riverside County Fire Department. Notes:- 1. Interest earnings are allocated to all funds that have cash balance at year end. 2. Sales Tax is paid in estimated monthly payments and adjusted for each quarter: 1st -Feb. - May, 2nd -June -Aug, 3rd- Sept -Nov, 4th- Nov - Feb. 3. TOT is received on monthly basis for example January collection is paid in February. 4. Property Taxes are collected from property owners in December and April bi annually and paid to the City in January and June. 5. Department of Motor Vehicle fees are paid twice a year by the State on February and June. 6. Franchise Fees are paid through property tax collection from Burtec and are paid in April for Time Warner. Edison and Gas Co. 7. General Gov. includes: City Council, City Clerk, City Attorney, City Manager, Finance, Audit, Human Resources, Information Tech., Insurance 8. Economic Development includes: Community Promotions, Market, Visitor Information, Economic Dev. 9. The Information (unaudited) derived from actual revenues and expenditures received by the City during the respective month-to-date reported and are accurate as of the date of the report. Changes to the revenue and expenditures could result from the fiscal year end audit, changes in estimates by payer agency's i.e. Ca. Dept. of Fee and Tax. Any changes will be reflected at next earliest reporting period. February 28, 2021 (year to date) Explanation Explanation YTD Budget based on