Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q2 Sales...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q2 Sales $175 S 195 $215 $245 Q1 Q3 Q4 Sales for the first quarter of the year after this one are projected at $190 million. Accounts receivable at the beginning of the year were $75 million. Wildcat has a 45-day collection period. Wildcať's purchases from suppliers in a quarter are equal to 50 percent of the next quarter's forecast sales. and suppliers are normally paid in 36 days. Wages, taxes, and other expenses run about 20 percent of sales. Interest and dividends are $11 million per quarter. Wildcat plans a major capital outlay in the second quarter of $98 million. Finally, the company started the year with a S80 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. (Enter your answers in millions. Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) WILDCAT, INC. Short-Term Financial Plan (in millions) Q1 Q2 Q3 Q4 Target cash balance $ 40.00 $ 40.00 $ 40.00 $ 40.00 Net cash inflow New short-term investments Income on 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 for the year under this target cash balance? (Negative amount should be indicated by a minus sign. Enter your answer in millions. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) %24 %24 %24 %24 %24 %24 %24 %24 a-2. What is the net cash cost for the year under this target cash balance? (Negative amount should be indicated by a minus sign. Énter your answer in millions. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Net cash cost b-1. Complete the following short-term financial plan assuming that Wildcat maintains a minimum cash balance of $20 million. (Enter your answers in millions. Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) WILDCAT, INC. Short-Term Financial Plan (in millions) Q2 Q1 Q3 $ 20.00 S 20.00 $ 20.00 Q4 S 20.00 Target cash balance Net cash inflow New short-term investments Income on short-term investments Short-term investments sold New short-term borrowing Interest on short-term borrowing Short-term borrowing repaid Ending cash balance 24 Minimum cash balance Cumulative surplus (deficit) Beginning short-term investments Ending short-term investments Beginning short-term debt Ending short-term debt b-2. What is the net cash cost for the year under this target cash balance? (Enter your answer in millions. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Net cash cost Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q2 Sales $175 S 195 $215 $245 Q1 Q3 Q4 Sales for the first quarter of the year after this one are projected at $190 million. Accounts receivable at the beginning of the year were $75 million. Wildcat has a 45-day collection period. Wildcať's purchases from suppliers in a quarter are equal to 50 percent of the next quarter's forecast sales. and suppliers are normally paid in 36 days. Wages, taxes, and other expenses run about 20 percent of sales. Interest and dividends are $11 million per quarter. Wildcat plans a major capital outlay in the second quarter of $98 million. Finally, the company started the year with a S80 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. (Enter your answers in millions. Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) WILDCAT, INC. Short-Term Financial Plan (in millions) Q1 Q2 Q3 Q4 Target cash balance $ 40.00 $ 40.00 $ 40.00 $ 40.00 Net cash inflow New short-term investments Income on 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 for the year under this target cash balance? (Negative amount should be indicated by a minus sign. Enter your answer in millions. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) %24 %24 %24 %24 %24 %24 %24 %24 a-2. What is the net cash cost for the year under this target cash balance? (Negative amount should be indicated by a minus sign. Énter your answer in millions. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Net cash cost b-1. Complete the following short-term financial plan assuming that Wildcat maintains a minimum cash balance of $20 million. (Enter your answers in millions. Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) WILDCAT, INC. Short-Term Financial Plan (in millions) Q2 Q1 Q3 $ 20.00 S 20.00 $ 20.00 Q4 S 20.00 Target cash balance Net cash inflow New short-term investments Income on short-term investments Short-term investments sold New short-term borrowing Interest on short-term borrowing Short-term borrowing repaid Ending cash balance 24 Minimum cash balance Cumulative surplus (deficit) Beginning short-term investments Ending short-term investments Beginning short-term debt Ending short-term debt b-2. What is the net cash cost for the year under this target cash balance? (Enter your answer in millions. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Net cash cost
Expert Answer:
Related Book For
Corporate Finance
ISBN: 978-0077861759
10th edition
Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe
Posted Date:
Students also viewed these general management questions
-
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 105 $ 90 $ 122 $ 140 Sales for the first quarter of the year after this one are projected...
-
The Torrey Pine Corporation s purchases from suppliers in a quarter are equal to 75 percent of the next quarter s forecast sales The payables period is 60 days Wages taxes and other expenses are 20...
-
The forecasted demand for fudge for the next four months is 140, 160, 90, and 70 pounds. a. What is the recommended production rate if a level strategy is adopted with no back orders or stock-outs?...
-
Here are the supply and demand equations for throstles, where p is the price in dollars: D (p) = 40 p S (p) = 10+p. On the axes below, draw the demand and supply curves for throstles, using blue...
-
-20 5 (2 9)(-3) Perform the indicated operations by hand.
-
Use the given identity to verify the related identity. Use the fundamental identity cosh 2 x - sinh 2 x = 1 to verify the identity coth 2 x - 1 = csch 2 x.
-
Find the Panel on Audit Effectiveness report by the Public Oversight Board (August 31, 2000) and outline the panel's major recommendations concerning forensic techniques (pp. 1 and 2).
-
The Beal Manufacturing Companys costing system has two direct-cost categories: direct materials and direct manufacturing labor. Manufacturing overhead (both variable and fixed) is allocated to...
-
Which action is associated with risk acceptance? A) Bind service providers through contractual arrangements B) Abandon the activities that pose a risk C) Establish contingency plans D) Put controls...
-
A p-doped wafer (boron concentration of 5 E17/cm^3) that is 200 m thick completely and homogenously absorbs a beam of photons, generating 2E19 excess free electrons (n) per cubic centimetre and per...
-
Consider the following linear programming problem: Maximize p = x y Subject to x - 2y 0 2x + y < 10 x > 0, y > 0. This problem (A) Must be solved using the techniques of Section 5.4. (B)...
-
Which of the following would not be considered an advantage of using an internal control questionnaire in understanding and documenting the controls in an important accounting application?...
-
A survey of 250 members from an organized union of over 20,000 members. In Exercises 1120, determine whether the data set is a population or a sample. Explain your reasoning.
-
The accounts payable department receives the purchase order form to accomplish all of the following except. a. Compare invoice price to purchase order price. b. Ensure that the purchase had been...
-
Authorization of transactions in a computerized processing environment can take place in the form of: a. Computerized authorization in the form of user-approved blanket authoriza- tions. b....
-
Assume that you were given these five options to describe the tone at the top: Excellent Moderate Indifferent Nonexistent Machiavellian (do whatever it takes) Required a. How would the auditor go...
-
Pleasehelp me find 1-a and 2-a. I am confused about how to find theincremental profit/loss Special-Order Pricing Barry's Bar-B-Que is a popular lunch-time spot. Barry is conscientious about the...
-
Drainee purchases direct materials each month. Its payment history shows that 65% is paid in the month of purchase with the remaining balance paid the month after purchase. Prepare a cash payment...
-
The most recent financial statements for Fontenot Co. are shown here: Assets and costs are proportional to sales. The company maintains a constant 30 percent dividend payout ratio and a constant debt...
-
Omega Airlines capital structure consists of 2.7 million shares of common stock and zero coupon bonds with a face value of $18 million that mature in six months. The firm just announced that it will...
-
Tricia Haltiwinger, the president of Braam Industries, has been exploring ways of improving the companys financial performance. Braam Industries manufactures and sells office equipment to retailers....
-
What is the primary requirement of a CVA certificate?
-
What three certifications does the National Association of Certified Valuation Analysts offer?
-
Which is the oldest appraisal organization? What certificate does it issue? Where is its home office
Study smarter with the SolutionInn App