Planning & Consolidation for Banks & Credit Unions

1. The Banking industry has unique models to plan/forecast their business and must combine traditional Finance FP&A with Balance Sheet/Net Interest Margin Planning
2. Overall budget process includes Net Interest Margin Planning, Capital Expenditures, Human Resource, Operating Costs and Fee Revenue
3. In addition to the traditional general ledger data necessary to produce financial statements and support internal controls, banks require easy access to sub ledger account detail for investments, loans, transactional deposit accounts, time deposits and borrowings
4. To calculate Net Interest Margin, they must be able to integrate data from loans and deposits with general ledger data and then apply growth and interest rate drivers to calculate interest earned and principal cash flows
5. 1. The calculations must include projections based on the attributes of existing customer accounts and the anticipated attributes of new balances
   2. These calculations must be based on forecasted interest rates
      

Performance Analytics will address all functions on a single platform: OneStream.

1. Financial Close including customer account data for loans and deposits
2. Scenario modeling allowing the finance team to test sensitivity to economic and demographic drivers
3. Budget and forecasting addressing the computational and data demands of Net Interest Margin planning
4. Profitability calculations based on Funds Transfer Pricing (FTP) and account attributes

Solution Architecture (OneStream)

To see a demonstration, click here.