Part B

Hillside Caf has provided the following estimates relating to the first quarter of the financial year beginning 1^st July 2020:

Cash Sales	$138,000
Credit Sales	$277,200
Receipts from Debtors	$214,500
Wages paid	$162,000
Caf Furniture purchased	$37,800
Utilities paid	$22,800
Administration paid	$11,400
Depreciation of furniture	$945
Receipt of Loan	$45,000
Credit Purchases	$98,400

The cash balance at 1 July 2020 is expected to be $66,000.

Required

Prepare a cash budget for the quarter ending 30 September 2020.

Hillside Caf

Cash Budget For the quarter ended 30 September 2020

Please help with the above question

Below is one example with solutions just like the above question:

Ainsworth Enterprises has provided the following estimates relating to the first quarter of 2011: Cash Sales $46,000 Credit Sales $92,400 Receipts from Debtors $71,500 Wages $54,000 Office Furniture $12,600 Utilities $3,800 Administration $14,100 Depreciation of furniture $315 Receipt of Loan $15,000 Credit Purchases $32,800 Payment to Creditors $52,900 The cash balance at 1 July 2011 was $11 250. Required Prepare a cash budget for the quarter ending 30 September 2011. Ainsworth Enterprises Cash Budget For the quarter ended 30 September 2011 Expected Cash Receipts $ Cash Sales $46,000 Receipts from Debtors $71,500 Receipt of Loan $15,000 $132,500 Total Expected Cash Payments Wages Office Furniture Utilities Administration Payment to Creditors $54,000 $12,600 $3,800 $14,100 $52,900 Total Net Cash flow Cash Balance 1 July 2011 Cash Balance 30 September 2011 $137,400 (4,900) $11,250 $6,350