Assignment 11 (use above videos and docs to complete Assignment)

Using this Ratio Analysis template 092617-1.xls, complete the financial analysis of P&G for the three most recent years. 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:

Staying Power

Earning Power

Overall efficiency ratios

Working capital cycle ratios

Use this CSI Market webpage (Links to an external site.) 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).

Submit the spreadsheet and Word doc to me via Canvas by the due date.