Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

image text in transcribed

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

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

The Handbook Of Energy Trading

Authors: Stefano Fiorenzani, Samuele Ravelli, Enrico Edoli

1st Edition

1119953693, 978-1119953692

More Books

Students also viewed these Finance questions