Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE ADD the excel equations for each answer so i know how to get the answers and understand how you got them thank you 2

PLEASE ADD
the excel equations for each answer so i know how to get the answers and understand how you got them thank you image text in transcribed
image text in transcribed
2 Condensed financial statements for Games Galore are summarized below: 3 Balance Sheet 5 Cash 6 Accounts Receivable, Net 7 Inventory 8 Prepaid insurance 9 Total Current Assets 10 Property and Equipment, Net 11 Total Assets 12 Current Liabilities 13 Long-term Liabilities 14 Total Liabilities 15 Contributed Capital 16 Retained Earnings 17 Total Stockholders' Effity 18 Total Labilities and Stockholders' Equity 19 Income Statement 21 Net Sales (all on account) 22 Cost of Goods Sold 22 Cost of Goods Sold 23 Gross Profit 24 Operatine Expenses 25 Income from Operations 26 interest fopense 27 income before income tax fxpense 28 income Tax Expense 29 Net income 30 31 Required: 32 Compute the following liquidity ratios for 2022. 33 Round to the required number of decimal places using the Excel =ROUND function 34 Current ratio (rounded to one decimal place) 35 Accounts recelvable turnover (rounded to two decimal places) 36 Days' sales uncollected (rounded to the nearest whole day) \begin{tabular}{l|c} \hline 2022 & 2021 \\ $185,000 & $143,000 \end{tabular} 80,00059,000 104,000134,000 \begin{tabular}{|r|r|} \hline 11,900 & 5,880 \\ \hline 380,900 & 341,880 \\ \hline \end{tabular} 514,500407,000 \begin{tabular}{|r|r|} \hline$895,400 & $748,880 \\ \hline$85,300 & $96,800 \\ \hline 284,000 & 224,000 \\ \hline 369,300 & 320,800 \\ \hline 299,000 & 299,000 \\ \hline 227,100 & 129,080 \\ \hline$26,100 & 428,080 \\ \hline$895,400 & $748,880 \\ \hline \end{tabular} \begin{tabular}{|r|} \hline$3,031,000 \\ \hline 1,949,000 \\ \hline 1,082,000 \\ \hline 891,400 \\ \hline 190,600 \\ \hline 14,500 \\ \hline 176,100 \\ \hline 47,000 \\ \hline$129,100 \\ \hline \\ \hline \\ \hline \end{tabular} 2 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your Nothing in this area will be graded, but it will be submitted with your assignment

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 Mcgraw Hill 36 Hour Course In Finance For Non Financial Managers

Authors: Robert Cooke

2nd Edition

0071425462, 978-0071425469

More Books

Students also viewed these Accounting questions

Question

Which of the tw 7 or (1) 8656 Which of the fol

Answered: 1 week ago