Purchase Solution

prepare the Trial balance with adjustments for a merchandising company

Not what you're looking for?

Ask Custom Question

See attached file.

The MS Excel file contains the trial balance and adjustment information for a merchandising company.
Trial Balance and Adjustment Information

DR CR
Cash $20,000.00
Machinery $16,000.00
Accumulated Depreciation $4,000.00
Merchandise (Jan 1) $30,000.00
Accounts Payable $7,000.00
Capital $44,000.00
Service Fees $8,000.00
Sales $20,000.00
Purchases $9,000.00
Telephone Expense $8,000.00
Total $83,000.00 $83,000.00

Adjustment Information:
(a) Depreciation for the year is $2,000.
(b) The ending merchandise inventory is $34,000
(c) Accrued Electrical usage is $120
(d) Service fees earned but not yet collected are $2,000

Prepare a worksheet for the company at the end of the financial period.
You can use Template_A_I for the solution.

Solution:

Account Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet
DR CR DR CR DR CR DR CR DR CR
Cash $20,000
Machinery $16,000
Accumulated Depreciation $4,000
Merchandise (Jan 1) $30,000
Accounts Payable $7,000
Capital $44,000
Service Fees $8,000
Sales $20,000
Purchases $9,000
Telephone Expense $8,000
Totals $83,000 $83,000
Depreciation Expense
Electrical Expense
Utilities Payable
Accounts Receivable
Totals

Totals
Net Income
Total

Purchase this Solution

Solution Summary

This solution is comprised of a detailed explanation to prepare the Trial balance with adjustments for a merchandising company.

Purchase this Solution


Free BrainMass Quizzes
Operations Management

This quiz tests a student's knowledge about Operations Management

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

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.