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 | 24 | 25.2 | 26.46 | 27.78 | 29.17 | 30.63 |
You collect 50% of sales in the current quarter and the remainder in the following quarter. You expect to spend 40% of the following quarter's sales on purchases of components from suppliers, and to pay 70% of those purchases in the current quarter and the remainder in the following quarter. Wages and other expenses add up to 30% of each quarter's sales.
You have to pay $4 million in interest and dividends each quarter, and plan to spend $7 million on new machinery in Q3.
Assume that each quarter has 90 days, sales occur evenly throughout the quarter and all other cash flows occur at the end of the quarter.
Part 1
What is your expected net cash flow in Q1 (in $ million)?
Q1 | Amount in million | |
Cash Inflow | 25 | |
50% Sales in current quarter | 12.6 | |
50%sales of previous quarter sales | 12 | |
Cash outflow | 22 | |
70% Purchases of Q1 | 7.7 | |
30% Purchases on Q4 | 3.03 | |
Wages and expenses | 7.56 | |
Interest and dividend | 4 | |
NetCash Inflow | 2.3 |
Net cash flow= $2.3 million
Workings
Intro It is the beginning of January. Actual sales for the previous quarter (Q4) and estimated...
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 24 25.2 26.46 27.78 29.17 30.63 You collect 50% of sales in the current quarter and the remainder in the following quarter. You expect to spend 40% of the following quarter's sales on purchases of components from suppliers, and to pay 70% of those...
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 24 25.2 26.46 27.78 29.17 30.63 You collect 50% of sales in the current quarter and the remainder in the following quarter. You expect to spend 40% of the following quarter's sales on purchases of components from suppliers, and to pay 70% of those...
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): 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 24 25.2 26.46 27.78 29.17 30.63 You collect 50% of sales in the current quarter and...
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): 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 24 25.2 26.46 27.78 29.17 30.63 You collect 50% of sales in the current quarter and...
The Thunder Dan's Corporation's purchases from suppliers in a quarter are equal to 65 percent of the next quarter's forecasted sales. The payables period is 60 days. Beginning accounts payables is $200. Wages, taxes, and other expenses are 16 percent of sales, and interest and dividends are $60 per quarter. No capital expenditures are planned. Sales for the first quarter of the following year are projected at $720. The receivables period is 45 days. Beginning accounts receivables is $150. Initial...
The Corporation purchases from suppliers in a quarter are equal to 55 percent of the next quarter's forecast sales. The payables period is 90 days. Wages, taxes and other expenses are 25 percent of sales and interest and dividends are $82 per quarter. No capital expenditures are planned. Here are the projected quarterly sales: Q1 Q2 Q3 Q4 Sales 1390 1520 1640 1160 Sales for the first quarter of the following year are projected at $1,740. Calculate the company's cash...
The MacDonald Corporation's purchases from suppliers in a quarter are equal to 75 percent of the next quarter's forecast sales. The payables period is 60 days. Wages, taxes, and other expenses are 30 percent of sales, and interest and dividends are $115 per quarter. No capital expenditures are planned. Projected quarterly sales are: Sales Q1 $1,530 Q2 $1,680 Q3 $1,740 Q4 $1,980 Sales for the first quarter of the following year are projected at $1,650. Calculate the company's cash outlays...
The MacDonald Corporation's purchases from suppliers in a quarter are equal to 75 percent of the next quarter's forecast sales. The payables period is 60 days. Wages, taxes, and other expenses are 30 percent of sales, and interest and dividends are $115 per quarter. No capital expenditures are planned. Projected quarterly sales are: Sales Q1 $1,530 Q2 $1,680 Q3 $1,740 Q4 $1,980 Sales for the first quarter of the following year are projected at $1,650. Calculate the company's cash outlays...
The MacDonald Corporation's purchases from suppliersin a quarter are equal to 75 percent of the next quarter's forecast sales. The payables period is 60 days. Wages, taxes, and other expenses are 30 percent of sales, and interest and dividends are $110 per quarter. No capital expenditures are planned. Projected quarterly sales are: Q1 Q2 Q3 Q4 $1,640 $1,920 $2,215 $2,355 Sales Sales for the first quarter of the following year are projected at $2,050. Calculate the company's cash outlays by...
The Glasgow Corporation's purchases from suppliers in a quarter are equal to 70 percent of the next quarter's forecast sales. The payables period is 60 days. Wages, taxes, and other expenses are 20 percent of sales and interest and dividends are $90 per quarter. No capital expenditures are planned. Here are the projected quarterly sales: Q1 Q2 Q3 Q4 Sales $2,340 $2,640 $2,340 $2,040 Sales for the first quarter of the following year are projected at $2,670. Calculate the company's...