Suppose that a firm's recent earnings per share and dividend per share are $3.15 and $2.60, respectively. Both are expected to grow at 6 percent. However, the firm's current P/E ratio of 27 seems high for this growth rate. The P/E ratio is expected to fall to 23 within five years. Compute the dividends over the next five years. Compute the value of this stock price in five years. Calculate the present value of these cash flows using an 8 percent discount rate.

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)
8th Edition
ISBN:9781285065137
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Eugene F. Brigham, Joel F. Houston
Chapter8: Risk And Rates Of Return
Section: Chapter Questions
Problem 6DQ
icon
Related questions
Question
Problem 8-20 Spreadsheet Problem: P/E Model and Cash Flow Valuation (LG8-5, LG8-7)
Suppose that a firm's recent earnings per share and dividend per share are $3.15 and $2.60, respectively. Both are expected to grow
at 6 percent. However, the firm's current P/E ratio of 27 seems high for this growth rate. The P/E ratio is expected to fall to 23 within
five years.
Compute the dividends over the next five years.
Compute the value of this stock price in five years.
Calculate the present value of these cash flows using an 8 percent discount rate.
Complete this question by entering your answers in the tabs below.
Dividends Stock price
Present value
Compute the dividends over the next five years.
Note: Do not round intermediate calculations. Round your answers to 3 decimal places.
Years
First year
Second year
Third year
Fourth year
Fifth year
Dividends
Dividends
Stock price
Transcribed Image Text:Problem 8-20 Spreadsheet Problem: P/E Model and Cash Flow Valuation (LG8-5, LG8-7) Suppose that a firm's recent earnings per share and dividend per share are $3.15 and $2.60, respectively. Both are expected to grow at 6 percent. However, the firm's current P/E ratio of 27 seems high for this growth rate. The P/E ratio is expected to fall to 23 within five years. Compute the dividends over the next five years. Compute the value of this stock price in five years. Calculate the present value of these cash flows using an 8 percent discount rate. Complete this question by entering your answers in the tabs below. Dividends Stock price Present value Compute the dividends over the next five years. Note: Do not round intermediate calculations. Round your answers to 3 decimal places. Years First year Second year Third year Fourth year Fifth year Dividends Dividends Stock price
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781285065137
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781305635937
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT