Square Peg Corp.'s actual sales for the previous quarter (Q4) and estimated sales for the next four quarters are given below (in $ million):

Quarter	Q4	Q1	Q2	Q3	Q4
Sales ($ million)	120	132	145	160	176

20% of sales are cash sales and the remainder are credit sales which are collected in the following quarter. The cash balance at the beginning of Q1 is $200 million.

The company sells its products for $10 per unit and it costs $5 to produce each unit. All production costs are paid in the quarter of the sale. In addition, the company incurs fixed costs of $40 million per quarter.

The company uses level production, producing one quarter of expected annual production in quarters 1 to 4.

1. Determine cash collections for Q1 to Q4. What are cash collections in Q4 (in $ million).
2. Determine cash disbursements for Q1 to Q4. What are cash disbursements in Q4 (in $ million)?
3. Determine cash balance at the end of Q1 to Q4. What is the cash balance at the end of Q4 (in $ million)?

Answer rating: 100% (QA)

To determine the cash collections for Q1 to Q4 we need to calculate the cash received from customers ... View the full answer