Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2...
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: Q1 Q2 Q3 Q4 Sales $140 $160 $180 $210 Sales for the first quarter of the following year are projected at $155 million. Accounts receivable at the beginning of the year were $61 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 paid in 36 days. Wages, taxes, and other expenses run about 25 percent of sales. Interest and dividends are $10 million per quarter. Wildcat plans a major capital outlay in the second quarter of $76 million. Finally, the company started the year with a $73 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 exces 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.) funds in short-term marketable WILDCAT, INC. Short-Term Financial Plan (in millions) Q1 Q2 Q3 Q4 Target cash balance $ 40.00 $ 40.00 2$ 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 -40.00 -40.00 -40.00 -40.00 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? (A negative answer 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.) 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 "O" 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 $ 20.00 2$ 20.00 $ 20.00 2$ 20.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 -20.00 -20.00 -20.00 -20.00 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 2$ 2.98 Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $140 $160 $180 $210 Sales for the first quarter of the following year are projected at $155 million. Accounts receivable at the beginning of the year were $61 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 paid in 36 days. Wages, taxes, and other expenses run about 25 percent of sales. Interest and dividends are $10 million per quarter. Wildcat plans a major capital outlay in the second quarter of $76 million. Finally, the company started the year with a $73 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 exces 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.) funds in short-term marketable WILDCAT, INC. Short-Term Financial Plan (in millions) Q1 Q2 Q3 Q4 Target cash balance $ 40.00 $ 40.00 2$ 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 -40.00 -40.00 -40.00 -40.00 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? (A negative answer 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.) 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 "O" 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 $ 20.00 2$ 20.00 $ 20.00 2$ 20.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 -20.00 -20.00 -20.00 -20.00 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 2$ 2.98
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?...
-
Which is not a difference between a limited liability company and a limited liability partnership? a. An LLC, unlike an LLP or LLLP, can exist with only one owner. b. All members of an LLC have...
-
Samples of student cars and faculty/staff cars were obtained at the author's college, and their ages (in years) are summarized in the accompanying frequency table. Find the standard deviation in age...
-
5. A three-stage, single acting compressor is required to compress 135m of free air per hour from 1bar to 64bar. Prove that with complete intercooling the stage pressure ratio should be equal to the...
-
As discussed in Example 6.7, the following stream at \(100^{\circ} \mathrm{F}\) and 484 psia is to be separated by two distillation columns into the Products \(1-3\) in the following table. Two...
-
It costs a pharmaceutical company $40,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be...
-
The following is a summary of the transactions for the year: a. Provided services, $108,000, of which $32,400 was on account and the balance was received in cash. b. Collected on accounts receivable,...
-
What are the triads using roman numerals and figured bass numbers for this excerpt? 30-3. Use Roman numerals and figured bass numbers to identify triads in these works. a. Schubert, "Death and the...
-
Fortune Drilling Company acquires a mineral deposit at a cost of $5,900,000. It incurs additional costs of $600,000 to access the deposit, which is estimated to contain 2,000,000 tons and is expected...
-
Karryn Bilski made $2,400,000 in 2001, the base year. By 2004 she was earning $3,600,000. If the CPI rose to 120 by 2004, how much were her real wages that year, and by what percentage had they...
-
Which statement is true? a) Only the owners of labor can earn an economic rent. b) Only the owners of land can earn an economic rent. c) Both the owners of land and labor can earn an economic rent....
-
Each of the following is a valid criticism of Henry Georges ideas except that _________. a) a tax on land would raise only a small fraction of needed government revenue b) landlords sometimes improve...
-
Ms. Spielvogel was paid $400 a week in 1987, the base year. By 1995 she was earning $900 a week. If the consumer price index was at 180 in 1995, how much were Ms. Spielvogels real wages that year,...
-
By real wages, economists mean what you can ___________.
-
Winthrop Merchandising is preparing its budget for 2011 (its first year of operation). Sales for the year are budgeted at $1,500,000; 20% are cash sales and 80% are credit sales. The company expects...
-
Suppose that a company has 10.000 outstanding shares in the beginning of the year. On April 1st, the company increases its shares by 6.000. On July 1st, the company increases its shares again, but...
-
You are discussing real options with a colleague. During the discussion, the colleague states, Real option analysis makes no sense because it says that a real option on a risky venture is worth more...
-
A company has a large bond issue maturing in one year. When it matures, the company will float a new issue. Current interest rates are attractive, and the company is concerned that rates next year...
-
How would the analysis of real options change if a company has competitors?
-
If youd like to have $5,000,000 at retirement in 45 years and you expect to earn 10 percent annually, which is around the average return over the past 50 years, what lump sum would you have to invest...
-
Obaidullah Hamzah, who recently sold his Ford Mustang, placed $15,000 in a savings account paying annual compound interest of 7 percent. a. Calculate the amount of money that will be accrued if he...
-
How many years will the following take? a. \($550\) to grow to \($1,049.50\) if invested at 6 percent compounded annually b. \($37\) to grow to \($63.87\) if invested at 9 percent compounded annually...
Study smarter with the SolutionInn App