Project Coca-Cola

The second interim report should build on the first interim report and also include #6, 7, 8, and 9 detailed on the syllabus:

6. Perform common size analysis. What does this analysis tell you about your company? Are there any trends apparent with either the industry or your firm?

7. Use the extended DuPont equation to provide a summary and overview of your firm’s financial condition.

8. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the CAPM method.

9. What do you estimate the company’s WACC?

Be sure to do all calculations for 3 years, using Excel. Use real numbers from the financials, not reported ratios provided by online and other sources. Show the source of the numbers. See the syllabus for complete details of the project.