Albany Data Stories

Albany Data StoriesAlbany Data StoriesAlbany Data Stories

Albany Data Stories

Albany Data StoriesAlbany Data StoriesAlbany Data Stories
  • Home
  • About Albany Data Stories
  • Albany's AIM Funding
  • Albany's Budget 2017-2025
  • Albany's Vendors
  • Albany's Population
  • Albany's Poverty
  • Albany's Taxable Property
  • Albany's Developable Land
  • Albany's Vacant Buildings
  • Albany's Housing
  • Albany's LowInc Housing
  • Albany's APD Complaints
  • Albany Crime Reports Pt 1
  • Albany Crime Reports Pt 2
  • Albany's PILOT program
  • Albany's Financial State
  • Albany's Open Data
  • What's Next

Albany’s Budget - 2017-2025. 14 Observations

Overview

One of our more ambitious efforts is to review the City of Albany’s budget data.  We had a few initial questions: 

  • What is the size of the budget?  
  • What are the revenue and expense components of the budget?
  • What are the budgetary trends?
  • Is there anything that is not understandable or that we need additional context to understand?


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 - 

  • General Fund - $158.3 million in the 2025 proposed budget
  • Realty Taxes - $63 million in the 2025 proposed budget


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.

Downloads

CityofAlbanyBudgets_2017-2025 (xlsx)

Download

Revenue Breakdown

What is in each Revenue category?

  • State Aid - includes NY State Aid to Municipalities (AIM), Mortgage tax, public safety and some smaller revenue sources
  • Capital City Funding - additional state aid that makes up for an imbalance in our AIM funding
  • 19A Pilot -  Payment in Lieu of Taxes (PILOT) from NY State for the Empire State Plaza
  • Federal Aid - American Rescue Plan and various Federal grants
  • Sales & Use Tax -  any taxes levied on different transactions
  • Property Tax - commercial and residential property taxes
  • Other PILOTS & Taxes - voluntary payments from Wholly Exempt property owners
  • Landfill Income - landfill usage charges, sale of methane gas produced from the landfill
  • Departmental Income - fees and income from waste collection, Department of General Services, code violations, golf course income, and various other revenue generating programs
  • Inter-Fund Transfers - per the budget office “An internal transaction that moves money from one major fund to another in furtherance of maintaining a balanced budget and recognizing spending appropriately”
  • Appropriated Debt Reserve - this is a revenue line that only appears in the 2020-22 budgets; we need more understanding of what this is
  • All Other - includes Federal Aid for 2024 & 2025, NY Opioid settlement funds  

Expenses Breakdown

 What is in each Expenditures category?

  • Wages - salaries
  • Retirement - payments to the NY State Retirement system and Social Security
  • FICA - payroll tax (Federal Insurance Contributions Act)
  • Health Insurance & Other Employee Benefits - self-described
  • Retiree Health Insurance & Medicare - self-described
  • Workers Compensation - self-described
  • Operating Expenses - expenditures from ongoing city programming, maintenance, and public works project 
  • Albany for All - distribution of American Rescue Plan Act (ARPA) funding through grants focused on housing, community spaces and direct services
  • Debt Service - Required payments of principal and interest on bonds and notes issued. 
  • Interfund Transfers - per the budget office “An internal transaction that moves money from one major fund to another in furtherance of maintaining a balanced budget and recognizing spending appropriately” 

revenue & expenditure growth - from 2017 to 2025

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

Revenue detail growth - Year over year

 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. 

expenditure detail growth - Year over year

 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.

Yearly growth rate - median and standard deviation

 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.

14 THOUGHTS & QUESTIONS FROM THE BUDGET DATA

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. 

1. Budget compared to CPI & Inflation

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.

2. Federal revenue spikes

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.

3. Missing narratives - Inter-fund Transfers and Appropriated Debt Reserve

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.  

4. Constant Revenue sources

There are three categories of revenue that have remained unchanged or are very predictable over 9 years.


  • 19A PILOT funding (payments from NY State for the Empire State Plaza) have been a constant $15 million
  • Capital City funding (payments to make up for AIM shortcomings) have had several step changes - $12.5 million between 2017-2021, $15 million between 2022-2024 and the 2025 budget predicts a $20 million revenue stream
  • Property tax revenue has grown 9% between 2017 and 2025, with recent years (2023-25) showing most of the growth

5. Comparing Albany’s budget vs. peers and neighbors

  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. 

6. Highly variable revenue - Landfill income

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.   

7. Highly variable revenue - Other PILOT and Taxes

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.  

  • 2023 Actual Cannabis Excite Tax Revenue - $30,535
  • 2024 Adopted Cannabis Excite Tax Revenue - $125,000
  • 2025 Proposed Cannabis Excite Tax Revenue - $500,000


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. 

8. Departmental Income

   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.   

9. Expenses - Wages

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? 


10. Expenses - Police Department Overtime

    

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:

  1. What portion of APD overtime is driven by staffing shortfalls?
  2. For staffing-related overtime what is the long-term impact to retention?
  3. For staffing-related overtime what is the long-term budgetary impact for retirement spending?
  4. What is the potential to shift overtime expenses into efforts that drive recruitment and retention?

11. Retirement Expenses and their predictability

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. 

12. Health Insurance & other benefits

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. 

13. Highly variable expenses - Debt service

Debt Service Year over Year

 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.   

Albany's Debt Schedule

 

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. 

14. Albany for All - Unpacking the spending

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:

  • 2023 - $10 million
  • 2024 - $12 million
  • 2025 - $2 million


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:

  1. The total Albany for All spending between 2023-25 is $24 million and the narrative suggests the total program is $25 million.  Is there an additional $1 million that will be in the 2026 budget?
  2. Can the City distribute a comprehensive list of the 35 programs and the allocation of Albany for All spending on each program between 2023 to 2025?
  3. Has the $2 million in the 2025 budget for Albany for All been allocated already or is this in progress?  There is some indication that the West Hill’s new community center (opening Fall 2025) could be the recipient of the funding, is this one target for the 2025 spending?

Summary

 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.

This website uses cookies.

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.

Accept