Question

In: Accounting

The Gorman Group End-of-Period Spreadsheet For the Year Ended October 31, 2019 Adjusted Trial Balance Account...

The Gorman Group
End-of-Period Spreadsheet
For the Year Ended October 31, 2019
Adjusted Trial Balance
Account Title Dr. Cr.
Cash $18,230
Accounts Receivable 39,680
Supplies 6,200
Prepaid Insurance 13,390
Land 141,000
Buildings 507,000
Accumulated Depreciation-Buildings 165,200
Equipment 366,000
Accumulated Depreciation-Equipment 215,100
Accounts Payable 46,930
Salaries Payable 4,650
Unearned Rent 2,110
Nicole Gorman, Capital 601,760
Nicole Gorman, Drawing 35,200
Service Fees 669,290
Rent Revenue    7,070
Salaries Expense 479,820
Depreciation Expense—Equipment 26,000   
Rent Expense 21,800   
Supplies Expense 15,440
Utilities Expense 13,950
Depreciation Expense—Buildings 9,300
Repairs Expense 7,690
Insurance Expense 4,220
Miscellaneous Expense 7,190
1,712,110 1,712,110

Required:

1. Prepare an income statement.

Gorman Group
Income Statement
For the Year Ended October 31, 2019
Revenues:
$
Total revenues $
Expenses:
$
Total expenses
Net income $

Prepare a statement of owner's equity (no additional investments were made during the year.)

Gorman Group
Statement of Owner's Equity
For the Year Ended October 31, 2019
$
$
$

Prepare a balance sheet.

Gorman Group
Balance Sheet
October 31, 2019
Assets Liabilities
Current assets: Current liabilities:
$ $
Total liabilities $
Total current assets $
Property, plant, and equipment: Owner's Equity
$
Total property, plant, and building
Total assets $ Total liabilities and owner's equity $

2. Journalize the entries that were required to close the accounts at October 31. For a compound transaction, if an amount box does not require an entry, leave it blank.

Date Account Debit Credit
Oct. 31
Oct. 31

3. If the balance of Nicole Gorman, Capital had instead increased $115,000 after the closing entries were posted and the withdrawals remained the same, what would have been the amount of net income or net loss?
$

Solutions

Expert Solution

1. Gorman Group

Income Statement

For the year ended October 31, 2019

$ $
Revenues
Service Fees 669,290
Rent Revenue 7,070
Total Revenues 676,360
Expenses
Salaries Expense 479,820
Depreciation Expense : Equipment 26,000
Rent Expense 21,800
Supplies Expense 15,440
Utlities Expense 13,950
Depreciation Expense : Buildings 9,300
Repairs Expense 7,690
Insurance Expense 4,220
Miscellaneous Expense 7,190
Total Expense 585,410
Net Income 90,950

Gorman Group

Statement of Owners' Equity

For the year ended October 31, 2019

$
Nicole Gorman, Capital, November 1, 2018 601,760
Net Income $ 90,950
Less: Nicole Gorman, Drawing 35,200 55,750
Nicole Gorman, Capital, October 31, 2019 657,510

Gorman Group

Balance Sheet

October 31, 2019

Assets $ $ Liabilities and Owners' Equity $ $
Current Assets Current Liabilities
Cash 18,230 Accounts Payable 46,930
Accounts Receivable 39,680 Salaries Payable 4,650
Supplies 6,200 Unearned Rent 2,110
Prepaid Insurance 13,390 Total Current Liabilities 53,690
Total Current Assets 77,500

Property Plant and Equipment

Owners' Equity
Land 141,000 Nicole Gorman, Capital 657,510
Buildings 507,000
Accumulated Depreciation: Buildings (165,200)
Equipment 366,000
Accumulated Depreciation : Equipment (215,100)
Total Property Plant and Equipment 633,700
Total Assets 711,200 Total Liabilities and Owner's Equity 711,200

2.

Date Account Debits Credits
$ $
October 31 Service Fees 669,290
Rent Revenue 7,070
Income Summary 676,360
To close the revenue accounts
October 31 Income Summary 585,410
Salaries Expense 479,820
Depreciation Expense: Equipment 26,000
Rent Expense 21,800
Supplies Expense 15,440
Utilities Expense 13,950
Depreciation Expense: Buildings 9,300
Repairs Expense 7,690
Insurance Expense 4,220
Miscellaneous Expense 7,190
To close expense accounts
October 31 Income Summary 90,950
Nicole Gorman, Capital 90,950
To close income summary
October 31 Nicole Gorman, Capital 35,200
Nicole Gorman, Drawings 35,200
To close drawings account

3. Net income = $ 115,000 + $ 35,200 = $ 150,200


Related Solutions

The end of period spreadsheet is useful in preparing an Adjusted Trial Balance from which the...
The end of period spreadsheet is useful in preparing an Adjusted Trial Balance from which the three Financial Statements can be prepared. Please indicate the results in the adjusted Trial Balance under the following circumstances. Please provide an example. a. An account has a debit balance. The adjustment requires a credit to that account. The debit amount is higher than the credit amount. Is the result in the Adjusted Trial Balance a debit or credit? Please provide an example. b....
Wong PTY LTD Adjusted trial balance As at 31 October 2019 Account name Debit Credit Cash...
Wong PTY LTD Adjusted trial balance As at 31 October 2019 Account name Debit Credit Cash $15,400 Supplies 1,550 Equipment 5,000 Accumulated depreciation 40 Accounts payable 2,550 Salaries payable 2,000 Bank loan (non-current) 5,000 Share capital 10,000 Retained earnings 0 Dividends 500 Service revenue 10,600 Salaries expense 7,650 Interest expense 50 Depreciation expense 40 $30,190 $30,190 Required: Prepare a Profit or Loss Statement Prepare a Balance Sheet Based on the Profit or Loss Statement and Balance Sheet, calculate the following...
The following accounts were taken from the Adjusted Trial Balance columns of the end-of-period spreadsheet for...
The following accounts were taken from the Adjusted Trial Balance columns of the end-of-period spreadsheet for April 30, for Finnegan Co.: Accumulated Depreciation $32,000 Fees Earned 78,000 Depreciation Expense 7,250 Rent Expense 34,000 Prepaid Insurance 6,000 Supplies 400 Supplies Expense 1,800 ​ Prepare an income statement.
The following data were taken from the Adjusted Trial Balance columns of the end-of-period spreadsheet for...
The following data were taken from the Adjusted Trial Balance columns of the end-of-period spreadsheet for April 30 for Abigail Company: Accumulated Depreciation $42,400 Prepaid Rent 6,800 Supplies 850 Unearned Fees 7,310 Trucks 49,300 Cash 3,400 Common Stock 2,000 Retained Earnings ? ​ Prepare a classified balance sheet.
The following data were taken from the Adjusted Trial Balance columns of the end-of-period spreadsheet for...
The following data were taken from the Adjusted Trial Balance columns of the end-of-period spreadsheet for April 30 for Abigail Trucking: Accounts Amount Accounts Payable $42,600 Accounts Receivable 83,400 Accumulated Depreciation-Trucks 28,000 Cash ? Common Stock 100,000 Prepaid Insurance 6,500 Prepaid Rent 12,000 Retained Earnings 215,000 Salaries Payable 12,500 Trucks 206,000 Supplies 4,700 Unearned Fees 5,000 Required: Prepare a classified balance sheet. Be sure to complete the statement heading. Refer to the lists of Accounts in the information given, Labels,...
The following is Gaze Corporation year-end adjusted trial balance dated December 31, 2019. Gaze Co. Adjusted...
The following is Gaze Corporation year-end adjusted trial balance dated December 31, 2019. Gaze Co. Adjusted Trial Balance at 31 December 2019                                                                                 Debit                        Credit                          Cash                                                                        € 51,402                            Accounts receivable                                                 2,400                                 Office supplies                                                         600                                    Prepaid rent                                                             1,440                                 Office equipment                                                     64,800                               Accumulated depreciation: office equipment                                        € 42,300 Accounts payable                                                                                      1,680 Interest payable                                                                                           432 Income taxes payable                                                                               2,100 Unearned revenue                                                                                  10,800 Capital stock                                                                                           36,000 Retained earnings                                                                                     9,600 Dividends                                                               1,200                                 Consulting services revenue                                                                   72,000 Office supplies expense                                           726                                    Depreciation expense: office...
The following calendar year-end information is taken from the December 31, 2019, adjusted trial balance and...
The following calendar year-end information is taken from the December 31, 2019, adjusted trial balance and other records of Leone Company. Advertising expense $ 34,600 Direct labor $ 679,900 Depreciation expense—Office equipment 8,300 Income taxes expense 242,200 Depreciation expense—Selling equipment 10,900 Indirect labor 60,000 Depreciation expense—Factory equipment 30,800 Miscellaneous production costs 10,200 Factory supervision 100,300 Office salaries expense 72,000 Factory supplies used 9,000 Raw materials purchases 971,000 Factory utilities 31,000 Rent expense—Office space 21,000 Inventories Rent expense—Selling space 27,600 Raw...
The following calendar year-end information is taken from the December 31, 2019, adjusted trial balance and...
The following calendar year-end information is taken from the December 31, 2019, adjusted trial balance and other records of Leone Company. Advertising expense $ 31,000 Depreciation expense—Office equipment 9,500 Depreciation expense—Selling equipment 11,900 Depreciation expense—Factory equipment 37,150 Factory supervision 103,860 Factory supplies used (indirect materials) 8,600 Factory utilities 34,200 Direct labor 678,000 Indirect labor 61,800 Miscellaneous production costs 8,425 Office salaries expense 69,050 Raw materials purchases (direct) 927,500 Rent expense—Office space 23,800 Rent expense—Selling space 27,000 Rent expense—Factory building 81,600...
The following calendar year-end information is taken from the December 31, 2019, adjusted trial balance and...
The following calendar year-end information is taken from the December 31, 2019, adjusted trial balance and other records of Leone Company. Advertising expense $ 33,300 Direct labor $ 678,000 Depreciation expense—Office equipment 10,200 Income taxes expense 269,000 Depreciation expense—Selling equipment 9,700 Indirect labor 56,100 Depreciation expense—Factory equipment 33,400 Miscellaneous production costs 9,900 Factory supervision 116,400 Office salaries expense 67,000 Factory supplies used 9,600 Raw materials purchases 936,000 Factory utilities 31,000 Rent expense—Office space 27,000 Inventories Rent expense—Selling space 27,100 Raw...
The year-end adjusted trial balance of the Corporation included the following account balances:
  The year-end adjusted trial balance of the Corporation included the following account balances: Retained earnings $325,000 Service revenue 741,000 Salaries expense 396,000 Rent expense 27,000 Interest expense 5,000 Dividends 200,000 Prepare the closing entries. 34. $________   In preparing the closing entries for the temporary accounts, how much should Retained earnings be credited? 35. $________   In preparing the closing entries for the temporary accounts, how much should Retained earnings be debited? 36. $_________ After closing the accounts, what is the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT