Sales |
Purchases |
|
June |
$60,000 |
$36,000 |
July |
$78,000 |
$54,000 |
August |
$66,000 |
$60,000 |
Required
Prepare a cash budget for August that identifies the expected cash receipts, cash payments and ending cash balance on 31 August.
Cash Budget for August | ||
Opening Cash Balance | 22,000 | |
Add: Expected Cash Receipts* | 67,200 | |
Total Available Cash | 89,200 | |
Less: Expected Cash Payments for Purchases** | 54,000 | (Payment made for July Purchases) |
Less: Expected Cash Payments for Others | 14,400 | |
Ending Cash Balance | 20,800 | |
Expected Cash Receipts*: | ||
For August Sales(66000*70%) | 46,200 | |
For July Sales(78000*20%) | 15,600 | |
For June Sales(60000*9%) | 5,400 | |
Total | 67,200 | |
Get Answers For Free
Most questions answered within 1 hours.