Part 1: Make two simple assumption changes:

Base year revenue is $2.0 billion in 2006 (as compared to $2.5 billion in the Book and Lecture).

The maturity growth rate is 7%, rather than 6%.

Please recreate the Free Cash Flow, Terminal Value and Total Enterprise Value tables and fill in numbers based on these assumption changes.

You should use Excel for the calculations. Then copy and paste that to Word. Please Paste Special and select Microsoft Excel Worksheet Object.

Part 2: Discuss some of the benefits and disadvantages of using the Discounted Cash Flow valuation method.

CASE STUDY APPLYING THE DISCOUNTED CASH FLOW METHOD OF BUSINESS VALUATION This case study applies the discounted cash flow method of business valuation to a company that has $2.5 billion in sales in 2006. Sales are expected to grow at declining rates of growth over the next five years from 10% in 2007 to a maturity growth rate of 6% (g) after the fifth year. For the purposes of this simple example we define free cash flow as the difference between net operating ncome after tax (NOPAT) and new net capital expenditures: NOPAT Earnings before Interest &Taxes (EBIT)(1 tax rate) NOPAT-New net capital expenditures FCF The discount rate is taken to be the weighted average costs of capital for the company, which this case study assumes is 12% (r). The capitalization rate that is used to compute the terminal value f the company after year 5 is the difference between this rate and the long-term growth rate WACC = r = 12% and k = Capitalization rate = r-g = 12%-6% 6% The enterprise value of the company is the present value of its future projected cash flows. This value is computed as the sum of the present value of the individually projected cash flows for the first five years and the capitalized terminal value. This value is computed as follows: Terminal value FCFo/r-g) It is important to remember that this terminal value is itself a year 5 value because it is the value of the company's cash flows that are projected to be received after year 5. Therefore, it must be brought to present value by dividing it by the PVIF applicable to year 5 or 1/1.12) Valuation Equation: FCF1 FCF2 FCFs FCFe/(r -g) Assumptions: Sales Growth: Growth at 10% per year declining by 5 and 6% thereafter Shares outstanding (mil): 40