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 201920182017 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-terititiabilites & & & \\ 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: 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

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

Accounting Information Systems

Authors: Patrick R. Wheeler, Ulric J. Gelinas, Richard B. Dull, Dull Gelinas Wheeler

International 10th Edition

017035539X, 9780170355391

More Books

Students also viewed these Accounting questions

Question

Describe some common hazards in the contemporary workplace

Answered: 1 week ago