Question
In: Finance
Today is January 31, 2018. You forecasted the following cash flows (in millions) for a firm:...
Today is January 31, 2018. You forecasted the following cash flows (in millions) for a firm:
|
Cash flow from operations |
|
|
January 31, 2019 |
$4,822.32 |
|
January 31, 2020 |
$5,342.00 |
|
January 31, 2021 |
$4,525.11 |
|
Cash investment in operations |
|
|
January 31, 2019 |
$800.44 |
|
January 31, 2020 |
$913.21 |
|
January 31, 2021 |
$874.14 |
In addition, you are given the following data:
|
Net debt |
|
|
January 31, 2018 |
$342.11 |
and
|
Free cash flow growth after 2021 |
3.00% |
|
Required return |
10.00% |
What is the equity value of the firm (in millions) using Discounted Cash Flow model? Hint: First, calculate the free cash flows and discount the free cash flows. Finally, subtract the net debt to obtain equity value.
|
$46,434.11 |
||
|
$48,111.02 |
||
|
$50,079.02 |
||
|
$52,515.77 |
Solutions
Expert Solution
| Years Ending | ||||||||
| Jan31,2019 | Jan31,2020 | Jan31,2021 | Jan31,2022 | |||||
| N | Years from today(Jan,312018) | 1 | 2 | 3 | 4 | |||
| A | Cash Flow from Operations ($ million) | $4,822.32 | $5,342.00 | $4,525.11 | ||||
| B | Cash Flow for investment ($ million) | ($800.44) | ($913.21) | ($874.14) | ||||
| C=A+B | Free Cash Flow ($ million) | $4,021.88 | $4,428.79 | $3,650.97 | ||||
| D | Expected Free Cah flow in year 4=3650.97*1.03 | $3,760.50 | ||||||
| E=D/(0.1-0.03) | Horizontal Value of the firm in year3 | $53,721.42 | SUM | |||||
| F=C/((1+0.1)^N) | Present Value of Expected Free Cash Flow | 3656.2545 | 3660.15702 | 2743.0278 | 10059.4394 | |||
| G | Net Present Value of Free Cash flows of Year1-3 | 10059.439 | ||||||
| H=E/(1.1^3) | Present Value of Horizontal Value | 40361.695 | ||||||
| I=G+H | Present Value of the firm($ million) | $50,421.13 | ||||||
| J | Present Value of Debt in Jan31.2018 | $342.11 | ||||||
| K=I-J | Equity Value of the firm ($ million) | $50,079.02 | ||||||
| ANSWER: $50,079.02(million) | ||||||||
jeff jeffy answered 1 year agoRelated Solutions
Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018...
Free Cash Flows
Rhodes Corporation: Income Statements for Year Ending
December 31 (Millions of Dollars)
2018
2017
Sales
$3,300.0
$3,000.0
Operating costs excluding depreciation
2,558.0
2,550.0
Depreciation and amortization
73.0
63.0
Earnings before interest and taxes
$669.0
$387.0
Less Interest
71.0
65.0
Pre-tax income
$598.0
$322.0
Taxes (40%)
239.2
128.8
Net income available to common stockholders
$358.8
$193.2
Common dividends
$323.0
$155.0
Rhodes Corporation: Balance Sheets as of December 31
(Millions of Dollars)
2018
2017
Assets
Cash
$49.0
$39.0
Short-term...
Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018...
Free Cash Flows
Rhodes Corporation: Income Statements for Year Ending
December 31 (Millions of Dollars)
2018
2017
Sales
$3,750.0
$3,000.0
Operating costs excluding depreciation
2,813.0
2,550.0
Depreciation and amortization
94.0
78.0
Earnings before interest and taxes
$843.0
$372.0
Less Interest
81.0
65.0
Pre-tax income
$762.0
$307.0
Taxes (40%)
304.8
122.8
Net income available to common stockholders
$457.2
$184.2
Common dividends
$411.0
$147.0
Rhodes Corporation: Balance Sheets as of December 31
(Millions of Dollars)
2018
2017
Assets
Cash
$38.0
$33.0
Short-term...
Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018...
Free Cash Flows
Rhodes Corporation: Income Statements for Year Ending
December 31 (Millions of Dollars)
2018
2017
Sales
$9,200.0
$8,000.0
Operating costs excluding depreciation
6,900.0
6,800.0
Depreciation and amortization
246.0
224.0
Earnings before interest and taxes
$2,054.0
$976.0
Less Interest
198.0
172.0
Pre-tax income
$1,856.0
$804.0
Taxes (40%)
742.4
321.6
Net income available to common stockholders
$1,113.6
$482.4
Common dividends
$1,002.0
$386.0
Rhodes Corporation: Balance Sheets as of December 31
(Millions of Dollars)
2018
2017
Assets
Cash
$146.0
$112.0
Short-term...
Free Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018...
Free Cash Flows
Rhodes Corporation: Income Statements for Year Ending
December 31 (Millions of Dollars)
2018
2017
Sales
$9,200.0
$8,000.0
Operating costs excluding depreciation
6,900.0
6,800.0
Depreciation and amortization
246.0
224.0
Earnings before interest and taxes
$2,054.0
$976.0
Less Interest
198.0
172.0
Pre-tax income
$1,856.0
$804.0
Taxes (40%)
742.4
321.6
Net income available to common stockholders
$1,113.6
$482.4
Common dividends
$1,002.0
$386.0
Rhodes Corporation: Balance Sheets as of December 31
(Millions of Dollars)
2018
2017
Assets
Cash
$146.0
$112.0
Short-term...
A project has the following forecasted cash flows: Cash Flows ($ thousands) C0 C1 C2 C3...
A project has the following forecasted cash flows:
Cash Flows ($ thousands)
C0
C1
C2
C3
−155
+95
+115
+105
The estimated project beta is 1.51. The market return
rm is 15%, and the risk-free rate
rf is 3%.
a. Estimate the opportunity cost of capital and
the project’s PV (using the same rate to discount each cash flow).
(Do not round intermediate calculations. Enter your cost of
capital answer as a percent and enter your PV answer in thousands....
A project has the following forecasted cash flows: Cash Flows ($ thousands) C0 C1 C2 C3...
A project has the following forecasted cash flows:
Cash Flows ($ thousands)
C0
C1
C2
C3
−125
+67
+85
+75
The estimated project beta is 1.55. The market return
rm is 17%, and the risk-free rate
rf is 7%.
a. Estimate the opportunity cost of capital and
the project’s PV (using the same rate to discount each cash flow).
(Do not round intermediate calculations. Enter your cost of
capital answer as a percent and enter your PV answer in thousands....
A project has the following forecasted cash flows: Cash Flows ($ thousands) C0 C1 C2 C3...
A project has the following forecasted cash flows: Cash Flows ($
thousands) C0 C1 C2 C3 −190 +130 +150 +140 The estimated project
beta is 1.58. The market return rm is 18%, and the risk-free rate
rf is 5%.
a. Estimate the opportunity cost of capital and the project’s PV
(using the same rate to discount each cash flow). (Do not round
intermediate calculations. Enter your cost of capital answer as a
percent and enter your PV answer in thousands....
A project has the following forecasted cash flows: Cash Flows ($ thousands) C0 C1 C2 C3...
A project has the following forecasted cash flows:
Cash Flows ($ thousands)
C0
C1
C2
C3
−125
+67
+85
+75
The estimated project beta is 1.55. The market return
rm is 17%, and the risk-free rate
rf is 7%.
a. Estimate the opportunity cost of capital and
the project’s PV (using the same rate to discount each cash flow).
(Do not round intermediate calculations. Enter your cost of
capital answer as a percent and enter your PV answer in thousands....
The Murdock Corporation Statement of Cash Flows For the Year Ended December 31, 2018 Cash flows...
The Murdock Corporation
Statement of Cash Flows
For the Year Ended December 31, 2018
Cash flows from Operating Activities:
Net Income
$ 50,000
Adjustments to reconcile Net Income to
Net Cash provided by operations
Depreciation Expense
$ 53,000
Gain on Sale of Debt securities
$ (4,500)
Gain on Sale of Equipment
$ 1,000
Increase in Accounts Receivables
$ (11,750)
increase in Inventory
$ (20,000)
Decrease in Prepaid Insurance
$ 500
Decrease in Accounts Payable
$ (72,330)
Decrease in Salaries Payable...
Your firm would like to evaluate a proposed new operating division. You have forecasted cash flows...
Your firm would like to evaluate a proposed new operating
division. You have forecasted cash flows for this division for the
next five years, and have estimated that the cost of capital
is
10%.
You would like to estimate a continuation value. You have made
the following forecasts for the last year of your five-year
forecasting horizon (in millions of dollars):
Year 5
Revenues
$259.5
Operating income
83.8
Net
income
54.5
Free cash flows
102.5
Book value of...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- PUT IN JAVA PROGRAMMING The StockB class: Design a class named StockB that contains the following...
- Draw a DFA for the following ( ∑ = {0,1}): Set of all strings with.
- In the article from Forbes notes that the goal of a leader is not to clone...
- Many people keep time using a 24 hour clock (11 is 11am and 23 is 11pm,...
- UNIX ONLY -- DIFFICULT LAB ASSIGNMENT This is an extremely difficult subject for me. Could you...
- Do you know why your credit card can be refused even though you are profitable?
- The Following Java expression: S/10 * 10 + 10 – S = C Show that this...
ADVERTISEMENT