Question Completion Status: Question 1 Firm CVS has estimated sales (in millions) for the next four...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question Completion Status: Question 1 Firm CVS has estimated sales (in millions) for the next four quarters as follows: Sales (in millions) For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BIUS Paragraph Arial Q1 $ 70 V b- Prepare cash disbursement table [ 15 Points] c-Prepare cash budget table [ 20 Points] d-Prepare short-term financial plan. [ 20 Points] e- What is the amount of cash generated by short-term financing? [5 Points] 14px Sales for the first quarter of the year after this one are projected at $110 million. Accounts receivable at the beginning of the year were $23 million. CVS has a 20-day collection period. CVS's purchases from suppliers in a quarter are equal to 30 percent of the next quarter's forecast sales, and suppliers are normally paid in 20 days. Wages, taxes, and other expenses run about 10 percent of sales. Interest and dividends are $7 million per quarter. CVS plans a major capital outlay in the second quarter of $50 million. Finally, the company started the year with a $35 million cash balance and wishes to maintain a $25 million minimum balance. Short term borrowing rate is 5%, short term lending rate is 3%. a-Prepare cash collection table [ 15 Points] Q2 $ 100 ✔ Ev Q3 $ 120 Ev A Q4 $ 130 MacBook Pro I X 75 points Save Answer Q 6===s *** Question Completion Status: Question 1 Firm CVS has estimated sales (in millions) for the next four quarters as follows: Sales (in millions) For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BIUS Paragraph Arial Q1 $ 70 V b- Prepare cash disbursement table [ 15 Points] c-Prepare cash budget table [ 20 Points] d-Prepare short-term financial plan. [ 20 Points] e- What is the amount of cash generated by short-term financing? [5 Points] 14px Sales for the first quarter of the year after this one are projected at $110 million. Accounts receivable at the beginning of the year were $23 million. CVS has a 20-day collection period. CVS's purchases from suppliers in a quarter are equal to 30 percent of the next quarter's forecast sales, and suppliers are normally paid in 20 days. Wages, taxes, and other expenses run about 10 percent of sales. Interest and dividends are $7 million per quarter. CVS plans a major capital outlay in the second quarter of $50 million. Finally, the company started the year with a $35 million cash balance and wishes to maintain a $25 million minimum balance. Short term borrowing rate is 5%, short term lending rate is 3%. a-Prepare cash collection table [ 15 Points] Q2 $ 100 ✔ Ev Q3 $ 120 Ev A Q4 $ 130 MacBook Pro I X 75 points Save Answer Q 6===s ***
Expert Answer:
Related Book For
Fundamentals of Corporate Finance
ISBN: 978-0077861704
11th edition
Authors: Stephen Ross, Randolph Westerfield, Bradford Jordan
Posted Date:
Students also viewed these general management questions
-
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...
-
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Sales for the first quarter of the following year are projected at $180 million. Accounts receivable at the...
-
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 of these is NOT one of the validity conditions for a t-test for the slope of a regression line? A. We should have a large sample size, typically n 20. B. The scatterplot of the sample data...
-
Robert Buey became Chief Executive Officer of Phelps Manufacturing two years ago. At the time, the company was reporting lagging profits, and Robert was brought in to "stir things up." The company...
-
Distinguish between IPO and HIPO charts.
-
What superseded SAS No. 82?
-
Tropicsun is a leading grower and distributor of fresh citrus products with three large citrus groves scattered around central Florida in the cities of Mt. Dora, Eustis, and Clermont. Tropicsun...
-
P3-6 (similar to) Effect of net income on a firm's balance sheet Conrad Air, Inc., reported net income of $1,368,000 for the year ended December 31, 2020. Show how Conrad's balance sheet would change...
-
On July 31, 2019, Ping Company purchased 90% of Santos Company?s common stock for $2,010,000 cash. Immediately after the acquisition, the two companies? balance sheets were as follows: Santos Company...
-
It is better to pay regular price than to stand ina long line for a free item. discuss the statement using a)Cost benefit analysis b) Incentive Principles c) opportunity cost
-
5) The large, consistently profitable firm you work for is considering a small project. Your firm is financed by 60% equity and 40% debt.Its cost of equity is 10%.Its cost of debt is 5%.The risk free...
-
How does the structure and organization of business documents like reports, memos, and proposals affect their effectiveness? Analyze the role of headings, bullet points, and executive summaries.
-
ABC Inc.'s wants to fund a $5 million investment by using its $ 3 million of retained earnings and borrowing $2 million. ABC Inc.'s common shareholders received a $2 per share dividend last year and...
-
As a student of business, you may know well that companies use many sophisticated models and techniques (for example, SWOT Analysis) to gain a competitive edge on the market. How can we use those...
-
An experiment was recently carried out where a child, an astrologer and a financial analyst were each given 10,000 to invest for eight years. Who do you think achieved the best results?
-
A portfolio that combines the risk-free asset and the market portfolio has an expected return of 7 percent and a standard deviation of 10 percent. The risk-free rate is 4 percent, and the expected...
-
Why is a help desk and production support critical to system implementations? Discuss its interrelationship with the problem management and reporting system.
-
Stock in Daenerys Industries has a beta of .95. The market risk premium is 7 percent, and T-bills are currently yielding 3.6 percent. The company's most recent dividend was $2.05 per share, and...
-
Shelton, Inc., has sales of $17.5 million, total assets of $13.1 million, and total debt of $5.7 million. If the profit margin is 6 percent, what is net income? What is ROA? What is ROE?
-
1. What implications do you draw from the graph for mutual fund investors? 2. Is the graph consistent or inconsistent with market efficiency? Explain carefully. 3. What investment decision would you...
-
Your brother works for a company that makes components for DVD players. The company has started to outsource some of its component assembly work to a country where employees wages are much lower than...
-
If your knowledge about personal fi nance is limited, being Web and tech savvy will help you learn more. Finance is a frequent topic on the news and is easy to research.
-
What are three characteristics of successful people? Describe how each characteristic might be an asset at school or work.
Study smarter with the SolutionInn App