Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Excel document (the XBRL worksheet)is incomplete. Every row needs to be filled in. Only the first two rows were completed in the worksheet I

image text in transcribed

The Excel document (the XBRL worksheet)is incomplete. Every row needs to be filled in. Only the first two rows were completed in the worksheet I submitted.

I attached the assignment and what I completed so far.

The first two attachments are the answers I have so far. The remaining three is the instructions to the assignment.

image text in transcribed ACCT 614 XBRL Study Module and Homework This is a self-paced study module with a graded homework assignment due in your assignment folder no later than the date shown in the related Conference and Course Schedule. In each section, I offer lecture notes on aspects of XBRL that take you to vetted XBRL resources that offer review of the concepts covered in the lecture. During this activity, remember, we do not have to learn a lot of XBRL code. What we have to learn is 1) the terminology, 2) how to read some code (similar to reading html code from an Internet doc), 3) how to select appropriate code from an XBRL taxonomy, and 4) how to check code in financial statements. At the end of module are several homework problems that you will submit for grading. Background on XBRL eXtensible Business Reporting Language (XBRL) is a language for the electronic communication of business and financial data and has been implemented by International Financial Reporting Standards (IFRS), the United States Generally Accepted Accounting Principles (U.S. GAAP), and many other national and international accounting standards bodies. In the United States, the Securities and Exchange Commission (SEC) requires public companies to file their financial statements in XBRL. The following article from Accounting Web provides a good summary todate of the path to XBRL compliance and the SEC's filing requirements: Public companies must submit XBRL exhibits to SEC in 2011. Essentially, we are now in \"Phase 3\ACCT 614 XBRL Mapping Assignment 2012 US GAAP Financial Reporting Taxonomy https://edgardashboard.xbrlcloud.com/flex/viewer/XBRLViewer.html?header-title=Laredo%20 DELTE Shad Clothes Inc Balance Sheet 20XX in millions ASSETS Cash & Cash Equivalents Short term Investments` Merchandise Inventory Other Current Assets Total Current Assets $1,885 $0 $1,615 $809 $4,309 Property, Plant & Equipment, Net Other Long-term Assets Total Assets $2,523 $590 $7,422 LIABILITIES & STOCKHOLDERS' EQUITY Accounts Payable Accrued Liabilities Current Maturities Income Taxes Payable Total Current Liabilities $1,066 $998 $59 $5 $2,128 Long Term Debt Total Liabilities $2,539 $4,667 Common Stock: $0.05 par value: 2,300 authorized, 1,106, issued and 485 outstanding. Additional Paid-in Capital Accum Other Comprehensive Income (Loss) Retained Earnings Treasury stock at cost (621 presented) Total Stockholders Equity Total Liabilities & Stockholders' Equity $55 $2,867 $229 $12,364 ($12,760) $2,755 $7,422 Linkbase Presentation: 104000 - Statement - Statement of Financial Position, Classified Calculation: 104000 - Statement - Statement of Financial Position, Classified ?header-title=Laredo%20Oil%2c%20Inc.%20(10-Q)&instance=http://www.sec.gov/Archives/edgar/data/1442492/000119983512000681/lrdc-20120831.xml# Name AssetsAbstract CashAndCashEquivalentsAtCarryingValue Prefix us-gaap us-gaap Namespace http://fasb.org/us-gaap/2012-01-31 http://fasb.org/us-gaap/2012-01-32 Balance Debit Debit Period Instant Instant dc-20120831.xml# Data Type XBRL Type xbrli:monetaryItemType monetaryItemType xbrli:monetaryItemType monetaryItemType ACCT 614 XBRL Mapping Assignment 2012 US GAAP Financial Reporting Taxonomy https://edgardashboard.xbrlcloud.com/flex/viewer/XBRLViewer.html?header-title=Laredo%20O DELTE Shad Clothes Inc Income Statement 20XX in millions INCOME STATEMENT Revenues Cost of Goods Sold Gross Profit $14,549 $9,275 $5,274 Operating Expenses Operating Income (Loss) $3,836 $1,438 Interest Income Interest Expense Income before Taxes Income Taxes Net Income (Loss) $5 ($74) $1,369 536 $833 Weighted - average number of shares - basic Weighted - average number of shares - diluted Earnings per Share - basic Earnings per Share - diluted Cash dividends declared and paid per share 529 533 $1.57 $1.56 $0.45 Linkbase ?header-title=Laredo%20Oil%2c%20Inc.%20(10-Q)&instance=http://www.sec.gov/Archives/edgar/data/1442492/000119983512000681/lrdc-20120831.xml# Name Prefix Namespace Balance Period dc-20120831.xml# Data Type XBRL Type XBRL is a data-rich dialect of XML (Extensible Markup Language), the universally preferred language for transmitting information via the Internet. It was developed specifically to communicate information between businesses and other users of financial information, such as analysts, investors and regulators. XBRL provides a common, electronic format for business reporting. It does not change what is being reported. It only changes how it is reported XBRL is a World-Wide standard, developed by an international, non-profitmaking consortium, XBRL International Inc. (XII). XII is made up of many hundred members, including government agencies, accounting firms, software companies, large and small corporations, academics and business reporting experts. XII has agreed the basic specifications; which define how XBRL works. Self-check Answers for XBRL Module Exercises Exercise 1 Go to https://xbrlviewer.bowne.com/. Select 4NET Software, Inc. from the left hand menu Select Quarterly Report (2012-06-30) Explore the information available in the viewer (do not access the Charts, they are temporarily down for maintenance). Locate the following information. You may insert screenshots for your responses. a) What is the company's CIK (SEC Central Index Key) number? and What is the company's Ticker Symbol and fiscal yearend? Exercise 2 Go to Footlocker. com. Under the Second Quarter 2012 Form 10-Q - filed 9/05/12, select the SEC XBRL Viewer. Under the financial statements, select the Consolidated Balance Sheets. Locate the following information for elements on the statement. Insert a screenshot of the statement below. Note: To create a screenshot, go to the screen that you want to capture, press Ctrl PrtScn. Go to the Word document where you want to insert your screen shot. Hit Ctrl V. Resize the image for the page. Or try JING, which is free capture software located at http://www.techsmith.com/download/jing/ KK, UMUC, 2013 Page 1 a) For the accounts payable account, July 28, 2012, provide the following information from the XBRL tags. You may copy and paste your responses. Element Name Taxonomy Namespace Data Type Balance Period Would the element name or the account label be used to tag the amount of $391 on the financial statement? Show the proper format. AccountsPayableNetCurrent or 391000AccountsPayableNetCurrent > b) Looking at the Summary of Significant Accounting Policies (left-hand menu), identify the tags for \"Recent Accounting Pronouncements\". Element Name KK, UMUC, 2013 Page 2 Type Standard Label Lang en-US Properties Property Name Namespace Data Type XBRL Type Substitution Group Period Type Abstract Nillable Label Income Statement [Abstract] Value IncomeStatementAbstract http://fasb.org/us-gaap/2015-01-31 xbrli:stringItemType stringItemType xbrli:item duration 1 1 ACCT 614 XBRL Mapping Assignment Shad Clothes Inc Balance Sheet 20XX in millions ASSETS Cash & Cash Equivalents Short term Investments Merchandise Inventory Other Current Assets Total Current Assets $1,885 $0 $1,615 $809 $4,309 Property, Plant & Equipment, Net Other Long-term Assets Total Assets $2,523 $590 $7,422 LIABILITIES & STOCKHOLDERS' EQUITY Accounts Payable Accrued Liabilities Current Maturities Income Taxes Payable Total Current Liabilities $1,066 $998 $59 $5 $2,128 Long Term Debt Total Liabilities $2,539 $4,667 Common Stock: $0.05 par value: 2,300 authorized, 1,106, issued and 485 outstanding. Additional Paid-in Capital Accum Other Comprehensive Income (Loss) Retained Earnings Treasury stock at cost (621 presented) Total Stockholders Equity Total Liabilities & Stockholders' Equity $55 $2,867 $229 $12,364 ($12,760) $2,755 $7,422 Linkbase Presentation: 104000 - Statement - S Calculation: 104000 - Statement - St Name AssetsAbstract CashAndCashEquivalentsAtCarryingValue Prefix Namespace us-gaap http://fasb.org/us-gaap/2012-01-31 us-gaap http://fasb.org/us-gaap/2012-01-31 Balance Period Data Type N/A Duration xbrli:stringItemType Debit Instant xbrli:monetaryItemType XBRL Type stringItemType monetaryItemType ACCT 614 XBRL Mapping Assignment Shad Clothes Inc Income Statement 20XX in millions INCOME STATEMENT Revenues Cost of Goods Sold Gross Profit $14,549 $9,275 $5,274 Operating Expenses Operating Income (Loss) $3,836 $1,438 Interest Income Interest Expense Income before Taxes Income Taxes Net Income (Loss) $5 ($74) $1,369 536 $833 Weighted - average number of shares - basic Weighted - average number of shares - diluted Earnings per Share - basic Earnings per Share - diluted Cash dividends declared and paid per share 529 533 $1.57 $1.56 $0.45 Linkbase Presentation: 124000 - Statement Calculation: 124000 - Statement - S Name IncomeStatementAbstract Revenues Prefix Namespace us-gaap http://fasb.org/us-gaap/2012-01-31 us-gaap http://fasb.org/us-gaap/2012-01-31 Balance Period N/A Duration Credit Duration Data Type xbrli:stringItemType xbrli:monetaryItemType XBRL Type stringItemType monetaryItemType

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting The Impact on Decision Makers

Authors: Gary A. Porter, Curtis L. Norton

9th edition

130565417X, 1305654174, 9781285972572 , 978-1285182964

More Books

Students also viewed these Accounting questions

Question

Go, do not wait until I come

Answered: 1 week ago

Question

Make eye contact when talking and listening

Answered: 1 week ago

Question

Do not go, wait until I come

Answered: 1 week ago