In: Accounting
Prepare the worksheet, income statement, statement of owner's equity and balance sheet using the following information.
Account Balances of Cross Lumber
Account No. | ||
110 | Cash | 1300 |
111 | Accounts Receivable | 1280 |
112 | Merchandise Inventory | 4300 |
113 | Lumber Supplies | 267 |
114 | Prepaid Insurance | 209 |
121 | Lumber Equipment | 3300 |
122 | Acc. Dep. Lumber Equipment | 530 |
220 | Accounts Payable | 1200 |
221 | Wages Payable | - |
330 | J. Cross, Capital | 5761 |
331 | J. Cross, Withdrawls | 2700 |
332 | Income Summary | - |
440 | Sales | 23200 |
441 | Sales Returns and Allowances | 230 |
550 | Purchases | 14500 |
551 | Purchases Discount | 325 |
552 | Purchases Returns and Allowances | 340 |
660 | Wages Expense | 2120 |
661 | Advertising Expense | 370 |
662 | Rent Expense | 780 |
663 | Dep. Exp., Lumber Equipment | - |
664 | Lumber Supplies Expense | - |
665 | Insurance Expense | - |
a./b. Merchandise inventory, Dec. 31 $4700
c. Lumber supplies on hand, Dec. 31 $75
d. Insurance expired $120
e. Depreciation for the year $210
f. Accrued wages on Dec. 31 $135
CROSS LUMBER | ||
Income Statement | ||
For the Period Ended Dec 31 | ||
Sales Revenue | ||
Sales | 23,200.00 | |
Less: Sales Return and Allowances | 230.00 | |
Net Sales | 22,970.00 | |
Cost of Goods Sold: | ||
Purchases | 14,500.00 | |
Less: Purchases Discount | 325.00 | |
Less: Purchases Return and Allowances | 340.00 | |
Net Purchases | 13,835.00 | |
Add: Beginnig Inventory | 4,300.00 | |
Cost of Goods Available for Sale | 18,135.00 | |
Less: Ending Inventory | 4,700.00 | |
Cost of Goods Sold | 13,435.00 | |
Gross Profit | 9,535.00 | |
Selling & Admn. Expenses | ||
Wages Expense ($2,120 + $135) | 2,255.00 | |
Advertising Expense | 370.00 | |
Rent Expense | 780.00 | |
Depreciation Expense - Lumber Equipment | 210.00 | |
Lumber Supplies Expense ($267 - $75) | 192.00 | |
Insurance Expense | 120.00 | 3,927.00 |
Net Income | 5,608.00 | |
CROSS LUMBER | ||
Statement of Owners' Equity | ||
For the Period Ended Dec 31 | ||
J. Cross, Capital - Beginning Balance | 5,761.00 | |
Net Income | 5,608.00 | |
J. Cross, Withdrawls | (2,700.00) | |
Net Increase (Decrease) in Net Income | 2,908.00 | |
J. Cross, Capital - Ending Balance | 8,669.00 | |
CROSS LUMBER | ||
Balance Sheet | ||
Dec 31 | ||
Assets | ||
Current Assets | ||
Cash | 1,300.00 | |
Accounts Receivable | 1,280.00 | |
Merchandise Inventory | 4,700.00 | |
Lumber Supplies | 75.00 | |
Prepaid Insurance ($209 - $120) | 89.00 | 7,444.00 |
Property, Plant & Equipment | ||
Lumber Equipment | 3,300.00 | |
Less: Acc. Dep. Lumber Equipment | 740.00 | 2,560.00 |
Total Assets | 10,004.00 | |
Liabilities & Owners' Equity | ||
Liabilities | ||
Current Liabilities | ||
Accounts Payable | 1,200.00 | |
Wages Payable | 135.00 | 1,335.00 |
Total Liabilities | 1,335.00 | |
Owners' Equity | ||
J. Cross, Capital | 8,669.00 | |
Total Liabilities & Owners' Equity | 10,004.00 |