Question

I was just wondering how the present value of future cash flows and discount at 10%...

I was just wondering how the present value of future cash flows and discount at 10% columns were calculated in this problem:

At the end of 2012, you forecast the following cash flows (in millions) for a firm with net debt of $759 million:

2013

2014

2015

Cash flow from operations

$1,450

$1,576

$1,718

Cash investment

1,020

1,124

1,200

You forecast that free cash flow will grow at a rate of 4 percent per year after 2015. Use a required rate of return of 10 percent in answering the following two questions:

  1. The firm’s enterprise value (in millions) at the end of 2012 is equal to:
  2. The firm’s equity value (in millions) at the end of 2012 is equal to:
Free cash flow = Cash flow from operation - Capital expenditure
Calculation of free cash flow
2013 2014 2015 Terminal value
Cash flow from operations $1,450 $1,576 $1,718
Cash investment $1,020 $1,124 $1,200
Free cash flow $430 $452 $518 $539 (518*1.04)
Discount factor @10% 0.909091 0.826446 0.751315
Present value of free cash flow $391 $374 $389
Sum of present value of free cash flow $1,154
Present value of terminal value [(539/(0.10-0.04)]/(1.10^3) $6,746
Enterprise Value $7,900
Less: Value of debt -759
Equity Value of firm $7,141
Firm's enterpise value at the end of 2012 is equal to $7,900 million
Firm's equity value at the end of 2012 is equal to $7,141 million

Homework Answers

Answer #1
Discount factor is calculated by above formula
1 / (1 + i)^n
(i) is discount rate = 10%
n = period like 1, 2, 3
So, Discount factor for 1st period = 1 / (1+0.10)^1 = 0.909091
for second period = 1 / (1 + 0.10)^2 = 0.826446
for third period = 1 / (1+0.10)^3 = 0.751315
Present value of free cash flow is calculated by multiplying discount factor value with future value.
year 2013 = 430 * 0.909091 = 391
Year 2014 = 452 * 0.826446 = 374
Year 2015 = 518 * 0.751315 389
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The following is a five year forecast for the company Free Cash Flow (in millions) 2010:...
The following is a five year forecast for the company Free Cash Flow (in millions) 2010: -10 2011: 5 2012: 20 2013: 40 2014: 60 After 2014, earnings before interest and tax will remain constant at $69 million, depreciation will equal capital expenditures each year, and working capital will increase by $2 million. The company's WACC is 12.9% and its tax rate is 12%. Estimate the market value of the company at the end of 2009. Please show work
Horizon Value Current and projected free cash flows for Radell Global Operations are shown below. Actual...
Horizon Value Current and projected free cash flows for Radell Global Operations are shown below. Actual 2013 2014 Projected 2015 2016 Free cash flow $606.96 $667.64 $707.69 $764.31 (millions of dollars) Growth is expected to be constant after 2015, and the weighted average cost of capital is 10.4%. What is the horizon (continuing) value at 2016 if growth from 2015 remains constant? Round your answer to the nearest dollar. Round intermediate calculations to two decimal places.
Horizon Value Current and projected free cash flows for Radell Global Operations are shown below. Actual...
Horizon Value Current and projected free cash flows for Radell Global Operations are shown below. Actual 2013 2014 Projected 2015 2016 Free cash flow $616.04 $676.72 $716.77 $766.94 (millions of dollars) Growth is expected to be constant after 2015, and the weighted average cost of capital is 12%. What is the horizon (continuing) value at 2016 if growth from 2015 remains constant? Round your answer to the nearest dollar. Round intermediate calculations to two decimal places.
IDX Technologies is a privately held developer of advanced security systems based in Chicago. As part...
IDX Technologies is a privately held developer of advanced security systems based in Chicago. As part of your business development strategy, in late 2013 you initiate discussions with IDX's founder about the possibility of acquiring the business at the end of 2013. Estimate the value of IDX per share using a discounted FCF approach and the following data: • Debt: $ 35 million • Excess cash: $ 111 million • Shares outstanding: 50 million • Expected FCF in 2014: $...
Estimating Share Value Using the DCF Model Following are forecasts of Abercrombie & Fitch's sales, net...
Estimating Share Value Using the DCF Model Following are forecasts of Abercrombie & Fitch's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 29, 2011. (Current-year NOPAT is lower due to transitory items; we use a longer term estimate for NOPM of 8%.) Reported Horizon Period (In millions) 2011 2012 2013 2014 2015 Terminal Period Sales $ 3,469 $ 3,989 $ 4,587 $ 5,275 $ 6,066 $ 6,187 NOPAT 152 319 367 422 485...
You forecast the free cash flows for your target firm over the next five years. The...
You forecast the free cash flows for your target firm over the next five years. The final cash flow, at the end of year five, is projected to be $200 million. Assuming a FCF terminal growth rate of 3% and an overall discount rate of 12%, what is the present valueof all future cash flows after the planning period? (Hint: do not forget to discount to today.)
Estimating Share Value Using the ROPI Model The following are forecasts of Abercrombie & Fitch's sales,...
Estimating Share Value Using the ROPI Model The following are forecasts of Abercrombie & Fitch's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 29, 2011. Refer to the information in the table to answer the following requirements. Reported Horizon Period (In millions) 2011 2012 2013 2014 2015 Terminal Period Sales $ 3,469 $ 3,989 $ 4,587 $ 5,275 $ 6,066 $ 6,187 NOPAT 152 319 367 422 485 495 NOA 1,032 1,173 1,349...
The table below shows the projected free cash flows of an acquisition target. The discount rate...
The table below shows the projected free cash flows of an acquisition target. The discount rate to value the target is 9% discount rate. The acquiring company expects the terminal period to begin at the end of 2022 with a perpetual growth rate of 4% from that point on. YEAR 2018 (Year 0) 2019 (Year 1) 2020 (Year 2) 2021 (Year 3) 2022 (Year 4) FREE CASH FLOW ($ thousands) -$120 $82 $92 $99 $101 The Present Value of $1...
The table below shows the projected free cash flows of an acquisition target. The discount rate...
The table below shows the projected free cash flows of an acquisition target. The discount rate to value the target is 11% discount rate. The acquiring company expects the terminal period to begin at the end of 2022 with a perpetual growth rate of 3% from that point on. YEAR 2018 (Year 0) 2019 (Year 1) 2020 (Year 2) 2021 (Year 3) 2022 (Year 4) FREE CASH FLOW ($ thousands) -$263 $68 $87 $89 $92 The Present Value of $1...
The table below shows the projected free cash flows of an acquisition target. The discount rate...
The table below shows the projected free cash flows of an acquisition target. The discount rate to value the target is 9% discount rate. The acquiring company expects the terminal period to begin at the end of 2022 with a perpetual growth rate of 3% from that point on. YEAR 2018 (Year 0) 2019 (Year 1) 2020 (Year 2) 2021 (Year 3) 2022 (Year 4) FREE CASH FLOW ($ thousands) -$171 $56 $72 $87 $92 The Present Value of $1...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT