Working with balance sheets

The Balance Sheet tab allows you to manage the budget for associated assets, liabilities, and equity.

To access the Balance Sheet tab:

  1. From the FI Home page, click Financial Planning.

    Click to enlarge image

  2. On the Financial Planning home page, click the notepad icon in the Plan Code column for the department.

    Click to enlarge image

  3. On the plan file page, click the Balance Sheet tab, if it is not already selected.

    Click to enlarge image

This tab contains the following elements: 

This section displays a summary or detailed view of accounts and department budget rollups, which is controlled by the View drop-down.
You can modify the display format for budget information about assets, liabilities, and equity using the following controls: Change data view, Measure, Summary/Detail (toggle), and View. See Controls available for displaying Assets, Liabilities, and Equity.
Sub-tabs group financial data into assets, liabilities, and equity. Each sub-tab breaks down a category, such as assets, into subcategories that identify the specific type of asset. Accounts then identify the departments that own a specific asset type.

To update information for assets, liabilities, or equity:

  1. Select how you want to display your budget information.
  2. Navigate to the account and department that you want to manage.

  3. Click the Notepad icon to edit the data.

    NOTE: The format of the table associated with the Notepad icon differs, depending on whether you select Summary or Detail view.

  4. From the View list, select the desired time period you want to display.

  5. From the balance projection method list, select the method you want to use to project balances, if enabled. The account opens to the balance method preassigned by the planning administrator and they will enable your ability to select a different method from this list. The list only displays calculation methods associated with the calculation method assigned to the account.

    Click image to view full size

    Input Details Description
    Input Monthly Balance

    This option allows the user to manually input ending balances by month. The calculation method then calculates outstanding new volume balances, based on the difference between the projected ending balance and the current portfolio ending balance.
    Input Year End Balance

    This option allows the user to input the target year-end balance and the calculation method linearly interpolates each month’s end balances. The calculation method then calculates new volume based on the difference between the projected ending balance and the current portfolio ending balance.
    Apply Growth Rate

    The budget administrator sets growth rates for all balance sheet ACCTS in the Acct Growth Drivers. The rates, which are applied globally across all plan files, can be adjusted by the user. In the Acct Growth Drivers the administrator also selects, by account, which method to use for calculating balance growth over the remainder of the base year. For more information, see Methods for calculating balance sheet growth.
    Input New Volume*

    This option allows users to input projected new volume production each month. Monthly ending balances are then calculated as remaining current portfolio ending balance plus the sum of monthly new volume amounts less projected new volume repayments.
    Input new vol / Year-end balance*

    This hybrid method is available for multi-year planning. The user will input new volume production in the initial plan years, and then project the remaining years by entering year-end target balances.

    NOTE: Your administrator indicates the number of years that they want you to enter new volumes in the Interest Bearing Maps driver.
    Input new vol / Annual Growth Rate*

    This hybrid method is available for multi-year planning. The user will input new volume production in the initial plan years, and project the remaining years’ balances using annual growth rates. Consistent with the Annual Growth Rate method, the user has the option to enter new volume balance adjustments in the years where growth rate projections apply.

    NOTE: The balance projection method list only displays new volume adjustments (New Input Volume, Input new vol/Year-end balance, and Input new vol/Annual Growth rate balance projection methods) when the Cash Flow calculation method is being used.

  6. Select the department that you want to maintain and enter information in the respective editable fields (based on the calculation method associated with the account).
  7. [Optional] Click to export the information in the table to an Excel spreadsheet.
  8. When you are done entering information for the balance sheet assets, liabilities, or equity, click the Save icon .

Controls available for displaying assets, liabilities, and equity

You can modify the display format for budget information about assets, liabilities, and equity using the controls described below.

Click the Change Data View icon to open a dialog box for configuring column views.

  • Clear one or more check boxes to hide columns from the table, in order to see more data without scrolling horizontally.

  • You can later select any cleared check boxes to display columns that you have hidden.
From the Measure drop-down, select one of the following measure types:
 
Option Description
Ending Balance Displays the end-of-month account balances.
Average Balance Displays the average account balances for each period. Average for the year is the monthly weighted average (by days) for the year.
Interest Displays interest income or expense for each period. Total for the year.
FTP Spread

Displays FTP spread, which is the difference between an account's interest and its FTP calculated. Total for the year.

NOTE: FTP must be enabled for the file group for FTP spread to be displayed.
Average Interest Rate Displays the average rate earned on interest-bearing assets (Yield) or the average rate paid for interest-bearing liabilities (Cost).
FTP Rate Spread

Displays FTP rate spread percentages. The difference between the average Yield or Cost and the FTP rate each period.

NOTE: FTP must be enabled for the file group for FTP rate spread to be displayed.

Use the toggle to set your account and department view to Summary or Detail.

  • To view a budget department list summary that allows you to drill down to account and department budget rollup, click Summary. See Summary view.

  • To view a budget department list detail that displays all budget accounts and department rollups, click Detail. See Detail view.
From the View drop-down list, specify the time period breakdown by selecting one of the following:
 
Option Description
Projected Months - 20XX-20XX Displays the last actual month plus projected months for the base year and plan year 1.
All Projected Months Displays the projected months for the base year, plan year 1, and plan year 2.
All Actual and Projected Months Displays the actual and projected months for the base year and projected months for plan year 1 and plan year 2.
Monthly - 20XX Displays the annual budgets and monthly budgets for the base year.
Monthly - 20XX Displays the annual budgets and monthly budgets for plan year 1.
Monthly - 20XX Displays the annual budgets and monthly budgets for plan years 2 through 5.
Annual Summary Displays the (previous year end, base, and projected) annual budgets.

Navigating to the account and department

You modify department budgets by clicking the notepad icon () associated with the account and department that you want to review and modify. Access to the notepad icon differs, based on whether you are viewing the summary or detail view of the plan file.

Summary view

To modify department budgets from the Summary view:

  1. In the Budget Section column, click the arrow () associated with the desired budget to show the account(s).
  2. In the Account column, click the arrow associated with the desired account to show the department budget rollups.
  3. In the Budget Rollup column, click the notepad icon () associated with the desired rollup to show and edit the selected department budget rollup details.

Click image to view full size

Detail view

To modify a department budget from the Detail view, click the notepad icon () in the Account column associated with the department budget roll-up.

Click image to view full size

Assets, Liabilities, and Equity data fields

Enter or select the applicable information for balance sheet assets, liabilities, and equity using the text entry fields and drop-down lists in the following table. All other fields are read-only and calculated by the system.

Field Action
Base Year (year)

When using the Apply Growth Rate calculation method, type a percentage for adjustment to growth rate.

When using the Input Year End Balance calculation method, type the target balance for the end of the year.
Plan Year 1 (year)

When using the Apply Growth Rate calculation method, type a percentage for adjustment to growth rate.

When using the Input Year End Balance calculation method, type the target balance for the end of the year.
Plan Year 2–5 (year)

When using the Apply Growth Rate calculation method, type a percentage for adjustment to growth rate.

When using the Input Year End Balance calculation method, type the target balance for the end of the year.
Projected (mo)

When using the Input Monthly Balance calculation method, type the target balance for the month.

When using the Cash Flow calculation method with the Input New Volume or Apply Growth rate, type the amount of new volume or new volume adjustment. 

When using either the Cash Flow or Simple Interest calculation methods, type a percentage for the Yield adjustment to calculated rate.

NOTE: For the Non-Interest calculation method, this is read-only and calculated by the system.
Plan (mo)

When using the Input Monthly Balance calculation method, type the target balance for the month.

When using the Cash Flow calculation method with the Input New Volume or Apply Growth rate, type the amount of new volume or new volume adjustment.

When using either the Cash Flow or Simple Interest calculation method, type a percentage for the Yield adjustment to calculated rate.

NOTE: For the Non-Interest calculation method, this is read-only and calculated by the system.
Comments Type a comment of up to 250 characters in length, using alphabetic or numeric characters.
See also