How Is Average Daily Balance Calculated?
Note: Historical calculations for average daily balance and
cost of funds for the month, quarter, and year-to-date for each day
are saved each time you run Transaction Posting (AD190).
The average daily balance of an account is calculated each time Transaction Posting (AD190) is run. The following equations are used for these calculations.
Period ADB | = | Previous Per End Balance | * | Post As of Effective Date | + | Weighted Total of Transactions | |
As of Effective Date | |||||||
Weighted total of transaction | = | Transaction Amount | * | As of (Effective Date | - | Transaction Date or Effective Date | + 1) |
Quarter to Date ADB | = | Weighted Sum | |||||
Quarter Days | |||||||
Year to Date ADB | = | Weighted Sum | |||||
Year Days | |||||||
Weighted Sum | = | Summation of each (Period ADB * Period Days) |