INSTRUCTIONS:
or Book access: The book is Horngren’s accounting 12th edition. If you have it great if not here are steps to access my copy. go to student.ashford.edu Login info: JUVEDD6486 Cheyanne10 once in go to modules and under week 2 you will see resources click on it. once there you will see a place to click for the book. You will use these files which will be in the file section. ACC 206 Final Paper Breakeven Chart.xls ACC 206 Final Paper Cash Flow.xls ACC 206 Final Paper CGS.xls Your paper should consist of the following sections: Cash flow Statement, Manufacturing Costs, Cost-Volume-Profit-Analysis, Horizontal and Vertical Analysis, and Ratios. Use two scholarly/peer-reviewed and/or credible sources in addition to the course text to support your analyses. Here is a breakdown of the sections within the body of the assignment: Cash Flow Statement From the data in the file ACC 206 Final Paper Cash Flow.xls complete a Cash Flow Statement. Use the column that corresponds to your course. For example, if your course stated May 22, you would use the data from the May–June column. My course started Aug18 Manufacturing Costs From the data in this file 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. (See pages 974 through 975 in the text) Use the column that corresponds to your course. For example, if your course stated May 22, you would use the data from the May–June column. My course started Aug18 Cost-Volume-Profit Analysis Last week you should have prepared a break-even chart for submission with this final paper. If you still need to complete it, here are the instructions. First, watch the video tutorial, Final Paper Break-Even Chart video that walks you through the steps. Next, download the Excel file, ACC 206 Final Paper Breakeven Chart.xls that includes the data you will use to complete the break-even chart. 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 (Links to an external site.) 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. The Company Analysis Final Paper Must be five to seven double-spaced pages in length (not including title and references pages) and formatted according to APA style Must include a separate title page with the following: Title of paper Student’s name Course name and number Instructor’s name Date submitted