Question

In: Accounting

The adjusted trial balance data given below is from the Morgan Company’s worksheet for the year...

The adjusted trial balance data given below is from the Morgan Company’s worksheet for the year ended December 31, 2019. The expense accounts numbered 611-615 represent selling expenses, and those numbered 621-631 represent general and administrative expenses.

ACCT. ADJUSTED TRIAL
BALANCE
NO. ACCOUNT NAME DEBIT CREDIT
399 Income Summary 73,000 64,000
401 Sales 390,000
451 Sales Returns and Allowances 5,300
491 Interest Income 890
501 Purchases 195,000
502 Freight In 4,400
503 Purchases Returns and Allowances 3,000
504 Purchases Discounts 3,300
611 Sales Salaries Expense 68,000
613 Advertising Expense 3,500
615 Travel Expense 12,900
621 Office Salaries Expense 19,700
623 Office Supplies Expense 890
625 Utilities Expense 5,900
627 Payroll Taxes Expense 2,900
629 Uncollectible Accounts Expense 1,490
631 Depreciation Expense - Office Equipment 690
691 Interest Expense 3,000

Prepare a classified income statement for the year ended December 31, 2019.

Solutions

Expert Solution

Classified income statement for the year ended December 31, 2019, is as prepared below:

Morgan Company
Classified Income Statement
For the Year Ending December 31, 2019
Operating Income
Sales 390,000
Less sales return and allowances -5,300
Net Sales 384,700
Cost of goods sold
Merchandise Inventory Jan 1, 2019 73,000
Purchases 195,000
Freight In 4,400
Delivered Cost of Purchases 199,400
Less: purchase return and allowances -3,000
Purchase discounts -3,300
Net delivered Cost of purchases 193,100
Total merchandise available for sale 266,100
Less: Merchandise inventory December 31, 2019 -64,000
Cost of goods sold 202,100
Gross Profit on sales 182,600
Operating Expenses
Selling Expenses
Salaries expense-sales 68,000
Advertising expense 3,500
Travel Expense 12,900
    Total selling expenses 84,400
General and administrative expenses
Salaries exp-office 19,700
Office supplies expense 890
Utilities exp 5,900
Payroll tax expense 2,900
Uncollectible account expense 1,490
Dep exp-office equipment 690
    Total general and administrative exp 31,570
Total operating exp 115,970
Income from operations 66,630
Other Income
Interest income 890
Other Expenses
Interest expense 3,000
Net Non operating income -2,110
Net income of the year 64,520

Related Solutions

The adjusted trial balance data given below is from the Morgan Company’s worksheet for the year...
The adjusted trial balance data given below is from the Morgan Company’s worksheet for the year ended December 31, 2019. The expense accounts numbered 611-615 represent selling expenses, and those numbered 621-631 represent general and administrative expenses. ACCT.      ADJUSTED TRIAL BALANCE      NO.   ACCOUNT NAME      DEBIT      CREDIT      399   Income Summary      65,000      60,000      401   Sales            310,000      451   Sales Returns and Allowances      4,500            491   Interest Income     ...
Selected worksheet data for jane Freeman Company presented below: Trial Balance Adjusted Trial Balance Dr Cr...
Selected worksheet data for jane Freeman Company presented below: Trial Balance Adjusted Trial Balance Dr Cr Dr Cr Account Receivable ? 34000 Prepaid Insurance 26000 18000 Supplies 7000 ? Accumulated Depreciation 12000 ? Salaries payable ? 5000 Service Revenue 88000 95000 Insurance Expenses ? Depreciation Expenses 10000 Supplies Expenses 4000 Salaries Expenses ? 49000 Instructions: A)Fill in the missing amounts Trial Balance Adjusted Trial balance Dr Cr Dr Cr Account Receivable ? 34000 Prepaid Insurance 26000 18000 Supplies 7000 ?...
Below the Adjusted Trial Balance for Torr's Towing Services is given. Using the Adjusted Trial Balance...
Below the Adjusted Trial Balance for Torr's Towing Services is given. Using the Adjusted Trial Balance prepare the closing entries at June 30, 2019 (on a piece of paper) and select the correct answer to the questions asked about the closing entries. TORR'S TOWING SERVICES WORKSHEET FOR THE YEAR ENDED JUNE 30, 2019 ADJUSTED TRIAL BALANCE ACCOUNT TITLES DEBIT ($) CREDIT ($) Cash                  56,820.00 Accounts Receivable                  28,200.00 Towing Supplies                    9,000.00 Notes Receivable                    2,500.00 Land                 180,000.00...
Below the Adjusted Trial Balance for Torr's Towing Services is given. Using the Adjusted Trial Balance...
Below the Adjusted Trial Balance for Torr's Towing Services is given. Using the Adjusted Trial Balance prepare the closing entries at June 30, 2019 (on a piece of paper) and select the correct answer to the questions asked about the closing entries.     TORR'S TOWING SERVICES WORKSHEET   FOR THE YEAR ENDED JUNE 30, 2019 ADJUSTED TRIAL BALANCE ACCOUNT TITLES       DEBIT ($)   CREDIT ($)        Cash       56,820.00      Accounts Receivable       28,200.00      Towing Supplies       9,000.00     ...
Panther Marine Instructions: Using the "changes columns" from the adjusted trial balance worksheet AND the below...
Panther Marine Instructions: Using the "changes columns" from the adjusted trial balance worksheet AND the below additional information to create a statement of cash flows using the INDIRECT METHOD. Round all amounts to the nearest cent. The rest of the formatting is up to the student. Note that grades are based on organization and clarity of this financial statement. Other required items and additional information are: a. Only use accounts that have changes or cash flows b. Proper report title...
Given an adjusted trial balance how do you calculate profit and the total assets from the adjusted trial balance.
Given an adjusted trial balance how do you calculate profit and the total assets from the adjusted trial balance. There was also another thing she wanted to know, but I can't remember what it was. All she ever showed us how to do was fill out the balance sheet, income statement, and to close accounts. We only brushed over adjusted trial balances and then it was a main part of the test.  
The adjusted trial balance for Pharoah Company is given below. Pharoah Company Trial Balance August 31,...
The adjusted trial balance for Pharoah Company is given below. Pharoah Company Trial Balance August 31, 2020 Before Adjustment After Adjustment Dr. Cr. Dr. Cr. Cash $10,200 $10,200 Accounts Receivable 8,900 9,900 Supplies 2,300 600 Prepaid Insurance 3,800 2,700 Equipment 13,500 13,500 Accumulated Depreciation-Equipment $ 3,700 $ 4,500 Accounts Payable 5,800 5,800 Salaries and Wages Payable 0 1,400 Unearned Rent Revenue 1,400 800 Common Stock 11,200 11,200 Retained Earnings 3,600 3,600 Service Revenue 33,900 34,900 Rent Revenue 11,100 11,700 Salaries...
Balance Sheet from Adjusted Trial Balance The following is the alphabetical adjusted trial balance of the...
Balance Sheet from Adjusted Trial Balance The following is the alphabetical adjusted trial balance of the Meadows Company on December 31, 2016: Debits Credits Accounts Payable $ 9,800 Accounts Receivable $ 19,000 Accrued Payables 7,100 Accumulated Depreciation 44,000 Additional Paid-in Capital 50,600 Cash 7,900 Common Stock, $5 par 29,600 Cost of Goods Sold 179,500 Current Portion of Long-Term Debt 6,200 Deferred Taxes Payable 12,500 Dividends Distributed 7,000 General Expenses 27,560 Income Tax Expense 12,340 Income Taxes Payable 7,500 Interest Expense...
Create a balance sheet The adjusted trial balance columns of the worksheet for Ayayai Company are...
Create a balance sheet The adjusted trial balance columns of the worksheet for Ayayai Company are as follows. Ayayai Company Worksheet (Partial) For the Month Ended April 30, 2019 Adjusted Trial Balance Account Titles Dr. Cr. Cash 11,500 Accounts Receivable 7,620 Prepaid Rent 2,180 Equipment 22,950 Accumulated Depreciation—Equip. 5,000 Notes Payable 5,800 Accounts Payable 4,500 Common Stock 20,500 Retained Earnings 8,550 Dividends 3,500 Service Revenue 15,500 Salaries and Wages Expense 10,800 Rent Expense 700 Depreciation Expense 600 Interest Expense 60...
Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and...
Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and balance sheet included with the data below. Also, create a pivot table. Create a general ledger, worksheet, income statement, changes in retained earnings, and balance sheet with the data below. June 1: Hudson Bloom invested $105,273.00 cash and computer equipment with a fair market value of $32,970.00 in his new business, Byte of Accounting. June 1:   Check # 5000 was used to purchased office...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT