HomeMy WebLinkAboutCouncil Presentation 11/17/2020-FY 2020-2021 1st Quarter Financial BriefFISCAL YEAR 2020 - 2021 FIRST QUARTER FINANCIAL BRIEF
This financial brief is intended to provide a broad overview and status of revenues and expenditures for the Town's selected major funds through the first
quarter of fiscal year 2021 (July 2020 - September 2020). Major funds included in this financial brief are the General Fund, Highway User Revenue Fund
HURF), Bed Tax Fund and Transportation Fund. Also included are the enterprise funds Airport, Water, and Water Reclamation. Please note that all
amounts are preliminary, un-audited and subject to change based upon adjusting entries, as necessary.
The table below shows an overview for each fund.
REVENUES EXPENDITURES OVER/UNDER
Fund FY 2021 Budget Actual % Budget FY 2021 Budget Actual % Budget YTD Over/Under
GENERAL FUND 50,205,356 14,607,515 29% 47,851,333 8,363,363 17% 6,244,152
HURF 3,281,296 1,167,900 36% 4,166,655 340,277 8% 827,623
TRANSPORTATION FUND 5,800,000 2,128,499 37% 21,037,629 109,257 1% 2,019,242
BED TAX FUND 1,104,840 229,611 21% 1,092,603 53,039 5% 176,572
WATER FUND 7,065,276 1,896,034 27% 7,658,018 2,104,615 27% 208,581
WATER RECLAMATION FU... 2,681,248 528,038 20% 2,497,887 258,030 10% 270,008
AIRPORT FUND 585,178 102,554 18% 585,178 77,613 13% 24,941
Click HERE for a User Guide and FAQ about this report
Microsoft Power BI 1 of 8 > 1 d /
FY 2020-2021 FIRST QUARTER: GENERAL FUND REVENUES
Select Revenue orExpens
EXPENSES
El REVENUES
Category FY 2021 Budget Actual % Budget
Sales Tax 24,389,464 8,319,808 34%
Intergovernmental 13,435,743 3,803,001 28%
Licenses, Fees,&Permits 4,427,112 1,538,491 35%
Charges for Services 503,000 116,801 23%
Other 7,450,037 829,413 11%
Total 50,205356 14,607,515 29%
OM
1 5 1\/1
50M
General Fund Relevant Information
The General Fund is the Town's primary operating fund.Sales Tax, Intergovernmental Revenues and Licenses,Fees,&Permits make up 95%of budgeted revenues for the fund.First quarter
collections are mostly above expected levels for FY2021 due to stronger than anticipated activity in most categories.Intergovernmental Revenues are amounts received from the State's
shared revenue program and are distributed based upon population estimates and economic conditions.Licenses,Fees,&Permits include Single Family Residential(SFR)permit revenue.
Other revenues,comprised of various sources include investment income earnings,AMRRP dividends and budgeted transfers-in from AZ CARES funding.
Year i 2019 <g 2020 0 2021
1oM Category 2019 2020 2021
Sales Tax 6,790,954 7,431,751 8,319,808
8M
Intergovernmental 2,950,239 3,245,275 3,803,001
6M
Licenses, Fees, &Permits 1,654,259 1,478,729 1,538,491
4M Charges for Services 134353 115,679 116,801
2M
Other 884631 1,039,403 829,413
Total 12,410,437 13,310,837 14,607,515
OM
Sales Tax Intergovernmental Licenses,Fees,& Other
Permits
Microsoft Power BI K 2 of 8 > d /
FY 2020-2021 FIRST QUARTER: HURF REVENUES
Select Revenue or Expena
Li EXPENSES
REVENUES
Category FY 2021 Budget Actual %Budget
Intergovernmental 3,276,296 976,963 30%
Charges for Services 0 190,631 0% y
Other 5,000 306 6%
Total 3,281,296 1,167,900 36%
1FV1
OM :+' 3M
HURF Relevant Information
The Highway User Revenue Fund or HURF is set by the collection of fees and taxes from users of the State's roads and highways which the State collects.Cities and towns receive a
percentage of revenues based on population estimates and gasoline sales within each county.First quarter HURF revenue collections are above forecasted levels.Charges for services are
pavement in lieu of fees collected from third parties to be expended for the preservation of roads.Other revenue is comprised of investment income.
Year $2019 $2020 02021
Category 2019 2020 2021
tom Intergovernmental 864,915 1,105,129 976,963
Charges for Services 190,631
Other 6,105 7,345 306
Total 871,020 1,112,474 1,167,900
0.5M
Intergovernmental Charges for Services Other
Microsoft Power BI 3 of 8 ) LE;' /
FY 2020-2021 FIRST QUARTER: TRANSPORTATION FUND REVENUES
Select Revenue orExpena
J EXPENSES
REVENUES
Category FY 2021 Budget Actual %Budget
Sales Tax 5,750,000 2,093,305 36%
Other 50,000 35,194 70%
Total 5,800,000 2,128,499 37%
2M
OM 1 . 6M
Transportation Fund Relevant Information
The Transportation Fund is comprised of 75%of all contracting taxes collected by the Town and is to be used for new road construction and reconstruction projects.First quarter revenue
collections are higher than anticipated due to strong residential housing (258 SFR permits issued vs.617 budgeted for the year)and commercial construction spurred by low interest rates.
Other revenue is comprised of investment income.
r
Year •2019 02020 0 2021
99
z.sM Category 2019 2020 2021
z.OM
Sales Tax 1,911,167 2,220,199 2,093,305
Other 61,258 54,128 35,194
15M Total 1,972,426 2,274,327 2,128,499
tom
0.5M
0.0M
Sales Tax Other
Microsoft Power BI 4 of 8 > I€' 7
FY 2020-2021 FIRST QUARTER: BED TAX FUND REVENUES
Select Revenue orExpen!
EXPENSES
REVENUES
Category FY 2021 Budget Actual % Budget
Sales Tax 1,104,840 229,611 21%
Total 1,104,840 229,611 21%
230K
OM 1M
Bed Tax Fund Relevant Information
The Bed Tax Fund accounts for the collection of the discriminatory portion of revenues restricted for tourism initiatives.First quarter revenue collections for FY2021 are below forecasted
levels due to the impact of the pandemic on the hospitality industry.Town staff will continue to monitor these revenues closely over the next few months.
Year •2019 02020 02021
0.3M Category 2019 2020 2021
Sales Tax 159,142 273,687 229,611
Total 159,142 273,687 229,611
0.2MIli€
0.1M
rr.m
0.0M
Sales Tax
Microsoft Power BI 5 of 8 > LE? Li
FY 2020-2021 FIRST QUARTER: WATER OPERATING FUND REVENUES
Select Revenue orExpenv
I EXPENSES
S REVENUES
Category FY 2021 Budget Actual % Budget
Intergovernmental 85,000
Licenses, Fees,&Permits 42,500 170,888 402%
z>.
Charges for Services 5,655,873 1,704,136 30%
Other 1,281,903 21,010 2%
Total 7,065,276 1,896,034 27% t iitiiiii i,?
iii. iiii
LJ
OMiiVirnii;::+ 7M
Water Fund Relevant Information
The current rates and fees for Marana Water customers can be found at-http://www.maranaaz.gov/water-rates-and-fees.Charges for Services(water sales)comprise the majority of the
revenue for the fund.First quarter revenue collections are slighly above expectations for FY2021.Licenses,fees,&Permits is above expectations primarily due to fees collected in
connection with the Water Treatment Plants construction.Other revenue is primarily comprised of miscellaneous revenue sources and an interfund transfer associated with a WIFA loan
payment scheduled to take place later in the fiscal year.
Year •2019 2020 e 2021
z.oM Category 2019 2020 2021
Licenses, Fees, &Permits 13,704 170,888
1.5M Charges for Services 1,413,986 1,556,416 1,704,136
Other 69,257 307,474 21,010
1.0M Total 1,496,947 1,863,890 1,896,034
0.5M
O.0M r
Licenses,Fees,&Permits Charges for Services Other
Microsoft Power BI 6 of 8 ) d /
FY 2020-2021 FIRST QUARTER: WATER RECLAMATION OPERATING FUND REVENUES
Select Revenue or Expen!
LI EXPENSES
REVENUES
Category FY 2021 Budget Actual % Budget
Licenses, Fees,&Permits 28,900 37,106 128%
Charges for Services 1,841,278 490,877 27%
Other 811,070 55 0%
Total 2,681,248 528,038 20%
528K
OM 3M
Water Reclamation Fund Relevant Information
The current rates and fees for Marana Sewer customer can be found at-http://www.maranaaz.gov/water-rates-and-fees.Charges for Services(sewer rates)comprise the majority of the
revenue for the fund.Overall,preliminary FY2021 first quarter revenue collections are as expected.Licenses, Fees,&Permits are above expectations due to stronger than anticipated
growth.The majority of Other revenue is mainly related to budgeted transfers between funds for debt service payments that are scheduled to take place later in the fiscal year.
Year •2019 2020 02021
0.5MCategory
2019 2020 2021
o.aM
Licenses, Fees,&Permits 10,018 9,439 37,106
Charges for Services 353,359 394,304 490,877
0.3M Other 962 2,167 55
Total 364,340 405,911 528,038
0.2M
0.1M
O.OM
Licenses,Fees,&Permits Charges for Services Other
Microsoft Power 81 7 of 8 > d /
FY 2020-2021 FIRST QUARTER: AIRPORT OPERATING FUND REVENUES
Select Revenue or Expen!
J EXPENSES
U REVENUES
Category FY 2021 Budget Actual % Budget
Charges for Services 360,336 102,288 28%
Other 224,842 266 0%
Total 585,178 102,554 18%
OK
103K
585K
Airport Fund Relevant Information
Overall,preliminary first quarter revenue collections for the Airport Fund are as expected.Charges for Services comprise of the majority of budgeted operating revenue,while Other
revenue is primarily comprised of miscellaneous revenues and transfers between funds scheduled to take place once all fund activity is finalized.
Year 02019 A 2020 2021
Category 2019 2020 2021
100K Charges for Services 78,808 72,634 102,288
Other 6,327 2,645 266
Total 85,135 75,279 102,554
SOK f ,'
ter;
OK
Charges for Services Other
Microsoft Power BI 8 of 8 > d /