I am stuck on this problem and need to put into excel with formulas. Please help. You want to buy SuperTech Inc. stock. They pay quarterly dividends, with the next dividend of $0.40 per share being paid later today. You believe that, during the next 6 years, their quarterly dividends will grow by 20% APR, compounded annually. But after 6 years, their quarterly dividends will grow more slowly… only at 4% APR, compounded annually. If the discount rate on this stock is 12% APR, compounded annually, then what would be a fair price for this stock right now?

I am stuck on this problem and need to put into excel with formulas. Please help. You want to buy SuperTech Inc. stock. They pay quarterly dividends, with the next dividend of $0.40 per share being paid later today. You believe that, during the next 6 years, their quarterly dividends will grow by 20% APR, compounded annually. But after 6 years, their quarterly dividends will grow more slowly… only at 4% APR, compounded annually. If the discount rate on this stock is 12% APR, compounded annually, then what would be a fair price for this stock right now?

Name: I am stuck on this problem and need to put into excel with formulas. P
Uploaded: 2024-03-20T06:51:32.000Z
Channel: Bartleby
Description: I am stuck on this problem and need to put into excel with formulas. Please help. You want to buy SuperTech Inc. stock. They pay quarterly dividends, with the next dividend of $0.40 per share being paid later today. You believe that, during the next

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter7: Common Stock: Characteristics, Valuation, And Issuance

Section: Chapter Questions

Problem 20P

See similar textbooks

Similar questions

Goodwin Technologies, a relatively young company, has been wildly successful but has yet to pay a dividend. An analyst forecasts that Goodwin is likely to pay its first dividend three years from now. She expects Goodwin to pay a $5.25000 dividend at that time (D₃ = $5.25000) and believes that the dividend will grow by 27.30000% for the following two years (D₄ and D₅). However, after the fifth year, she expects Goodwin’s dividend to grow at a constant rate of 4.32000% per year. Goodwin’s required return is 14.40000%. Fill in the following chart to determine Goodwin’s horizon value at the horizon date (when constant growth begins) and the current intrinsic value. To increase the accuracy of your calculations, do not round your intermediate calculations, but round all final answers to two decimal places. Term Value Horizon value Current intrinsic value Assuming that the markets are in equilibrium, Goodwin’s current expected dividend yield is , and…
Goodwin Technologies, a relatively young company, has been wildly successful but has yet to pay a dividend. An analyst forecasts that Goodwin is likely to pay its first dividend three years from now. She expects Goodwin to pay a $4.50000 dividend at that time (D₃ = $4.50000) and believes that the dividend will grow by 23.40000% for the following two years (D₄ and D₅). However, after the fifth year, she expects Goodwin’s dividend to grow at a constant rate of 4.14000% per year. Goodwin’s required return is 13.80000%. Fill in the following chart to determine Goodwin’s horizon value at the horizon date (when constant growth begins) and the current intrinsic value. To increase the accuracy of your calculations, do not
Goodwin Technologies, a relatively young company, has been wildly successful but has yet to pay a dividend. An analyst forecasts that Goodwin is likely to pay its first dividend three years from now. She expects Goodwin to pay a $5.00000 dividend at that time (D₃ = $5.00000) and believes that the dividend will grow by 26.00000% for the following two years (D₄ and D₅). However, after the fifth year, she expects Goodwin’s dividend to grow at a constant rate of 4.26000% per year. Goodwin’s required return is 14.20000%. Fill in the following chart to determine Goodwin’s horizon value at the horizon date (when constant growth begins) and the current intrinsic value. To increase the accuracy of your calculations, do not round your intermediate calculations, but round all final answers to two decimal places. 1. Term Value Horizon value Current intrinsic value 2. Assuming that the markets are in equilibrium, Goodwin’s current expected dividend yield…
Goodwin Technologies, a relatively young company, has been wildly successful but has yet to pay a dividend. An analyst forecasts that Goodwin is likely to pay its first dividend three years from now. She expects Goodwin to pay a $1.25000 dividend at that time (D₃ = $1.25000) and believes that the dividend will grow by 6.50000% for the following two years (D₄ and D₅). However, after the fifth year, she expects Goodwin’s dividend to grow at a constant rate of 3.36000% per year. Goodwin’s required return is 11.20000%. Fill in the following chart to determine Goodwin’s horizon value at the horizon date (when constant growth begins) and the current intrinsic value. To increase the accuracy of your calculations, do not round your intermediate calculations, but round all final answers to two decimal places. Term Value Horizon value $18.69 Current intrinsic value $13.61 If investors expect a total return of 12.20%, what will be Goodwin’s expected dividend and…
Chadmark Corporation is expanding rapidly, and it currently needs to retain all of its earnings, hence it does not pay any dividends. However, investors expect Chadmark to begin paying dividends, with the first dividend of $0.75 coming 2 years from today. The dividend should grow rapidly, at a rate of 40% per year, during Years 3 and 4. After Year 4, the company should grow at a constant rate of 10% per year. If the required return on the stock is 16%, what is the value of the stock today? $18.87 $16.05 $16.93 $17.54 $15.78
The Bell Weather Co. is a new firm in a rapidly growing industry. The company is planning on increasing its annual dividend by 21 percent a year for the next 4 years and then decreasing the growth rate to 6 percent per year. The company just paid its annual dividend in the amount of $2.10 per share. What is the current value of one share of this stock if the required rate of return is 7.60 percent?
Microtech Corporation is expanding rapidly and currently needs to retain all of its earnings, hence it does not pay dividends. However, investors expects Microtech to begin paying dividends, beginning with a dividend of $1.00 coming 3 years from Today. The dividend should grow rapidly-at a rate of 50 percent per year-during Years 4 and 5, but after Year 5 growth should be constant 8 percent per year. If the required return on Microtech is 15 percent, what is the value of the stock today?
Yam-Hash Corporation is expanding rapidly, and it does not pay any dividends because it currently needs to retain all of its earnings. However, investors expect Simpkins to begin paying dividends, with the first dividend of 60 coming 3 years from today. The dividend should grow rapidly—at a rate of 50% per year—during Years 4 and 5. After Year 5, the company should grow at a constant rate of 8% per year. If the required return on the stock is 15%, what is the value of the stock today?
Simpkins Corporation does not pay any dividends because it is expanding rapidly and needs to retain all of its earnings. However, investors expect Simpkins to begin paying dividends, with the first dividend of $2.00 coming 3 years from today. The dividend should grow rapidly - at a rate of 60% per year - during Years 4 and 5. After Year 5, the company should grow at a constant rate of 9% per year. If the required return on the stock is 16%, what is the value of the stock today (assume the market is in equilibrium with the required return equal to the expected return)? Do not round intermediate calculations. Round your answer to the nearest cent.
Yam-Hash Corporation is expanding rapidly, and it does not pay any dividends because it currently needs to retain all of its earnings. However, investors expect Simpkins to begin paying dividends, with the first dividend of registration# coming 3 years from today. The dividend should grow rapidly at a rate of 50% per year during Years 4 and 5. After Year 5, the company should grow at a constant rate of 8% per year. If the required return on the stock is 15%, what is the value of the stock today?
Yam-Hash Corporation is expanding rapidly, and it does not pay any dividends because it currently needs to retain all of its earnings. However, investors expect Simpkins to begin paying dividends, with the first dividend of 5 coming 3 years from today. The dividend should grow rapidly—at a rate of 50% per year—during Years 4 and 5. After Year 5, the company should grow at a constant rate of 8% per year. If the required return on the stock is 15%, what is the value of the stock today? Solve question without using escel.