In: Accounting
Question: Prepare a classified income statement for the year ended December 31, 2019. The expense accounts represent warehouse expenses, selling expenses, and general and administrative expenses.
Prepare a statement of owner’s equity for the year ended December 31, 2019. No additional investments were made during the period.
Prepare a classified balance sheet as of December 31, 2019. The mortgage payable extends for more than one year.
Cash |
$ |
98,400 |
||||
Petty Cash Fund |
600 |
|||||
Notes Receivable, due 2020 |
12,000 |
|||||
Accounts Receivable |
139,600 |
|||||
Allowance for Doubtful Accounts |
$ |
3,200 |
||||
Interest Receivable |
120 |
|||||
Merchandise Inventory |
127,900 |
|||||
Warehouse Supplies |
2,700 |
|||||
Office Supplies |
640 |
|||||
Prepaid Insurance |
4,040 |
|||||
Land |
15,400 |
|||||
Building |
104,000 |
|||||
Accumulated Depreciation—Building |
16,400 |
|||||
Warehouse Equipment |
19,200 |
|||||
Accumulated Depreciation—Warehouse Equipment |
9,200 |
|||||
Office Equipment |
8,800 |
|||||
Accumulated Depreciation—Office Equipment |
3,600 |
|||||
Notes Payable, due 2020 |
14,400 |
|||||
Accounts Payable |
56,300 |
|||||
Interest Payable |
340 |
|||||
Loans Payable—Long-Term |
14,000 |
|||||
Mortgage Payable |
17,000 |
|||||
Colin O’Brien, Capital (Jan. 1) |
321,020 |
|||||
Colin O’Brien, Drawing |
70,050 |
|||||
Income Summary |
130,800 |
127,900 |
||||
Sales |
1,098,300 |
|||||
Sales Returns and Allowances |
7,800 |
|||||
Interest Income |
520 |
|||||
Purchases |
457,000 |
|||||
Freight In |
9,200 |
|||||
Purchases Returns and Allowances |
13,050 |
|||||
Purchases Discounts |
8,640 |
|||||
Warehouse Wages Expense |
108,000 |
|||||
Warehouse Supplies Expense |
5,200 |
|||||
Depreciation Expense—Warehouse Equipment |
2,800 |
|||||
Salaries Expense—Sales |
151,100 |
|||||
Travel Expense |
23,400 |
|||||
Delivery Expense |
36,825 |
|||||
Salaries Expense—Office |
84,400 |
|||||
Office Supplies Expense |
1,160 |
|||||
Insurance Expense |
9,275 |
|||||
Utilities Expense |
7,400 |
|||||
Telephone Expense |
3,220 |
|||||
Payroll Taxes Expense |
31,000 |
|||||
Building Repairs Expense |
3,100 |
|||||
Property Taxes Expense |
15,800 |
|||||
Uncollectible Accounts Expense |
2,980 |
|||||
Depreciation Expense—Building |
5,000 |
|||||
Depreciation Expense—Office Equipment |
1,560 |
|||||
Interest Expense |
3,400 |
|||||
Totals |
$ |
1,703,870 |
$ |
1,703,870 |
Income Statement | ||||
For the year ended December 31, 2019 | ||||
Operating revenue | ||||
Sales | 1,098,300 | |||
Less: Sales returns | (7,800) | |||
Net sales | 1,090,500 | |||
Cost of goods sold | ||||
Opening stock | 130,800 | |||
Purchases | 457,000 | |||
Freight in | 9,200 | |||
Delivered cost of purchases | 466,200 | |||
Purchase returns | (13,050) | |||
Purchase discounts | (8,640) | |||
Net delivered cost of purchase | 444,510 | |||
Total merchandise of sale | 575,310 | |||
Less: Closing stock | (127,900) | |||
Cost of goods sold | 447,410 | |||
Gross profit on sales | 643,090 | |||
Operating expenses | ||||
Warehouse expenses | ||||
Warehouse wages expense | 108,000 | |||
Warehouse supplies expense | 5,200 | |||
Depreciation expense—Warehouse equipment | 2,800 | |||
Total warehouse expenses | 116,000 | |||
Selling expenses | ||||
Salaries expense—Sales | 151,100 | |||
Travel and entertainment expense | 23,400 | |||
Delivery wages expense | 36,825 | |||
Total selling expenses | 211,325 | |||
General and administrative expenses | ||||
Salaries expense—Office | 84,400 | |||
Office supplies expense | 1,160 | |||
Insurance expense | 9,275 | |||
Utilities expense | 7,400 | |||
Telephone expense | 3,220 | |||
Payroll taxes expense | 31,000 | |||
Building repairs expenses | 3,100 | |||
Property taxes expense | 15,800 | |||
Uncollectible accounts expense | 2,980 | |||
Depreciation expense—Building | 5,000 | |||
Depreciation expense—Office equipment | 1,560 | |||
Total general and administrative exp. | 164,895 | |||
Total operating expenses | 492,220 | |||
Income from operations | 150,870 | |||
Other Income | ||||
Interest Income | 520 | |||
Other expenses | ||||
Interest expenses | (3,400) | |||
Net Non operating expenses | (2,880) | |||
Net Income for the year | 147,990 | |||
Statement of Owner's Equity | ||||
For the year ended December 31, 2019 | ||||
Colin O’Brien, Capital, January 1, 2019 | 321,020 | |||
Net income for year | 147,990 | |||
Less: Withdrawals for year | 70,050 | |||
Increase in capital | 77,940 | |||
Colin O’Brien, Capital, December 31, 2019 | 398,960 | |||
Balance Sheet | ||||
December 31, 2019 | ||||
Assets | ||||
Current assets | ||||
Cash | 98,400 | |||
Petty cash fund | 600 | |||
Notes receivable | 12,000 | |||
Accounts receivable | 139,600 | |||
Less: Allowance for doubtful accounts | (3,200) | 136,400 | ||
Interest Receivable | 120 | |||
Merchandise inventory | 127,900 | |||
Prepaid expenses | ||||
Warehouse supplies | 2,700 | |||
Office supplies | 640 | |||
Prepaid insurance | 4,040 | |||
7,380 | ||||
Total current assets | 382,800 | |||
Plant and equipment | ||||
Land | 15,400 | |||
Building | 104,000 | |||
Less: Accumulated depreciation | (16,400) | 87,600 | ||
Warehouse equipment | 19,200 | |||
Less: Accumulated depreciation | (9,200) | 10,000 | ||
Office equipment | 8,800 | |||
Less: Accumulated depreciation. | (3,600) | 5,200 | ||
Total plant and equipment | 118,200 | |||
Total assets | 501,000 | |||
Liability and Owner’s Equity | ||||
Current liabilities | ||||
Notes payable | 14,400 | |||
Accounts payable | 56,300 | |||
Interest payable | 340 | |||
Total current liabilities | 71,040 | |||
Long-term liabilities | ||||
Mortgage payable | 17,000 | |||
Loans payable | 14,000 | |||
Total long term liabilities | 31,000 | |||
Total liabilities | 102,040 | |||
Owner's Equity | ||||
Colin O’Brien, Capital | 398,960 | |||
Total Liability and Owner’s Equity | 501,000 | |||