Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Enter the income statement and balance sheet data for Virtual Gaming Systems shown below in a Microsoft Excel spreadsheet. VIRTUAL GAMING SYSTEMS Balance Sheets December

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Enter the income statement and balance sheet data for Virtual Gaming Systems shown below in a Microsoft Excel spreadsheet. VIRTUAL GAMING SYSTEMS Balance Sheets December 31 \begin{tabular}{lll} 2019 & 2018 & 2017 \\ \hline \end{tabular} Assets Current assets: CashAccountsreceivableInventoryPrepaidrent$216,00090,000140,00015,000$196,00091,000115,00013,000$154,00070,000145,0007,200 Long-term assets: Liabilities and Stockholders' Equity. Current liabilities: \begin{tabular}{lrrr} Accounts payable & $161,000 & $76,000 & $137,200 \\ Interest payable & 12,000 & 8,000 & 4,000 \\ Income tax payable & 13,000 & 20,000 & 15,000 \\ \hline Long-terintiabilites & & & \\ Notes payable & 450,000 & 295,000 & 235,000 \end{tabular} Inventory Prepaid rent 140,00015,000115,00013,000145,0007,200 Long-term assets: InvestmentinbondsLandEquipmentLess:AccumulateddepreciationTotalassets115,000310,000310,000(124,000)$1,072,000115,000220,000280,000(84,000)$946,0000250,000220,000(52,000)$794,200 Liabilities and Stockholders' Equity. Current liabilities: 3. Calculate the following risk ratios for 2018 and 2019 using formulas in Excel as demonstrated in class: a. Receivables turnover ratio. (Hint: Use net sales for net credit sales.) b. Inventory turnover ratio. c. Current ratio. d. Debt to equity ratio. 4. Calculate the following profitability ratios for 2018 and 2019 using formulas in Excel as demonstrated in class: a. Gross profit ratio. (Hint: Use net sales for net credit sales.) b. Return on assets. c. Profit margin. d. Asset turnover. (Hint: Use net sales for net credit sales.)

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_2

Step: 3

blur-text-image_3

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

Survival Audit And Calculations Manual

Authors: Dr Joseph Lee Bounds

1st Edition

1505425573, 978-1505425574

More Books

Students also viewed these Accounting questions

Question

5. Describe the visual representations, or models, of communication

Answered: 1 week ago