Description
Must be five to seven double-spaced pages in length.
Must include a separate title page with the following:
Title of paper
Student’s name
Course name and number
Instructor’s name
Date submitted
Must utilize academic voice. Must include an introduction and conclusion paragraph. Your introduction paragraph needs to end with a clear thesis statement that indicates the purpose of your paper.
Your paper should consist of the following sections: Cash flow Statement, Manufacturing Costs, Cost-Volume-Profit-Analysis, Horizontal and Vertical Analysis, and Ratios.
From the data in the file ACC 206 Final Paper Cash Flow.xls..complete a Cash Flow Statement. Use the column that is marked Sep-Oct
Manufacturing Costs
From the data in this file ACC 206 Final Paper CGS.xls Download ACC 206 Final Paper CGS.xls , complete a Schedule of Cost of Goods Manufactured and a Manufacturing Company Income statement. Use the Cost of Goods Manufactured that was developed in the Schedule of Cost of Goods Statement in the income statement. Use the column that is marked Sep-Oct
Next, download the Excel file, ACC 206 Final Paper Breakeven Chart.xls Download ACC 206 Final Paper Breakeven Chart.xls that includes the data you will use to complete the break-even chart. prepare and Submit the break-even chart as part of your final assignment.
Horizontal and Vertical Analysis
Using the data from the Coca-Cola 2017 Annual Report (Links to an external site.) financial statements, starting on page 60, prepare a horizontal analysis for the balance sheet for a 2-year period and a vertical analysis for the income statement for a 2-year period. Submit the company financial statements with your analysis. The analysis must show all formula calculations to support your results.
Ratio Analysis
Using the data from the Coca-Cola 2017 Annual Report ( financial statements, starting on page 60, calculate the following ratios:
Common Stockholders Equity Ratio
Profit Margin Ratio
Cash Ratio
Debt to Equity Ratio
Debt Ratio
Explain how the ratio is calculated and discuss and interpret the ratios that you calculated. Submit a screenshot of the company financial statements as an appendix. The analysis must show all formula calculations to support your results.
