$$

$$ Sales $($in millions$)$ Q$1170$ Q$2185$ Q$3200$ Q$4225$

$$ sales for the first quarter for the following year $=180$ million

Accounts recievable $=71$ million

$45$ day collection period

Purchases from suppliers are $45\%$ of next quarters forecsst sales and suppliers are paid in $36$ days. Wages taxes and other expenses are $25\%$ of sales. Inteest and dividends and $$14$ million per quarter. Wildcat plans a major capital outlay in the $2$nd quarter of $$85$ million. The company started the year with a $$54$ million cash balance and wishes to maintain a $$30$ million minimum balance.

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.

b$-1.$ Complete the following short$-$term financial plan for Wildcat, Inc. $($A negative answer should be indicated by a minus sign. Leave no cells blank $-$ be certain to enter $"O"$ wherever required. Do not round intermediate calculations and enter your answers in millions, not dollars, rounded to $2$ decimal places, e$.$g$.,32\mathrm{.}16.)$

$\backslash$table$[[$WILDCAT$,$ INC.$],[$Short$-$Term Financial Plan$],[($in millions$)],[,$Q$1,$Q$2,$Q$3,$Q$4],[$Target cash balance,$$,30\mathrm{.}00,$$$,30\mathrm{.}00,$$$,30\mathrm{.}00,$$$,30\mathrm{.}00],[$Net cash inflow$],[$New short$-$term investments$],[$Income from 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,$-,-30\mathrm{.}00,,-30\mathrm{.}00,,-30\mathrm{.}00,,-30\mathrm{.}00],[$Cumulative surplus $($deficit$),$$$,0,$$$,0,$$$,0,$$$,0],[$Beginning short$-$term investments$],[$Ending short$-$term investments$],[$Beginning short$-$term debt$],[$Ending short$-$term debt,,,,,,,,$]]$Wildcat$,$ Inc., has estimated sales $($in millions$)$ for the next four quarters as follows:

Sales for the first quarter of the following year 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 $$30$ million minimum balance.