Log in
Accounting
1
answer
0
watching
137
views

Find the financial statements for a publicly tradedcompany, and examine its statement of cash flows. Prepare the cashratios and prepare an overview (300 words) of what is revealedabout the company by its statement of cash flows and cash ratios.Post a link to the financial statements with your initial post, andinclude the company name in the subject line. Do not choose acompany that one of your classmates has already selected. Toparticipate in follow-up discussion, choose one of the companiesthat a classmate has reviewed, examine the company’s financialstatements, and provide your own commentary on it. All posts shouldbe grammatically correct and proofread for spelling.

Watch
1
answer
0
watching
137
views

For unlimited access to Homework Help, a Homework+ subscription is required.

Jamar Ferry
Jamar FerryLv2
28 Sep 2019

Unlock all answers

Get 1 free homework help answer.
Already have an account? Log in
Share

Related questions

Must be original, not copied and must pass turnitin. also musthave the link data came from. Find the financial statements forWalmart a publicly traded company, and examine its statement ofcash flows. Prepare the cash ratios presented in the Module 7Readings, and prepare an overview (300 words) of what is revealedabout the company by its statement of cash flows and cash ratios.Post a link to the financial statements with your initial post, andinclude the company name in the subject line. Do not choose acompany that one of your classmates has already selected. Toparticipate in follow-up discussion, choose one of the companiesthat a classmate has reviewed, examine the company’s financialstatements, and provide your own commentary on it. All posts shouldbe grammatically correct and proofread for spelling.

Find the financial statements for a publicly tradedcompany, and examine its statement of cash flows. Prepare the cashratios and prepare an overview (300 words) of what is revealedabout the company by its statement of cash flows and cash ratios.Post a link to the financial statements with your initial post, andinclude the company name in the subject line.

Hands-On Project 10-12

IMPROVING DECISION MAKING: USING SPREADSHEET SOFTWARE TO ANALYZEA DOT- COM BUSINESS

Software skills: Spreadsheet downloading, formatting, andformulas

Business skills: Financial statement analysis 10- 12

Pick one e- commerce company on the Internet— for example,Ashford, Buy. com, Yahoo, or Priceline. Study the Web pages thatdescribe the company and explain its purpose and structure. Use theWeb to find articles that comment on the company. Then visit theSecurities and Exchange Commission’s Web site at www. sec.gov to access the company’s 10- K ( annual report) formshowing income statements and balance sheets. Select only thesections of the 10- K form containing the desired portions offinancial statements that you need to examine, and download theminto your spreadsheet. Instructions below provide more detailedinstructions on how to download this 10- K data into a spreadsheetand information on financial statements. Create simplifiedspreadsheets of the company’s balance sheets and income statementsfor the past three years.

• Is the company a dot- com success, borderline business, orfailure? What information provides the basis of your decision? Why?When answering these questions, pay special attention to thecompany’s three- year trends in revenues, costs of sales, grossmargins, operating expenses, and net margins.

• Prepare a PowerPoint overhead presentation (with a minimum offive slides), including appropriate spreadsheets or charts, andpresent your work to your professor and classmates. An examplePowerPoint slide presentation is attached for your review in thislearning module folder in Blackboard.

As needed: Students can find material on understanding financialstatements on financial Web sites such as Ameritrade(www.ameritrade.com) or the Small Business Knowledge Basehttp://www.bizmove.com/finance/m3b2.htm.

Downloading the Data into a Spreadsheet

Use the Convert Text to Columns Wizard in your spreadsheetsoftware to arrange the 10-K data you downloaded into spreadsheetcolumns and rows. From the Excel menu, select Data and then selectthe Text to Columns option. The software brings up a Wizard toconvert the imported text into spreadsheet columns. Although youcan decide to create line breaks, it may be easiest to accept thedefault settings (Fixed Width, General format) and then adjustcolumn widths after the Wizard has arranged the data in spreadsheetcolumns.

Financial Statements

Financial statements are used to evaluate the performance of abusiness and diagnose its strengths and weaknesses. The two primaryfinancial statements are income statements and balance sheets. Theincome statement, also called an operating statement or profit andloss statement, shows the income and expenses of a firm over aperiod of time, such as a year, a quarter, or a month. Gross profitis calculated by subtracting the cost of goods sold from revenues,or sales. The gross margin is calculated by dividing gross profitby revenues (or sales). Net profit (or loss) is calculated bysubtracting all other expenses, including operating expenses andincome taxes from gross profit. Operating expenses are all businesscosts (such as expenditures for sales and marketing, general andadministrative expenditures, and depreciation) other than thoseincluded in the cost of goods sold. Net margins arecalculated by dividing net profit (or loss) by revenues (orsales).

A balance sheet provides a snapshot of a company’s financialassets and liabilities on a given date, usually the close of anaccounting period. It lists what material andintangible assets the business owns and what money the businessowes either to its creditors (liabilities) or to its owners(shareholders’ equity, also known as net worth). At any given timea business’s assets equals the sum of its liabilities plus its networth. Current assets include cash, securities, accountsreceivable, or other investments that are likely to be convertedinto cash within one year. Liabilities are outstanding obligationsof the firm. Current liabilities are debts that are due within oneyear. Long-term debt consists of liabilities that are not due untilafter a year or more. If too much debt has been used to finance thefirm’s operations, problems may arise in meeting future interestpayments and repaying outstanding loans. By examining a series ofbalance sheets, one can identify and analyze trends in thefinancial strength of a business.

Weekly leaderboard

Home
Homework Help 3,900,000
Accounting 580,000
Start filling in the gaps now
Log in