find the correct Market Implied cost of capital (ROE) in excel using the solver function with the
Fantastic news! We've Found the answer you've been seeking!
Question:
find the correct Market Implied cost of capital (ROE) in excel using the solver function with the data given below
Transcribed Image Text:
Stock Valuation: 10-Period Growth Model 3.21% Long run dividend growth rate 12.33% Opportunity Cost of Capital $11.69 Stock Value @ Time Zero $7.26 Current Market Price of Stock $4.43 Stock Value- Market Price Projected Cash Dividend $1.40 End of Period 0 1 2 3 4 5 6 7 8 9 10 1.50 0.00 1.05 1.05 1.10 1.05 1.30 1.40 1.50 1.60 Market Implied Cost of Capital (ROE) Dividend Growth Horizon / Continuing Undiscounted Total Value Cash Flow Rate 7.14% -100.00% N/A 0.00% 4.76% -4.55% 23.81% 7.69% 7.14% 6.67% $18.11 $1.50 0.00 1.05 1.05 1.10 1.05 1.30 1.40 1.50 19.71 Discount Factor Rate 12.33% 1.0000 0.8902 0.7925 0.7055 0.6281 0.5591 0.4978 0.4431 0.3945 0.3512 0.3126 Present Value of Cash Flows $1.34 0.00 .74 .66 .62 .52 .58 55 .53 6.16 Stock Valuation: 10-Period Growth Model 3.21% Long run dividend growth rate 12.33% Opportunity Cost of Capital $11.69 Stock Value @ Time Zero $7.26 Current Market Price of Stock $4.43 Stock Value- Market Price Projected Cash Dividend $1.40 End of Period 0 1 2 3 4 5 6 7 8 9 10 1.50 0.00 1.05 1.05 1.10 1.05 1.30 1.40 1.50 1.60 Market Implied Cost of Capital (ROE) Dividend Growth Horizon / Continuing Undiscounted Total Value Cash Flow Rate 7.14% -100.00% N/A 0.00% 4.76% -4.55% 23.81% 7.69% 7.14% 6.67% $18.11 $1.50 0.00 1.05 1.05 1.10 1.05 1.30 1.40 1.50 19.71 Discount Factor Rate 12.33% 1.0000 0.8902 0.7925 0.7055 0.6281 0.5591 0.4978 0.4431 0.3945 0.3512 0.3126 Present Value of Cash Flows $1.34 0.00 .74 .66 .62 .52 .58 55 .53 6.16
Expert Answer:
Answer rating: 100% (QA)
Answer To find the correct Market Implied Cost of Capital ROE using Excels Solver function you can f... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1285190907
8th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these finance questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
A researcher wanted to find out if there was difference between older movie goers and younger movie goers with respect to their estimates of a successful actors income. The researcher first...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
To build each unit of a certain product Z , a firm needs one unit of component W and two units of component Y . Each unit of Yin turn requires one unit of component X and three units of W . Finally,...
-
Explain why stocks traded on the NYSE generally exhibit less risk than stocks that are traded on other exchanges.
-
Using the annual financial report obtained for Exercise 11, answer the following questions: a. Review the Statement of Net Position for the proprietary funds. Is the Net Position or the Balance Sheet...
-
Milton Hershey was the founder of the Hershey Chocolate Company, which is now known as Hershey Foods, the maker of Hershey's Milk Chocolate, Hershey's Kisses, and other products with which all...
-
Liquid water is fed to a boiler at 24C and 10bar and is converted at constant pressure to saturated steam. Use the steam tables to calculate H (kJ/kg) for this process, and then calculate the heat...
-
Mayra owns 100 shares of stock in one company. On Tuesday, the stock price dropped $13 per share. Wh was the total effect on Mayra's portfolio? (If it was a loss, be sure to use the minus sign to...
-
This problem continues the Draper Consulting, Inc., situation from Problem 2-62 of Chapter 2. Start from the trial balance and the posted T-accounts that Draper Consulting, Inc., prepared at December...
-
What are intellectual property rights? How can organizations protect their intellectual property? How has the TRIPS treaty protected intellectual property rights? (TRIPS>The Agreement on...
-
A non-dividend paying stock is currently trading at 42. Over each of the next two 3-month periods it is expected to either go up by 10% or down by 10%. The risk-free interest rate is 8% per annum...
-
Explain the unique anatomical adaptations of the human hand that allow for complex manipulative abilities and fine motor skills, referencing the role of the thumb, tendons, and intrinsic hand muscles...
-
Magnificent Modems, Inc. makes modem cards that are used in notebook computers. The company completed the following transactions during year 1. All purchases and sales were made with cash. Acquired...
-
A furniture store has a love seat on sale for $699.00, with the payment due one year from today. The store is willing to discount the price at an annual rate of 7% if you pay today. What is the...
-
Describe the anatomy of the human heart, emphasizing the organization of cardiac chambers, valves, and coronary circulation, and discuss how these features support coordinated cardiac function and...
-
Mountain Mouse makes freeze-dried meals for hikers. One ofMountain Mouse's biggest customers is a sporting goods superstore.Every 19 days, Mountain Mouse checks the inventory level at thesuperstore...
-
Find the center of mass of a thin triangular plate bounded by the y-axis and the lines y = x and y = 2 - x if (x, y) = 6x + 3y + 3.
-
In Problem 10.16, we projected financial statements for Walmart Stores for Years +1 through +5. The data in Chapter 12 Exhibits 12.17-12.19 include the actual amounts for 2012 and the projected...
-
The Apollo Group is one of the largest providers of private education, and runs numerous programs and services, including the University of Phoenix. Exhibit 3.25 provides the statement of cash flows...
-
In 2000, Enron enjoyed remarkable success in the capital markets. During that year, Enron's shares increased in value by 89%, while the S&P 500 index fell by 9%. At the end of 2000, Enron's shares...
-
What is the Euro Areas total for Groups A through C? Use the following balance of payments data for the Euro Area from the IMF to answer this problem. Assumptions (billion US$) 2000 2001 2002 2003...
-
What is the Euro Areas total for Groups A through D? Use the following balance of payments data for the Euro Area from the IMF to answer this problem. Assumptions (billion US$) 2000 2001 2002 2003...
-
Trade Deficits and J-Curve Adjustment Paths. Assume that the United Arab Emirates has the following import/ export volumes and prices. It undertakes a major devaluation of the UAE Dirham (AED) by 6%...
Study smarter with the SolutionInn App