Problem 11 Intro You expect the following sales for the next four quarters (in $ million): Quarter Sales Q1 41 Q2 43.05 Q3 45.2 Q4 47.46 Your beginning accounts receivable balance is $20.5 million and your average collection period (receivables period) is 20 days. You expect to always spend 50% of the following quarter's sales on purchases of components from suppliers. The initial accounts payable balance is $16.4 million and your average account payable period is 60 days. Wages and taxes make up 25% of each quarter's sales. You have to pay $4 million in interest and dividends each quarter, and plan to spend $5 million on new machinery in Q2. You start the year with $3 million in cash. Assume that each quarter has 90 days and that sales occur evenly throughout each quarter. Attempt 1/10 for 8 pts. Part 1 What are your expected cash collections in Q1 (in $ million)? 0+ decimals Submit Attempt 1/10 for 8 pts. Part 2 What are your expected cash disbursements in Q1 (in $ million)? 1+ decimals Submit Attempt 1/10 for 8 pts. Part 3 What is your expected cash balance at the end of Q1 (in $ million)? 1+ decimals Attempt 1/10 for 8 pts. Part 4 What are your expected cash collections in Q2 (in $ million)? 1+ decimals Submit Attempt 1/10 for 8 pts. Part 5 What are your expected cash disbursements in Q2 (in $ million)? 1+ decimals Submit Attempt 1/10 for 8 pts. Part 6 What is your expected cash balance at the end of Q2 (in $ million)? 1+ decimals Problem 11 Intro You expect the following sales for the next four quarters (in $ million): Quarter Sales Q1 41 Q2 43.05 Q3 45.2 Q4 47.46 Your beginning accounts receivable balance is $20.5 million and your average collection period (receivables period) is 20 days. You expect to always spend 50% of the following quarter's sales on purchases of components from suppliers. The initial accounts payable balance is $16.4 million and your average account payable period is 60 days. Wages and taxes make up 25% of each quarter's sales. You have to pay $4 million in interest and dividends each quarter, and plan to spend $5 million on new machinery in Q2. You start the year with $3 million in cash. Assume that each quarter has 90 days and that sales occur evenly throughout each quarter. Attempt 1/10 for 8 pts. Part 1 What are your expected cash collections in Q1 (in $ million)? 0+ decimals Submit Attempt 1/10 for 8 pts. Part 2 What are your expected cash disbursements in Q1 (in $ million)? 1+ decimals Submit Attempt 1/10 for 8 pts. Part 3 What is your expected cash balance at the end of Q1 (in $ million)? 1+ decimals Attempt 1/10 for 8 pts. Part 4 What are your expected cash collections in Q2 (in $ million)? 1+ decimals Submit Attempt 1/10 for 8 pts. Part 5 What are your expected cash disbursements in Q2 (in $ million)? 1+ decimals Submit Attempt 1/10 for 8 pts. Part 6 What is your expected cash balance at the end of Q2 (in $ million)? 1+ decimals