Pickett Inc. forecasts the free cash flows (FCFS) (in millions) shown below. The weighted average cost...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Pickett Inc. forecasts the free cash flows (FCFS) (in millions) shown below. The weighted average cost of capital (WACC) is 8%, and the FCFS are expected to continue growing at a 3% rate after Year 4. The firm has $90.14 million of market-value debt, but it has no preferred stock or any other outstanding claims. There are 25 million shares outstanding. Year 3 4 FCF $10 $20 $40 $65 a. What is the value of the stock price today (Year 0)? b. Set up a simple Excel data table where you show how the estimated intrinsic value varies as the long-run growth rate varies over the following range (2.00%, 2.25%, 2.50%, 2.75%, 3.00%, 3.25%, 3.50%, 3.75%, 4.00%, 4.25%, 4.50%, and 4.75%) - assuming everything else stays constant. When correctly set up, an Excel Data Table will automatically recalculate when input variables are changed. Refer to the Calculator Excel Tutorials folder under the Files page on the Canvas website for the Excel file and video explaining how to create data tables. Pickett Inc. forecasts the free cash flows (FCFS) (in millions) shown below. The weighted average cost of capital (WACC) is 8%, and the FCFS are expected to continue growing at a 3% rate after Year 4. The firm has $90.14 million of market-value debt, but it has no preferred stock or any other outstanding claims. There are 25 million shares outstanding. Year 3 4 FCF $10 $20 $40 $65 a. What is the value of the stock price today (Year 0)? b. Set up a simple Excel data table where you show how the estimated intrinsic value varies as the long-run growth rate varies over the following range (2.00%, 2.25%, 2.50%, 2.75%, 3.00%, 3.25%, 3.50%, 3.75%, 4.00%, 4.25%, 4.50%, and 4.75%) - assuming everything else stays constant. When correctly set up, an Excel Data Table will automatically recalculate when input variables are changed. Refer to the Calculator Excel Tutorials folder under the Files page on the Canvas website for the Excel file and video explaining how to create data tables.
Expert Answer:
Related Book For
Cost Management Measuring Monitoring and Motivating Performance
ISBN: 978-0470769423
2nd Canadian edition
Authors: Leslie G. Eldenburg, Susan Wolcott, Liang-Hsuan Chen, Gail Cook
Posted Date:
Students also viewed these accounting questions
-
How is the weighted average cost of capital determined?
-
Eclipse Corporation uses no debt. The weighted average cost of capital is 8%. Required 1. If the current market value of the equity is $18 million and there are no taxes, what is EBIT? 2. Suppose the...
-
How is the weighted average cost of financing calculated?
-
What is the difference between an optimistic approach and a pessimistic approach to decision making under assumed uncertainty?
-
When a computer chip is examined to discover how many of the solder joints have become cracked, there is a probability of 0.12 that none of the joints are cracked, a probability of 0.43 that one of...
-
In general, what role should performance appraisals play in internal selection decisions? Are there some cases in which they are more relevant than others? Explain.
-
True or False: If \(E R R>M A R R\), then \(I R R>E R R>M A R R\).
-
On June 30, 2009, Mischa Auer Company issued $4,000,000 face value of 13%, 20-year bonds at $4,300,920, a yield of 12%. Auer uses the effective interest method to amortize bond premium or discount....
-
2. What is the computational complexity of the following function Mystery1? int Mystery1(int n) { int sum = 0; for (int i=0; i
-
Using basic accounting principles as a guide, provide arguments to support The IASB approach for reporting R&D costs, and The ASPE approach for reporting R&D costs. In this era of rapidly changing...
-
Which one of the following is a major loss? Entry Exit large reservoir friction When looking at pipe flow: Major losses are always greater than minor losses Major losses are reduced by decreasing the...
-
Exhibit 7-5 Accounting Services, Inc. has two customers. Customer X generates $600,000 in income after direct fixed costs are deducted, and Customer Z generates $580,000 in income after direct fixed...
-
D owes various credit card issuers $40,000. D files a Chapter 7 petition. D gets a discharge. Her creditors get nothinga no-asset case. If D still voluntarily pays the credit card debts can the...
-
Create 3 interfaces for a personnel, and in each one make an abstract method. First interface for his personal info having its abstract method to accept 3 parameters: name, age, location, and...
-
In managing day-to-day office expenses, the petty cash fund is utilized for minor purchases like a box of paper clips. What account is debited when recording this transaction in the petty cash...
-
It is a tax on a person's income, payments, profits arising from property, the practice of the profession, conduct of a trade or business or on the relevant items of gross income included in the Tax...
-
Why do you think buying BPO solutions vs. building them in-house is so attractive for startup companies? What potential downsides do you perceive?
-
Ex. (17): the vector field F = x i-zj + yz k is defined over the volume of the cuboid given by 0x a,0 y b, 0zc, enclosing the surface S. Evaluate the surface integral ff, F. ds?
-
You have been appointed the assistant-controller of a major manufacturer of newsprint, fine paper, and different types of specialty papers. Michaela, the controller, has been asked by the board of...
-
The offices and factory of Okanagan Company were destroyed by a flood on July 31, 2012, the year-end date of the company. Almost all of the accounting records were lost in the flood and the company...
-
The accountant at Fighting Kites has always prepared a budget that is calculated using only one estimated volume of sales. He has asked you to help him set up a spreadsheet that can be used for...
-
Because the flow speed in your capillaries is much less than in the aorta, the total cross-section area of the capillaries considered together must be much larger than that of the aorta. Given the...
-
A ball is hung from a rope, making a pendulum. When it is pulled 5 to the side, the restoring force is 1.0 N. What will be the magnitude of the restoring force if the ball is pulled 10 to the side?...
-
Two oscillating systems have periods T 1 and T 2 , with T 1 2. How are the frequencies of the two systems related? A. fi f
Study smarter with the SolutionInn App