Question

calculate the price of a stock using the corporate valuation (FCF) method with excel. Create a model that has 4 years of abnormal growth and then settles into a constant growth rate using excel and show how to do it so i can replicate the steps. can use random numbers

- Free cash flow in year 1
- Free cash flow in year 2
- Free cash flow in year 3
- Free cash flow in year 4
- Constant growth rate
- WACC
- Market value of debt and preferred stock
- Number of shares of stock outstanding

And the excel must show the right intrinsic price of the stock

thank you .

Answer #1

Values assumed: FCF0 = 10 million

Abnormal growth rate = 10%; constant growth rate = 3%

WACC = 12%

Market value of debt = 50 million

Market value of preferred stock = 20 million

Shares outstanding = 2 million

Formulas screenshot:

The corporate valuation model, the price-to-earnings (P/E)
multiple approach, and the economic value-added (EVA) approach are
some examples of valuation techniques. The corporate valuation
model is similar to the dividend-based valuation that you’ve done
in previous problems, but it focuses on a firm’s free cash flows
(FCFs) instead of its dividends. Some firms don’t pay dividends, or
their dividends are difficult to forecast. For that reason, some
analysts prefer to use the corporate valuation model, which
maintains that the value...

The corporate valuation model, the price-to-earnings (P/E)
multiple approach, and the economic value added (EVA) approach are
some examples of valuation techniques. The corporate valuation
model is similar to the dividend-based valuation that you’ve done
in previous problems, but it focuses on a firm’s free cash flows
(FCFs) instead of its dividends. Some firms don’t pay dividends, or
their dividends are difficult to forecast. For that reason, some
analysts use the corporate valuation model.
Tropetech Inc. has an expected net...

The corporate valuation model, the price-to-earnings (P/E)
multiple approach, and the economic value added (EVA) approach are
some examples of valuation techniques. The corporate valuation
model is similar to the dividend-based valuation that you’ve done
in previous problems, but it focuses on a firm’s free cash flows
(FCFs) instead of its dividends. Some firms don’t pay dividends, or
their dividends are difficult to forecast. For that reason, some
analysts use the corporate valuation model.
Tropetech Inc. has an expected net...

You have been assigned the task of using the corporate, or free
cash flow, model to estimate Petry Corporation's intrinsic value.
The firm's WACC is 10.00%, its end-of-year free cash flow (FCF1) is
expected to be $70.0 million, the FCFs are expected to grow at a
constant rate of 5.00% a year in the future, the company has $200
million of long-term debt and preferred stock, and it has 30
million shares of common stock outstanding. What is the firm's...

3. You have been assigned the task of using the corporate, or
free cash flow, model to estimate Petry Corporation's intrinsic
value. The firm's WACC is 10.00%, its end-of-year free cash flow
(FCF1) is expected to be $70.0 million, the FCFs are expected to
grow at a constant rate of 5.00% a year in the future, the company
has $200 million of long-term debt and preferred stock, and it has
30 million shares of common stock outstanding. Assume the firm...

The corporate valuation model, the price-to-earnings (P/E)
multiple approach, and the economic value added (EVA) approach are
some examples of valuation techniques. The corporate valuation
model is similar to the dividend-based valuation that you’ve done
in previous problems, but it focuses on a firm’s free cash flows
(FCFs) instead of its dividends. Some firms don’t pay dividends, or
their dividends are difficult to forecast. For that reason, some
analysts use the corporate valuation model.
Charles Underwood Agency Inc. has an...

CORPORATE VALUATION
Scampini Technologies is expected to generate $150 million in
free cash flow next year, and FCF is expected to grow at a constant
rate of 7% per year indefinitely. Scampini has no debt or preferred
stock, and its WACC is 13%. If Scampini has 65 million shares of
stock outstanding, what is the stock's value per share? Round your
answer to two decimal places.
Each share of common stock is worth $ ____, according to the
corporate valuation...

Using the free cash flow valuation model to price an
IPO - Personal Finance Problem
Assume that you have an opportunity to buy the stock of
CoolTech, Inc., an IPO being offered for $7.69 per share. Although
you are very much interested in owning the company, you are
concerned about whether it is fairly priced. To determine the value
of the shares, you have decided to apply the free cash flow
valuation model to the firm's financial data that you've...

11. More on the corporate valuation model
Galaxy Corp. is expected to generate a free cash flow (FCF) of
$14,415.00 million this year (FCF₁ = $14,415.00 million), and the
FCF is expected to grow at a rate of 26.20% over the following two
years (FCF₂ and FCF₃). After the third year, however, the FCF is
expected to grow at a constant rate of 4.26% per year, which will
last forever (FCF₄). Assume the firm has no nonoperating assets. If
Galaxy...

Scampini Technologies is expected to generate $50 million in
free cash flow next year, and FCF is expected to grow at a constant
rate of 6% per year indefinitely. Scampini has no debt or preferred
stock, and its WACC is 11%. If Scampini has 45 million shares of
stock outstanding, what is the stock's value per share? Round your
answer to two decimal places.
Each share of common stock is worth $____ , according to the
corporate valuation model.

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 31 minutes ago

asked 42 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 3 hours ago