Question

he MacDonald Corporation’s purchases from suppliers in a quarter are equal to 65 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 $123 per quarter. No capital expenditures are planned. Projected quarterly sales are:

	Q1	Q2	Q3	Q4
Sales	$1,260	$1,410	$1,500	$1,710

Sales for the first quarter of the following year are projected at $1,380. Calculate the company’s cash outlays by completing the following: (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Q1 Q2 Q3 Q4 Payment of accounts Wages, taxes, other expenses Long-term financing expenses (interest and dividends)

Answer 1

C 1,410 $ D 1,500 $ E F 1,710 $1,380 A B 1 Sales $ 1,260 $ 2 01 4 Payment of accounts $ 851.50 $ 5 Wages, taxes, other expenses $ 252.00 $ 6 Interest and dividends $ 123.00 $ 3 02 936.00 282.00 123.00 03 $ 1,020.50 $ 300.00 $ 123.00 04 $ 1,040.00 $ 342.00 $ 123.00 7 8 Total $1,226.50 $1,341.00 $1,443.50 $1,505.00

. Ε 1410 1500 1710 1380 3 A B 1 Sales 1260 2 Q1 4. Payment of accounts =(2/3)*65%*B1+(1/3)*65%*C1 5 Wages, taxes, other expenses =+B1*0.2 6 Interest and dividends 123 7 8 Total =SUM(B4:37) =2/3)*65%*C1+(1/3)*65%*D1 =+C1*0.2 123 Q3 =(2/3)*65%*D1+(1/3)*65%*E1 =+D1*0.2 123 04 =(2/3)*65%*E1+(1/3)*65%*F1 =+E1*0.2 123 =SUM(C4:07) =SUM(D4:07) =SUM(E4:E7)

*Please rate thumbs up