Previous | Next | Contents | Index | Navigation | Glossary | Library |
This example assumes that we are looking at the activity and balances for one account in a set of books. The ending balance for May 31st was $100,000.
Example: Period Average-to-Date Calculation | ||||
Day | Activity | Ending Balance | PTD Aggregate Balance | PTD Range |
June 1 | $5,000 | $105,000 | $105,000 | 1 |
June 2 | $8,000 | $113,000 | $218,000 | 2 |
June 3 | $4,000 | $117,000 | $335,000 | 3 |
= | PTD Aggregate Balance (as of June 3) divided by PTD Range (number of days: period-to-date) | ||
= | $335,000 / 3 days | ||
= | $111,666.67 |
Note: The PTD aggregate balance is reset to zero at the beginning of each period.
Relationship Between Aggregate and Average Balances
Example: Quarter Average-to-Date Balance
Example: Year Average-to-Date Balance
Previous | Next | Contents | Index | Navigation | Glossary | Library |