In: Finance
From the following facts, Molly Roe has requested you to calculate the average daily balance. The customer believes the average daily balance should be $877.67. Respond to the customer’s concern.
|
28-day billing cycle |
||||
|
3/18 |
Billing date |
$ |
704 |
Previous balance |
|
3/24 |
Payment |
$ |
58 |
cr. |
|
3/29 |
Charge: Sears |
205 |
||
|
4/5 |
Payment |
20 |
cr. |
|
|
4/9 |
Charge: Macy’s |
188 |
||
Average daily balance: ____
Ans: Average Daily balnce is arrived as per below :
Closing balance/Billing cycle
In this question, customer is incorrect about his daily closing balance of $877.67.
Correct Average daily balance is $591.964
| Date | Particulars | Transaction amount | Type | Closing Balance |
| 18-Mar | biling date | 704 | Credit | 704 |
| 19-Mar | 704 | Credit | 704 | |
| 20-Mar | 704 | Credit | 704 | |
| 21-Mar | 704 | Credit | 704 | |
| 22-Mar | 704 | Credit | 704 | |
| 23-Mar | 704 | Credit | 704 | |
| 24-Mar | payment | 58 | Credit | 762 |
| 25-Mar | 762 | |||
| 26-Mar | 762 | |||
| 27-Mar | 762 | |||
| 28-Mar | 762 | |||
| 29-Mar | -205 | debit | 557 | |
| 30-Mar | 557 | |||
| 31-Mar | 557 | |||
| 01-Apr | 557 | |||
| 02-Apr | 557 | |||
| 03-Apr | 557 | |||
| 04-Apr | 557 | |||
| 05-Apr | 20 | Credit | 577 | |
| 06-Apr | 577 | |||
| 07-Apr | 577 | |||
| 08-Apr | 577 | |||
| 09-Apr | -188 | 389 | ||
| 10-Apr | 389 | |||
| 11-Apr | 389 | |||
| 12-Apr | 389 | |||
| 13-Apr | 389 | |||
| 14-Apr | 389 | |||
| Average Daily balance | 591.9643 |