This week’s activity illustrates the role trend analysis plays in evaluating performance within an industry.
– 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.
Scenario: Attached you will find 10-k reports for Starbucks and Dunkin Donuts.
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.