In: Accounting
Financial Statements and Closing Entries The Gorman Group is a financial planning services firm owned and operated by Nicole Gorman. As of October 31, 2018, the end of the fiscal year, the accountant for The Gorman Group prepared an end-of-period spreadsheet, part of which follows: The Gorman Group End-of-Period Spreadsheet For the Year Ended October 31, 2018 Adjusted Trial Balance Account Title Dr. Cr. Cash $15,460 Accounts Receivable 33,660 Supplies 5,260 Prepaid Insurance 11,360 Land 120,000 Buildings 430,000 Accumulated Depreciation-Buildings 140,100 Equipment 311,000 Accumulated Depreciation-Equipment 182,500 Accounts Payable 39,820 Salaries Payable 3,950 Unearned Rent 1,790 Common Stock 179,000 Retained Earnings 332,360 Dividends 29,900 Service Fees 567,820 Rent Revenue 6,000 Salaries Expense 407,070 Depreciation Expense-Equipment 22,100 Rent Expense 18,500 Supplies Expense 13,100 Utilities Expense 11,840 Depreciation Expense-Buildings 7,890 Repairs Expense 6,520 Insurance Expense 3,580 Miscellaneous Expense 6,100 1,453,340 1,453,340 Required: 1. Prepare an income statement. The Gorman Group Income Statement For the Year Ended October 31, 2018 Revenues: Total Revenues Expenses: Total Expenses Net income Prepare a Retained Earnings Statement. The Gorman Group Retained Earnings Statement For the Year Ended October 31, 2018 Prepare a balance sheet. The Gorman Group Balance Sheet October 31, 2018 Assets Liabilities Current assets: Current liabilities: Total liabilities Total current assets Property, plant, and equipment: Stockholders' Equity Total property, plant, and equipment Total stockholders' equity Total assets Total liabilities and stockholders' equity
Given Data | ||||
Cash | $ 15,460.00 | Accumulated Depreciation -Building | $ 140,100.00 | |
Accounts Receivable | $ 33,660.00 | Service Fees | $ 567,820.00 | |
Supplies | $ 5,260.00 | Accumulated Depreciation -Equipment | $ 182,500.00 | |
Prepaid Insurance | $ 11,360.00 | Accounts Payable | $ 39,820.00 | |
Land | $ 120,000.00 | Salary Payable | $ 3,950.00 | |
Building | $ 430,000.00 | Unearned Rent | $ 1,790.00 | |
Dividend | $ 29,900.00 | Common Stock | $ 179,000.00 | |
Salary Expenses | $ 407,070.00 | Retained Earnings | $ 332,360.00 | |
Depreciation Expenses -Equipment | $ 22,100.00 | Rent Revenue | $ 6,000.00 | |
Rent Expenses | $ 18,500.00 | |||
Insurance Expenses | $ 3,580.00 | |||
Equipment | $ 311,000.00 | |||
Supplies Expenses | $ 13,100.00 | |||
Utilities Expenses | $ 11,840.00 | |||
Depreciation Expense-Building | $ 7,890.00 | |||
Repair Expenses | $ 6,520.00 | |||
Miscellaneous Expenses | $ 6,100.00 | |||
Total | $ 1,453,340.00 | Total | $ 1,453,340.00 | |
a) | The GORMAN GROUP | |||
INCOME STATEMENT | ||||
FOR THE MONTH OF October 31st,2018 | ||||
Revenue | ||||
Service Fees | $ 567,820.00 | |||
Rent Revenue | $ 6,000.00 | |||
Expenses | ||||
Supplies Expenses | $ 13,100.00 | |||
Rent Exepnses | $ 18,500.00 | |||
Salary Expenses | $ 407,070.00 | |||
Utilities Expenses | $ 11,840.00 | |||
Insurance Expenses | $ 3,580.00 | |||
Repair Expenses | $ 6,520.00 | |||
Miscellaneous Expenses | $ 6,100.00 | |||
Depreciation Expense-Building | $ 7,890.00 | |||
Depreciation Expenses -Equipment | $ 22,100.00 | |||
Total Expenses | $ 496,700.00 | |||
Net Income | $ 77,120.00 | |||
The GORMAN GROUP | ||||
RETAINED EARNINGS STATEMENT | ||||
FOR THE MONTH OF October 31st,2018 | ||||
Opening retained Earnings | $ 332,360.00 | |||
Net Income | $ 77,120.00 | |||
Less : Dividend Paid | $ 29,900.00 | |||
Retained Earnings on October 31st | $ 379,580.00 | |||
The GORMAN GROUP | ||||
BALANCE SHEET | ||||
AT Cotober 31st,2018 | ||||
ASSETS | ||||
Cash | $ 15,460.00 | |||
Accounts Receivable | $ 33,660.00 | |||
Supplies | $ 5,260.00 | |||
Prepaid Insurance | $ 11,360.00 | |||
Land | $ 120,000.00 | |||
Equipment | $ 311,000.00 | |||
Building | $ 430,000.00 | |||
Total Assets | $ 926,740.00 | |||
LIABILITIES & STOCK HOLDER's EQUITY | ||||
Liabilities | ||||
Accounts Payable | $ 39,820.00 | |||
Salary Payable | $ 3,950.00 | |||
Unearned Rent | $ 1,790.00 | |||
Accumulated Depreciation-Building | $ 140,100.00 | |||
Accumulated Depreciation-Equipment | $ 182,500.00 | |||
Total Liabilities | $ 368,160.00 | |||
Shareholder's Equity | ||||
Common Stock | $ 179,000.00 | |||
Reatined Earnings | $ 379,580.00 | |||
Total Shareholder's Equity | $ 558,580.00 | |||
Total Liabilities & Stockholder's Equity | $ 926,740.00 | |||