ACC 345 Module Two Assignment Guidelines and Rubric
Overview
Accountants must be familiar with Ønding and interpreting data in a company’s balance sheet and income statement. They will take these documents and create a condensed version showing
multiple years to review changes. It is important for accountants to understand the categories of the balance sheet and income statement, and the types of ratios discussed in the Ønancial
statements. This information is reported to stakeholders by accountants.
Directions
Use Nike’s SEC 2022 10-K Øling in the Supporting Materials section to complete this assignment. There are two parts for this assignment: the condensed Ønancial statements and the summary.
Module Two Workbook Template
In the condensed Ønancial statements part of this assignment, you will use the company’s Securities and Exchange Commission (SEC) 2022 10-K Øling to build a condensed version of the
balance sheet and income statement in the Module Two Workbook Template linked in the What to Submit section. The SEC 2022 10-K Øling will provide three years of income statements and
only two years of balance sheets. You will need to Ønd Nike’s 2020 Form 10-K Øling on the SEC website to pull the 2020 balance sheet to complete the template.
Categories will be different than what you Ønd in the annual report. Use your best judgement when classifying them. If you need to lump certain costs together, then do so. Make certain you
keep accounts in the correct category (i.e., current assets, non-current assets, current liabilities, long term liabilities, and owner’s equity). Each of these sections has an “other” category you can
use. It is important to use the correct categories to have ratios calculate correctly. For example, the company shows cost of sales of $100K, general and administrative (G&A) expenses of $50K,
and marketing expense of $10K. Combine the G&A and marketing expenses in the single line on the income statement called “Sales, General, and Administrative Expenses” in the amount of
$60K.
The template will provide a check digit for the Balance Sheet and Income Statement tabs. It will help with ensuring the Balance Sheet tab is balanced and the Income Statement tab net income
is correct before tax.
In the template, the ratios auto-calculate. You will not need to analyze the Ratio tab for historical data. You will only use the Ratio tab for explanatory purposes to complete the Module Two
Summary Template.
Note: You may choose to complete an assignment using a desktop program instead of SNHU’s virtual desktop (VDI); however, technical support will not be provided by SNHU if you select this
option.
Module Two Summary Template
Complete Module Two Summary Template linked in the What to Submit section.
SpeciØcally, you must address the following rubric criteria:
 
Module Two Workbook Template
1. Prepare the company’s balance sheet accurately and completely on the Balance Sheet tab in the workbook. Include the following detail in your response:
A. Provide all data available from May 31, 2020, to May 31, 2022.
2. Prepare the company’s income statement accurately and completely on the Income Statement tab in the workbook. Include the following details in your response:
A. Provide all data available from May 31, 2020, to May 31, 2022.
Module Two Summary Template
1. DeØne the measurement of each type of ratio and the accounts included in the calculation. Refer to the Ratios tab.
2. Explain the signiØcance of each ratio to the company.
3. Identify an asset or liability being measured at fair value. Include the following details in your response:
1. Provide the speciØc disclosure note(s).
2. Include the citation(s).
4. Provide the classiØcation for the GAAP standard that allows the fair value measurement.
If you need writing support, access the Academic Support module of your course.
What to Submit
Module Two Workbook Template
Submit the Module Two Workbook Template with the following tabs completed: Balance Sheet, Income Statement, Ratios.
Module Two Summary Template
Submit your completed Module Two Summary Template as a 2- to 4-page Microsoft Word document with double spacing, 12-point Times New Roman font, and one-inch margins. Sources
should be cited according to APA style.
Supporting Materials
The following resources support your work on the project:
Website: Nike’s SEC 2022 10-K Filing
This resource provides Nike’s 2022 10-K. Read through the material in Item 8: Financial Statements and Supplementary Data and through the Notes To Consolidated Financial Statements
section. It is not necessary to click on additional links on the website for this assignment.
Website: Nike’s SEC 2021 10-K Filing
This resource provides Nike’s 2021 10-K. Read through the material in Item 8: Financial Statements and Supplementary Data and through the Notes To Consolidated Financial Statements
section. It is not necessary to click on additional links on the website for this assignment.
Website: Generally Accepted Accounting Principles (GAAP)
The resource provides access to the GAAP standard through the Financial Accounting Standards Board (FASB). Select “Basic View” to access the standards.
Module Two Assignment Guidelines and Rubric