Case study on Coca Cola

Prepare Financial Forecast Using eVal Excel Model

. Make sure that eVal financial data are available for the company (See: http://www.lundholmandandsloan.com)

The analysis needs to include:

1. Explanation of Growth Rates - Include an explanation about growth rate projections for the company. (Note: it is difficult to justify long-term growth rates that exceed the growth rate of the economy.)

2. Explanation of All Other Assumptions - Include an explanation of all other assumptions related to future operating performance including costs, margins, efficiency, capitalization, etc. Note: All assumptions used in the forecast need to be explained in the written analysis. A worksheet is provided for this analysis and it should be incorporated as a table in the written analysis.

3. Explanation and Interpretation of Projected Financial Statements - Explanation and interpretation of the projected financial statements anddiscounted free cash flows to include pro forma financial statements (income statements, balance sheets, and statements of cash flows).

4. Explanation and Interpretation of Overall Forecast Results - Examination and interpretation of the overall forecast results and the projected financial ratio analysis.