Prepare a cash budget month by month for the quarter

1.Actual Receipts (money in) from Accounts Receivable are 70% of the previous
months Credit Sales and the balance of 30% owing is received in the following
month. For example if we had Credit Sales of $100000 in January we would
expect to receive 70% of that $100000 in February and the balance (30%) in
March.
Credit Sales for September 2020 were $80,000 as they were in August 2020.
Cash Sales were $16,500 in August 2020 and $18,000 in September of 2020.
2. Payment of Accounts Payable is paid 60% of purchases in the month of
purchase and the remaining 40% in the month following. Purchases in
September 2020 were $36,000.
3. The cash balance at 1 October 2020 was $52,890
Required
Prepare a cash budget month by month for the quarter ending 31 December 2020.
Note that marks will be deducted for each incorrect posting to the cash budget.
(15 Marks).

Need Help Writing an Essay?

Tell us about your assignment and we will find the best writer for your project

Write My Essay For Me

The post Prepare a cash budget month by month for the quarter appeared first on Assignment Freelancers.