Question

Problem 8-1 Stock Values. ? X - Sign In Saf Calculating stock price - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW P M Calibri - 11 - Á À = % 1 Paste B I U . 3- A - Alignment Number Conditional Format as Cell Formatting Table Styles Clipboard Font G Styles Cells - A1 A B C D E F G H I J The Jackson-Timberlake Wardrobe Co. just paid a dividend of $1.95 per share on its stock. The dividends are expected to grow at a constant rate of 4 percent per year indefinitely. If investors require a return of 10.5 percent on the stock, what is the current price? What will the price be in three years? In 15 years? $ 1.95 4% 10.5% Current dividend Dividend growth rate Required return Price in Year Price in Year Price in Year Complete the following analysis. Do not hard code values in your calculations. Dividend in one year Price today Dividend in 4 years Price in 3 years

I want the answer to be in excel formula , for example (D1,D1,,..)

Answer 1

Current dividend Dividend growth rate Required return $ 1.95 4% 10.50% Dividend in one year Price today $ 2.03 $ 31.20 Dividend in 4 years Price in 3 years $ 2.28 $ 35.10 Dividend in 16 years Price in 15 years $ 3.65 $56.19

A B E Current dividend 1.95 Dividend growth rate 0.04 Required return 0.105 Dividend in one year =D6*(1+D7)^1 Price today =D16/(D8-D7) Dividend in 4 years Price in 3 years =D6*(1+D7)^4 =D19/(D8-D7) Dividend in 16 years Price in 15 years =D6*(1+D7)^16 =D22/(D8-D7)

Please do rate me and mention doubts, if any, in the comments section.