Coca-Colamini-Case

Coca-Colamini-case

Projected financial statements

Prospective analysis is the final step in the financial statement analysis process. It can only be undertaken once the historical financial statements have been properly adjusted to accurately reflect the economic performance of the company. As we will discuss in this course, these adjustments may include, for example, eliminating transitory items in the income statement or reallocating them to past or future years, capitalizing (expensing) items that have been expensed (capitalized) by management, capitalizing operating leases and other forms of off-balance sheet financing, and so forth. Prospective analysis includes forecasting of the balance sheet, income statement and statement of cash flows.

Prospective analysis is central to security valuation. Both the free cash flow and residual income valuation models require estimates of future financial statements. The residual income model, for example, requires projections of future net profits and book values of equity in order to estimate current stock price. Prospective analysis is also useful to examine the viability of companies’ strategic plans. For this, we analyze whether a company will be able to generate sufficient cash flows from operations to finance expected growth or whether it will be required to seek debt or equity financing in the future. We are also interested in analyzing whether current strategic plans will yield expected benefits. And finally, prospective analysis is useful to creditors to assess a company’s ability to meet its debt service requirements.

Assignment:

Read WSH chapter 10 on projections.
Download the Coca-Cola data set (KO 10Y 10-K.xls). Using this data, and the projection assumptions provided below, prepare a forecasted income statement and balance sheet for 2004.

Projection assumptions:

Sales growth...... / 7.56%
Gross profit margin...... / 63.1%
Selling, general & administrative expense/ Sales...... / 31.5%
NOPAT/ Sales...... / 21.8%
Depreciation rate (Depreciation expense/ Prior year gross PP&E)...... / 9.4%
Interest rate (Interest expense/ Prior year long-term debt)...... / 2.3%
Tax rate (Income tax/ Pretax income)...... / 20.9%
Cash dividend per share...... / $0.89
Asset turnover—ATO (Sales/ Average net operating assets)...... / 1.01
Accounts receivable turnover—ART (Sales/ Average accounts receivable)... / 10.05
Days sales outstanding—DSO...... / 36.32
Inventory turnover—INVT (COGS/ Average inventory)...... / 6.10
Days inventory outstanding...... / 59.86
PP&E turnover—PAT (Sales/ Average PP&E)...... / 1.17
Accounts payable turnover—APT (COGS/ Average accounts payable)..... / 2.00
Days payables outstanding...... / 182.22
Working capital turnover—WCT (Sales/ Net operating working capital).... / 7.16
Capital expenditures/ Sales...... / 3.4%
Taxes paid rate (Tax payable/ Tax expense)...... / 0.80