Using this ratio analysis template 2021 master-3.xlsx , complete the financial analysis of Procter and Gamble (PG) for the two most recent years. S

Financial analysis of Procter and Gamble

Using this ratio analysis template 2021 master-3.xlsx , complete the financial analysis of Procter and Gamble (PG) for the two most recent years.

Access Yahoo Finance, enter PG in stock symbol field, Select Financials from the menu selections just below the stock price. After accessing a financial statement, click on EXPAND ALL (top right of the statement.

Using Word, analyze the data over the two 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 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).

 

Using this ratio analysis template 2021 master-3.xlsx , complete the financial analysis of Procter and Gamble (PG) for the two most recent years. S