Firm Valuation Exercise I

Using the assumptions below, project HPs free cash flow (FCF) for each of the next three years: Sales will increase over the next three years at an annual rate of 10.5 percent. Cost of sales for fiscal 20X1 will be 66.5 percent. The ratio of cost of sales to sales is expected to decrease by 0.25 percentage points for each year 20X2 and 20X3. Selling, general, and administrative expenses (SG&A) will be 20.2 percent of sales for fiscal 20X1; 20.5 percent for 20X2; and 20.6 percent for 20X3. Depreciation expense will be forecasted over the next three years using the historical relation to sales. Capital expenditures will be forecasted over the next three years using the historical relation to sales. Net working capital will be forecasted over the next three years using the historical relation to sales. The tax rate is 37%. Free cash flow (FCF) beyond year 3 will grow at 4.0 percent forever. WACC is 9.5 percent.

Consolidated Statement of Earnings, Consolidated Balance Sheet,(in millions),(in millions),Fiscal year ended,12/31/20X0 12/31/20X0 Assets Net sales $81,511 Cash and equivalents $793 Cost of sales 54,191 Short-term Investments 14 Gross profit 27,320 Accounts receivable 2,396 Selling, general & adm. expenses 16,485 Inventory 11,401 Depreciation & amortization 1,472 Other current assets 742 EBIT 9,363 Total current assets 15,346 Interest expense, net 81 Net property & equipment 24,901 EBT 9,282 Other long-term assets 4,235 Income tax expense 3,444 Total Assets $44,482 Net Income $5,838 Liabilities & Shareholders' Equity Accounts payable $6,032 Accrued expenses 2,823 Taxes payable 876 Deferred revenue 1,757 Other current liabilities 1,413 Total current liabilities 12,901 Long-term debt 2,672 Other non-current liabilities 2,000 Total Liabilities $17,573 Common stock 120 Paid-in capital 7,287 Retained earnings 28,943 Treasury stock (9,712) Other 271 Total Shareholders' Equity $26,909 Total Liabilities & Shareholders' equity $44,482 Capital Expenditures = $3,881