Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please solve the ratios using Excel if possible begin{tabular}{|c|c|c|c|c|c|} hline multicolumn{6}{|c|}{SMOLIRAGOLFCORPORATION2020and2021BalanceSheets} hline Assets & 2020 & 2021 & Liabilities and Owners' Equity & 2020
Please solve the ratios using Excel if possible
\begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{SMOLIRAGOLFCORPORATION2020and2021BalanceSheets} \\ \hline Assets & 2020 & 2021 & Liabilities and Owners' Equity & 2020 & 2021 \\ \hline Current assets & & & Current liabilities & & \\ \hline Cash & $24,206 & $25,700 & Accounts payable & $24,784 & $28,700 \\ \hline Accounts receivable & 14,048 & 16,800 & Notes payable & 13,000 & 12,400 \\ \hline Inventory & 27,622 & 28,700 & Other & 13,171 & 15,900 \\ \hline \multirow[t]{5}{*}{ Total } & $65,876 & $71,200 & Total & $50,955 & $57,000 \\ \hline & & & Long-term debt & $85,000 & $95,455 \\ \hline & & & Owners' equity & & \\ \hline & & & Common stock and paid-in surplus & $40,000 & $40,000 \\ \hline & & & Accumulated retained earnings & 230,616 & 240,545 \\ \hline Fixed assets & & & & & \\ \hline Net plant and equipment & $340,695 & $361,800 & Total & $270,616 & $280,545 \\ \hline Total assets & $406,571 & $433,000 & Total liabilities and owners' equity & $406,571 & 433,000 \\ \hline \end{tabular} Find the following financial ratios for Smolira Golf Corporation (use year-end figures rather than average values where appropriate): (Enter the profitability ratio answers as a percent rounded to 2 decimal places, e.g., 32.16. Round the remaining answers to 2 decimal places, e.g., 32.16.) \begin{tabular}{|l|l|l|} \hline \multicolumn{1}{|c|}{ Asset utilization ratios: } & & \\ \hline d. Total asset turnover & & times \\ \hline e. Inventory turnover & & times \\ \hline f. Receivables turnover & & times \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{ Long-term solvency ratios: } & \multicolumn{2}{c|}{2020} & \multicolumn{2}{c|}{2021} \\ \hline g. Total debt ratio & & times & & times \\ \hline h. Debt-equity ratio & & times & & times \\ \hline i. Equity multiplier & & times & & times \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline j. Times interest earned & & times \\ \hline k. Cash coverage ratio & & times \\ \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