Wildcat, Inc., has estimated sales $($In millions$)$ for the next four quarters as follows:

$\backslash$table$[[$Q$1,$Q$2,$Q$3],[$Sales $$105,$$$125,]]$

Sales for the first quarter of the year after this one are projected at $$120$ million.

Accounts recelvable at the beginning of the year were $$47$ 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 forecasted sales, and suppliers are normally paid in $36$ days. Wages, taxes, and other expenses run about $20$ percent of sales. Interest and dividends are $$11$ million per quarter.

Wildcat plans a major capltal outlay In the second quarter of $$60$ million. Finally, the company started the year with a $$66$ million cash balance and wishes to maintaln a $$40$ million minimum balance.

a$-1.$ Assume that Wildcat can borrow any needed funds on a short$-$term basls at a rate of $3$ percent per quarter and can Invest any excess funds in short$-$term marketable securitles at a rate of $2$ percent per quarter. Complete the following short$-$term financlal plan for Wildcat. $($Leave no cells blank $-$ be certain to enter $"0"$ wherever required. A negative answer should be Indicated by a minus sign. Do not round Intermedlate calculatlons and enter your answers In millilons, 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],[$Minimum cash balance,$$,40\mathrm{.}00,$$$,40\mathrm{.}00,$$$,40\mathrm{.}00,$$$,40\mathrm{.}00],[$Net cash inflow,,$83\mathrm{.}00,,,,,,],[$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$],[$Cumulative surplus $($deficit$)],[$Beginning short$-$term investments$],[$Ending short$-$term investments$],[$Beginning short$-$term debt$],[$Ending short$-$term debt,,,,,,,,$]]$