PLEASE ANSWER FULL QUESTIONS AND FILL IN THE BLANKS

Widcat, Incorporated, has estimated sales $($in millions$)$ for the next four quarters as follows:

$\backslash$table$[[,01,02,03,04],[$Sales$,$$$105,$$$125,$$$145,$$$175]]$

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 caliection periad.

Widcat'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, tawes, and other expenses run about $20$ percent of sales. Interest and dividends are $$11$ million per quarter.

Wideat plans a major capital outlay in the second quarter of $$60$ million. Finally, the company started the year with a $$66$ millian cash balance and wishes to maintain a $$30$ million minimum baiance.

a$.$ Complete the following cash budget for Wildcat, Incorporated. $($A negative answer should be indicated by a minus sign. Do not round intermediate caiculations and enter your answers in mililons rounded to $2$ decimal places, e$\mathrm{.}9.32\mathrm{.}16.$ Leave no cells blank $-$ be certain to enter $"O"$ wherever required.$)$

$\backslash$table$[[$WILDCAT$,$ INCORPORATED$],[$Cash Budget$],[($ millions$)],[,$ar$,$Q$\_(2),$Q$3,04],[$Target eash balanos,$66\mathrm{.}00,,,],[$Nut cash infow$],[$Ending cash balarob$],[$Mirimum cash balanse,$-30\mathrm{.}00,-30\mathrm{.}00,-30\mathrm{.}00,-30\mathrm{.}00],[$Cumbative surpius $[$doficix$),,,,]]$

Assume that Wildcat can borrow any needed funds on a short:term basis at a rate of $3$ percent per quarter and can inwest any excess funds in short$-$term marketable securities at a rate of $2$ percent per quarter.

b$-1.$ Complete the following shortserm financial plan for Wildcat, Incorporated. $($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$\mathrm{.}932\mathrm{.}16.$ Leave no cells blank $-$ be certain to enter $"O"$ wherever required.$)$

$\backslash$table$[[$WLDCAT$,$ INCORPORATED$],[$Shont$-$Term Finamseial Plan$],[($in milliens$)],[,$at$,$Q$\_(2),$Q$3,$Q$4],[$Target Eash balariou,$3,30\mathrm{.}60,$$$,30\mathrm{.}00,$$$,30\mathrm{.}00,$$$,30\mathrm{.}00],[$Nat cash imfow$],[$Now short$-$berm iewestmems$],[$Goome frow short$-$sem iewestmunts$],[$Shart$-$sarm ifwesiments soid$],[$Now shont$-$berm borrowing$],[$butareat on shont$-$tarmi bomowing$],[$Shon$-$sam barrowing repa$$d$],[$Ending cash balanob$],[$Minimum cash balanse,,$-30,,-30,,-30,,-30],[$Comblation surpius $[$doficin$)],[$Beginning short$-$term investrwemta$],[$Ending shart$-$serm ifwusimunts$],[$Beginning short$-$term dabt$],[$Ending shori$-$sarm debt,,,,,,,,$]]$

b$-2.$ What is the net cash cost fitotal interest paid minus total investment income earned$)$ for the year? $($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.$ Leave no cells blank $-$ be certain to enter $"0"$ wherever required.$)$