Using this Ratio Analysis template 092617-1.xls, complete the financial analysis of P&G for each year. Submit the spreadsheet to me via Canvas.
Access Yahoo Finance, enter PG in 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:
Overall efficiency ratios
Working capital cycle ratios
Use this CSI Market webpage (链接到外部网站。)链接到外部网站。 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).