Question

In: Accounting

The following accounts appear in the ledger of Celso and Company as of June 30, the...

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.

Solutions

Expert Solution

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


Related Solutions

The following accounts and their balances appear in the ledger of Goodale Properties Inc. on June...
The following accounts and their balances appear in the ledger of Goodale Properties Inc. on June 30 of the current year: 1 Common stock, $45 par $3,042,000.00 2 Paid-In Capital from Sale of Treasury Stock 115,400.00 3 Paid-In Capital in Excess of Par-Common Stock 270,400.00 4 Retained Earnings 20,585,800.00 5 Treasury Stock 321,900.00 Prepare the Stockholders’ Equity section of the balance sheet as of June 30. Eighty thousand shares of common stock are authorized, and 8,700 shares have been reacquired....
The following accounts appear in the ledger of Sheldon Company on January 31, the end of...
The following accounts appear in the ledger of Sheldon Company on January 31, the end of this fiscal year. Cash $16,400 Accounts Receivable 15,100 Merchandise Inventory 55,500 Store Supplies 1,603 Prepaid Insurance 3,080 Store Equipment 24,900 Accumulated Depreciation, Store Equipment 3,860 Accounts Payable 14,400 M. E. Sheldon, Capital 126,484 M. E. Sheldon, Drawing 36,000 Sales 227,000 Sales Returns and Allowances 2,000 Purchases 172,000 Purchases Returns and Allowances 2,375 Purchases Discounts 3,567 Freight In 7,491 Wages Expense 24,800 Advertising Expense 5,912...
The ledger of Marco Rentals on 30 June 2019 includes the following selected accounts before adjusting...
The ledger of Marco Rentals on 30 June 2019 includes the following selected accounts before adjusting entries have been prepared: Debit $ Credit $ Prepaid insurance 28080 Supplies 16800 Equipment 195000 Accumulated depreciation—equipment 39000 Bank loan 156000 Rent revenue received in advance 72540 Rent revenue 468000 Wages expense 109200 An analysis of the accounts shows the following adjustments that need to be made: The equipment depreciates $3250 per month. The rent revenue received in advance was for 9 months commencing...
Payroll Accounts and Year-End Entries The following accounts, with the balances indicated, appear in the ledger...
Payroll Accounts and Year-End Entries The following accounts, with the balances indicated, appear in the ledger of Garcon Co. on December 1 of the current year: 211 Salaries Payable — 212 Social Security Tax Payable $11,628 213 Medicare Tax Payable 3,060 214 Employees Federal Income Tax Payable 18,870 215 Employees State Income Tax Payable 18,360 216 State Unemployment Tax Payable 1,938 217 Federal Unemployment Tax Payable 612 218 Bond Deductions Payable 4,000 219 Medical Insurance Payable 35,500 411 Operations Salaries...
Payroll Accounts and Year-End Entries The following accounts, with the balances indicated, appear in the ledger...
Payroll Accounts and Year-End Entries The following accounts, with the balances indicated, appear in the ledger of Codigo Co. on December 1 of the current year: 101 Salaries Payable — 102 Social Security Tax Payable $2,913 103 Medicare Tax Payable 728 104 Employees Federal Income Tax Payable 4,490 105 Employees State Income Tax Payable 4,078 106 State Unemployment Tax Payable 1,260 107 Federal Unemployment Tax Payable 360 108 Retirement Savings Deductions Payable 2,300 109 Medical Insurance Payable 2,520 201 Sales...
Payroll Accounts and Year-End Entries The following accounts, with the balances indicated, appear in the ledger...
Payroll Accounts and Year-End Entries The following accounts, with the balances indicated, appear in the ledger of Garcon Co. on December 1 of the current year: 211 Salaries Payable — 212 Social Security Tax Payable $17,328 213 Medicare Tax Payable 4,560 214 Employees Federal Income Tax Payable 28,120 215 Employees State Income Tax Payable 27,360 216 State Unemployment Tax Payable 2,888 217 Federal Unemployment Tax Payable 912 218 Bond Deductions Payable 7,000 219 Medical Insurance Payable 52,900 411 Operations Salaries...
Payroll Accounts and Year-End Entries The following accounts, with the balances indicated, appear in the ledger...
Payroll Accounts and Year-End Entries The following accounts, with the balances indicated, appear in the ledger of Codigo Co. on December 1 of the current year: 101 Salaries Payable — 102 Social Security Tax Payable $2,913 103 Medicare Tax Payable 728 104 Employees Federal Income Tax Payable 4,490 105 Employees State Income Tax Payable 4,078 106 State Unemployment Tax Payable 1,260 107 Federal Unemployment Tax Payable 360 108 Retirement Savings Deductions Payable 2,300 109 Medical Insurance Payable 2,520 201 Sales...
Bentley Company’s June 30 bank statement and June ledger accounts for cash are summarized below: BANK...
Bentley Company’s June 30 bank statement and June ledger accounts for cash are summarized below: BANK STATEMENT Checks Deposits Balance Balance, June 1 $ 7,750 Deposits during June $ 15,950 23,700 Checks cleared during June $ 16,700 7,000 Bank service charges 27 6,973 Balance, June 30 6,973 Cash (A) June 1 Balance 7,750   June Checks written 19,250 June Deposits 18,400 Required: 1. Reconcile the bank account. A comparison of the checks written with the checks that have cleared the bank...
The following selected accounts appear in the ledger of Upscale Construction Inc. at the beginning of...
The following selected accounts appear in the ledger of Upscale Construction Inc. at the beginning of the current year: Preferred 2% Stock, $80 par (200,000 shares authorized, 65,000 shares issued) $5,200,000 Paid-In Capital in Excess of Par—Preferred Stock 360,000 Common Stock, $12 par (3,000,000 shares authorized, 1,400,000 shares issued) 16,800,000 Paid-In Capital in Excess of Par—Common Stock 1,290,000 Retained Earnings 110,900,000 During the year, the corporation completed a number of transactions affecting the stockholders’ equity. They are summarized as follows:...
The following selected accounts and their current balances appear in the ledger of Clairemont Co. for...
The following selected accounts and their current balances appear in the ledger of Clairemont Co. for the fiscal year ended May 31, 2018: Cash $108,300 Retained Earnings 477,200 Accounts Receivable 293,800 Dividends 64,800 Inventory 329,100 Sales $3,965,700 Estimated Returns Inventory 22,500 Cost of Goods Sold 2,293,800 Office Supplies 10,200 Sales Salaries Expense 645,000 Prepaid Insurance 7,900 Advertising Expense 177,400 Office Equipment 238,300 Depreciation Expense—    Store Equipment 34,600 Accumulated Depreciation—    Office Equipment 161,900 Miscellaneous Selling Expense 15,100 Store Equipment 743,800 Office...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT