Trend Analysis in accounting

Assignment Content

  1. Purpose of Assignment 
    This week’s activity illustrates the role trend analysis plays in evaluating performance within an industry.

    Resources 

    – Generally Accepted Accounting Principles (GAAP), U.S. Securities and Exchange Commission (SEC)

    -Tutorial help on Excel and Word functions can be found on the Microsoft Office website. There are also additional tutorials in week 1 of class.

    Assignment Steps

    Scenario: Attached you will find 10-k reports for Starbucks and Dunkin Donuts.

    https://s22.q4cdn.com/869488222/files/doc_financials/2019/2019-Annual-Report.pdf
    https://s22.q4cdn.com/869488222/files/doc_financials/annual/2017/01/FY17-Starbucks-Form-10-K.pdf

    and

    http://investor.dunkinbrands.com/static-files/7a80a22d-8895-4d5d-b625-603b127cb27f
    http://investor.dunkinbrands.com/static-files/797ff4b1-73b5-42ae-8fd1-473b938ad3ed

    dachshund inc income statement.xlsx

    You are the CFO for Dachshund Coffee Company. The company has been operating for 3 years. President Kessel wants to see how our sales and net income compare to the industry.

    FIRST Prepare in Excel: A horizontal analysis of total net revenues from the Consolidated Statement of income for 5 years for both companies. All calculations must be performed in the cells.

    SECOND Prepare in Excel: A horizontal analysis of net earnings from the Consolidated Statement of income for 5 years for both companies(look for the double lines under it). All calculations must be performed in the cells.

    THIRD Prepare in Excel: A horizontal analysis of net revenues and net income for 3 years for Dachshund Coffee. All calculations must be performed in the cells.

    Prepare a memo in a maximum 500 words using business writing including the following information:

    –         What pages in the statements (found on bottom of page) contain the Income Statement and Balance Sheet for Starbucks and Dunkin Donuts?

    –         Based on the results of your analysis of all 3 companies, how is Dachshund Coffee doing?

    Use the memo template provided in week 1 for formatting. ONLY use APA for citations and references. Please use the FREE citation and reference generator in the library.

    Submit your memo as a word document.

    Submit your excel spreadsheet as a separate submission.Do not embed it-I need to see your calculations in the cells. Please make sure your documents can be opened and are correctly attached.

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"
[promo2]