Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have complete part 1 of this question need a step by step solution for Part 2 the Cash Budget. Sales revenue Purchases Cost of

I have complete part 1 of this question need a step by step solution for Part 2 the Cash Budget.

image text in transcribedimage text in transcribed

Sales revenue Purchases Cost of sales Marketing and administration expenses Occupancy expenses Depreciation expense 31 March $ 790 000 504 000 395 000 188 000 87000 14 400 Quarter ending 30 June 30 September $ 890 000 $990 000 429 000 409 000 445 000 495 000 188 000 188 000 87000 87 000 14400 14 400 31 December $1 040 000 439 000 520 000 188 000 87 000 14400 Sales in the December quarter of 2017 were $690 000. - All sales are on credit, of which 55 per cent are collected in the quarter of sale and 45 per cent in the following quarter. Purchases are on credit, and entity policy is such that all purchases are paid for in the same quarter. The marketing and administration expenses incurred and paid are the same. Occupancy expenses incurred and paid are usually the same, except that the electricity bill (estimated to be $700) for December 2018 will not be paid until January 2019. A major IT hardware acquisition of $27 300, to be paid for in cash, is expected in the December quarter. The bank balance at 31 December 2017 was $18 450. Required a. Prepare a schedule of receipts from accounts receivable showing cash collections for each quarter of 2018. b. Prepare a cash budget (on a quarterly basis) for the 12 months ending 31 December 2018. a. Receipts from Debtors Schedule for 12 months ending 31 December 2018 September December Credit Sales December $690,000 March $790,000 June $890,000 September $990,000 December $104,0000 Total Cash Receipts March June 310,500 434,500 355,500 489,500 400,500 544,500 445,500 572,000 1,017,500 745,000 845,000 945,000 Rainbow Enterprises Cash budget (insert Date line) March June September Dec Total List as many non-cash items that you can think of

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Social Media A Governance And Risk Guide

Authors: Peter R. Scott, J. Mike Jacka

1st Edition

1118061756, 978-1118061756

More Books

Students also viewed these Accounting questions

Question

What is the effect of word war second?

Answered: 1 week ago

Question

1. Identify three approaches to culture.

Answered: 1 week ago

Question

2. Define communication.

Answered: 1 week ago

Question

4. Describe how cultural values influence communication.

Answered: 1 week ago