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...
-
A silicate glass has 10 mol% Na2O and 5 mol% CaO. Calculate the O:Si ratio and the composition in wt% for this glass.
-
Two compounds, A and B, have the same molecular formula, C6H8. Both A and B react with two molar equivalents of hydrogen in the presence of platinum to yield cyclohexane. Compound A shows three...
-
Water is flowing through a long pipe of diameter \(15 \mathrm{~cm}\) at \(300 \mathrm{~K}\). The pressure gradient is \(500 \mathrm{~Pa} / \mathrm{m}\). Using the Blasius equation for the friction...
-
You are selling a product on commission, at the rate of $1,000 per sale. To date you have spent $800 promoting a particular prospective sale. You are confident you can complete this sale with an...
-
Cullumber Manufacturing incurs $ 8 0 , 0 0 0 of direct labour costs. Supporting records show that the assembly department used $ 4 6 , 7 0 0 of the direct labour and the finishing department used the...
-
After researching the different forms of business organization. Natalie Koebel decides to operate Cookie Creations as a proprietorship. She then starts the process of getting the business running. In...
-
(i) Complete the following code of a function that simulates playing the lotto 6/49 with the same ticket until you win the jackpot. You have to insert code where it says HERE. play_lotto
-
Provide your top 3 DOs and top 3 DON'Ts for marketing your graduate skills in business and management. Meaning, what are the three positives you will emphasize, and the three negatives you will...
-
Describe how a firm would establish reordering levels. Include consumption-based ordering. Include how firms use inventory turns. How would the firm establish safety, buffer, and seasonal stock...
-
Which of the four freight flows (Millions of Markets, Global Market place, One world order, Naftastique) should the Tractor Supply Company prepare itself for and what should they do to prepare for...
-
There are external risks to a supply chain that cannot be controlled by an organization nor its supply chain partners. However, these risks can be monitored, mitigated or even avoided by the...
-
Using the following information for Tesla, Porsche, and BMW, answer the questions below. Tesla Motors 2,3 2013 2014 2015 2016 2017 Cars Produced 22477 31655 51095 76230 101312 Employees 6000 10161...
-
Please complete the below questions and upload your response to BrightSpace under Assignments. Any format that is professional is fine. Include your name and student number. This will be marked in...
-
Tell whether the angles or sides are corresponding angles, corresponding sides, or neither. AC and JK
-
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....
-
Consider a stochastic process such that the underlying security \(S\) follows the model: \[d S_{t}=\mu S_{t} d t+\sigma_{t} S_{t} d Z_{t}\] where \(Z\) is a standard Brownian motion. Suppose the...
-
Calculate the solution to the following SDE: \[d X_{t}=\alpha\left(m-X_{t} ight) d t+\sigma d B_{t}\] with \(X_{0}=x\). The process satisfying this equation is called the meanreverting...
-
If \(X_{t} \sim N(0, t)\), calculate the distribution of \(\left|X_{t} ight|\). Calculate \(\mathbf{E}\left|X_{t} ight|\) and \(V\left(\left|X_{t} ight| ight)\).
Study smarter with the SolutionInn App