Allen_Berk_DeMarzo_Problem_9-19_Start
.xlsx
keyboard_arrow_up
School
East Carolina University *
*We aren’t endorsed by this school
Course
6604
Subject
Finance
Date
Feb 20, 2024
Type
xlsx
Pages
4
Uploaded by lexinallen2000
Problem 9-19
Year
1
2
3
FCF (millions)
$53
$68
$78
a.
Estimate the enterprise value of Heavy Metal.
b.
If Heavy Metal has no excess cash, debt of $300 million, and 40 million
Cost of capital
14.00%
Long-run growth rate
4.00%
Year
1
2
3
FCF (millions)
$53.00
$68.00
$78.00
Terminal value (millions)
Total cash flow (millions)
$53.00
$68.00
$78.00
a.
Estimate the enterprise value of Heavy Metal.
Enterprise value (millions)
b.
If Heavy Metal has no excess cash, debt of $300 million, and 40 million
Debt (millions)
$300.00
Complete the steps below using cell references to given data or previous c
is all you need. To copy/paste a formula across a row or down a column, a
reference may be preferred. If a specific Excel function is to be used, the d
not type in numerical data into a cell or function. Instead, make a referen
your computations only in the blue cells highlighted below. In all cases, un
appearance of the data in your formulas, usually the Given Data section.
Heavy Metal Corporation is expected to generate the following free cash flow
After then, the free cash flows are expected to grow at the industry average of
model and a weighted average cost of capital of 14%:
Number of shares (millions)
40 Equity value (millions)
Stock price
Requirements
1.
Start Excel - completed.
2.
3.
4.
5.
6.
7.
Save the workbook. Close the workbook and then exit Excel. Submit th
In cell G19
, by using cell references, calculate the terminal value of the
In cell G20
, by using cell references, calculate the total cash flow for ye
In cell D24
, by using cell references and the function NPV
, calculate th
In cell D31
, by using cell references, calculate the equity value of the co
In cell D32
, by using cell references, calculate the stock price (1 pt.)
.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Year
Amount
$20,000/yr.
35,000/yr.
1-5
6-10
Find the present value of cash flows, assuming that the firm's opportunity cost is 14 percent.
Lütfen birini seçin:
a. $120,820
O b. $131,065
c. $ 14,850
d. $ 19,830
arrow_forward
QUESTION 19
Simkins Renovations Inc. is considering a project that has the following cash flow data. What is the
project's IRR?
Year
Cash flows
A. 28.55%
O B. 24.50%
○ C. 20.88%
O D. 17.63%
○ E. 14.67%
○ F. 11.98%
G. 9.51%
OH. 7.24%
0
-$850
1
2
3
4
$300
$390
$280
$270
arrow_forward
QUESTION 23
Reno Company is considering a project that has the following cash flow data. What is the project's IRR?
Year
Cash flows
O a. 14.05%
O b. 15.61%
OC. 17.34%
O d. 19.27%
O e. 21.20%
0
-$1,050
1
$400
2
$400
3
$400
4
$400
arrow_forward
Q22
arrow_forward
Division
Next Period's
Expected Free
Cash
Flow ($mm)
Asset
Beta
Oil Exploration
1.4
450
Oil Refining
1.1
525
Gas & Convenience Stores
0.8
600
The risk-free rate of interest is 3% and the market risk premium is 5%.
The value of the oil exploration division is closest to:
A. $4500
B. $10,000
C. $7500
O D. $8750
Expected
Growth
Rate
4.0%
2.5%
3.0%
arrow_forward
None
arrow_forward
11:52
Investment Appraisal (Year 2 Column 2...
2 years 8 months
3. An investment has the following cash
flows. What is the ARR?
Year 0
-120,000
Year 1
30,000
Year 2
40,000
60,000
Year 3
Year 4
90,000
90,000
Year 5
38%
36%
32%
35%
4. An investment has the following cash
flows. What is the ARR?
Year 0
-90,000
Year 1
45,000
...
Activity
Chat
Teams
Assignments
More
10
arrow_forward
27
arrow_forward
3 QS 24-1 (Algo) Payback period and equal cash flows LO P1 Park Company is considering an investment of $29,000 that provides net cash flows of $13,400 annually for four years. What is the investment's payback period? Numerator: Initial investment 1 Payback Period Denominator: Annual net cash flow Payback Period Payback period
arrow_forward
еВook
Problem Walk-Through
A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows:
1
2
3
4
5
7
Project A
-$300
-$387
-$193
-$100
$600
$600
$850
-$180
Project B
-$400
$133
$133
$133
$133
$133
$133
$0
arrow_forward
Problem 13: Value of a Mixed Stream
Find the present value of the streams of cash flows shown in the following table. Assume that
the firm's opportunity cost is 12%.
A
B
C
Year
Cash Flow
Year
Cash Flow
Year
1
- $2,000
1
$ 10,000
1-5
Cash Flow
$ 10,000/yr
8,000/yr
2
3,000
2-5
6-10
4,000
6
6,000
8,000
3
4
5
5,000/yr
7,000
arrow_forward
Vd
Subject: acounting
arrow_forward
Exercise 26-3 (Algo) Payback period and unequal cash flows LO P1
Beyer Company is considering buying an asset for $400,000. It is expected to produce the following net cash flows.
Year 2
$80,000
Year
Initial investment
Year 1
Year 2
Year 3
Year 4
Year 5
Total
Year 1
$80,000
Net cash flows
Compute the payback period for this investment.
Note: Cumulative net cash outflows must be entered with a minus sign. Round your Payback Period answer to 2 decimal places.
Net Cash Flows
$
(400,000)
Payback period=>
Year 3
$70,000
Cumulative Cash
Flows
Year 4
$200,000
Year 5
$15,000
arrow_forward
question for my
arrow_forward
E3
arrow_forward
Vinubhai
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Year Amount $20,000/yr. 35,000/yr. 1-5 6-10 Find the present value of cash flows, assuming that the firm's opportunity cost is 14 percent. Lütfen birini seçin: a. $120,820 O b. $131,065 c. $ 14,850 d. $ 19,830arrow_forwardQUESTION 19 Simkins Renovations Inc. is considering a project that has the following cash flow data. What is the project's IRR? Year Cash flows A. 28.55% O B. 24.50% ○ C. 20.88% O D. 17.63% ○ E. 14.67% ○ F. 11.98% G. 9.51% OH. 7.24% 0 -$850 1 2 3 4 $300 $390 $280 $270arrow_forwardQUESTION 23 Reno Company is considering a project that has the following cash flow data. What is the project's IRR? Year Cash flows O a. 14.05% O b. 15.61% OC. 17.34% O d. 19.27% O e. 21.20% 0 -$1,050 1 $400 2 $400 3 $400 4 $400arrow_forward
- Q22arrow_forwardDivision Next Period's Expected Free Cash Flow ($mm) Asset Beta Oil Exploration 1.4 450 Oil Refining 1.1 525 Gas & Convenience Stores 0.8 600 The risk-free rate of interest is 3% and the market risk premium is 5%. The value of the oil exploration division is closest to: A. $4500 B. $10,000 C. $7500 O D. $8750 Expected Growth Rate 4.0% 2.5% 3.0%arrow_forwardNonearrow_forward
- 11:52 Investment Appraisal (Year 2 Column 2... 2 years 8 months 3. An investment has the following cash flows. What is the ARR? Year 0 -120,000 Year 1 30,000 Year 2 40,000 60,000 Year 3 Year 4 90,000 90,000 Year 5 38% 36% 32% 35% 4. An investment has the following cash flows. What is the ARR? Year 0 -90,000 Year 1 45,000 ... Activity Chat Teams Assignments More 10arrow_forward27arrow_forward3 QS 24-1 (Algo) Payback period and equal cash flows LO P1 Park Company is considering an investment of $29,000 that provides net cash flows of $13,400 annually for four years. What is the investment's payback period? Numerator: Initial investment 1 Payback Period Denominator: Annual net cash flow Payback Period Payback periodarrow_forward
- еВook Problem Walk-Through A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 1 2 3 4 5 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$400 $133 $133 $133 $133 $133 $133 $0arrow_forwardProblem 13: Value of a Mixed Stream Find the present value of the streams of cash flows shown in the following table. Assume that the firm's opportunity cost is 12%. A B C Year Cash Flow Year Cash Flow Year 1 - $2,000 1 $ 10,000 1-5 Cash Flow $ 10,000/yr 8,000/yr 2 3,000 2-5 6-10 4,000 6 6,000 8,000 3 4 5 5,000/yr 7,000arrow_forwardVd Subject: acountingarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you