Calculate the mean and median valuation ratios

Assignment Help Financial Econometrics
Reference no: EM132550800

Question 1. Using Comparables to Value DNKN and TXRH

Reassess our previous valuations for Dunkin Brands (DNKN) and Texas Roadhouse (TXRH). The valuation ratios from the six peer firms and the fundamentals for DNKN and TXRH are given below. The peer firms are Yum! Brands (YUM), McDonald's (MCD), Chipotle Mexican Grill (CMG), Domino's Pizza (DPZ), Starbucks (SBUX), and Wendy's (WEN).

Ratio

YUM

MCD

CMG

DPZ

SBUX

WEN

Trailing PE

14.99

22.38

67.64

40.62

17.97

9.07

Forward PE

24.37

21.95

52.64

32.54

22.70

31.72

Price/Sales

4.61

5.95

2.77

3.87

3.33

3.22

Price/Cash flow

13.26

18.28

37.11

35.43

19.76

23.94

Dividend yield %

1.73

2.39

0.00

0.81

2.12

1.92

PEG ratio

1.22

2.68

2.98

1.77

1.13

3.85

Market cap $bil

27.20

133.10

12.50

11.50

78.90

4.10








Fundamental

DNKN

TXRH





Trailing EPS

2.30

2.08





Forward EPS

2.73

2.40





Sales/Share

11.65

31.94





Cash flow/Share

2.99

3.19





Dividend per share

1.39

1.00





Market price $

67.12

63.87





Use only the information from four of the peers (YUM, MCD, SBUX, and WEN) to do the analysis below. (Delete CMG and DPZ from the set of peers).
A. Calculate the mean and median valuation ratios for the six peer firms
B. Using the median ratios for the peer firms, calculate the indicated prices for DNKN and TXRH.
C. Calculate a weighted average price for DNKN and TXRH using a 0.40 weight for the indicated price from the forward PE and a 0.15 weight for the prices indicated by the other four ratios.
D. If you use the mean values of the peer ratios instead of the medians, would this increaseor decrease the weighted average prices for DNKN and TXRH?

Question 2. Using the residual income model to value Hess Electrical Contractors. ValueHess Electrical with the residual income method. You have assembled the following information and assumptions for your analysis.
• Book value per share is $20.00
• EPS will be 20% of beginning book value for the next ten years
• Cash dividends will be 40% of EPS each year
• At the end of ten years, market price per share will be 1.8 times book value per share
• The Hess beta 0.9, the risk-free rate is 3.0%, and the equity risk premium is 5.0%

1. Prepare a table showing, for each year, the beginning and ending book values, net income per share, dividends per share, residual income, and the present value of residual income.
2. Estimate the per share value of REM stock using the residual income model.
3. Estimate the per share value of REM stock using the dividend discount model.

Reference no: EM132550800

Questions Cloud

Maximum increase in the money supply : Assume that Elliott deposits $1,000 in coins he collected into his checking account. The required reserve ratio for the banking system
What would be the average inventory level : Ann Chovies, owner of the Perfect Pasta Pizza Parlour, If she were to order 80 pounds of pepperoni at a time, what would be the average inventory level
Explain the difference between leaders and managers : Explain the difference between leaders and managers, as well as the influence and power they may have on the success of this program.
Macroeconomic concept is governor lowe : On 22 February 2019 Philip Lowe, the Governor of the Reserve Bank of Australia, told the house economics committee
Calculate the mean and median valuation ratios : Calculate the mean and median valuation ratios for the six peer firms and Calculate a weighted average price for DNKN and TXRH using a 0.40 weight
Prepare the equity section on the January : Prepare the equity section on the January 31, 2020, balance sheet, assuming profit earned during January 2020 was $597,500
Aggregate supply curve of shangri la : The shape of the aggregate supply curve of Shangri La is steep and the government applied expansionary monetary
Natural level of output : If the economy is at its natural level of output, and then there is an increase in productivity ( example due to new technology)
Central bank of saudi arabia : The central bank of Saudi Arabia (Saudi Arabian Monetary Authority or SAMA) has pegged (fixed) the country's currency

Reviews

len2550800

6/20/2020 3:03:29 AM

Please do the word file docx "Assignment3" on excel read the instruction carefully and transfer the answer to excel spread sheet. This assignment includes two problems. Problem 1 is an assignment using market valuation ratios from peer firms to estimate the value of two subject firms. Problem 2 is a residual income model valuation. Both problems are similar to problems worked in the narrated Excel lecture when completed. The solution examples and assignment samples are attached pdf. You can look the sample on how my teacher did it. Please finish it on time.

Write a Review

Financial Econometrics Questions & Answers

  A project report on banking system

The objective of this business report is to focus upon evaluating the current portfolio of Baituna home loans product of Bank Muscat and its volumes. It focus upon the current standing of the product in Oman and its performance on the basis of its vo..

  Questions on financial econometrics

Objective and multiple choice questions on Financial Econometrics responsible for creating financial statements.

  Option valuation report

Value Joseph's option position based on Black-Scholes method and analysis needs cover details behind the standard Black - Scholes method and explain detailed adjustment made to the standard BS method

  Conduct a bivariate nonlinear conintegration tests

Conduct a bivariate nonlinear conintegration tests using threshold Vector Error Correction (TVEC) methodology. Need to develop Matlab code.

  Calculate the expected exchange rate

Use a properly labelled IS-LM graph to analyze and illustrate the effect and calculate the expected exchange rate for the end of the year.

  Capm and capital structure

Reflect on the papers. Synthesize the key points they're making and consider the challenges of such points in a given context within your environment.

  Calculate the npv-irr and non-discounted payback period

Calculate the NPV, IRR, and Non-Discounted Payback Period using Excel - Outline and write the essay starting with the evidence-supported defense of your points and slowly transition into an address of opposing points.

  Objectives and principles guiding corporate governance

What is corporate governance and what are the objectives and principles guiding corporate governance?

  What is the capital budgeting process

What is capital budgeting, what is the capital budgeting process, what are the principles of capital budgeting and when do we make a capital investment?

  How do taxes affect the cost of capital

What is the cost of capital, what are WACC and MCC and how do taxes affect the cost of capital?

  How do you create or decrease leverage

What is leverage, how do you create or decrease leverage and why is leverage used?

  Calculate the wacc for both investment

Outline and write the essay starting with the evidence-supported defense of your points and slowly transition into an address of opposing points - Calculate the WACC for both investment. Calculate the NPV for investments discounted at their respec..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd