Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

An experienced budget analyst at Al Rawa,, , has been charged with assessing the firm's financial performance during 2021 and its financial position at year-end

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
An experienced budget analyst at Al Rawa,, , has been charged with assessing the firm's financial performance during 2021 and its financial position at year-end 2021. To complete this assignment, she gathered the firm's 2021 financial statements (below). In addition, he obtained the firm's ratio values for 2019 and 2020, along with the 2021 industry average ratios (also applicable to 2019 and 2021). TO DO Q1. Calculate the firm's 2021 financial ratios, and then fill in the preceding table. (Assume a 365-day year.) (28 marks ) (2 mark each ratio listed above ) Q2. Analyze the firm's current financial position from both a cross-sectional and a time-series viewpoint. Break your analysis into evaluations of the firm's liquidity, activity, debt, profitability, and market. (10 marks) ( 2 marks each categories ) Q3. Summarize the firm's overall financial position on the basis of your findings in part b ( 8 marks ) "R THE YEAR ENDED DEC 2021 IS GIVEN BELOW Al Rawa Statement of Retained Earnings for the year ended December 31, 2021 Retainedearnings(January12021)Plus:NetProfitsaftertaxes(2021)Less:Cashdividends(paidduring2021)Retainedearningsbalance(December31,2021)$50200$42900$20000$$73,100 Al Rawa Historical and Industry Average Ratios \begin{tabular}{|l|c|c|c|c|} \hline Ratio & Actual 2019 & Actual 2020 & Actual 2021 & Industry Average 2021 \\ \hline & & & & \\ \hline Current ratio & 1.6 & 1.8 & & 1.3 \\ \hline quick ratio & 1 & 0.9 & & 1.1 \\ \hline Inventory turnover & 5.2 & 5 & & 11.2 \\ \hline Average collection period & 50.7 & 55.8 & & 44 \\ \hline Total Asset turnover & 1.5 & 1.5 & & 2 \\ \hline Debt ratio & 45.80% & 54.30% & . & 24.50% \\ \hline Times interest earned ratio & 2.2 & 1.9 & & 2.5 \\ \hline Gross profit margin & 27.50% & 28% & & 26% \\ \hline Net profit margin & 1.10% & 1% & & 1.20% \\ \hline Return on total assets & 1.70% & 1.50% & . & 2.40% \\ \hline Return on common equity & 3.10% & 3.30% & & 3.20% \\ \hline Price/earnings ( P/E ) ratio & 32.50% & 38.7 & & 43.40% \\ \hline Market /book ( M/B) ratio & 1.00% & 1.1 & & 1.20% \\ \hline \end{tabular} An experienced budget analyst at Al Rawa,, , has been charged with assessing the firm's financial performance during 2021 and its financial position at year-end 2021. To complete this assignment, she gathered the firm's 2021 financial statements (below). In addition, he obtained the firm's ratio values for 2019 and 2020, along with the 2021 industry average ratios (also applicable to 2019 and 2021). TO DO Q1. Calculate the firm's 2021 financial ratios, and then fill in the preceding table. (Assume a 365-day year.) (28 marks ) (2 mark each ratio listed above ) Q2. Analyze the firm's current financial position from both a cross-sectional and a time-series viewpoint. Break your analysis into evaluations of the firm's liquidity, activity, debt, profitability, and market. (10 marks) ( 2 marks each categories ) Q3. Summarize the firm's overall financial position on the basis of your findings in part b ( 8 marks ) "R THE YEAR ENDED DEC 2021 IS GIVEN BELOW Al Rawa Statement of Retained Earnings for the year ended December 31, 2021 Retainedearnings(January12021)Plus:NetProfitsaftertaxes(2021)Less:Cashdividends(paidduring2021)Retainedearningsbalance(December31,2021)$50200$42900$20000$$73,100 Al Rawa Historical and Industry Average Ratios \begin{tabular}{|l|c|c|c|c|} \hline Ratio & Actual 2019 & Actual 2020 & Actual 2021 & Industry Average 2021 \\ \hline & & & & \\ \hline Current ratio & 1.6 & 1.8 & & 1.3 \\ \hline quick ratio & 1 & 0.9 & & 1.1 \\ \hline Inventory turnover & 5.2 & 5 & & 11.2 \\ \hline Average collection period & 50.7 & 55.8 & & 44 \\ \hline Total Asset turnover & 1.5 & 1.5 & & 2 \\ \hline Debt ratio & 45.80% & 54.30% & . & 24.50% \\ \hline Times interest earned ratio & 2.2 & 1.9 & & 2.5 \\ \hline Gross profit margin & 27.50% & 28% & & 26% \\ \hline Net profit margin & 1.10% & 1% & & 1.20% \\ \hline Return on total assets & 1.70% & 1.50% & . & 2.40% \\ \hline Return on common equity & 3.10% & 3.30% & & 3.20% \\ \hline Price/earnings ( P/E ) ratio & 32.50% & 38.7 & & 43.40% \\ \hline Market /book ( M/B) ratio & 1.00% & 1.1 & & 1.20% \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions