Question
part A has been completed answer part B cash budget (second photo) part B question: Prepare a cash budget (on a quarterly basis) for the
part A has been completed answer part B cash budget (second photo)
part B question: Prepare a cash budget (on a quarterly basis) for the 12 months ending 31 December 2018. (Please leave any answer fields without an entry blank. Enter negative amounts using either a negative sign preceding the number, e.g. -45, or parentheses, e.g. (45).)
Rainbow Enterprises has presented the following estimates relating to 2018 activities:
Sales in the December quarter of 2017 were $550,000. All sales are on credit, of which 65 per cent are collected in the quarter of sale and 35 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 $560) for December 2018 will not be paid until January 2019. A major IT hardware acquisition of $25,900, to be paid for in cash, is expected in the December quarter. The bank balance at 31 December 2017 was $18,310.
Prepare a cash budget (on a quarterly basis) for the 12 months ending 31 December 2018. (Please leave any answer fields without an entry blank. Enter negative amounts using either a negative sign preceding the number, e.g. -45, or parentheses, e.g. (45).)
Rainbow Enterprises has presented the following estimates relating to 2018 activities: Sales revenue Purchases Cost of sales Marketing and administration expenses Occupancy expenses Depreciation expense 31 March $650,000 411,000 325,000 160,000 73,000 13,000 Quarter ending 30 June 30 September $750,000 $850,000 415,000 395,000 375,000 425,000 160,000 160,000 73,000 73,000 13,000 13,000 31 December $900,000 425,000 450,000 160,000 73,000 13,000 Sales in the December quarter of 2017 were $550,000. All sales are on credit, of which 65 per cent are collected in the quarter of sale and 35 per cent in the following to be $560) for December 2018 will not be paid until January 2019. A major IT hardware acquisition of $25,900, to be paid for in cash, is expected in the December qua (a) ZYour answer has been saved and sent for grading. See Gradebook for score details, Prepare a schedule of receipts from accounts receivable showing cash collections for each quarter of 2018. (Please leave any answer fields without an entry blank. Rainbow Enterprises Schedule of receipts from accounts receivable for the quarters ending 31 December 2018 Receipts ($) Month Sales March June September December December 2017 $550,000 192,500 March $650,000 422,500 227,500 June $750,000 487,500 262,500 September $850,000 552,500 297,500 December 2018 $900,000 585,000 Total 615,000 715,000 815,000 882,500 Type here to search ty 9 FT F2 F3 F4 F5 FG Prisen FB Home 9 End 10 Pgu # % A * & 7 ( 9 2 3 4 5 6 8 11 DUR. EN galve amounts using either a negative sign Rainbow Enterprises Cash budget for the quarters ending 31 December 2016 June (5) September (9) March (5) December (5) Total (9) SHOW HINT mere to search OBI E * DI Prisen FO Home End TVO Paup F F6 F ES # A & $ 4 % 5 3 6 7 2 8 9 E R Y T W U O activities: 31 March Sales revenue Purchases Cost of sales Marketing and administration expenses Occupancy expenses Depreciation expense $650,000 411,000 325,000 160,000 73,000 13,000 Quarter ending 30 June 30 September $750,000 $850,000 415,000 395,000 375,000 425,000 160,000 160,000 73,000 73,000 13,000 13,000 31 December $900,000 425,000 450,000 160,000 73,000 13,000 Sales in the December quarter of 2017 were $550,000. All sales are on credit, of which 65 per cent are collected in the quarter of to be $560) for December 2018 will not be paid until January 2019. A major IT hardware acquisition of $25,900, to be paid for in (a) Your answer has been saved and sent for grading. See Gradebook for score details, Prepare a schedule of receipts from accounts receivable showing cash collections for each quarter of 2018. (Please leave any ans Month Rainbow Enterprises Schedule of receipts from accounts receivable for the quarters ending 31 December 2018 Receipts ($) Sales March June September $550,000 192,500 $650,000 422,500 227,500 $750,000 487,500 262,500 December 2017 March June ere to search O RI Depreciation expense 73,000 13,000 73,000 13,000 73,000 13,000 73,000 13,000 Sales in the December quarter of 2017 were $550,000. All sales are on credit, of which 65 per cent are collected in the quarter of sale and 35 per cent in the following qua to be $560) for December 2018 will not be paid until January 2019. A major IT hardware acquisition of $25,900, to be paid for in cash, is expected in the December quarte (a) ZYour answer has been saved and sent for grading. See Gradebook for score details Prepare a schedule of receipts from accounts receivable showing cash collections for each quarter of 2018. (Please leave any answer fields without an entry blank. En Month December December 2017 March Rainbow Enterprises Schedule of receipts from accounts receivable for the quarters ending 31 December 2018 Receipts (5) Sales March June September $550,000 192,500 $650,000 422,500 227,500 $750,000 487,500 262,500 $850,000 552.500 $900,000 June September 297,500 December 2018 585,000 Total 615,000 715,000 815,000 882,500 (b) Prepare a cash budget (on a quarterly basis) for the 12 months ending 31 December 2018. (Please leave any answer fields without an entry blank. Enter negative amount Rainbow Enterprises Cash budget for the quarters ending 31 December 2018 March ($) June ($) September (5) December (5) V e here to search O DI x () FT F2 F3 F4 FS F6 Prtsen FB F7 Home 19 End 710 # $ % 5 & 7 2 3 4 6 8 9 0 w E R T Y U 1 Prepare a cash budget (on a quarterly basis) for the 12 months ending 31 December 2018. (Please leave any answer fields without an entry blank. Enter negative amounts wing either a negative sign preced Rainbow Enterprises Cash budget for the quarters ending 31 December 2018 March (5) June ($) September (5) December (5) Total (5) SHYW HIND do ING 2238 14/10/2 O f E Type here to search * End Prison 40 Home Poon 40 PU F TY F2 A % # & $ 4 6 7 00 9 0 5 2 3 P a Y T T R il E w Q G H K F A D S Rainbow Enterprises has presented the following estimates relating to 2018 activities: Sales revenue Purchases Cost of sales Marketing and administration expenses Occupancy expenses Depreciation expense 31 March $650,000 411,000 325,000 160,000 73,000 13,000 Quarter ending 30 June 30 September $750,000 $850,000 415,000 395,000 375,000 425,000 160,000 160,000 73,000 73,000 13,000 13,000 31 December $900,000 425,000 450,000 160,000 73,000 13,000 Sales in the December quarter of 2017 were $550,000. All sales are on credit, of which 65 per cent are collected in the quarter of sale and 35 per cent in the following to be $560) for December 2018 will not be paid until January 2019. A major IT hardware acquisition of $25,900, to be paid for in cash, is expected in the December qua (a) ZYour answer has been saved and sent for grading. See Gradebook for score details, Prepare a schedule of receipts from accounts receivable showing cash collections for each quarter of 2018. (Please leave any answer fields without an entry blank. Rainbow Enterprises Schedule of receipts from accounts receivable for the quarters ending 31 December 2018 Receipts ($) Month Sales March June September December December 2017 $550,000 192,500 March $650,000 422,500 227,500 June $750,000 487,500 262,500 September $850,000 552,500 297,500 December 2018 $900,000 585,000 Total 615,000 715,000 815,000 882,500 Type here to search ty 9 FT F2 F3 F4 F5 FG Prisen FB Home 9 End 10 Pgu # % A * & 7 ( 9 2 3 4 5 6 8 11 DUR. EN galve amounts using either a negative sign Rainbow Enterprises Cash budget for the quarters ending 31 December 2016 June (5) September (9) March (5) December (5) Total (9) SHOW HINT mere to search OBI E * DI Prisen FO Home End TVO Paup F F6 F ES # A & $ 4 % 5 3 6 7 2 8 9 E R Y T W U O activities: 31 March Sales revenue Purchases Cost of sales Marketing and administration expenses Occupancy expenses Depreciation expense $650,000 411,000 325,000 160,000 73,000 13,000 Quarter ending 30 June 30 September $750,000 $850,000 415,000 395,000 375,000 425,000 160,000 160,000 73,000 73,000 13,000 13,000 31 December $900,000 425,000 450,000 160,000 73,000 13,000 Sales in the December quarter of 2017 were $550,000. All sales are on credit, of which 65 per cent are collected in the quarter of to be $560) for December 2018 will not be paid until January 2019. A major IT hardware acquisition of $25,900, to be paid for in (a) Your answer has been saved and sent for grading. See Gradebook for score details, Prepare a schedule of receipts from accounts receivable showing cash collections for each quarter of 2018. (Please leave any ans Month Rainbow Enterprises Schedule of receipts from accounts receivable for the quarters ending 31 December 2018 Receipts ($) Sales March June September $550,000 192,500 $650,000 422,500 227,500 $750,000 487,500 262,500 December 2017 March June ere to search O RI Depreciation expense 73,000 13,000 73,000 13,000 73,000 13,000 73,000 13,000 Sales in the December quarter of 2017 were $550,000. All sales are on credit, of which 65 per cent are collected in the quarter of sale and 35 per cent in the following qua to be $560) for December 2018 will not be paid until January 2019. A major IT hardware acquisition of $25,900, to be paid for in cash, is expected in the December quarte (a) ZYour answer has been saved and sent for grading. See Gradebook for score details Prepare a schedule of receipts from accounts receivable showing cash collections for each quarter of 2018. (Please leave any answer fields without an entry blank. En Month December December 2017 March Rainbow Enterprises Schedule of receipts from accounts receivable for the quarters ending 31 December 2018 Receipts (5) Sales March June September $550,000 192,500 $650,000 422,500 227,500 $750,000 487,500 262,500 $850,000 552.500 $900,000 June September 297,500 December 2018 585,000 Total 615,000 715,000 815,000 882,500 (b) Prepare a cash budget (on a quarterly basis) for the 12 months ending 31 December 2018. (Please leave any answer fields without an entry blank. Enter negative amount Rainbow Enterprises Cash budget for the quarters ending 31 December 2018 March ($) June ($) September (5) December (5) V e here to search O DI x () FT F2 F3 F4 FS F6 Prtsen FB F7 Home 19 End 710 # $ % 5 & 7 2 3 4 6 8 9 0 w E R T Y U 1 Prepare a cash budget (on a quarterly basis) for the 12 months ending 31 December 2018. (Please leave any answer fields without an entry blank. Enter negative amounts wing either a negative sign preced Rainbow Enterprises Cash budget for the quarters ending 31 December 2018 March (5) June ($) September (5) December (5) Total (5) SHYW HIND do ING 2238 14/10/2 O f E Type here to search * End Prison 40 Home Poon 40 PU F TY F2 A % # & $ 4 6 7 00 9 0 5 2 3 P a Y T T R il E w Q G H K F A D SStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started