Problem ABC is a young starup company. Currently, they do not pay dividends. The first scheduled...

Problem ABC is a young starup company. Currently, they do not pay dividends. The first scheduled dividend will be paid at the end of year 3, with amount of $1.50. In the next 4 years, the dividend will grow at 20% every year. After that, it will maintain a sustainable growth rate of 6% forever. The required rate of return is 15%. John hired you as an excel programmer. He asks you to write only one flexible excel program that has all of the following requirements respect to the change of input data: a) The amount of stock price must be shown at “answer section” ( 1 point) b) Please use IF function to develop a fexible model displaying the stock price and dividend for this model.

Solutions

Expert Solution

Stock Price = present value of all Dividends

= 1.5/(1.15)³ + 1.5*1.2/(1.15)⁴+1.5 (1.2)²/(1.15)⁵+1.5 (1.2)³/(1.15)⁶ +1.5 (1.2)⁴/(1.15)⁷ + 1.5 (1.2)⁴/(1.15)⁷ (1.06)/(1.15-1.06)

= $19.15

jeff jeffy answered 9 months ago

Next > < Previous

Related Solutions

ABC is a young start-up company. No dividends will be paid on the stock over the...

ABC is a young start-up company. No dividends will be paid on the stock over the next 3 years because the firm needs to plow back its earnings to fuel growth. The company plans to pay a $6 per share dividend in 4 years and will increase the dividend by 4 percent per year thereafter. What is the current share price if the required return on this stock is 16 percent?

ABC, Company is expected to pay a dividends of $2.18 on their common stock. The company...

ABC, Company is expected to pay a dividends of $2.18 on their common stock. The company expects the growth rate to be 3.2% infinitely. If today's price of the stock is $72.57, what is the dividend yield?

Lincoln Motors does not pay dividends currently but plans to pay its first dividend of $1.00...

Lincoln Motors does not pay dividends currently but plans to pay its first dividend of $1.00 three years from today (D3). The dividend will grow at 10% in years 4 and 5 and after year 5 will grow at 3% forever. Find the price per share of Lincoln Motors if the required rate of return is 8%.

9. Stocks that don't pay dividends yet Goodwin Technologies, a relatively young company, has been wildly...

9. Stocks that don't pay dividends yet 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 $2.5000 dividend at that time (D3D3 = $2.5000) and believes that the dividend will grow by 13.00% for the following two years (D4D4 and D5D5). However, after the fifth year, she expects Goodwin’s dividend...

9. Stocks that don't pay dividends yet Goodwin Technologies, a relatively young company, has been wildly...

9. Stocks that don't pay dividends yet 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 $2.00000 dividend at that time (D₃ = $2.00000) and believes that the dividend will grow by 10.40000% for the following two years (D₄ and D₅). However, after the fifth year, she expects Goodwin’s dividend...

9. Stocks that don't pay dividends yet Goodwin Technologies, a relatively young company, has been wildly...

9. Stocks that don't pay dividends yet 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 $2.00000 dividend at that time (D₃ = $2.00000) and believes that the dividend will grow by 10.40000% for the following two years (D₄ and D₅). However, after the fifth year, she expects Goodwin’s dividend...

9. Stocks that don't pay dividends yet Goodwin Technologies, a relatively young company, has been wildly...

9. Stocks that don't pay dividends yet 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.25000 dividend at that time (D₃ = $4.25000) and believes that the dividend will grow by 22.10000% for the following two years (D₄ and D₅). However, after the fifth year, she expects Goodwin’s dividend...

In order to pay off the most recent invoice, a company is scheduled to pay $2000...

In order to pay off the most recent invoice, a company is scheduled to pay $2000 today and $1500 in 6 months. Due to a decrease in sales, the company has chosen to renegotiate the payments. The invoice will be settled by a payment of $1000 in 3 months and a final payment 12 months from now. Determine the size of the final payment if interest is 6% p.a. compounded quarterly.

?Staton-Smith Software is a new? start-up company and will not pay dividends for the first five...

?Staton-Smith Software is a new? start-up company and will not pay dividends for the first five years of operation. It will then institute an annual cash dividend policy of ?$4.75 with a constant growth rate of 4?%, with the first dividend at the end of year six. The company will be in business for 25 years total. What is the? stock's price if an investor wants a. a return of 12?%? b. a return of 13?%? c. a return of...

Staton-Smith Software is a new start-up company and will not pay dividends for the first five...

Staton-Smith Software is a new start-up company and will not pay dividends for the first five years of operation. It will then institute an annual cash dividend policy of $3.75 with a constant growth rate of 6%, with the first dividend at the end of year six. The company will be in business for 25 years total. What is the stock's price if an investor wants a. a return of 10%? b. a return of 15%? c. a return of...

Subjects