Please follow the instructions and answer all the questions correctly.

Thank you in advance!

ACCT 2331 Internet Financial Statement Analysis Ratio Project The goal of this assignment is for you to experience finding out relevant accounting and other information about a corporation as if you were an investor. You will find out that it is relatively easy to look up information about any publicly traded company on line. Instructions: Follow the directions for each question below to look up the answers to the questions on the worksheet. Write the appropriate response in the spaces provided on the worksheet. Then STARTING NOVEMBER 16 use the worksheet to answer the multiple choice questions on BLACKBOARD ON LINE ASSESSMENT. The worksheet is for you to look up your answers and write them down so that you can answer the multiple choice questions without guessing. To receive credit you must complete the BLACKBOARD ON LINE ASSESSMENT on or before December 1, 2016. Your score will be based on approximately 1.6 points for each correct answer out of 16 (up to a maximum of 25 points). Please be sure to look up the answers and fill out the worksheet before doing the online assessment. If you just guess you will probably end up with a low score. THE ON LINE ASSESSMENT WILL BE AVAILABLE ONLY BETWEEN November 16 AND December 1. Project Worksheet The following assignment is designed to introduce you to some of the FREE financial information that is available on the web. This can be especially useful for personal investing decisions. We focus on a single site, Yahoo! Finance. There are, however, various other good sites such as Google Finance. We encourage you to explore these web sites on your own. Use the glossary of terms for any items that are new to you. For the purposes of this exercise, we will be examining IBM and in the second part of the project comparing it to Apple. The fiscal year end of IBM is December 31, and the fiscal year end of Apple is September 24. In order to use recent comparable information in the second part of the project you will gather financial statement facts from the 3rd quarterly report (of fiscal year 2016) of IBM ending September 30, 2016 and compare those with the 3rd quarter (of fiscal year 2016) of Apple ending June 25, 2016. FIRST PART OF THE PROJECT First, go to the following web site: http://finance.yahoo.com Type \"IBM\" in the box next to \"get quotes\" Then click on \"get quotes\" Select the ticker symbol \"IBM\" from the menu of choices This will take you to a page of basic information about IBM's stock. It will show you the current price and the volume of trading. There are several links to other information about IBM in the left column of the page you will find the links menu. From this menu, you will click on the following links to obtain the necessary information: (NOTE: The ticker symbol for International Business Machines Corporation is IBM. The ticker symbol is a letter designation that is assigned to stocks and mutual funds traded on U.S. exchanges. You may use it to \"get quotes\" instead of typing in the whole company name) Profile (under company) Historical Prices (under quotes) Income Statement and Balance Sheet (under financials - quarterly data) Competitors (under company) Analyst Estimates (under analyst coverage) Each of the above links will be discussed in the following pages. You will be asked to go to each of the linked pages and record information in the spaces provided. Internet Financial Statement Analysis and Ratio Project Worksheet Before clicking on the links answer the following questions from the basic information (summary) page. Basic Information The earnings per share of a company measures the amount of income earned for each share of stock, which is net income divided by shares of common stock outstanding Earnings per share are abbreviated as \"EPS\" The earnings per share (EPS) for IBM for the most recent year shown on this page are (Note: ttm = trailing twelve months (the past 12 months) _____________ The current price of IBM's common stock is? _____________ on Date:____________________(Record the Last Trade price and the date you looked at it) Profile From this page, you can obtain a brief Business Summary and Financial Summary. There is also general contact information as well as links to several other items, such as the company web site. From this page, answer the following questions about IBM: 1. What Industry is IBM in? ___________________ 2. How many full time employees work for IBM? __________________ 3. Who is the Chief Executive Officer? _______________________ 4. Who is the Chief Financial Officer? ________________________ Internet Financial Statement Analysis and Ratio Project Worksheet Historical Prices From this page, you can obtain daily, weekly, and monthly prices for your company for a range of dates. You can also obtain information on dividends. Select December 31, 2015 as the start and end date to capture the historical price at the end of last year. Make sure that the daily price quote is chosen: Daily Weekly Monthly Dividends Look at the column listing the adjusted closing price (this price is adjusted for stock splits and stock dividends). What was the adjusted Closing price of the company for December 31, 2015? Closing Price How much money would you have made or lost from the price change if you had purchased 1 share of IBM stock on December 31, and sold it on the day you looked up the current price? ___________________ Analyst Estimates From this page, you can see current broker recommendations and estimates of future earnings. (See \"growth estimates\") What is the consensus estimate for the rate of growth of IBM's earnings over the next five years? _______________________________ What is the consensus estimate for the rate of growth of the Industry's earnings over the next five years? ___________________________________ Internet Financial Statement Analysis and Ratio Project Worksheet 2nd PART OF THE PROJECT Financials From these pages, you can view the recent quarterly financial statements of the company. In order to compare IBM to a close competitor we will use data for the quarter ending September 30, 2016. Click on income statement or balance sheet of IBM as requested below. Then be sure you are viewing Quarterly Data. If you get \"Annual Data\" then switch to quarterly by clicking on the Quarterly Data link at the top. Notice that all numbers are in thousands of dollars (for example 200,000 is really 200,000 x 1,000 or 200 million), but write them on your worksheet just as they are. If it says 200,000 just write 200,000. Questions 1 through 16 pertain to IBM. 1. From the quarterly Income Statement, what was the total revenue for the quarter ending on September 30, 2016? 2. From the quarterly Income Statement, what was the total revenue for the previous quarter ending on June 30, 2016? 3. Now use your answers to 1 and 2 to calculate the % growth in revenue for the quarter (subtract revenues for the quarter ending June 30, 2016 from revenues for the quarter ending September 30, 2016 and divide the result by the revenues for the quarter ending June 30, 2016. Then express the result as a percentage). 4. % Growth in Revenue = ______________________________ From the quarterly Income Statement, what was Net Income for the quarter ending on September 30, 2016? ____ 5. From the quarterly Income Statement, what was the Gross Profit for the quarter ending on September 30, 2016? 6. From the quarterly Income Statement, what was the Cost of Revenues (cost of goods sold) for the quarter ending on September 30, 2016? Internet Financial Statement Analysis and Ratio Project Worksheet 7. From the quarterly Balance Sheet, what was the value of inventories as of September 30, 2016? 8. From the quarterly Balance Sheet, what was the value of inventories as of June 30, 2016? 9. From the quarterly Balance Sheet, what was the total asset value as of September 30, 2016? 10. From the quarterly Balance Sheet, what were the total liabilities as of September 30, 2016? 11. From the quarterly Balance Sheet, what was the total current assets value as of September 30, 2016? 12. From the quarterly Balance Sheet, what was the total current liabilities value as of September 30, 2016? 13. The largest current asset category is: __________ 14. The largest current liability category is: __________ 15. The largest non-current asset category is: ___________ 16. The largest non-current liability category is: ___ FINANCIAL RATIOS: Use the information gathered from IBM's Financials on the previous pages to calculate the following ratios for IBM. Do not try to look these up on the website. Instead you must make the calculation yourself. Inventory Turnover (Cost of Goods Sold / Average Inventory) Gross profit % (Gross Profit / Revenues)*100 Debt Ratio Internet Financial Statement Analysis and Ratio Project Worksheet ___________________ __________________ ________________________ (Total Liabilities/Total Asset) Current Ratio (Current Asset/Current Liabilities) _______________________ COMPARISON OF IBM TO A CLOSE COMPETITOR- APPLE, INC. Now open up the income statement and balance sheet for Apple: In \"get quotes\" enter AAPL for Apple. On the left menu find the income statement and the balance sheet under Financials. Look up the following income statement information: Total Quarter Revenues (June 25, 2016) _______________ Total Quarter Revenues (March 26, 2016) ______________ Quarter Gross Profit (June 25, 2016) ________________ Look up the following balance sheet information for June 25, 2016 Total Assets ____________________ Total Liabilities ___________________ Current Assets ___________________ Current Liabilities ___________________ Now use these 7 values (above) to calculate the following ratios for Apple in order to compare them to IBM. Use the same calculation methods as for IBM. Revenue Growth Gross Profit Margin _______________________ (it could be negative) ________________________ Debt (total liabilities) to Total Assets Current Ratio ____________________ _______________________ Based on a comparison of these two ratios between IBM and Apple which company seems to have better liquidity, which has better margin which has better solvency and which has better revenue growth? Internet Financial Statement Analysis and Ratio Project Worksheet Revenue Growth? ____________________ Margin? __________________ Solvency? __________________ Liquidity? __________________ Internet Financial Statement Analysis and Ratio Project Worksheet