1. what is your expected total cash collection in future Q4?

2. what is your expected total cash disbursement in future Q4?

3. what is your expected cash balance at the end of Q4?

Please provide excel worksheet with and without formulas.

Intro It is the beginning of January. Actual sales for the previous quarter (Q4) and estimated sales for the next five quarters are as follows (in $ million): Quarter Q4 Q1 Q2 Q3 Q4 Q1 Sales 61 63 68 70 73.2 75 You collect 30% of sales in the quarter of the sale, and the remainder in the next quarter You expect to always spend 40% of the following quarter's sales on purchases of components from suppliers. You pay 60% of purchases in the quarter of the purchase, and the reminader in the next quarter Wages and other expenses add up to 35% of each quarter's sales. You have to pay $4 million in interest and dividends each quarter and plan to spend $60 million on new machinery in Q2. You start the year with $3 million in cash. Any additional short-term borrowing will be done at a quarterly interest rate of 1%