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

QAssume 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 securitles

at a rate of $2$ percent per quarter.

b$-1.$ Complete the following short$-$term financlal plan for Wildcat, Incorporated. $($A

negatlve answer should be Indlcated by a minus sign. Do not round Intermedlate

calculations and enter your answers in millions, not dollars, rounded to $2$ decimal

places, e$.$g$.,32\mathrm{.}16.$ Leave no cells blank $-$ be certaln to enter $"O"$ wherever

required.$)$

Answer is not complete$\mathrm{.}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 recelvable 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 forecast sales, and supplers are normally pald In $36$ days. Wages, taxes, and other expenses run about $20$ percent of sales. Interest and dividends are $$15$ million per quarter.

Wildcat plans a major capital outlay in the second quarter of $$94$ million. Finally, the company started the year with a cash balance of $$72$ million and wishes to maintan a $$30$ million minimum balance.

a$.$ Complete the following cash budget for Wildcat, Incorporated. $($A negative answer should be Indicated by a minus sign. Do not round Intermediate calculations and enter your answers In millions, not dollars, rounded to $2$ decimal places, e$.$g$.,32\mathrm{.}16.)$