One of our more ambitious efforts is to review the City of Albany’s budget data. We had a few initial questions:
Albany’s Budget Office manages the budgets and makes current and past budgets available via their portal. We made a decision to look at the approved budgets (2017-2024) and the 2025 proposed budget, 9 years of budgets. We will make the Excel spreadsheet with all of the data available for anyone to follow along or perform their own analysis.
Before reviewing our analysis and thoughts, we would suggest doing a quick review of one of the budget presentations; 2024 works well. The Mayor and Budget Office have created a readable and understandable narrative on top of the basic facts of the budget.
An Albany budget has 3 main sections - a Revenue overview, a Revenue breakdown and an Expenditures breakdown. There are two separate sections that we did not include in our analysis - the Youth & Workforce Services Fund and the Water Fund which are out of scope for this analysis.
The Revenue Overview breaks down the two main revenue sources -
In this article we will show the Revenue and Expense breakdowns, explain several additions that we make to the budget sheet to help us with our analysis and drill into 14 questions and observations from the 2017-2015 budgets.
CityofAlbanyBudgets_2017-2025 (xlsx)
DownloadWhat is in each Revenue category?
What is in each Expenditures category?
We added four additional pieces of information. Note that all of this added detail is in the accompanying Excel spreadsheet.
Growth rate - to understand the budgetary changes over time we added a field that analyzes the overall growth (or decline) between 2017 and 2025 budgets to every Revenue Overview, Revenue Detail and Expenditure Detail line
We created a separate table that, for each revenue component, shows the growth between the previous year and current year.
For example, State Aid declined 3% between 2021 ($16.458 million) and 2022 ($15.883 million). We also color coded the table so that revenue increases are green (a generally favorable event); and revenue loss is colored in red. Note the decline in “All Other” in 2025 as the Federal American Rescue Plan Act funding declines dramatically.
We created a separate table that, for each expenditure component, shows the growth or decline between the previous year and current year. We color coded this table where expenditure decline (generally a positive thing) shows up in green; expenditure growth shows up in red. For example, in 2025 FICA costs increased by 6% over 2024.
Lastly, we added for every Revenue and Expenditure component two additional calculations. We added the median yearly growth rate and the standard deviation of the growth rate.
The standard deviation of the growth rate helps us understand which components are the most volatile or dynamic over 9 years of budgets. The higher the number, the higher the dynamic nature. For example, “All Other” revenue has the highest standard deviation (0.38) and is the most dynamic due to the lumpy nature of how we receive Federal funding, especially ARPA funding. 19A PILOT funding is the most consistent (Albany’s 19A funding is unchanged over 9 years at $15 million/year) and the standard deviation is therefore 0.00.
We came up with 14 observations and questions from our initial analysis of the 9 years of budget data. We list these below in a flow that aligns with how we looked through the data.
We started with a basic question - is the increase in the size of Albany’s budget reasonable?
Albany’s budget in 2017 - $176,982,803
Albany’s budget in 2025 - $221,256,965
Growth in Albany’s budget between 2017 and 2025 - 25%
There are two measures that we can use for comparison - inflation and consumer price index (CPI). The overall inflation rate between 2017 and 2025 is roughly 29% depending upon the months you pick as the start and finish. The overall growth in the consumer price index between 2017 and 2025 is approximately 28%, varying based on start/end month. We can view as a a positive that Albany’s budget has grown at a slower rate than inflation and the CPI.
The Cov19 impact and related Federal funding (driven by American Rescue Plan Act funding) shows a 2023 spike and make year to year comparisons difficult. Federal funding falls under the “All Other” line which looks like this for the past 5 years:
2021 = $12,586,140
2022 = $20,609,208
2023 = $32,318,242
2024 = $38,800,943
2025 = $14,927,476
With this spike and subsequent decline we do need to be careful in how we examine and draw conclusions from trends.
While Albany’s budget narratives present detail and context on the budget in a generally understandable fashion, the “Inter-fund Transfers” and “Appropriated Debt Reserve” (2020-2022) are budget lines that require more context on what they are or were.
There are three categories of revenue that have remained unchanged or are very predictable over 9 years.
Comparing budgets between two cities can be an apples and oranges exercise (or maybe a honey crisp apple vs. a granny smith apple comparison). Cities are different, their populations and needs are different and we don’t want to infer too much in our comparisons. However we can look at some basic data. Let’s look at Albany versus a few neighbors and upstate peers. We will use budget dollars per capita as our comparison metric.
All cities are in the same ballpark and Albany is the lowest per capita spend of these four cities. In a separate article we examine the inequities in AIM funding; Syracuse and Rochester receive more AIM funding on a per capita basis than Albany which may drive some portion of their higher per capita spending.
Landfill income is the second most dynamic revenue stream when viewed on a year over year basis for the 9 years of this study. We can look at growth rates (positive and negative) year over year. The image shows year over year landfill income growth in green, decline in red.
A projected 27% growth rate in 2025 Landfill Income ($3.23 to 4.11 million from 2024 to 25) represents an unprecedented growth rate. There is little information in the narrative that describes the expected factors driving this growth. We would want to see more detail to understand if this is a realistic growth number.
Other PILOTs and Taxes revenue is expected to grow by 14%, from $6.3 to $7.2 million. There is little information in the narrative that describes the expected factors driving this growth. We would want to see more detail to understand if this is a realistic growth number. The image shows year over year PILOT income growth in green, decline in red.
In addition, the City of Albany’s Cannabis Excise taxes fall in this “Other PILOT and Taxes” revenue category. From the budget narrative, there is a significant increase in revenue for 2025.
A 4X Cannabis excise tax revenue increase draws our attention. This is a brave new world and we would expect that these projections are educated guesses OR we would want to understand the analysis that suggests this growth, whether City or New York State analysis.
Departmental Income is expected to grow from $17.87 to $25.19 million, a 41% growth rate of $7.32 million. We attempted to unpack what is behind this growth in the 2025 budget. We found several revenue lines that represent 6 figure growth (e.g. “DGS Fees” will grow from $550k to $800k, “Code Violations Court” grows from $86k to $225k).
We did find that “Traffic Viol/Pol Court Fines” shows a projected $6 million increase. The budget narrative does not call out that “Fines and Forfeitures” falls under Departmental Income, however it is the best explanation. Our assumption is that this revenue increase is all driven by the introduction of school-related speed cameras. Note that we can see a quote in the Times Union that the Mayor added $6 million revenue in the budget for the speed camera program; we would expect that this commentary should show up in the budget narrative.
In any industry or level of government, new revenue streams of any type are exceptionally challenging to project accurately. For the school speed camera program payment rates, growth or decline of violators, and decisions that the City makes on the minimum threshold to issue a ticket will all impact how much revenue this program will generate.
Wages have grown by 32% between 2017 and 2025, compared to the overall budget growth rate of 25%. Year over year growth rates are variable, presumably timed with collective bargaining cycles and any retroactive payments. The image shows year over year wage high growth in red, low growth and decline in green.
Reviewing the Wages in isolation is interesting, however we would want to see the full time employee count. Has overall staffing gone up or down? The most interesting number to us is how have wages increased on a per employee basis?
The Albany Police Department has a known shortfall of full time officers. There is a single comment in the 2025 Budget narrative about closing this gap:
“Launched the Join Albany Public Safety hiring campaign, including developing lateral hiring policies, a dedicated web page, and APD digital marketing campaign.”
It is beyond the scope of this article to suggest strategies for closing this gap, however we can examine one potential impact of staffing shortfalls. Overtime represents 22.5% of the Police Department wage budget ($8.31 million out of $36.9)
Not all APD overtime is driven by staffing shortfalls. Here are some starter questions:
When we examine retirement expenses we noted that the last few years have seen significant volatility.
There is little information in the Budget narrative that explains the 2025 projected spending. We would want to understand what is driving these changes. In addition, we would like to see a projection for future Retirement expenses and what the rates of growth will look like.
One of the bigger surprises was to see the consistency in Health Insurance & Other Employee Benefits. In a time where news reports describe double digit health insurance increases (for employers and employees) we were not expecting only a 2% growth in this category. The image shows year over year wage health insurance growth in red, low growth and decline in green.
Health insurance represents 8% of City budget so this is an important number. Is the slow rate of increase due to lower staffing, year over year? Is the benefit package shrinking? Are City employees paying a larger portion of costs? This is information that would be important to see in the Budget narrative.
Albany’s Debt Service is the most volatile expense, year over year, when measured by growth rate standard deviation.
Public debt is not a bad thing, it is how we build infrastructure. We do want to understand what the debt is for. In our personal lives if we pay a car loan, a credit card payment, or a mortgage payment we can put cause and effect together - we paid for a trip on a credit card and now the bill comes due.
The 2025 Budget narrative does have a schedule that shows the current anticipated payments.
What is missing is an explanation of what did this debt buy us as a City? What are we paying for now that we have been receiving the benefit from? Debt Service is slightly less than 8% of the overall City budget; we should have more visibility on the breakdown.
Albany for All represents the distribution of American Rescue Plan Act (ARPA) funding through grants focused on housing, community spaces and direct services. We are excited to see the positive impact in all of those areas. Albany for All shows up in 3 budget years of expenditures:
The Budget narrative describes the program status:
"The Albany for All initiative was launched, with those priorities in mind, to invest $25 million of funding directly into the community. Through a rigorous selection process, city officials ultimately chose to fund 35 projects that would be highly impactful and transformative for the community. As the city approaches the halfway point of the initiative, the various projects are already demonstrating positive impacts in the community with much more progress still on the way"
The Budget narrative also describes some of the operational practice associated with the program:
"Continued to manage administration of the $25 million Albany for All program, preparing quarterly reports to U.S Treasury Department, managing all grant reimbursements, and collecting program data."
This brings up a few questions:
With our examination of Albany’s budget we pose both observations and questions. This is just a single point of view and we hope that others dig into the Excel data and envision other data-driven questions that we need to ask. We also hope that this feedback helps the Budget office as an input feed into continued explanation of the budget.
Thoughts, comments, explanations? Drop us an email at AlbanyDataStories@gmail.com
Copyright © 2025 Albany Data Stories - All Rights Reserved.
We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.