Town of Taos Fiscal Year 2023 Additional Information
This report presents additional information related to the Town of Taos's fiscal year 2023 budget, including details on salaries, benefits, property tax schedules, debt schedules, and more. The document provides insights into the financial operations and planning of the town for the upcoming year.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
Click to edit Master title style Town of Taos DFA Supporting Schedules 2022/2023 FY Presented by: Lupe E. Martinez, Finance Director 1
Click to edit Master title style Budget Supporting Schedules Additional Information Property Tax Schedule Debt Schedule Form S-5 Revenue GRT Schedule S-2 Insurance Schedule Salary Schedule Investment Schedule 2
Click to edit Master title style Town of Taos Additional Information 3
Click to edit Master title style ENTITY: TOWN OF TAOS Fiscal Year: 2023 ADDITIONAL INFORMATION 1 Enter the number of full time employees. Enter the number of part time employees. "Total" is a formula. Verify the number of total employees is correct. FTE's Full Time Part Time Total 152 11 163 $ 1.00 2 Budgeted Salary Increase %** 175,440 3 Town Manager's Salary 131,950 4 Town Attorney 's Salary 11,239,973 5 Total Salaries and Benefits 42,071 6 Budgeted Audit Cost If Applicable: N/A 7 Sole Communiity Provider Payments N/A 8 Medicaid 1/16th 4
Click to edit Master title style Town of Taos Property Tax Schedule 5 5
Click to edit Master title style Town of Taos Debt Schedule 7 7
Click to edit Master title style FORM DS DEBT SCHEDULE Fiscal Year: County/ Municipality: TOWN OF TAOS - TAOS, NEW MEXICO 2022-2023 (ROUNDED TO NEAREST DOLLAR) GENERAL OBLIGATION BONDS (A) (B) (C) (D) (E) (F) (G) (H) (I) (J) ORIGINAL OUTSTANDING Date Date OUTSTANDING BOND ISSUE INTEREST AMOUNT OF PRINCIPAL PRINCIPAL Principal INTEREST Interest PRINCIPAL [Bond series, Reason for Issuance and Fund Location] DATE RATE BOND ISSUE AMOUNT Payments Due Payments Due AMOUNT @ Beginning FY Due this FY Due this FY @ Yr end GRT 2008 Shared Gross Receipts Tax RB ( Fund 41) Fund 40200 Page 19 of LGBMS Detail Summary PDF 1/30/2008 4.00% 6,395,000 1,980,000 465,000 6/1/2023 82,696 12/1/21 & 6/1/2022 1,515,000 6,395,000 1,980,000 465,000 82,696 1,515,000 GRT Total UTILITY - RUS 1993A Water & Sewer RB (Fund 73 ) Fund 40200 Page 19 of LGBMS Detail Summary PDF 1995A Utility RB (Fund 77) Fund 40200 Page 19 of LGBMS Detail Summary PDF 1998B Water & Sewer RB (Fund 79) Fund 40200 Page 19 of LGBMS Detail Summary PDF 2/4/1996 5.63% 635,600 331,600 22,000 3/16/2023 18,371 3/16/2023 309,600 12/21/1995 5.13% 1,315,000 766,000 39,000 12/5/2022 39,258 12/5/2022 727,000 10/29/1997 4.75% 475,000 2,425,600 8,820,600 306,000 1,403,600 3,383,600 12,000 73,000 538,000 7/28/2022 14,535 72,164 154,860 7/28/2022 294,000 1,330,600 2,845,600 UTILITY Total REVENUE BOND TOTAL OTHER LONG TERM DEBT (Loans, i.e NMFA, RUS, BOF) NM ED Clear Water State Revolving Loan Fund (Fund 67) Fund 40400 Page 20 of LGBMS Detail Summary PDF Original Amount Outstanding Amount 10/13/09 & 3/13/13 Final 0.00% 1,200,000 660,000 60,000 1/31/2023 0 No Interest 600,000 NMFA Water Trust Board Loan (Fund 67) Fund 40400 Page 20 of LGBMS Detail Summary PDF Admin Fee - 6/1/2023 4/19/2013 0.00% 197,390 109,815 9,859 6/1/2023 275 99,956 NMFA Water Trust Board Loan (Fund 67) Fund 40400 Page 20 of LGBMS Detail Summary PDF NM ED Clean Water State Revolving Loand Fund 053 (Fund 67) - Project not completed (Anticipated to be completed on or around August 2023) Interest/Admin Fee- 6/1/2022 9/11/2009 0.00% 730,000 263,238 37,324 6/1/2023 658 225,914 6/1/2016 2.00% 850,000 850,000 26,537 1/31/2023 17,000 1/31/2023 823,463 NMFA PPRF Disadvantage Program Landfill (Fund 70) Fund 40400 Page 20 of LGBMS Detail Summary PDF OTHER LONG TERM DEBT TOTAL Interest/Admin Fee - 12/1/22 & 6/1/2023 7/1/2016 1.15% 1,376,046 4,353,436 563,142 2,446,195 183,425 317,145 6/1/2023 8,932 379,717 2,129,050 26,865 Check [ ] if this form is a revision. Revision Date:_________ Revision No:___________________ Revision Date:_______________ Revised: 02-2007 8
Click to edit Master title style Town of Taos Form S-5 9
Click to edit Master title style Column C enter budget amount for the requested fiscal year. Columns D, E, F, G, & H, enter entity's future fiscal year reserves for that project. Do not include LGD 1/12th reserve requirements. These are additional earmarked reserves per project need. INSTRUCTIONS - DETAIL OF NON BUDGETED RESERVE REQUIREMENTS FORM S-5 County/ Municipality: Town of Taos DETAIL OF ADDITIONAL RESERVE REQUIREMENTS IN EXCESS OF LGD REQUIRED RESERVE Fiscal Year: 2022-2023 (CENTS ROUNDED TO NEAREST DOLLAR) (A) (B) FUND NUMBER (C) (D) (E) (F) (G) (H) FUND NAME & PROJECT TITLE BUDGET REQUEST FY__23____ Future FY__24____ Future FY______ Future FY______ Future FY______ Future FY______ Road Projects Project A - Cruz Alta Project B - TBD Project C - TBD 59 59 59 300,000 300,000.00 - - One Time Costs Weight Room Enclosure & Additions Rink Sound System Improvements Plastic Lockers for Men's Locker Room Chemical Controllers for 3 Pools 2 - 20' Cargo Containers Coronado Hall Improvements Co2 Compressor Replacement 53 53 53 53 53 53 53 10,000 25,000 19,000 17,000 24,000 80,000 1,020,000 10,000.00 25,000.00 19,000.00 17,000.00 24,000.00 80,000.00 1,020,000.00 1,195,000.00 - - - - - - - - - - - 1,195,000 0 Check [ ] if this form is a revision. Revision No:___________________ Revision Date:_______________ Page 1 of 1 Form revised 1-2005 10
Click to edit Master title style Town of Taos Revenue Schedule 11
INSTRUCTIONS - REVENUE CHECKLIST Column A: Enter the respective fund number Column B: FOR INFORMATION ONLY [no data input needed] Click to edit Master title style Column C: Identify Other GRT Revenue Dedication, rows 33-34 Column D: Enter the respective enactment rate Column E: Enter previous year actual revenues Column F: Enter current year budgeted revenues Column G: Enter interim/final requested budgeted revenues Column H: Enter intercepted revenues [Ensure the full amount of the intercept is budgeted in its respective fund] Entity Name: TOWN OF TAOS Fiscal Year: 2022-2023 A B C D E F G H C = County, M = Municipality B = Both Prior Yr ACTUAL Revenue Current Yr Budgeted Amount Int/Final Budgeted Request Int/Final Intercept Amount Fund Number Local Option Taxes Descriptions Enactment Rate 11000 & 21600 B GRT - Local Option 1.3750% 6,292,513 5,629,280 6,243,552 - 11000 M GRT - State Shared-1.225%- Distribution 1.2250% 5,639,617 4,822,712 5,330,283 - C GRT - State Equalization Distribution GRT - Infrastructure 0.0000% - - - - 30500 & 50100 B GRT - Infrastructure 0.2500% 1,145,884 998,341 1,104,134 - B GRT - Capital Outlay 0.0000% - - - - 30500 B GRT - Environmental Services 0.0625% 286,459 247,764 281,777 - B GRT - Quality of Life 0.0000% - - - - M GRT - Regional Spaceport 0.0000% - - - - M GRT - Higher Education Facilities 0.0000% - - - - C GRT - Emergency Communications & 0.0000% - - - - Medical Services Tax 0.0000% - - - - C GRT - Education 0.0000% - - - - C GRT - Health Care (Medicaid/Ind) 0.0000% - - - - C GRT - County Hospital 0.0000% - - - - B GRT - Other Dedication 0.0000% - - - - B GRT - Other Dedication 0.0000% - - - - TOTAL GROSS RECEIPTS TAX REVENUE 2.9125% 13,364,473 11,698,097 12,959,746 0 C County Detention Distribution (HB 316-2007) - - - - 12
Click to edit Master title style Town of Taos S-2 Insurance Schedule 13
Click to edit Master title style Please list all coverage your entity will purchase for the fiscal year, the company purchased from, the agent, the effective dates, coverage amount, and the premium amount. Include only the total amount of coverage purchased by "insurance type" and the page numbers where they are budgeted. INSTRUCTIONS: County/ Municipality: TOWN OF TAOS FORM S - 2 Entity Code: 20-126 Fund Number: All SCHEDULE OF INSURANCE (CENTS ROUNDED TO NEAREST DOLLAR) Fiscal Year: 2022-2023 (A) (B) (C) (D) (E) (F) COVERAGE AMOUNT PREMIUM AMOUNT COVERAGE EFFECTIVE DATES COVERAGE INSURER AGENT FROM 7/1/2022 6/30/2023 TO New Mexico Self Insurer's Fund New Mexico Self Insurer's Fund Worker's Compensation Fund & Page # Personnel Services Schedule RECAP Personnel Services Schedule RECAP Personnel Services Schedule RECAP Personnel Services Schedule RECAP Personnel Services Schedule RECAP Personnel Services Schedule RECAP General Fund Lodger's Tax Water - Utility Billing Water Division WasteWater Collection Regional Landfill 96,816 3,180 728 13,492 6,637 17,062 TOTAL WORKER'S COMPENSATION 137,915 Law Enforcement Officers Fund & Page # New Mexico Self Insurer's Fund Fund 11000 Page 8 of LGBMS Detail Summary PDF (Object Code - 57999) New Mexico Self Insurer's Fund 65,315 Civil Rights Fund & Page # New Mexico Self Insurer's Fund Fund 11000 Page 4 of LGBMS Detail Summary PDF New Mexico Self Insurers' Fund 34,682 Property Coverage Fund & Page # New Mexico Self Insurer's Fund Fund 11000 Page 4 of LGBMS Detail Summary PD Various Funds New Mexico Self Insurers' Fund 208,430 14 14 Check [ ] if this form is a revision. Revision No:___________________ Revision Date:_______________ Page No: 2 of 2 Form revised: 1-2005
Click to edit Master title style Town of Taos Salary Schedule 15
Click to edit Master title style TOWN OF TAOS Municipality: PERSONNEL SERVICES SCHEDULE RECAP FY 2023 FINAL BUDGET SALARY ESTIMATES Town of Taos 03:12 PM 21-Jul-22 FY 41011 F.I.C.A. SOC SEC MEDICARE 21,821 10,396 41,162 42,327 11,703 24,123 24,396 24,538 16,260 24,238 11,573 30,343 11,639 26,104 11,208 11,688 361,589 24,444 12,686 30,119 15,717 20,081 103,047 464,636 41012 P.E.R.A. EMPLOYER CONTRIBUTION 1,158,466 1,334,049 41013 GENERAL HEALTH INSURANCE 31,862 245,952 110,201 1,056,752 193,239 1,249,991 41017 RETIREE HEALTH CARE 128,064 24,557 152,621 41014 UNEMP. COMP. 41015 WORKER'S COMP. ASSESSMENT 41016 WORKER'S COMP PREMIUM SALARY INCREASE ACCOUNT CODE 11-11 11-12 11-13 11-14 11-15 11-16 11-17 11-18 11-19 11-20 11-21 11-22 11-23 11-24 11-25 11-28 11-29 11-30 11-31 # ANNUAL SALARY (AS) 1,676,609 6,504,098 1,347,025 7,851,122 EMP 4 3 9 27 Police Department 13 Taos Fire Department 9 Streets 10 Recreation 9 Parks 2 Fleet 3 Planning & Zoning Department 7 Public Library 3 Human Resources Department 11 Facilities Services Department 5 Council 2 Airport 14 Aquatics 2 Legal 3 IT Department 1 Community Events DEPARTMENTS TOTALS 386,450 186,919 762,468 2,438,063 1,162,033 459,159 463,290 471,673 127,565 298,325 442,124 212,707 585,099 222,898 143,310 482,901 197,206 221,215 9,331,284 458,615 233,147 552,742 281,994 382,191 1,908,689 11,239,973 Executive Municipal Judge Finance Department PAGE NO. PAGE NO. PAGE NO. PAGE NO. PAGE NO. PAGE NO. PAGE NO. PAGE NO. PAGE NO. PAGE NO. PAGE NO. PAGE NO. PAGE NO. PAGE NO. PAGE NO. PAGE NO. PAGE NO. PAGE NO. PAGE NO. 2 3 4 285,241 135,891 538,065 40,575 9,839 76,414 418,775 205,591 42,089 45,103 44,725 12,647 30,394 37,598 21,490 51,714 13,904 13,960 44,499 20,844 21,490 6,814 5,675 2,710 10,687 35,902 16,128 5,888 6,308 6,255 1,769 4,251 5,258 3,006 7,233 1,945 1,952 6,224 2,915 3,006 953 - - - - 1,277 610 2,491 18,498 11,290 18,920 7,885 7,900 1,327 2,125 2,702 751 9,945 691 2,767 5,919 729 751 238 96,816 3,180 728 13,492 6,637 17,062 41,100 137,915 27,473 68,149 24,000 1,500 - - - - - - - - - - - - - - - - 1,500 - 120 - - 5-6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 - - - - - - - - - - - - - - - - 807,120 315,329 318,905 320,761 89,942 212,545 316,839 151,280 396,639 152,142 97,624 341,223 146,510 152,780 48,653 52,810 60,692 67,494 15,000 32,750 55,489 24,607 89,225 42,577 19,538 58,933 15,000 31,500 7,500 6,881 7,468 3,722 67,880 General Fund Total: 24,000 24,000 24-00 62-26 62-27 63-28 82-32 4 4 10 Water Division 6 WasteWater Collections Systems 5 Regional Landfill Lodger's Tax Water - Utility Billing PAGE NO. PAGE NO. PAGE NO. PAGE NO. PAGE NO. 22 23 24 25 26 319,527 165,828 393,719 205,453 262,497 45,478 23,499 50,550 24,586 31,470 175,583 35,625 27,000 57,792 26,162 46,660 6,361 3,287 7,070 3,439 4,401 - - - - 19 Other Funds Total: Grand Total: 24,000 48,000 139 1,639 Positions 163 16
Click to edit Master title style Town of Taos Investment Schedule 17
