Question
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
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 HistorStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started