Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

what are the right answers and what did i do wrong Design a spreadsheet similar to the one below to compute the value of a

what are the right answers and what did i do wrong image text in transcribed
Design a spreadsheet similar to the one below to compute the value of a variable growth rate firm over allve-year horizon. (Do not round Intermediate calculations. Round your answers to 2 decimal places) .. What is the value of the stock if the current dividend is $1.0, the first stage growth is 18%, the second stage growth is 9%, and the discount rate is 14%? Year 1 $ 1.18 Answer is complete and correct. Year 2 Year 3 Year 4 Year 5 $ 1.39 $ 1.54 $ 1.949 $ 225 $ 49.87 Proiected dividend Terminal price Present value $ 31.45 b. What is the value of the stock if the current dividend is $10, the first stage growth is 1%, the second stage growth is 9%, and the discount rate is 100%? Projected dividend Terminal price Present value Answer is complete but not entirely correct. Year 1 Year 2 Year 3 Year 4 Year 5 $ 1.010s 1.02 $ 1.03 $ 1.04 $ 1.05% $ 115,61% $ 75.68% c. What is the value of the stock if the current dividend is $2.0, the first stage growth is 13%, the second stage growth is 7%, and the discount rate is 12%? Answer is complete and correct. Year 2 Year 3 Year 4 Year 5 $ 2.55 $ 2.89 $ 3.20 $ 3.68% $ 78.86 Year 1 $ 2.26 Projected dividend Terminal price

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance

Authors: Angelico Groppelli, Ehsan Nikbakht

7th Edition

1438010362, 9781438010366

More Books

Students also viewed these Finance questions