all that needs to be done is the general journal tab, multiple step insome statement tab, sing step income statement tab, balence sheet tab and ratio tab. thank you in advance!
The fiscal year-end unadjusted trial balance for Adams Company is found on the trial balance tab. Rent expense and salaries expense are equally divided between selling activities and general and administrative activities. Adams Company uses a perpetual inventory system. Descriptions of items that require adjusting entries on January 31, 2019, follow. a. Store supplies still available at fiscal year-end amount to $2,350, b. Expired insurance, an administrative expense, for the fiscal year is $1,640, c. Depreciation expense on store equipment, a selling expense, is $6,100 for the fiscal year. d. To estimate shrinkage, a physical count of ending merchandise inventory is taken. It shows $10,430 of inventory is still available at fiscal year-end. Requirement General Journal General Ledger Trial Balance Multiple Step IS Single Step IS Balance Sheet Ratios For transactions 1-4 prepare the required adjusting Journal entries. For transactions 5-8, prepare the required closing entries. View transaction list View journal entry worksheet Date Account Title Credit No 1 Debit 2,350 Jan 31 Store supplies expenso Store supplies 2,350 2 Jan 31 1,640 Insurance expense Prepaid insurance Anret ARARAR No Date Account Title Debit Credit 1 Jan 31 Store supplies expense Store supplies 2,350 2,350 2 Jan 31 Insurance expense 1,640 Prepaid insurance 3 Jan 31 6,100 Depreciation expense - Store equip. Accumulated depreciation - Store equip 6,100 4 Jan 31 Cost of goods sold Merchandise inventory 10,430 10,430 General Ledger Account Cash Merchandise inventory Debit Credit No. Debit Credit No. Date Jan 31 Balance 15,650 Date Jan 31 Jan 31 Balance 11,100 670 10,430 Prepaid insurance Store supplies Debit Credit No. No. Debit Credit Date Jan 31 Jan 31 Balance 7,050 4,700 Date Jan 31 Balance 2,600 2 1 2,350 Store equipment Accumulated depreciation - Store equip. No. Debit Credit No. Debit Credit Date Jan 31 Balance 61,000 Date Jan 31 Jan 31 Balance 27,450 33,550 3 6,100 Common stock Accounts payable Debit Credit No. Balance No. Debit Credit Date Jan 31 Date Jan 30 Balance 7,400 12,400 Dividends Retained earnings Debit Credit No. No. Date Debit Credit Balance Date Jan 31 Balance 30,600 Jan 31 4,600 Sales Salos discounts No. Debit Credit No. Debit Credit Date Jan 31 Balance 124,000 Date Jan 31 Balance 3,700 Cost of goods sold No. Sales returns and allowances Date Debit Credit Jan 31 No. Date Debit Credit Balance 3,900 Jan 31 Jan 31 Balance 37,000 47,430 4 10,430 Depreciation expense - Store equip. Date Debit Credit Jan 31 Jan 31 6.100 No. Salaries expense Debit Credit No. Balance 0 6,100 Date Jan 31 Balance 32,000 3 Insurance expense Rent expense No. Date Debit Credit No. Date Debit Credit Balance 0 1,640 Balance 12,800 Jan 31 Jan 31 Jan 31 2 1,640 Store supplies expense Debit Credit Advertising expense Debit Credit No. No. Date Jan 31 Jan 31 Balance 0 2,350 Date Jan 31 Balance 10,450 1 2.350 Adams company Trial Balance January 31, 2019 Account Title Debit Credit $ 15,650 670 4,700 2,600 61,000 33,550 12,400 7,400 30,600 4,600 Cash Merchandise inventory Store supplies Prepaid insurance Store equipment Accumulated depreciation - Store equip. Accounts payable Common stock Retained earnings Dividends Sales Sales discounts Sales returns and allowances Cost of goods sold Depreciation expense - Store equip. Salaries expense Insurance expense Rent expense Store supplies expense Advertising expense Total 124,000 f 1 1 1 3,700 3.900 47.430 6.100 32,000 1,640 12,800 2,350 10,450 209.590/S Is 207.950 Adjusted Adams Company Income Statement For Year Ended January 31, 2019 $ 0 $ 0 0 Net sales 0 0 0 Gross profit 0 a. Store supplies still available at fiscal year-end amount to $2,350. b. Expired insurance, an administrative expense, for the fiscal year is $1.640. c. Depreciation expense on store equipment, a selling expense, is $6,100 for the fiscal year. d. To estimate shrinkage, a physical count of ending merchandise inventory is taken. It shows $10,430 of inventory is still available at fiscal year-end. General General Requirement Trial Balance Multiple Step Single Step Is Balance Sheet Ratios Journal Ledger A single-step income statement yields the same net income, but does not show the same level of detail/subtotals as the multiple-step income statement. Use the information from the multiple-step income statement to complete the single-step income statement below. Adjusted Adams Company Income Statement For Year Ended January 31, 2019 Revenues: $ 0 $ 0 Net sales Expenses: Cost of goods sold Total selling expenses Total general and administrative expenses Total expenses Not income 0 0 0 Prepare a classified balance sheet as of January 31, 2017. Adjusted Adams Company Balance Sheet January 31, 2019 Assets Current Assets $ 0 0 0 0 0 Plant assets $ 0 0 Total assets Liabilities and Equity Liabilities $ 0 0 0 0 Plant assets $ $ 0 0 Total assets Liabilities and Equity Liabilities $ 0 0 Equity $ 0 (4,600) Total liabilities and equity (4,600) (4,600) $ Rent expense and salaries expense are equally divided between selling activities and general and administrative activities. Adams Company uses a perpetual inventory system. Descriptions of items that require adjusting entries on January 31, 2019, follow. a. Store supplies still available at fiscal year-end amount to $2,350. b. Expired insurance, an administrative expense, for the fiscal year is $1.640. c. Depreciation expense on store equipment, a selling expense, is $6,100 for the fiscal year. d. To estimate shrinkage, a physical count of ending merchandise inventory is taken. It shows $10,430 of inventory is still available at fiscal year-end. Ratios General Requirement General Multiple Step Singie Step Is Balance Sheet Joumal Trial Balance Ledger Compute the following ratios as of January 31, 2017. Round each ratio to 2 decimal places. Dates: Jan 31 Current ratio Acid-test ratio Gross margin ratio to: Jan 31 Balance Sheet