ATTACHED ARE RESOURCES THAT MUST BE USED NO EXCEPTIONS.
ATTACHED IS BREAK EVEN CHART AND OTHER EXCEL SPREADSHEETS THAT MUST BE USED.
PLEASE READ INSTRUCTIONS CAREFULLY AND THOROUGHLY. PAPER MUST BE 5 TO 7 PAGES.
PLEASE ADDRESS AND ANSWER ALL PARTS TO PAPER
You will use three documents to complete this assignment:
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.
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.
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.
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:
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
For further assistance with the formatting and the title page, refer to APA Formatting for Word 2013(Links to an external site.).
Carefully review theGrading Rubric(Links to an external site.)for the criteria that will be used to evaluate your assignment.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more