Answered step by step
Verified Expert Solution
Question
1 Approved Answer
G19. Balance Shect Microsoft Excel Home Insert Page Layout Formulas Data Review View Dule Femme Bas 9 E Split E Zoom 100% Zoom to New
G19. Balance Shect Microsoft Excel Home Insert Page Layout Formulas Data Review View Dule Femme Bas 9 E Split E Zoom 100% Zoom to New SelectionWindow Glicine Headings Mesar Showice Arrange Freeze Pancs Nomal Pape rege Bak Custom Full Layout Preview Views Screen Workbook Views E10 Macros Side by Side 5 Save Switch w stron Workspace Windows Window Will you please create a balance sheet for the info below. Thank you 3 Account Title Credit Debit 119,000 115.000 $ $ 4,025 $ $ $ 79,115 8.000 1.200 $ $ 200.000 60,000 $ 62,500 25,000 $ $ 31,950 27,370 7 Accounts Receivable 8 Allowance For Doubtful Accounts 9 Inventory 10 Prepaid Rent 11 Supplies 12 Land 13 Ruilding 14 Equipment 15 Accumulated Depreciation, Building 16 Accumulated Depreciation Equipment 17 Goodwill 18 Patent 19 Accounts Payable 20 Nates Payable 21 Uneamed Service Revenue 22 Commen Stock 23 Retained Earnings 24 Revenue 25 Salary Expense 25 Cost of Goods Sold 27 Advertising Expense 28 Rent Expense 29 Miscellaneous Expense 30 Supplies Expense 31 Depreciation Expense 32 Salaries Payable 33 Loss on Sale of Equipment Amortization Expense 35 Loss due to Market Dedine for Inv. 35 Bad Debt Expense 37 Allowance to reduce inventory to cost 1.57,715 178,000 104,000 90,000 175,000 731,000 $ $ $ $ $ $ $ $ 4 .500 201,000 15,000 48,000 1.000 4,000 19,500 $ 4,500 $ $ $ $ 2.000 6.600 3,858 6,625 $ 1,492,598 $ 3,858 1,492,598 NEM Sheet1 Sheet2 Sheet Ready
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