find the correct formula for Market Implied Cost of Capital (ROE) in excel using the given data
Fantastic news! We've Found the answer you've been seeking!
Question:
find the correct formula for Market Implied Cost of Capital (ROE) in excel using the given data
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)
To find the Market Implied Cost of Capital ROE we can use the Gordon Growth Model formul... View the full answer
Related Book For
Financial Management Theory and Practice
ISBN: 978-1305632295
15th edition
Authors: Eugene F. Brigham, Michael C. Ehrhardt
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...
-
pick 1 1 point A small island nation has license plates that consist of 2 letters ( \( A-Z \) allowed) followed by 3 numbers (0 \( -9 \) allowed). How many plates are possible that do not repeat the...
-
(a) Use the atomic masses m = 13.00574 u for 7 13 N and m = 13.003354 u for 6 13 C to calculate the Q value (in MeV) for the decay 7 13 N 6 13 C + + + v e (b) Explain why you need to add two...
-
Secure Home provides house-sitting for people while they are away on vacation. Some of its customers pay immediately after the job is finished. Some customers ask that the business send them a bill....
-
Water flows down a wide rectangular channel having Manning's \(n=0.015\) and bottom slope \(=0.0015\). Find the rate of discharge and normal depth for critical flow conditions.
-
Pascarella & Wiker was retained by K & L Gates to assist in the fraud investigation requested by Le-Nature's Special Committee. What type of professional service was Pascarella & Wiker providing?...
-
(1) What was the background of Mr Wang Gang? What was his character? How did these two elements help him in his career development? (2) What was the benefits for Mr Wang Gang to have a partner? What...
-
Given two arrays each of length n, arr1, and arr2, in one operation, any two elements of an array can be swapped. This can occur any number of times. Find the maximum possible sum of i*(arr2[1]-...
-
Derive and prove an explicit formula for n k3 n for k ( / ). k=0 k
-
The CNO has asked to meet with you to discuss your stakeholder analysis. Prepare a stakeholder map, power/interest grid, and stakeholder analysis in advance of the meeting. Also include a one-page...
-
Assume the situation from question 13 , except now assume that banks hold a ratio of \(0.5 \%\) of excess reserves to deposits and the public keeps \(20 \%\) of its liquid assets in the form of cash....
-
You are the chief nurse executive at an organization that provides clinic services to Medicare patients; seven of the clinics are located in underserved areas. While visiting one of the clinics, you...
-
An investment company has \(\$ 1.05\) million of assets, \(\$ 50,000\) of liabilities, and 10,000 shares outstanding. a. What is its NAV? b. Suppose the fund pays off its liabilities while at the...
-
You are an NP who sees mostly posthead trauma patients and who refers many of these patients to physical and occupational services. On one routine follow-up visit, your patient claims that he has not...
-
You was given the following information to create both a financial statement and income statement. After you have created the financial statements, please answer the questions below. Total Equity...
-
The rate at which the temperature of an object changes is proportional to the difference between its own temperature and the temperature of the surrounding medium. Express this rate as a function of...
-
Schwarzentraub Corporation's expected free cash flow for the year is $500,000; in the future, free cash flow is expected to grow at a rate of 9%. The company currently has no debt, and its cost of...
-
Paul Duncan, financial manager of EduSoft Inc., is facing a dilemma. The firm was founded 5 years ago to provide educational software for the rapidly expanding primary and secondary school markets....
-
a. Several reasons have been proposed to justify mergers. Among the more prominent are: (1) tax considerations, (2) risk reduction, (3) control, (4) purchase of assets at below replacement cost, (5)...
-
Dawson Industries began operations early in January 2024. On 31 December 2024, records showed the following asset, liability, equity, income and expense amounts: Required (a) Prepare a statement of...
-
A new business graduate with one subject of accounting prepared the financial statements below for Amirs Delivery Service at the end of the first year of operations. Additional analysis revealed the...
-
Tiffany established The Marketing Store, an Instagram management business on 1 January 2024 as a sole trader business. She contributed $10 000 in cash to the business and did not withdraw funds for...
Study smarter with the SolutionInn App