DATE: November 29, 2012
RE: Valuing Kraft
Through the use of historical sales, growth rate, and capital structure data for Kraft Foods, Inc. we were able to estimate a current valuation of the company. Furthermore, by projecting historical data out to predict future cash flows, we were able to fairly value Kraft Foods.
Process Steps
1. Estimate the WACC for Kraft
2. Calculate historic growth rate
3. Calculate the average income tax rate and determine the relationship between sales and cost of sales, capital expenditures, depreciation, and net working capital
4. Determine the sales growth rate required to meet Kraft’s 2016 sales projections
5. Project 5-year cash flows starting in 2012 and ending in 2016
6. Discount cash flow projections beyond 2016 at the WACC rate to estimate the projected firm value in 2016
7. Discount cash flow projections from 2012 to 2016 at the WACC rate to estimate the fair firm value today, and add the present value of the cash flows beyond 2016, to estimate the value of the firm
8. Calculate Kraft’s capital structure to better understand this valuation
9. Determine the current fair share price
Estimating the WACC
In order to calculate the WACC, we used the following figures:
Cost of equity: 5.5155%
Cost of debt: 4.31%
Percentage of equity financing: 0.667
Percentage of debt financing: 0.333
Corporate tax rate: 28%
Plugging these figures into the WACC formula, we were able to determine a weighted average cost of capital of 4.711%.
Calculating the Historic Growth Rate
To calculate the historic growth rate, we averaged the growth rate from the past 10 years. This yielded us an average historic growth rate of 7.212%.
Average Income Tax Rate
The average income tax rate for the past 10 years was determined to be 30.64%.
Next, the the relationship between sales and cost of sales, capital expenditures, depreciation, and net working capital are presented in the following table: