Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am so confused by this. Can someone PLEASE help me?!?!? The company is Wal-Mart. Excel: Part I Instructions Company Information (Tab 1), and Historical

I am so confused by this. Can someone PLEASE help me?!?!? The company is Wal-Mart.

Excel: Part I Instructions

Company Information (Tab 1), and

Historical Income Statements, Balance Sheets, and Cash Flows (Tabs 2-4)

  • Go to the Securities and Exchange Commission's EDGAR database and access your chosen company's most recent Form 10-K (annual report).
  • Make an Excel workbook, including data for your chosen company as follows:
  • The1sttab(worksheet) in your Financial Statement Analysis Template must be labeledCompany Information. The following information must be included:
  • Company Name and ticker symbol
  • Industry
  • Products or services offered
  • Major competitors
  • An example of this tab is provided in Exhibit A.
  • The2ndtabin your Financial Statement Analysis Template must be labeledHistorical Income Statements.
  • Include the latestthree yearsbased on SEC filings.
  • Ensure that the worksheet includes a header with:
  • Company Name
  • Financial Statement Name (Income Statements)
  • Financial Statement Dates
  • Denomination level ($s in millions or thousands, etc.)
  • The3rdtabin your Financial Statement Analysis Template must be labeledHistorical Balance Sheets.
  • Include the latestthree yearsbased on SEC (10-K) filings. (Note: Some 10-Ks only provided 2 years of balance sheet data. You may need to download the second most recent 10-K for your company in order to obtain 3 years of balance sheet data.)
  • Ensure that the worksheet includes a header with:
  • Company Name
  • Financial Statement Name
  • Financial Statement Dates
  • Denomination level ($s in millions or thousands, etc.)
  • A partial balance sheet example is provided in Exhibit B.
  • The4thtabin your Financial Statement Analysis Template must be labeledHistorical Statement of Cash Flows.
  • Include the latestthree yearsbased on SEC (10-K) filings.
  • Make sure that the Income Statement, Balance Sheet, and Cash Flows Statement tie in as follows:
  • Net Income from Income Statement agrees with Net Income on the Statement of Cash Flows.
  • Ending Cash Balance from Statement of Cash Flows agrees with Cash in the Balance Sheet.
  • Ensure that the worksheet includes a header with:
  • Company Name
  • Financial Statement Name
  • Financial Statement Dates
  • Denomination level ($s in millions or thousands, etc.)
  • Other instructions:
  • The Excel workbook should be professionally formatted. Professional formatting includes:
  • All numbers are formatted similarly. The use of decimals, commas for thousands, and other formatting is consistent.
  • Dollar signs are included in the first and last numbers of each column.
  • Subtotals and totals are preceded by a single underline. Totals are followed by a double underline.
  • All extraneous information is removed from the spreadsheet. Sometimes, files downloaded from the SEC website contains extra characters or other things that need to be deleted.
  • Line descriptions are indented/bolded in a manner that makes the spreadsheet easy to read.
  • All totals and subtotals should be calculated using formulas.

These are the links to find the relevent information:

https://www.sec.gov/ix?doc=/Archives/edgar/data/104169/000010416921000033/wmt-20210131.htm

https://s2.q4cdn.com/056532643/files/doc_financials/2020/ar/Walmart_2020_Annual_Report.pdf

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

Step: 3

blur-text-image

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

Detecting Accounting Fraud Analysis And Ethics

Authors: Cecil Jackson

1st Edition

0133078604, 9780133078602

More Books

Students also viewed these Accounting questions