An asset manager running equipment finance and small business product strategies was cash flow forecasting across dozens of siloed spreadsheet tabs, disconnected from the source-of-truth data held by its fund administrator. Oak Branch Advisors consolidated the forecasting and reporting into PCS/1, removing the manual bottleneck.
The manager’s cash flow forecasting models had grown to more than 50 discrete, non-normalized spreadsheet tabs and workbooks (per reporting period!), making routine internal reporting and forecasting slow and cumbersome. The models were also operationally disconnected from the data held with the fund administrator, and asset-level expenses were being tracked manually from invoice PDFs and entered into the models by hand.
Oak Branch’s team deployed PCS/1 to survey, structure, forecast, and report on the manager’s strategies in an integrated way, replacing the fragmented spreadsheet tabs with a single, consistent model. Our team worked directly with the manager’s operations group to drive insightful, dynamic reporting, with collaborative forecasting scenarios built for each specific strategy.
Data feeding PCS/1 is sourced directly from transaction documents, the client, and third-party data providers, where it is integrated with our cash flow forecasts to create interactive reporting.
The manager moved from a fragmented, manually maintained forecasting process to a single integrated model connected directly to its source-of-truth data, giving its operations and investment teams faster, more reliable reporting across every strategy.
A single model replaces 50-plus disconnected spreadsheet tabs and workbooks, aggregating and parsing data across every strategy the manager runs.
Data is pulled directly from transaction documents, the client, and third-party providers such as banks and administrators.
PCS/1 is regularly refined and re-published, including mobile views, as new reporting needs are identified.
This approach fits any manager, regardless of strategy, whose forecasting has outgrown spreadsheets, particularly where internal models have become fragmented or are disconnected from third party data.
Data comes directly from transaction documents, the client, and third-party data providers such as banks and administrators.
Yes. PCS/1 includes mobile views alongside desktop reporting, refined regularly as new needs are identified.
