Company: PG

years: 2022, 2021, 2020 (unless it has to be starting 2021, 2020, 2019).

problem:

1) Using an Excel spreadsheet, you will create a three-year ratio trend analysis from the financial statements for your assigned corporation. The trend will consist of the following ratios:

Current Ratio and the Quick Ratio from the I. Short term solvency, or liquidity, ratios category

Return on Assets Ratio and the Return on Equity Ratio from the IV. Profitability ratios category

Price Earnings Ratio and the Price Sales Ratio from the V. Market value ratios category.

Then provide a one-page (minimum) discussion about what each trend indicates for your assigned corporation. Is the trend good or bad, why?

PG balance sheet from morningstar

PG cash flow annual from morningstar

PG income statement from morningstar

Work:

I believe this is right above

this part I'm not sure about

this part I'm not sure. How would you calculate the price per share since the 134.44 isn't accurate for 2021,2020 or any other year?( i included it for the stock price from market beat)

thanks! I can repost additionally if needed. Just wanted to make sure I'm on the right track with short term solvency tab. the two problems below it I'm not sure about. thank you!

A B C D E F formulas from table 3.8 current ratio = issets/current liabilities quick ratio =-inventory) / current liabilities \begin{tabular}{|c|c|c|c|c|} \hline & 2022 & 2021 & 2020 & 2019 \\ \hline current assets & 1.17208E+11 & 1.1931E+11 & 1.207E+11 & 1.15095E+11 \\ \hline \end{tabular} "balance sheet" morningstar tab \begin{tabular}{|l|l|l|l|l|} current liabilities 70354000000 & 7.2653E+10 & 73822000000 & 67516000000 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline inventory & 6924000000 & 5983000000 & 5498000000 & 5017000000 \\ \hline \end{tabular} current ratio = issets/current liabilities \begin{tabular}{|c|c|c|c|c|} \hline & 2022 & 2021 & 2020 & 2019 \\ \hline current ratio & 1.665974927 & 1.64214829 & 1.635013952 & 1.704707032 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline quick ratio & 1.567558348 & 1.55979794 & 1.560537509 & 1.63039872 \\ \hline \end{tabular} A B C D net income/total assets return on equity ratio ROE= net income/total equity 2018 2019 2020 2021 2022 equity (balance sheet) 52883000000 47579000000 income (income statement) I. short term solvency IV. Profitability ratios balance sheet morningstar income statement morningstar Ready Accessibility: Good to go Procter \& Gamble - PG Dividend Yield, Date \& Histor? rocter \& Gamble - PG Dividend Yield, Date E Histor