Wildcat, Incorporated, 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 $$180$ million. Accounts recelvable 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 pald 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.

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.

a$-1.$ Complete the following short$-$term financlal plan assuming that Wildcat maintains a minimum cash balance of $$40$ million. $($A negative answer should be indicated by a minus sign. Do not round intermedlate calculations and enter your answers in millions of dollars rounded to $2$ decimal places, e$.$g$.,3216.$ Leave no cells blank be certain to enter $"0"$ wherever required.$)$

$\backslash$table$[[$WILDCAT$,$ INCORPORATED$],[$Short$-$Term Financial Plan$],[($in millions$)],[,$Q$1,$Q$2,$Q$3,$Q$4],[$Target cash balance,$$,40\mathrm{.}00,$$$,40\mathrm{.}00,$$$,40\mathrm{.}00,$$$,40\mathrm{.}00],[$Net cash inflow$],[$New short$-$term investments$],[\backslash$table$[[$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,,,,,,,,$]]$

a$-2.$ What is the net cash cost $($total Interest pald minus total Investment Income earned$)$ for the year? $($Do not round intermediate calculations and enter your answer in millions of dollars rounded to $2$ decimal places, e$.$g$.,3216.)$

Net cash costWildcat$,$ Incorporated, has estimated sales $($in millions$)$ for the next four quarters as follows: Q$1$ Q$2$ Q$3$ Q$4$ Sales $ $135$ $ $155$ $ $175$ $ $205$ Sales for the first quarter of the following year are projected at $$150$ million. Accounts receivable at the beginning of the year were $$59$ million. Wildcat has a $45-$day collection period. Wildcat$$s purchases from suppliers in a quarter are equal to $40$ percent of the next quarter$$s forecastWildcat, Incorporated, 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 $$180$ million. Accounts recelvable 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 pald 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 malntaln a $$30$ million minimum balance.

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.

a$-1.$ Complete the following short$-$term financlal plan assuming that Wildcat maintains a minimum cash balance of $$40$ million. $($A negative answer should be indicated by a minus sign. Do not round intermedlate calculations and enter your answers in millions of dollars rounded to $2$ decimal places, e$.$g$.,3216.$ Leave no cells blank be certaln to enter $"0"$ wherever required.$)$

$\backslash$table$[[$WILDCAT$,$ INCORPORATED$],[$Short$-$Term Financial Plan$],[($in millions$)],[,$Q$1,$Q$2,$Q$3,$Q$4],[$Target cash balance,$$,40\mathrm{.}00,$$$,40\mathrm{.}00,$$$,40\mathrm{.}00,$$$,40\mathrm{.}00],[$Net cash inflow$],[$New short$-$term investments$],[\backslash$table$[[$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 c