Wildcat plans a major capital outlay in the second quarter of $68 million. Finally, the company started the year with a cash balance of $71 million and wishes to maintain 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.16.) \table[[WILDCAT, INCORPORATED],[Cash Budget],[(in millions)],[,,21dots,Q2,Q3,Q4],[Beginning cash balance,,71.00,,,-],[{ \table[[Beginning cash balance],[Net cash inflow]]}],[],[Minimum cash balance,,-30.00,-30.00,-30.00,-30.00],[Cumulative surplus (deficit),,,,,]] Wildcat plans a major capital outlay in the second quarter of $68 million. Finally, thecompany started the year with a cash balance of $71 million and wishes to maintain a$30 million minimum balance.a. Complete the following cash budget for Wildcat, Incorporated. (A negativeanswer should be indicated by a minus sign. Do not round intermediatecalculations and enter your answers in millions, not dollars, rounded to 2 decimalplaces, e.g., 32.16.)WILDCAT, INCORPORATEDCash Budget(in millions)Q1Q2Q3Q4Beginning cash balance$71.00Net cash inflowEnding cash balanceMinimum cash balance-30.00-30.00-30.00-30.00Cumulative surplus (deficit)

Here's a detailed calculation for better understanding. Assumptions: We start with a beginning cash…

Answered: Wildcat plans a major capital outlay in…

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter4: Financial Planning And Forecasting

Section: Chapter Questions

Problem 9P

See similar textbooks

Related questions

Question

Wildcat plans a major capital outlay in the second quarter of $68 million. Finally, the company started the year with a cash balance of $71 million and wishes to maintain 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.16.) \table[[WILDCAT, INCORPORATED],[Cash Budget],[(in millions)],[,,21dots,Q2,Q3,Q4],[Beginning cash balance,,71.00,,,-],[{ \table[[Beginning cash balance],[Net cash inflow]]}],[],[Minimum cash balance,,-30.00,-30.00,-30.00,-30.00],[Cumulative surplus (deficit),,,,,]]