Purchase Solution

Worksheet and Adjusting and Closing Entries

Not what you're looking for?

Ask Custom Question

Preparation of Work Sheet and Adjusting and Closing Entries

The following account balances are taken from the general ledger of Whitni Corporation on December 31, 20013, the end of its fiscal year. The corporation was organized January 2005.
Cash. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .$ 40,250
Notes Receivable. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .16,500
Accounts Receivable. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .63,000 Allowance for Bad Debts (credit balance). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 650 Inventory, December 31,2013. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94,700
Land . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80,000
Buildings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. 247,600 Accumulated Depreciation Buildings. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .18,000
Furniture and Fixtures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15,000 Accumulated Depreciation Furniture and Fixtures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9,000
Notes Payable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18,000
Accounts Payable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72,700
Common Stock,$100 par. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .240,000
Retained Earnings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .129,125
Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .760,000
Sales Returns and Allowances . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17,000
Cost of Goods Sold . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .465,800
Utilities Expense. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .16,700
Property Tax Expense. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10,200
Salaries and Wages Expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89,000
Sales Commissions Expense. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .73,925
Insurance Expense. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18,000
Interest Revenue . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2,600
Interest Expense. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2,400

Data for adjustments at December 31, 2013, are as follows:

(a) Depreciation (to nearest month for additions): furniture and fixtures, 10%; buildings, 4%.
(b) Additions to the buildings costing $150,000 were completed June 30, 2013.
(c) Allowance for Bad Debts is to be increased to a balance of $2,500.
(d) Accrued expenses: sales commissions, $700; interest on notes
payable, $45; property taxes, $6,000.
(e) Prepaid expenses: insurance, $3,200.
(f) Accrued revenue: interest on notes receivable, $750.
(g) The following information is also to be recorded:
(1) On December 30, the board of directors declared a quarterly dividend of $1.50 per share
on common stock, payable January 25, 2014, to stockholders of record January 15,2014.
(2) Income taxes for 2008 are estimated at $15,000.
(3) The only charges to Retained Earnings during the year resulted from the declaration of the regular quarterly dividends.

Instructions:
1.Prepare an 8-column spreadsheet. There should be a pair of columns each for trial balance, adjustments, income statement, and balance sheet.
2. Prepare all the journal entries necessary to record the effects of the foregoing information and to adjust and close the books of the corporation.

Purchase this Solution

Solution Summary

The expert examines worksheet and adjusting closing entries.

Solution Preview

Please find the full solution attached.

Adjusting Entries

(a1) Depreciation Expense?Furniture and Fixtures 1,500
Accumulated Depreciation?Furniture and Fixtures 1,500
($15,000 × .10 = $1,500)

(a2) Depreciation Expense?Buildings 6,904
Accumulated Depreciation?Buildings 6,904
[($97,600 × .04) + ($150,000 × .04 × 6/12) = $6,904)]

(b) Doubtful ...

Solution provided by:
Education
  • BA, Ain Shams University, Cairo Egypt
  • MBA, California State University, Sacramento
Recent Feedback
  • "ty i have more need help with"
  • "ty i have jmore i need help with"
  • "great help"
  • "excellent help"
  • "Very helpful and easy to understand."
Purchase this Solution


Free BrainMass Quizzes
Learning Lean

This quiz will help you understand the basic concepts of Lean.

Introduction to Finance

This quiz test introductory finance topics.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.