FIMAC Solutions, LLC HomeProducts & ServicesNewsEventsTraining & EducationContactLogin
Colorado photo
FIMAC Solutions, LLC

 

BAnk Consulting

Does budgeting always make the end of the year a time of high stress and frustration?

We have a solution to make budgeting easier…

Leading Light, our Microsoft Excel® based budget model, makes working through the annual budget process a more straight-forward and intuitive progresses.

This system is simple to use and understand. With our three step entry process, FIMAC uploads modeled data from your Risk Analytics® ALM Model into Leading Light budget model. We provide built-in tools to project activity in each balance sheet category as each institution desires. In addition, each non-interest income and non-interest expense category can be broken down into as many as fifty sub-accounts to track activity by cost or profit center, department, or by GL accounts that you want to budget.

Reports, graphs and ratios are available for analysis of pro forma balance sheets, income statements, key operating ratios, and projected-to-actual profit analysis.

Loading Your Actual Data:
FIMAC provides up to date “Beginning Balances” with your institution’s actual yield rates on investments, loans, and deposits. FIMAC accurately provides those rates by month for the upcoming fiscal year to reflect maturities. Current actual balance sheet data is automatically transferred from your Risk Analytics® IRR model. Leading LightSM current figures for non-interest income and expense are easily entered for the most recent fiscal year.

Building the budget is a straight-forward three step process:

  • Step 1: “Enter Balance Sheet Growth Assumptions”. FIMAC provides all the beginning balances preloaded from the balance sheet produced by Risk Analytics ALM Model. No more tedious transcribing of numbers to spreadsheets!
    Enter data manually or choose from any one of the other three pre-programmed growth methods to adjust the beginning balances as you see fit. Macros in the spreadsheet allocate the changes you want to make.

  • Step 2: “Incorporate Detailed Non Interest Income or Expense Data into the Model”.

    Break down the non-interest income and/or expenses by sub-account or cost/profit center.
    User’s can create a budget for specific accounts that they identify, and wish to budget individually, using up to 50 sub-accounts.

  • Step 3: “Enter Growth Assumptions for Non-Interest Income or Expense” - Finally,
    enter projections for the budget period by month, using any one of the 7 built-in
    tools available in Leading Light.

Receive Enhanced Results – Immediately

  • Projected Balance Sheets
  • Income Summaries
  • Key Ratios
  • Color Charts and Graphs!

Need to make changes in the budget?
No worries. Leading Light makes changing assumptions or numbers easy and quick.

For a professional consultation just contact Randall Corwin at extension 739 or Bob Rosen at extension 729 to make your budgeting process a breeze.