Building and Maintaining a Grant Forecast

In the current funding climate, it can be hard for community colleges and non-profits to stage grants due to uncertainty around the availability of funds or inconsistent funding schedules. One tool which can help alleviate this unpredictability is a grant forecast. A grant forecast centralizes knowledge about predicted, soon to be available, and open grant opportunities, both public and philanthropic. Using a forecast allows organizations to begin the grant application process sooner, which not only makes the entire experience less stressful, it also produces better quality applications. In this blog we review New Growth’s process for building and maintaining a grant forecast.


Building your Forecast

A grant forecast is not a complicated document. Depending on how you intend on using the forecast, a searchable spreadsheet or database works best. When building the forecast, it is helpful to think about who will be using the forecast and collecting and centralizing information about funding opportunities. Consider:

  • What are our strategic priorities, and how can funding support them?
  • Which projects or programs need the most financial support?
  • Who will be using the forecast and what information is most relevant to them?

Answering these questions will help you narrow your grant search and specify the information you need to gather to make the tool useful.

Once you have set the boundaries of your search, it is time to begin to fill in your forecast. The easiest place to start is to look at previous awards. Consider:

  • Who awarded the grant?
  • Did we deliver on our expectations?
  • Is this a recurring opportunity? If so, when will we have an opportunity to reapply?
  • Do we still have a relationship with the program officer? What information can we learn from them about other funding opportunities?

The answers to these questions will fill the base of your forecast. From here you can look to other sources of information such as, the foundation center, state departmental websites, and other grantees to identify potential or open opportunities.


Maintaining your Forecast

A grant forecast is not a static document, it must be updated frequently to be useful. At New Growth we update our master forecast at least once a month, and sometimes more frequently depending on the funding cycle. Maintaining the forecast also requires data cleaning. When a grant opportunity has closed or will no longer be offered, this knowledge must be shared. This process requires monitoring and upkeep. We use separate tabs for opportunities based on their status (potential/open, closed, no longer offered), to help make information accessible. Our Grants Manager, Robin King, estimates that building a forecast can take up to 55 hours of staff time, and once it is built maintaining it can require up to 10 hours of staff time per month


New Growth Can Help

For smaller organizations, the capacity required to build and maintain a grant forecast might seem like a challenge. New Growth is here to help. We have  helped community colleges and non-profits from across the nation stage their grants through the use of a grant forecast. We have a master forecast that we share with clients to give them a shot in-time analysis of current funding opportunities and provide them with a forecast template that they can update as needed. We also work more closely with clients, through digging into their strategic priorities and providing them with a customized forecast which identifies the best grant opportunities for them. If you need help identifying potential funding sources for your next project, email Robin and she’ll co-create a forecasting solution that fits the needs of your organization.