Complete the following short$-$term financial plan assuming that Wildcat maintains a minimum cash balance of $$20$ million. $($Leave no cells blank $-$ be certain to enter $"0"$ wherever required. A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers in millions, rounded to $2$ decimal places, e$.$g$.,32\mathrm{.}16.)$ Wildcat, Inc., has estimated sales $($in millions$)$ for the next four quarters as follows:

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

Accounts receivable at the beginning of the year were $$77$ million. Wildcat has a $45-$day

collection period.

Wildcat's purchases from suppliers in a quarter are equal to $50$ percent of the next

quarter's forecasted sales, and suppliers are normally paid in $36$ days. Wages, taxes, and

other expenses run about $25$ percent of sales. Interest and dividends are $$10$ million per

quarter.

Wildcat plans a major capital outlay in the second quarter of $$85$ million. Finally, the

company started the year with a $$81$ 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. $($Leave no cells blank $-$ be certain to enter $"$O$"$ wherever

required. A negative answer should be indicated by a minus sign. Do not round

intermediate calculations and enter your answers in millions, 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,$$,20\mathrm{.}00,$$$,20\mathrm{.}00,$$$,20\mathrm{.}00,$$$,20\mathrm{.}00],[$Net cash inflow$],[$New short$-$term investments,,,,$0,,,,],[$Income from short$-$term investments$],[$Short$-$term investments sold,,$0,,,,0,,0],[$New short$-$term borrowing,,$0,,0,,0,,0],[$Interest on short$-$term borrowing,,$0,,0,,0,,0],[$Short$-$term borrowing repaid,,$0,,0,,0,,0],[$Ending cash balance,$$,20\mathrm{.}00,$$$,20\mathrm{.}00,$$$,20\mathrm{.}00,$$$,20\mathrm{.}00],[$Minimum cash balance,,$-20\mathrm{.}00,,-20\mathrm{.}00,,-20\mathrm{.}00,,-20\mathrm{.}00],[$Cumulative surplus $($deficit$),$$$,0,$$$,0,$$$,0,$$$,0],[$Beginning short$-$term investments$],[$Ending short$-$term investments$],[$Beginning short$-$term debt,$$,0,$$$,0,$$$,0,$$$,0],[$Ending short$-$term debt,$$,0,$$$,0,$$$,0,$$$,0]]$