I need the wk 2 & 3 to be edited. I do not need the screenshots.
XBRL Audit Instructions
With this project you will explore Starbucks’ use of XBRL in filing 10-Ks with the SEC. This audit will
require you to look at the underlying data in the electronic filing of the 10-K of Starbucks in comparison
to the data contained within the Enterprise System of Starbucks and tie those numbers based on the
XBRL tags in the FASB Codification database. Below you will find links to a couple of different files and
tools you will need to complete this Audit:
10-K of Starbucks – File sbux-10k.html
XBRL of Starbucks 10-K – File sbux-XBRL.xml in the Files section of the Course Menu
Download Microsoft XML Notepad (https://www.microsoft.com/en-us/download/details.aspx?id=7973)
FASB Codification (http://www2.aaahq.org/ascLogin.cfm)
It has come to the attention of Starbucks’ management through an inquiry by the SEC that irregularities
have been detected by the SEC’s
Accounting Quality Model (a.k.a. RoboCop).
Your task is to research the irregularities, audit the financial statements, and correct the irregularities to put Starbucks back in good standing with the SEC. Your corrections should accompany a formal memo to the SEC explaining the remedy of the irregularities.
Week 1
: Download the materials provided and install Microsoft XML Notepad on your computer. Read
over the financial statements and make sure your professor had given you access to the FASB
Codification.
Week 2
: Use the following data to help you hone in on the financial statement irregularities:
1) The SEC has indicated that the cash carrying value transmitted in the XBRL file does not tie
to the balance sheet number in the printed copy of Starbucks’ 10-K. Find the XBRL element
in the FASB Codification, search the XBRL/XML file, and reconcile the 10-K to the XBRL file
and correct the error. Once identified use a text editor to correct the issue.
2) The value transmitted to the SEC for accounts payable is incorrect as compared to the 10-K.
The error is causing the right side of the balance sheet equation to be off by double the
account’s total value. Find the XBRL tag in the FASB Codification, search the XBRL/XML file,
and reconcile the 10-K to the XBRL file and correct the error. Once identified use a text
editor to correct the issue.
3) The value of retained earnings is overstated as compared to the 10-K. Find the XBRL tag in
the FASB Codification, search the XBRL/XML file, and reconcile the 10-K to the XBRL file and
correct the error. Once identified use a text editor to correct the issue.
4) The Company-operated stores Net Revenue number is understated due to a typographical
error. Find the XBRL tag in the FASB Codification, search the XBRL/XML file, and reconcile
the 10-K to the XBRL file and correct the error. Once identified use a text editor to correct
the issue.
Week 3
: Correct the errors in the XBRL file based on your previous week’s audit. Deliver the modified
XBRL file. Use Microsoft XML Notepad or Notepad to make your modifications. Make sure your file is
well formed when you save it.
0 comments