Reference no: EM132189892
Question: Using Yahoo Finance, complete the following:
1. Select a publicly traded to company to evaluate. Do not select banks or holding companies.
2. To the left of the Get Quotes icon, type the stock symbol or the name of the company you wish to evaluate. If you cannot find a stock symbol, search Google by entering the company name followed by the words stock symbol.
3. Enter the stock symbol or select the symbol from the list
4. Scroll down to the bottom left and the Financial Statements heading will display.
Requirements: (Submit via Canvas)
1. Using the attachment below, complete the financial analysis of your company for each year. Submit the spreadsheet to me via Canvas. It will be easier if you print the financial statements.
Access Yahoo Finance, enter the stock symbol field, Scroll to bottom left to select financial statements.
Using Word, analyze the data over the three year period and reference the industry averages in the following areas:
Staying Power
Earning Power
Overall efficiency ratios
Working capital cycle ratios
Ratio Analysis template (attached)
Use CSI Market. com below to look up industry averages (Go, enter stock symbol, select Fundamentals. Use Industry column to retrieve data for all ratios except Earnings Quality and Accounts Payable turnover).
Information related to above question is enclosed below:
Attachment:- Ratio Analysis template 092617.rar