Mass Housing Partnership

MHP has an aggressive ten year strategic plan that is critical to the long-term operational viability of the organization. Because of the strategic goals, processes and tools needed to support the monitoring and measurement of this long-term strategy. MHP was experiencing challenges in effectively aligning their operational budgeting needs to the organizational strategy of the business. These challenges were due to financial data being located in multiple, disparate locations as well as the primary use of spreadsheets to manage company financial processes.

With financial data being located in various locations, any changes made to the data were not necessarily being reflected in all locations and therefore causing manual, time-intensive data integration problems across the organization. In addition, relying on spreadsheets created significant problems as they were not designed for multiple users, data consolidation, or to provide the appropriate level of security for financial information. The lack of data integration and consolidation across the organization also compounded the data management problem.

Caturano and Company worked with MHP to effectively articulate the operational budgeting needs and worked to align these requirements with the strategic planning process. To accomplish this goal, Caturano evaluated MHP’s business requirements, selected a software solution, and deployed a system that offered better functional reporting, on-demand availability, and a lower total cost of ownership. This solution allowed MHP to quickly see how changes made to data had a direct effect on the business model.

Caturano and Company met with MHP’s finance team to determine their requirements for a functional budget model that fit their operations and was easy to maintain across the organization. In addition, existing loan portfolio and forecasted loan assumptions were consolidated from spreadsheets into a model where they could be used for reporting and seamlessly integrate into MHP’s financial projections.

Within weeks, MHP had the ability to effectively review and analyze an operating plan that was closely aligned with their organizational goals. The ability to report on profitability and the health of the business allowed MHP to effectively evaluate and identify where issues reside in their business, as well as make management decisions to address these areas. MHP now has the ability to analyze when their portfolio will require additional funding based on its loan forecast resulting in more confidence and efficiency around their budgeting and forecasting processes.