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.
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.
