Non-Interest
Use the Non-Interest calculation method to plan balance sheet accounts that are entirely composed of instruments that are not interest-bearing, such as demand deposit (DDA) GL accounts. This calculation method will budget ending balance, average balance, and FTP (optional). The FTP calculations are enabled by setting the file group variable called FTPCalcFlag to Yes.
The Non-Interest calculation method has three planning methods that the user can use to plan the account balance. Ending balances are calculated and the average is calculated as the average of prior ending balance and projected ending (2 point average). The administrator has the option in the Balance Sheet Projections to allow the user to override the calculated average balance. The administrator can also set the average balance equal to the ending balance, thereby allowing the user to enter the average balance in cases where there are wide daily swings in balances and a 2 point average isn't appropriate for projecting average balance. Use this approach if the focus is projecting averages for interest calculations.
| Balance Planning Method | 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. |
IMPORTANT: When you make changes to plan file drivers, you must process the plan file in order to see your changes in the department budget rollup.
Average balance calculation type
An account that is assigned to use the Non-Interest calculation method can be configured to use the average balance calculation type of either Ending Balance or 2 Point Average, which affects the plan file:
- When the account is configured in the Balance Sheet Projections driver to use the average balance calculation type of Ending Balance, the monthly projected fields display the average balance as equaling the ending balance.
- When the account is configured in the Interest Bearing Map driver to use the average balance calculation type of 2 Point Average, the average balance equals (prior month ending balance + current balance) ¸ 2.
Click image to view full size
