Skip to Content

Five-year budget projection for large NFP

May 31, 2017 Case Study 1 min read
Large social service agency increases board's confidence with comprehensive five-year budget plan.

 Image of people meeting

The client

A large social service agency with a multi-faceted mission; including senior living, refugee settlement, foster care, adoption, and family preservation.

The challenge

The agency has a sophisticated finance team and a board that places an emphasis on long-term financial planning; however, they didn't have the time necessary to create the desired long-term plan. Additionally, their long-term planning would be very complicated given the vast array of services they provide.

The solution

Our team created a three-phased project plan to develop an interactive five-year budget model for their major service lines. Our experts met with management to gain an in-depth understanding of the major revenue and expense drivers. We built a custom excel-based model that projected out revenues and expenses based on those drivers by building in assumptions that management can manipulate. For example, number of residents served, rates changed, inflation, pay increases, etc. This tool allows management to adjust any assumption and immediately generate a new five-year projection.

The benefit

Long-term planning can help an organization prepare well in-advance for major changes in revenues or expenses. This was a relatively small investment made by the organization , but has a big impact on the organization’s future sustainability. Presenting the tool and the long-term plan to the board increased the board’s confidence in the organization’s management team.

Related Thinking

U.S. Capitol building during the day against a cloudy sky.
May 20, 2024

Expanded Inflation Reduction Act electric vehicle (EV) and charging station credits for businesses, tax-exempts, and governmental entities

Article 11 min read
Exterior of the Shedd Aquarium in Chicago.
May 13, 2024

Shedd Aquarium: Celebrating curiosity, compassion, and conservation

Case Study 4 min read
Three quarters overhead view of a busy modern office space
April 26, 2024

Q1 2024 U.S. Office Real Estate Market Report

Article 10 min. read