INVESTMENTS (LL)
INVESTMENTS (LL)
11th Edition
ISBN: 9781260150407
Author: Bodie
Publisher: MCG
bartleby

Videos

Question
Book Icon
Chapter 18, Problem 16PS

a.

Summary Introduction

To calculate:The intrinsic value when GE’s P/E ratio starting in 2020 will be 16.

Introduction:

Unlevered Beta: This is also called as asset beta. It is one of the risk measurement unit which is used to compare the risk of company that doesnot have any debts with that of risk of the markets. In other words, risk of the company without dedts and risk of the market is compared.Intrinsic Value of Stock=Intrinsic value of BusinessNo. of Outstanding Shares

  Intrinsic value of Business=FCFE1( 1+r)1+FCFE2( 1+r)2+..+Terminal value( 1+r)n

a.

Expert Solution
Check Mark

Answer to Problem 16PS

The intrinsic value when P/E ratio in the year 2020 is 16 will be $111868 and of FCFE will be $77595.80.

Explanation of Solution

Given information:

Spreadsheet 18.2 − Free cash flow model

      20162017201820192020
    A.Input data      
    P/E  14.3514.2514.1714.0814
    Cap spending'shr 2.652.72.822.933.05
    LT Debt 3000028500273332616725000
    Shares 18001800179817971795
    EPS 3.13.753.833.924
    Working capital 3682537750411734459748020
    Discount rate calculations
    Current beta0.95
    unlevered beta0.767
    terminal growth0.02
    tax_rate0.35
    r.debt0.036
    risk-free rate0.02
    market risk premium0.08

The formulas to be entered in the cells are as follows:

  INVESTMENTS (LL), Chapter 18, Problem 16PS , additional homework tip  1

  INVESTMENTS (LL), Chapter 18, Problem 16PS , additional homework tip  2

After inputing the required value in the cell related to G3, we get the following values.

  INVESTMENTS (LL), Chapter 18, Problem 16PS , additional homework tip  3

  INVESTMENTS (LL), Chapter 18, Problem 16PS , additional homework tip  4

  INVESTMENTS (LL), Chapter 18, Problem 16PS , additional homework tip  5

Therefore the intrinsic value when P/E ratio in the year 2020 is 16 will be $111868 and of FCFE will be $77595.80

b.

Summary Introduction

To calculate: The intrinsic value when GE’s unlevered beta is 0.80.

Introduction:

Unlevered Beta: This is also called as asset beta. It is one of the risk measurement unit which is used to compare the risk of company that doesnot have any debts with that of risk of the markets. In other words, risk of the company without dedts and risk of the market is compared.Intrinsic Value of Stock=Intrinsic value of BusinessNo. of Outstanding Shares

  Intrinsic value of Business=FCFE1( 1+r)1+FCFE2( 1+r)2+..+Terminal value( 1+r)n

b.

Expert Solution
Check Mark

Answer to Problem 16PS

The intrinsic value of FCFF is $113972 and FCFE is $79038.50.

Explanation of Solution

Given information:

Spreadsheet 18.2 − Free cash flow model

      20162017201820192020
    A.Input data      
    P/E  14.3514.2514.1714.0814
    Cap spending'shr 2.652.72.822.933.05
    LT Debt 3000028500273332616725000
    Shares 18001800179817971795
    EPS 3.13.753.833.924
    Working capital 3682537750411734459748020
    Discount rate calculations
    Current beta0.95
    unlevered beta0.767
    terminal growth0.02
    tax_rate0.35
    r.debt0.036
    risk-free rate0.02
    market risk premium0.08

The formulas to be entered in the cells are as follows:

  INVESTMENTS (LL), Chapter 18, Problem 16PS , additional homework tip  6

  INVESTMENTS (LL), Chapter 18, Problem 16PS , additional homework tip  7

  INVESTMENTS (LL), Chapter 18, Problem 16PS , additional homework tip  8

We need to change the vaue of unlevered beta from 0.767 to 0.80. After inputing the required value in the cell related to B22, we get the following values.

  INVESTMENTS (LL), Chapter 18, Problem 16PS , additional homework tip  9

  INVESTMENTS (LL), Chapter 18, Problem 16PS , additional homework tip  10

Therefore, the intrinsic value of FCFF is $113972 and FCFE is $79038.50.

c.

Summary Introduction

To calculate: Intrinsic value when the market risk premium is 7.5%

Introduction:

Unlevered Beta: This is also called as asset beta. It is one of the risk measurement unit which is used to compare the risk of company that doesnot have any debts with that of risk of the markets. In other words, risk of the company without dedts and risk of the market is compared.Intrinsic Value of Stock=Intrinsic value of BusinessNo. of Outstanding Shares

  Intrinsic value of Business=FCFE1( 1+r)1+FCFE2( 1+r)2+..+Terminal value( 1+r)n

c.

Expert Solution
Check Mark

Answer to Problem 16PS

The intrinsic value of FCFF will be$ 119921 and for FCFE it will be $83151.40.

Explanation of Solution

Given information:

Spreadsheet 18.2 − Free cash flow model

      20162017201820192020
    A.Input data      
    P/E  14.3514.2514.1714.0814
    Cap spending'shr 2.652.72.822.933.05
    LT Debt 3000028500273332616725000
    Shares 18001800179817971795
    EPS 3.13.753.833.924
    Working capital 3682537750411734459748020
    Discount rate calculations
    Current beta0.95
    unlevered beta0.767
    terminal growth0.02
    tax_rate0.35
    r.debt0.036
    risk-free rate0.02
    market risk premium0.08

The formulas to be entered in the cells are as follows:

  INVESTMENTS (LL), Chapter 18, Problem 16PS , additional homework tip  11

  INVESTMENTS (LL), Chapter 18, Problem 16PS , additional homework tip  12

  INVESTMENTS (LL), Chapter 18, Problem 16PS , additional homework tip  13

We need to change the vaue of unlevered beta from 0.08 to 0.075. After inputing the required value in the cell related to B27, we get the following values.

  INVESTMENTS (LL), Chapter 18, Problem 16PS , additional homework tip  14

  INVESTMENTS (LL), Chapter 18, Problem 16PS , additional homework tip  15

Therefore the intrinsic value of FCFE will be$ 119921 and for FCFE it will be $83151.40.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Using the equity asset valuation model (CAPM) equation, determine the required return for the shares of the following companies, if the market return is 7.50% (Rm = 7.50%) and the risk-free asset return is 1.25% (RF = 1.25%). You must show all counts. Stock Beta SKT 0.65 COST 0.90 SU 1.42 AMZN 1.57 V 0.94
Consider a two-state outcome for the following problem:                   Winterhold Publishing House       Current Stock Price $25.00        Exercise Price $27.00        Risk-free Rate 0.05       Share Price, High $30.00        Share Price, Low $20.00                  Required:         Using the data above, please find the hedge ratio. You currently own several shares of this company. The purchase puts according to the Hedge ratio to construct a non-random portfolio. Show the payoff for both outcomes, then solve for present value and the price of the put.
The following table shows betas for several companies. Calculate each stock’s expected rate of return using the CAPM. Assume the risk-free rate of interest is 4%. Use a 7% risk premium for the market portfolio. Note: Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.       Company Beta Cost of Capital Caterpillar 0.98   % Apple 1.35   % Johnson & Johnson 0.69   % Consolidated Edison 0.13   %
Knowledge Booster
Background pattern image
Finance
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Text book image
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Text book image
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Text book image
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Investing For Beginners (Stock Market); Author: Daniel Pronk;https://www.youtube.com/watch?v=6Jkdpgc407M;License: Standard Youtube License