In: Finance
Calculate the average daily balance and finance charge:
(Assume a 30-day billing cycle.)
|
4. |
4/20 |
Billing date previous balance |
$700 |
||
|
4/26 |
Payment |
200 |
|||
|
4/30 |
Charge |
400 |
|||
|
5/4 |
Payment |
150 |
|||
|
5/12 |
Cash advance |
180 |
|||
|
APR is 12% |
|||||
| Date | Opening balance | Debits | Credits | Closing balance | |
| 20-Apr | 700.00 | - | - | 700.00 | |
| 21-Apr | 700.00 | - | - | 700.00 | |
| 22-Apr | 700.00 | - | - | 700.00 | |
| 23-Apr | 700.00 | - | - | 700.00 | |
| 24-Apr | 700.00 | - | - | 700.00 | |
| 25-Apr | 700.00 | - | - | 700.00 | |
| 26-Apr | 700.00 | - | 200.00 | 500.00 | |
| 27-Apr | 500.00 | - | - | 500.00 | |
| 28-Apr | 500.00 | - | - | 500.00 | |
| 29-Apr | 500.00 | - | - | 500.00 | |
| 30-Apr | 500.00 | 400.00 | - | 900.00 | |
| 1-May | 900.00 | - | - | 900.00 | |
| 2-May | 900.00 | - | - | 900.00 | |
| 3-May | 900.00 | - | - | 900.00 | |
| 4-May | 900.00 | - | - | 900.00 | |
| 5-May | 900.00 | - | 150.00 | 750.00 | |
| 6-May | 750.00 | - | - | 750.00 | |
| 7-May | 750.00 | - | - | 750.00 | |
| 8-May | 750.00 | - | - | 750.00 | |
| 9-May | 750.00 | - | - | 750.00 | |
| 10-May | 750.00 | - | - | 750.00 | |
| 11-May | 750.00 | - | - | 750.00 | |
| 12-May | 750.00 | 180.00 | - | 930.00 | |
| 13-May | 930.00 | - | - | 930.00 | |
| 14-May | 930.00 | - | - | 930.00 | |
| 15-May | 930.00 | - | - | 930.00 | |
| 16-May | 930.00 | - | - | 930.00 | |
| 17-May | 930.00 | - | - | 930.00 | |
| 18-May | 930.00 | - | - | 930.00 | |
| 19-May | 930.00 | - | - | 930.00 | |
| Total | 580.00 | 350.00 | 23,390.00 | [A] | |
| Number of days | 30 | [B] | |||
| Average balance | 779.67 | [A/B] | |||
| Interest rate | 12.00% | ||||
| Interest to be paid | 7.69 | [ 23390 × 0.12 × 30/365 ] | |||
| Balance due | 787.36 | [ 779.67 + 7.69] |
Average daily balance is 779.67
Finance charge 7.69