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,...
-
A study of the amount of rainfall and the quantity of air pollution removed produced the following data:(a) Find the equation of the regression line to predict, the particulate removed from the...
-
A simplified diagram of an overhead traveling crane is shown in Fig. 7.20. The girder, with square cross section, and the wire rope, with circular cross section, are made up of steel. Design the...
-
The T-account for cash and the bank statement of Mee Auto Services for the month of March 2010 follows: Cash Mar 1 3,200 Check #704 540 Mar 10 deposit 750 Check #705 210 Mar 31 deposit 200 Check #706...
-
Currently, at a price of $1 each, 100 popsicles are sold per day in the perpetually hot town of Rostin. Consider the elasticity of supply. In the short run, a price increase from $1 to $2 is...
-
Steven and Carol, who file a joint tax return, have taxable income of $135,000 before the following sales of stock: Purchase Date Sale Date Cost Sales Proceeds 02/14/Year 10 07/14/Year 10 $2,120...
-
Use the following information to answer questions. Viva Electronics produces and sells two products, VE1 and VE2. Viva incurred $168,000 overhead costs in a single cost pool. Viva allocates the...
-
(9%) Problem 11: Laser beams are sometimes used to burn away cancerous tissue. 100% Part (a) What is the intensity, in watts per square meter, of a laser beam that is 90.0% absorbed by a 1.95-mm...
-
We normally assume that the yield to maturity must always be positive. A negative yield to maturity would imply that you are willing to pay more for a bond today than you will receive for it in the...
-
Show that the Euler totient function is multiplicative for coprime numbers, that is, if gcd(a, b) =1 then (ab) = (a)(b).
-
For the following, determine two distinct basic feasible solutions at which the optimal value of the objective function is attained. Minimize x1-3x2-6x3 subject to 2x1 - x2 + x3 + x4 60 3x1 + 4x2 +...
-
As a leader it is important to know how to feel your feelings and express them as well. This helps with self-change because emotional intelligence is the process of understanding your feelings, but...
-
Evaluate an existing mode of transportation. For example, take a bicycle and describe its cost (how much does a bike cost, how much is maintenance and upkeep?), its environmental impact (pretty low...
-
Ms. A is an employee of a Canadian public company, Square Co. (SQUARE/Employer). She lives in Mississauga, ON and her salary for 2022 year is $115,000. She is not a salesperson and does not receive...
-
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...
-
Refer to Problem P3-46 Problem P3-46 The accounts of Marciano Services Ltd. at March 31, 2020, are listed in alphabetical order. 1. Use the Marciano Lid. data in problem P3-46A to prepare the...
-
The accounts of Marciano Services Ltd. at March 31, 2020, are listed in alphabetical order. Requirements 1. All adjustments have been journalized and posted, but the closing entries have not been...
-
Sundance Apartments Inc.'s unadjusted and adjusted trial balance at April 30, 2020, follow: Requirements 1. Make the adjusting entries that account for the differences between the two trial balances....
Study smarter with the SolutionInn App