Financial Concepts Week5 Exercise9

Question # 00255435 Posted By: kimwood Updated on: 04/18/2016 08:55 AM Due on: 05/18/2016
Subject Finance Topic Finance Tutorials:
Question
Dot Image
Financial Concepts
Week5 Exercise9
Equity Pricing
Name: <your Name>
Instructions
Show work by showing the algebra in the Excel cell(s) and any intermediate steps in the calculations.
Leave all answers to TWO decimal places.
Q1. Company A has projected net income per share for this year at $3.00 per share. It has traditionally paid out a dividend of 25% of its net income. Income and dividends have been growing at a constant rate (indefinitely) of 4% per year. The equity discount rate for this company is 10%.
a) What is the projected dividend for next year?
D1 =
b) What is the current value of the stock using the Constant Growth Model of the Dividend Discount Model? monkey2
P0 =
Q2. If from Question 1, having that projected EPS of $3.00, Company A decides to reduce its dividend rate to 20%, and expects that the growth rate will increase as a result of the higher retained earnings to 5% per year:
a) What is the new projected dividend for next year?
D1new =
b) What is the new stock value?
P0new =
Q3. A separate company, Company B, has a ROE of 10%.
a) What will be its estimated growth rateif it has a dividend payout ratio of 40%?
g =
b) If the company decreases the dividend payout ratio to 30%, what will be the new estimated growth rate?
gnew =
Q4. A separate third company, Company C, will have earnings per share of $5.00 this year. It pays a dividend equal to 40% of net income. It is expecting that income and dividends will grow by 25% next year and 20% the year after. In subsequent years, it is expecting to return to its historical constant growth rate of 5% per year. The relevant discount rate for this company is 10%.
a) What are the projected level of dividends for years 1, 2 and 3.
D1 =
D2 =
D3 =
b) What is the value of the stock in year 2?
P2 =
c) What is the value of the stock today? [assume dividend D0 has been paid out].
P0 =
Q5. Company D has EBITDA of $500 million. It has outstanding debt of $600 million. Its industry has typically displayed a Value/EBITDA ratio of between 8x and 10x EBITDA. If Company D has 100 million shares outstanding, what is the estimate of the per share value of this company?
Low-end High-end
Value/EBITDA ratio: 8 10
Per Share Value:
Average Per Share Value =
Dot Image
Tutorials for this Question
  1. Tutorial # 00250683 Posted By: kimwood Posted on: 04/18/2016 08:55 AM
    Puchased By: 3
    Tutorial Preview
    for this company is 10%. a) What is the projected dividend ...
    Attachments
    Copy_of_Wk_5_Ex9_Equity_Pricing.xlsx (13.21 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    gin...rdo Rating Awesome work done, recommended to all 05/14/2017

Great! We have found the solution of this question!

Whatsapp Lisa