Question: Part 1 Using the account listing in the appendix, you are to create standard financial statements for the corporation, namely: 1) Income Statement, 2) Retained
Part 1
Using the account listing in the appendix, you are to create standard financial statements for the corporation, namely: 1) Income Statement, 2) Retained Earnings Statement, 3) Statement of Stockholders Equity, and 4) Balance Sheet. Note: a Microsoft Excel spreadsheet of this data will be made available to you. Also, in preparation for the financial statements, you may want to prepare an unadjusted Trial Balance, as the data provided is pre-closing December 31, 2015.
| Fort Myers General Merchandise Co. | Data provided in Grey | ||
| Chart of Accounts and balances as of 12/31/2015 | |||
| Selected Balances provided as of 12/31/2014 | |||
| Balances | Selected Balances | ||
| Acct No. | Description | 12/31/2015 | 12/31/2014 |
| 1100 | Cash | 84,500 | 73,050 |
| 1120 | Accounts Receivable | 247,450 | 253,975 |
| 1150 | Merchandise Inventory | 550,000 | 383,475 |
| 1160 | Prepaid Insurance | 4,800 | 2,400 |
| 1170 | Store Supplies | 4,000 | 750 |
| 1230 | Store Equipment | 569,500 | |
| 1240 | Accumulated DepreciationStore Equipment | 70,700 | 56,700 |
| 2100 | Accounts Payable | 209,000 | 198,525 |
| 2110 | Salaries Payable | 47,750 | 42,625 |
| 2210 | Long-term Notes | 300,000 | 300,000 |
| 3100 | Common Stock (10,000 shares issued, $25 Par) | 250,000 | 250,000 |
| 3110 | Capital in Excess of Par Value | 100,000 | 100,000 |
| 3120 | Dividends Paid | 100,000 | |
| 3200 | Retained Earnings | 335,300 | 335,300 |
| 4100 | Sales | 5,032,350 | 4,225,135 |
| 4110 | Sales Returns and Allowances | 113,700 | 15,955 |
| 4120 | Sales Discounts | 61,600 | 35,455 |
| 5100 | Cost of Merchandise Sold | 3,012,150 | 2,300,422 |
| 5200 | Sales Salaries Expense | 727,800 | |
| 5210 | Advertising Expense | 292,000 | |
| 5220 | Depreciation Expense | 14,000 | |
| 5230 | Store Supplies Expense | 9,800 | |
| 5290 | Miscellaneous Selling Expense | 12,600 | |
| 5300 | Office Salaries Expense | 417,700 | |
| 5310 | Rent Expense | 88,700 | |
| 5320 | Insurance Expense | 12,000 | |
| 5390 | Miscellaneous Administrative Expense | 7,800 | |
| 5650 | Interest Expense | 15,000 | |
| Total Assets at 12/31/2014 | 1,125,138 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
