Wildcat, Incorporated, has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $170 $185 $200 $225 Sales for the first quarter of the year after this one are projected at $180 million. Accounts receivable at the beginning of the year were $71 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. Wages, taxes, and other expenses run about 25 percent of sales. Interest and dividends are $14 million per quarter. Wildcat plans a major capital outlay in the second quarter of $85 million. Finally, the company started the year with a $54 million cash balance and wishes to maintain a $40 million minimum balance. a-1. Assume that Wildcat can borrow any needed funds on a short-term basis at a rate of 3 percent per quarter and can invest any excess funds in short-term marketable securities at a rate of 2 percent per quarter. Complete the following short-term financial plan for Wildcat. (A negative answer should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round Intermediate calculations and enter your answers in millions, not dollars, rounded to 2 decimal places, e.g., 3216.) Target cash balance Nel cash inflow New short term investments Income on short-term investments Short-term investments sold New short-term borrowing Interest on short-term borrowing Short-term borrowing repaid Ending cash balance Minimum cash balance Cumulative surplus (deficit) Beginning short-term investments Ending short-term investments Beginning short-term debl Ending short-term debt WILDCAT, INCORPORATED Short-Term Financial Plan (in millions) Q1 Nel cash cont -40.00 2 -40.00 -40.00 a-2. What is the net cash cost for the year under this target cash balance? (A negative answer should be indicated by a minus sign. Do not round Intermediate calculations and enter your answer in millions, not dollars, rounded to 2 decimal places, e.g. 32.16.) Q4 -40.00

Wilccot, incorporated, hos estimoted soles. (in millions) for the next four querters as follows: Soles for the first quorter of the yeor ofter this one ore projected at $180 million. Accounts receivoble at the beginning of the your were $71 milion. Wildcat hos o 45-doy collection period: Widicat's purcheses from suppliers in a quartet are equal to 45 percent of the rext quarter's forecast soles, and suppliens ore normally peid in 36 doys. Wages, taxes, and other expenses nun obout 25 percent of soles. interest and dividends ere 514 million per quarter. Wildcat plans o mojor copital ourloy in the second qutner of $85 milion. Finaly, the compeny stonted the year with o $54 millon cosh bolonce ond wishes to mentain a $40 milion minimum bolance. a-1. Assume thot Widcet can borrow ony needed funds on a short-term bosis ot o rate of 3 percent pet quarter and can invest ony excess funds in short-term morketsble securities ot o rate of 2 petcent per quartec Complete the following shortiorm finenciel plen for Widicot. (A negatlve answer should be indicated by a minus sign. Leave no cells blank - be certain to enter " 0wherever required. Do not round intermediate calculations and enter your answers in milions, not dollars, rounded to 2 decimal places, =9.3216.) 22. Whar a the nert cosh cout for the yesr under thid terget cash belence" i negurve plecec. +3.32k6 )