Gainesville Logo
Share to Facebook Share to Twitter Bookmark and Share
File #: 180528.    Version: Name:
Type: Staff Recommendation Status: Passed
File created: 11/6/2018 In control: Utility Advisory Board
On agenda: 11/8/2018 Final action: 11/15/2018
Title: Financial Modeling Services (B)
Attachments: 1. 180528 Whitebirch Financial Modeling contract 20181108


Financial Modeling Services (B)


For a number of years GRU has utilized internally developed models to construct financial forecasts and assist in rate development. During the FY19 budget process 70 different model runs were generated to address various rate structure questions and issues, a process which required significant staff time and effort.

 A spin-off of GRU’s financial advisor Public Financial Management, Inc. has developed modeling software that provides the ability to consider many scenarios, as well as their associated branches and sequels that are typically requested as part of the budget process. It takes into account variables such as demand, rates across customer classes, operating revenue, capital forecasts, and financing alternatives.  The model provides real-time analysis including:

                     Rate-setting across multiple customer classes, what-ifs and analysis

                     Volume/demand sensitivities

                     Capital projects, magnitude and timing

                     Operating initiatives, programs and projects

                     Financing options and alternatives

                     Real-time credit benchmarking against rating agency methodologies

This item was presented to the UAB on November 8, 2018, where it was approved on consent.


Fiscal Note

The contract calls for a one-time implementation fee of $75,000 and annual fees of $75,000.



Staff recommends that the City Commission approve the agreement with PFM Solutions LLC for provision of financial modeling platform services.  

The UAB recommends the City Commission approve the staff recommendation.




© 2014 City of Gainesville, Florida. All right reserved.

City Departments
Online Contact
200 East University Ave.
Gainesville, FL 32601