Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the following data to calculate your stock value. Note the following: ROE = NI / Total equity Payout ratio = total cash dividends /

Use the following data to calculate your stock value.

Note the following:

ROE = NI / Total equity

Payout ratio = total cash dividends / NI

There are 10million shares outstanding.

T-bill rate is 3.0%, S&P500 mkt return was 10.00%, and beta of this company is 1.5.

equity beta of this company is 1.5.

FCF (Free cash flow) = EBIT * (1-tax rate) + Depreciation NCS change in NWC

assume that the market value of debt is equal to the book value of debt.

Balance sheet (in millions) of 2021 and 2022

2021

2022

2021

2022

Current Assets

380

450

Current liabilities

150

200

Fixed Asset

600

500

Fixed Debt

380

250

Total equity

450

500

Total Asset

980

950

Total liabilities+equity

980

950

Income Statement (in millions) of 2022

Revenue

500

all expenses

-200

EBIT

300

Interest expense

-100

EBT

200

Tax

-90

NI =

110

Assume this company does not pay any dividend. And further assume that the Free cash flow and the earnings will grow at the constant rate of 4.5%.

Question #1. With this assumption, What should be the stock value per share using the Free Cash Flow (FCF) model?

----------------------------------------------------------------------------------

For the following questions, find the expected stock price using the table below per price ratio analyses:

image text in transcribed

QUESTION #2. Find the expected stock price for year 2017 using the p/e ratio

QUESTION #3. Find the expected stock price for year 2017 using the p/cf ratio

QUESTION #4. Find the expected stock price for year 2017 using the p/s ratio

- Formulas for the first question:

FCF = EBIT(1 Tax Rate) + Depreciation (Net) Capital Spending Change in Net Working Capital

- Formulas for the 2,3 and 3 question:

historical P/E ratio x projected EPS

historical P/CF ratio x projected CFPS

historical P/S ratio x projected SPS

\begin{tabular}{l|rrrrrr} year & 2011 & 2012 & 2013 & 2014 & 2015 & 2016 \\ \hline price & $94.50 & $100.40 & $99.10 & $97.90 & $121.50 & $136.80 \\ eps & 4.34 & 5.05 & 5.22 & 6.06 & 7.00 & 8.00 \\ cfps & 7.27 & 8.24 & 8.71 & 10.12 & 11.8 & 13.1 \\ sps & 52.6 & 58.52 & 57.9 & 60.69 & 71.6 & 78.7 \\ \hline dividend & $1.00 & $1.08 & $1.17 & $1.25 & $1.35 & $1.40 \end{tabular} \begin{tabular}{l|rrrrrr} year & 2011 & 2012 & 2013 & 2014 & 2015 & 2016 \\ \hline price & $94.50 & $100.40 & $99.10 & $97.90 & $121.50 & $136.80 \\ eps & 4.34 & 5.05 & 5.22 & 6.06 & 7.00 & 8.00 \\ cfps & 7.27 & 8.24 & 8.71 & 10.12 & 11.8 & 13.1 \\ sps & 52.6 & 58.52 & 57.9 & 60.69 & 71.6 & 78.7 \\ \hline dividend & $1.00 & $1.08 & $1.17 & $1.25 & $1.35 & $1.40 \end{tabular}

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

Fundamentals Of Corporate Finance

Authors: Robert Parrino, David S. Kidwell, Thomas W. Bates

5th Edition

1119795435, 978-1119795438

More Books

Students also viewed these Finance questions