Trend Analysis in accounting
Assignment Content
- 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.pdfand
http://investor.dunkinbrands.com/static-files/7a80a22d-8895-4d5d-b625-603b127cb27f
http://investor.dunkinbrands.com/static-files/797ff4b1-73b5-42ae-8fd1-473b938ad3eddachshund 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? Get Expert Help at an Amazing Discount!”

The post Trend Analysis in accounting appeared first on Nursing Experts Help.


