# Trend analysis | Accounting homework help

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.

The post Trend analysis | Accounting homework help appeared first on nursing writers.