In: Accounting
The following accounts appear in the ledger of Celso and Company as of June 30, the end of this fiscal year.
Cash | $ 15,349 |
Accounts Receivable | 13,810 |
Merchandise Inventory | 50,280 |
Store Supplies | 1,935 |
Prepaid Insurance | 1,385 |
Store Equipment | 18,640 |
Accumulated Depreciation, Store Equipment | 6,882 |
Accounts Payable | 10,065 |
B. E. Celso, Capital | 96,524 |
B. E. Celso, Drawing | 30,000 |
Sales | 208,030 |
Sales Returns and Allowances | 1,740 |
Purchases | 133,050 |
Purchases Returns and Allowances | 4,295 |
Purchases Discounts | 3,853 |
Freight In | 8,350 |
Wages Expense | 35,400 |
Advertising Expense | 7,710 |
Rent Expense | 12,000 |
The data needed for the adjustments on June 30 are as follows: | |
a-b. | Merchandise inventory, June 30, $54,600. |
c. | Insurance expired for the year, $475. |
d. | Depreciation for the year, $4,380. |
e. | Accrued wages on June 30, $1,492. |
f. | Supplies on hand at the end of the year, $100. |
Required: | |
1. | Prepare a work sheet for the fiscal year ended June 30. |
2. | Prepare an income statement. |
3. | Prepare a statement of owner’s equity. No additional investments were made during the year. |
4. | Prepare a balance sheet. |
5. | Journalize the adjusting entries. |
6. | Journalize the closing entries. |
7. | Journalize the reversing entry as of July 1, for the wages that were accrued in the June adjusting entry. |
Answer to Question 1:
Work Sheet for the fiscal year ended:
Celso & Co. for the year ended 20xx
Income Statement | Balance Sheet | |||
Account Name | Debit | Credit | Debit | Credit |
Cash | $15349 | |||
Account Receivable | $13810 | |||
Merchandise Inventory | $50280 | |||
Store Supplies | $1935 | |||
Prepaid Insurance | $1385 | |||
Store Equipment | $18640 | |||
Acc.Dep'n, Store Equipment |
$6882 | |||
Account Payable | $10065 | |||
B.E.Celso, Capital | $96524 | |||
B.E.Celso, Drawing | $30000 | |||
Sales | $208030 | |||
Sales Return and Allowances | $1740 | |||
Purchase | $133050 | |||
Purchase Return and Allowances | $4295 | |||
Purchase Discount | $3853 | |||
Freight in | $8350 | |||
Wages Expense | $35400 | |||
Accrued Wages | $1492 | $1492 | ||
Advertising Expense | $7710 | |||
Rent Expenses | $12000 | |||
Depreciation | $4380 | $4380 | ||
Income Summary | $204122 | $216178 | ||
Net Income | $12056 | $12056 | ||
Total | $216178 | $216178 | ||
$131399 | $131399 | |||
Answer to Question 2:
Income Statement for the year ended, 20XX:
Particulars | Amount($) | Amount($) |
Revenue | ||
a) Sales | 208030 | |
b) Sales Return | (1740) | 206290 |
Total Revenue | 206290 | |
Expenses | ||
a) Advertising | 7710 | |
b) Rent | 12000 | |
c) Freight | 8350 | |
d) Cost of goods sold(net): Purchases | 133050 | |
Less:P. Returns & Discounts | (8148) | 124902 |
e) Depreciation | 4380 | |
f) Wages(35400+1492) | 36892 | |
Total Expenses(ii) | 194234 | |
Net Income before tax(i-ii) | 12056 | |
Less: Income tax expenses | ( -) | |
Income from Continuing Operation | 12056 |
Answer to Question 3:
Statement of Owner's Equity:
Particulars | Amount($) |
Opening Capital | 96524 |
Add: Investment durung the period | - |
Add: Net Income during the period | 12056 |
Less: Drawing during the perid | (30000) |
Celso & Co.'s Capital, June 30th | 78580 |
Answer to Question 4
Balance sheet as on June,20XX
Celso & Co.
Liabilities |
Amount($) | Amount($) | Assets | Amount($) | Amount($) |
Owner Capital | 78580 | Non Current Asset | |||
Account Payable | 10065 | Store Equipment | 18640 | ||
o.Wages | 1492 | Less: Acc. Dep'n | (6882+4380) | 7378 | |
Current Asset | |||||
Prepaid Insurance | 1385 | ||||
Store supplies | 1935 | ||||
Inventory | 50280 | ||||
Account Receivable | 13810 | ||||
cash | 15349 | ||||
Total | 90137 | Total | 90137 | ||
Answer to Question 7:
Reversing Entry:
Accrued Wages A/c Dr. 1492
To, Wages 1492