Prepare income statement and blancesheet from 2017 trial balance
Codel Art $1,239,009.75 $846,000.00 21 22 5 Account ID Account Description 6 Det Art 10100 Cash on Hand 7 10200 Regular Checking Account $2,275.23 8 10300 Payroll Checking Account $557,125 92 9 10400 Savings Account 10 11000 Accounts Receivable $3,645,599.15 11 $61,515.259.98 11400 Other Receivables $1,250,000.00 12 11500 Allowance for Doubtful Accounts 13 12000 Inventory $67,724,527.50 14 12300 Reserve for inventory Obsolescence 15 14100 Prepaid in urance $3,424,213.78 16 14200 Prepaid Rent 17 14300 Office Supplies $8,540.00 18 14400 Notes Receivable Current 19 14700 Other Qurrent Assets 20 15000 Land $117.000.00 15100 Buildings and Land improvements $674,313.92 15200 Machinery, Equipment Office Furniture $2.929,097.13 23 17000 Accum. Depreciation 24 19000 Investments $1.998,780 39 25 19900 Other Noncurrent Assets $53.840.59 26 20000 Accounts Payable 27 23100 Sales Tax Payable 28 23200 Wages Payable 29 23300 FICA Employee Wholding 30 23350 Medicare Withholding 31 23400 Federal Payroll Taxes Payable 32 23500 PUTA Tax Payable 33 23600 State Payroll Taxes Payable 34 23700 SUTA Tax Payable 35 23800 FICA Employer Withholding 26 2016 Trial Balance 2017 Trial Balance Ready Calculate $609,500.00 $1,922,095.91 $8,439.65 $11.414.99 5118,086.12 $55,106.86 $8,439.65 RELE + A A B C D $11414.99 $118.086.12 $55,106.86 $8.439.65 $11.414.99 $44.403,000.00 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 $12,000,000.00 $8,105,000.00 $7.423,000.00 $6,590,983.64 $242,713,452.88 23350 Medicare Wehoking 23400 Federal Payroll Taxes Payable 23500 FUTA Tax Payable 23600 State Payroll Taxes Payable 23700 SUTA Tax Payable 23800 FICA Employer Withholding 23900 Medicare Employer Withholding 24100 Line of Credit 24200 Current Portion Long-Term Debt 24700 Other Current Liabides 27000 Notes Payable-Noncurrent 39003 Common Stock 39004 Paid-in Capital 39005 Retained Earnings 40000 Sales - Spotlight 41000 Sales Returns 42000 Warranty Expense 45000 Income from Investments 46000 Interest Income 47000 Miscellaneous Income 50010 Cost of Goods Sold 57500 Freight 60000 Advertising Expense 61000 Auto Expenses 62000 Research and Development 64000 Depreciation Expense 64500 Warehouse Salaries 65000 Property Tax Expense GEOCOLAORLand Professional Expense 2016 Trial Balance 2017 Trial Balance Ready Calculate $11,100 220.89 $1,158,128.47 $1,426,089.31 $131.881.46 $2,166,000.00 $130,196,645 26 $4,240,263.09 $1,036,854.01 $210.502.80 $528,870.44 $446,000.00 $4,720,715.56 $99,332.45 $49133224.45 a Ma D $2,166,000.0 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 $130,196,645 26 $4240,263.09 $1,036 85401 $210,502 80 $528 87044 $446,000.00 $4,720,715.56 $99,332.45 $4913 224 45 A B 47000 Miscelous Income 50010 Cost of Goods Sold 67500 Freight 60000 Advertising Experise 61000 Auto Expenses 62000 Research and Development 64000 Depreciation Experise 64500 Warehouse Salaries 65000 Property Tax Expense 66000 Legal and Professional Expense 67000 Bad Debt Expense 68000 Insurance Expense 70000 Maintenance Expense 70100 Utilities 70110 Phone 70120 Postal 71000 Miscellaneous Oice Expense 72000 Payroll Tax Exp 73000 Pension Prote-Sharing Plan Ex 74000 Rent or Lease Expense 77500 Administrative Wages Expense 78000 Interest Expense 78500 Income Tax Expense - Federal 78510 Income Tax Expense - State $36,106.92 $35,502.87 $137,332.18 $52,599.02 $77,803.61 $24,891.82 $1,577 811.85 $3,300,000.00 $1,206,574.00 $16,197 22543 $2,591,736.50 $8,900,000.00 $3,100,000.00 $329,788,915 21 70 $329.788.915 21 71 72 73 74 75 76 77 2017 Trial Balance 2016 Trial Balance Calculate Ready M
