In: Finance
The Torrey Pine Corporation’s purchases from suppliers in a quarter are equal to 60 percent of the next quarter’s forecast sales. The payables period is 60 days. Wages, taxes, and other expenses are 25 percent of sales, and interest and dividends are $85 per quarter. No capital expenditures are planned. |
Projected quarterly sales are shown here: |
Q1 | Q2 | Q3 | Q4 | |||||||||
Sales | $ | 2,190 | $ | 2,490 | $ | 2,190 | $ | 1,890 | ||||
Sales for the first quarter of the following year are projected at $2,520. 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.) |
|
I have answered the question below using excel and have attached the image below.
Please up vote for the same and thanks!!!
Do reach out in the comments for any queries
Answer: