Question
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $230 $195 $270 $290 Sales for
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows:
| Q1 | Q2 | Q3 | Q4 |
Sales | $230 | $195 | $270 | $290 |
Sales for the first quarter of the year after this one are projected at $250 million. Accounts receivable at the beginning of the year were $79 million. Wildcat has a 45-day collection period.
Wildcat's purchases from suppliers in a quarter are equal to 45 percent of the next quarter's forecast sales, and suppliers are normally paid in 36 days. (Hint: Accounts payable at the beginning of the year were 230*0.45*(2/5).) Wages, taxes, and other expenses run about 30 percent of sales. Interest and dividends are $15 million per quarter.
Wildcat plans a major capital outlay in the second quarter of $90 million. Finally, the company started the year with a $73 million cash balance and wishes to maintain a $35 million minimum balance.
1. What is the ending cash balance (in millions) Q2?
2. What is the ending cash balance (in millions) in Q3?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started