Question
DO BY HAND AND ON EXCEL A project has expected cash flows of $55 next year...
DO BY HAND AND ON EXCEL
-
A project has expected cash flows of $55 next year (year 1). These cash flows will grow at 6% per year through year 6. Growth from year 6 to 7 will be -2%, and this negative growth will continue in perpetuity. Assume a discount rate of 8%. What is the present value today (year 0) of these cash flows? (For this problem, feel free to use Excel, or you can do this by hand using annuity and perpetuity formulas. However, you should be comfortable doing this type of problem either way. If you’re not, I encourage you to do it both ways.)
Homework Answers
Answer #1
EXCEL FORMULA:
Not the answer you're looking for?
Similar Questions
HAND CALCULATIONS ONLY. NO EXCEL Pepsico’s most recent dividend was $1. The dividend next year is...
HAND CALCULATIONS ONLY. NO EXCEL
Pepsico’s most recent dividend was $1.
The dividend next year is expected to increase 10%. The dividend is
expected to continue growing at 10% for two addition years after
that. After these three years of strong growth, the stock is then
expected to grow at a constant 4% thereafter. Calculate the
intrinsic value using the multi-stage dividend discount model.
Pepsico’s required rate of return is 8%.
Industrial Bruin Lights is expected to have $12 millions in free cash flows next year. The...
Industrial Bruin Lights is expected to have $12 millions in free
cash flows next year. The growth rate of free cash flows is
expected to be 14% in the following year, 12% in the year after
that, and continue declining by 2% until it reaches 6%, where it is
expected to remain indefinitely. The firm has no debt, and there
are 6 million shares outstanding. Investors require 15% return on
the company stock. The tax rate is 40%. What is...
Industrial Bruin Lights is expected to have $33 millions in free cash flows next year. The...
Industrial Bruin Lights is expected to have $33 millions in free
cash flows next year. The growth rate of free cash flows is
expected to be 14% in the following year, 12% in the year after
that, and continue declining by 2% until it reaches 6%, where it is
expected to remain indefinitely. The firm has no debt, and there
are 6 million shares outstanding. Investors require 15% return on
the company stock. The tax rate is 40%. What is...
Use Excel and the text to calculate the present value of a series of cash flows...
Use Excel and the text to calculate the present value of a
series of cash flows if you put $3,500 into a fund at the end of
the year for 10 years at 6%, but you won’t start depositing money
for 10 years, i.e., will defer your annuity for 10 years? Be
prepared to describe how you calculated your answer. Use the two
step approach that subtracts values in your Excel work because
calculating factors is more difficult in Excel
You are valuing a company with free cash flows expected to grow at a stable 2.0%...
You are valuing a company with free cash flows expected to grow
at a stable 2.0% rate in perpetuity. Analysts are forecasting free
cash flows of $36 million for next year (FCFF1). The company has
$33 million of debt and $6 million of cash. Cost of capital is
12.6%. There are 15 million shares outstanding. How much is each
share worth according to your valuation? Round to one decimal
place.
Expected Net Cash Flows &n
Expected Net Cash Flows
Year Project
T Project
F
0
($100,000)
($100,000)
1
75,000
40,000
2
65,000
42,000
3
—
44,000
4
—
46,000
The projects provide a necessary service, so whichever one is
selected is expected to be repeated into the foreseeable future.
Both projects have a 12% cost of capital.
a. What is each project’s initial NPV without
replication?
b. What is each project’s equivalent annual
annuity?
c. Suppose you replicate Project T so...
1. A company is projected to generate free cash flows of $159 million next year and...
1. A company is projected to generate free cash flows of $159
million next year and $204 million at the end of year 2, after
which it is projected grow at a steady rate in perpetuity. The
company's cost of capital is 9.7%. It has $171 million worth of
debt and $51 million of cash. There are 27 million shares
outstanding. If the exit multiple for this company's free cash
flows (EV/FCFF) is 5.1, what's your estimate of the company's...
Assuming cash flows in a year are divisible, what is the payback on the following project?...
Assuming cash flows in a year are divisible, what is the payback
on the following project? Would
you accept the project if your required payback is 3 years? 4
years? Explain.
year
0
1
2
3
4
5
description
Project Cost
Cash Inflow
Cash Inflow
Cash Inflow
Cash Inflow
Cash Inflow
Cash flows
-300,000
77,000
83,000
88,000
92,000
96,000
Do not use Excel!
Sumeet has a 16 year annuity that pays at the end of each year. The first...
Sumeet has a 16 year annuity that pays at the end of each year.
The first payment is $9000 and the payments grow by R = 3% per
year. Interest rates are r = 6% annually.
a) How much is Sumeet's annuity worth? Consider the following
two options:
Option A: An annuity with the same number of payments, only each
payment is twice the payment of his current annuity.
Option B: An annuity where the initial payment is the same...
Heavy Metal Corporation is expected to generate the following free cash flows over the next five...
Heavy Metal Corporation is expected to generate the following
free cash flows over the next five years:
Year
1
2
3
4
5
FCF ($ millions)
53
68
78
75
85
After then, the free cash flows are expected to grow at the
industry average of 4% per year. Using the discounted free cash
flow model and a weighted average cost of capital of 14%:
A. Estimate the geometric mean growth rate (also known as
CAGR=Compound Average Growth Rate) of...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 26 minutes ago
asked 45 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour 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