You will use three documents to complete this assignment: 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...

1 answer below »

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 fileACC 206 Final Paper Cash Flow.xlscomplete 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.









Manufacturing Costs





From the data in this fileACC 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.









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 Chartvideo

Play media comment.that walks you through the steps.





Next, download the Excel file,ACC 206 Final Paper Breakeven Chart.xlsthat 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.)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.)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 as outlined in the Ashford Writing Center’sAPA Style(Links to an external site.)Links to an external site.

  • Must include a separate title page with the following:

    • Title of paper

    • Student’s name

    • Course name and number

    • Instructor’s name

    • Date submitted







For further assistance with the formatting and the title page, refer toAPA Formatting for Word 2013(Links to an external site.)Links to an external site..






Carefully review theGrading Rubric(Links to an external site.)Links to an external site.for the criteria that will be used to evaluate your assignment.

http://investor.cokeconsolidated.com/static-files/e04a4211-5283-4ffe-923c-a87703dcaa31
This is a website for Coke company
Answered Same DayMar 17, 2021

Answer To: You will use three documents to complete this assignment: ACC 206 Final Paper Breakeven Chart.xls...

Aarti J answered on Mar 18 2021
153 Votes
Accounting Final paper
Financial Analysis of Coca Cola
Course Name
Course Date
Student’s Name
Financial analysis – Coca Cola
Introduction
Coca Cola is one of the biggest beverages company, The company caters to non-alcoholic beverages which includes the sprinkle soft drinks, sports and water drinks, juices, tea and coffee and other energy drinks. The company has its
operations across the globe and has different operating segments.
In this paper, we have done the financial analysis of the company for the year 2016 and 2017. We have emphasized on different forms of financial analysis which includes the horizontal analysis, vertical analysis and ratio analysis.
Horizontal Analysis:
In the horizontal analysis, the company analyse its income statement and the balance sheet as comparison from the pervious year.
Horizontal analysis – Income Statement:
    THE COCA-COLA COMPANY AND SUBSIDIARIES
    
    
    
    
    CONSOLIDATED STATEMENTS OF INCOME
    
    
    
    
    Year Ended December 31,
    2017
    
    2016
    
    %
    (In millions except per share data)
    
    
    
    
    
    NET OPERATING REVENUES
     $ 35,410
    
     $ 41,863
    
    -15.41%
    Cost of goods sold
    13,256
    
    16,465
    
    -19.49%
    GROSS PROFIT
    22,154
    
    25,398
    
    -12.77%
    Selling, general and administrative expenses
    12,496
    
    15,262
    
    -18.12%
    Other operating charges
    2,157
    
    1,510
    
    42.85%
    OPERATING INCOME
    7,501
    
    8,626
    
    -13.04%
    Interest income
    677
    
    642
    
    5.45%
    Interest expense
    841
    
    733
    
    14.73%
    Equity income (loss) – net
    1,071
    
    835
    
    28.26%
    Other income (loss) – net
    -1,666
    
    -1,234
    
    35.01%
    INCOME FROM CONTINUING OPERATIONS BEFORE INCOME
    
    
    
    
    
    TAXES
    6,742
    
    8,136
    
    -17.13%
    Income taxes from continuing operations
    5,560
    
    1,586
    
    250.57%
    NET INCOME FROM CONTINUING OPERATIONS
    1,182
    
    6,550
    
    -81.95%
    Income from discontinued operations (net of
    
    
    
    
    
    income taxes of $47, $0 and $0, respectively)
    101
    
     -
    
    
    CONSOLIDATED NET INCOME
    1,283
    
    6,550
    
    -80.41%
    Less: Net income attributable to noncontrolling
    
    
    
    
    
    Interests
    35
    
    23
    
    52.17%
    NET INCOME ATTRIBUTABLE TO SHAREOWNERS OF
    
    
    
    
    
    THE COCA-COLA COMPANY
     $ 1,248
    
     $ 6,527
    
    -80.88%
Looking at the operations of the company, we can see the company’s performance for the year 2017 was weaker as compared to the year 2016. The company’s profits has decreased, as there is a decrease in the revenues, and overall profitability of the company. The revenues of the company decreased by 15.41% along with the decrease in few expenses. Spme expenses increased like other operating charges, which led to decrease in the net income. The net income for the year decreased by 80.88% in 2017 as compared to 2017.
Horizontal analysis: - Balance Sheet:
    THE COCA-COLA COMPANY AND SUBSIDIARIES
    
    
    
    CONSOLIDATED BALANCE SHEETS
    
    
    
    December 31,
    2017
    2016
    %
    (In millions except par value)
    
    
    
    ASSETS
    
    
    
    CURRENT ASSETS
    
    
    
    Cash and cash equivalents
     $ 6,006
     $ 8,555
    -29.80%
    Short-term investments
    9,352
    9,595
    -2.53%
    TOTAL CASH, CASH EQUIVALENTS AND SHORT-TERM INVESTMENTS
    15,358
    18,150
    -15.38%
    Marketable securities
    5,317
    4,051
    31.25%
    Trade accounts receivable, less allowances of $477 and $466,
    
    
    
    Respectively
    3,667
    3,856
    -4.90%
    Inventories
    2,655
    2,675
    -0.75%
    Prepaid expenses and other assets
    2,000
    2,481
    -19.39%
    Assets held for sale
    219
    2,797
    -92.17%
    Assets held for sale - discontinued operations
    7,329
     -
    
    TOTAL CURRENT ASSETS
    36,545
    34,010
    7.45%
    EQUITY METHOD...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here