Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work areas as indicated.
Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work areas as indicated.
Please provide an answer for red cells. Use responses using the Cell reference formula.
Using Excel to Calculate Shareholders' Equity Ratios PROBLEM RIngtone Inc. has the following selected financial data: Net income Total assets Preferred shares, cumulative Common shares Retained earnings Accumulated other comprehensive income Total shareholders' equity Cash dividends paid in the year Market price of common shares Weighted average number of common shares Dividend rate on preferred shares There were no preferred dividends in arrears. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work areas as indicated. \begin{tabular}{rrr} \multicolumn{2}{r}{2023} & \multicolumn{1}{r}{2022} \\ \hline$220,000 & $680,000 \\ 5,136,000 & 4,525,000 \\ 600,000 & 600,000 \\ 350,000 & 350,000 \\ 2,786,000 & 2,190,000 \\ 145,000 & 130,000 \\ 3,881,000 & 3,270,000 \\ 124,000 & 170,000 \\ 97.46 & 64.33 \\ 80,000 & 80,000 \\ 4% & \end{tabular} (3) Book value Book value per share \begin{tabular}{|l|l|} \hline$ & \\ \hline & \\ \hline & \\ \hline 11.20 & times \\ \hline \end{tabular} (3) Price earnings ratio Earnings per share Price earnings ratio \begin{tabular}{|c|c|} \hline & 5,951,000 \\ \hline$ & 24,000 \\ \hline & 11.70% \\ \hline \end{tabular} (2) Payout ratio Payout ratio \begin{tabular}{|r|} \hline \\ \hline 17.82% \\ \hline \end{tabular} (a) Calculate the following ratios for 2023. (1) Rate of return on common shareholders' equity Average common shareholders' equity Preferred dividends Rate of return on common shareholders' equity \begin{tabular}{|c|c|c|} \hline$ & 8.70 & \\ \hline & 11.20 & times \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} (4) Rate of return on total assets $41.01 Rate of return on total assets 14.91% (b) Is Khalid Inc. trading on the equity? \begin{tabular}{|l|l|} \hline Because Khalid's & payout ratio \\ \hline exceeds its & rate of return on assets \\ \hline the company is & trading on the equity \\ \hline \end{tabular}Step 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