Purchase Solution

Worksheet

Not what you're looking for?

Ask Custom Question

Complete the six-column table. Please see attachment.

Required
1. Complete the six-column table by entering adjustments that reflect the following information:
a. As of December 31, 2005, employees had earned $900 of unpaid and unrecorded salaries. The next payday is January 4, at which time $1,600 of salaries will be paid.
b. The cost of supplies still available at December 31, 2005, is $2,700.
c. The notes payable requires an interest payment to be made every three months. The amount of unrecorded accrued interest at December 31, 2005, is $1,250. The next interest payment, at an amount of $1,500, is due on January 15, 2006.
d. Analysis of the unearned member fees account shows $5,600 remaining unearned at December 31, 2005.
e. In addition to the member fees included in the revenue account balance, the company has earned another $9,100 in unrecorded fees that will be collected on January 31, 2006. The company is also expected to collect $8,000 on that same day for new fees earned in January 2006.
f. Depreciation expense for the year is $12,500.

The following six-column table for Bullseye Ranges includes the unadjusted trial balance as of December 31, 2005.

ACCOUNT TITLE UNADJUSTED ADJUSTED
TRAIL BALANCE ADJUSTMENTS TRAIL BALANCE

DR CR DR CR DR CR

Cash $13,000
Accounts receivable . . . . . . . . . . 0
Supplies . . . . . . . . . . . . . . . . . . 5,500
Equipment . . . . . . . . . . . . . . . . 130,000
Accumulated depreciation?
Equipment . . . . . . . . . . . . . . . $ 25,000
Interest payable . . . . . . . . . . . . . 0
Salaries payable . . . . . . . . . . . . . 0
Unearned member fees . . . . . . . 14,000
Notes payable . . . . . . . . . . . . . . 50,000
T. Allen, Capital . . . . . . . . . . . . . 58,250
T. Allen, Withdrawals . . . . . . . . . 20,000
Member fees earned . . . . . . . . . 53,000
Depreciation expense?
Equipment . . . . . . . . . . . . . . . 0
Salaries expense . . . . . . . . . . . . 28,000
Interest expense . . . . . . . . . . . . 3,750
Supplies expense . . . . . . . . . . . . 0
Totals . . . . . . . . . . . . . . . . . . . . $200,250 $200,250

Attachments
Purchase this Solution
Solution Summary

The solution explains how to prepare a six column worksheet.

Purchase this Solution
Free BrainMass Quizzes
Learning Lean

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

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Basic Social Media Concepts

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

Introduction to Finance

This quiz test introductory finance topics.

View More Free Quizzes
Related BrainMass Solutions

  • Excel S4-R1 Copy Worksheet

    56430 Excel S4-R1 Copy Worksheet Excel S4-R1 Copy the Week 2 worksheet, positioning the new sheet after Week 3. 2. Rename the Week2 (2) worksheet as Week 4. 3. Delete the Week 3 worksheet 4.

  • Excel: Worksheets and Workbooks

    , tells Excel to use the data from worksheet Q2 from cells A1 and A2. If you change the data in worksheet Q2, cells A1 or A2 the change is reflected in worksheet Q1 cell A3.

  • Trial balance columns and worksheet

    256514 Trial balance columns and worksheet Enter the trial balance on a worksheet and complete the worksheet. E4-2 The adjusted trial balance columns of the worksheet for Goode Company are as follows.

  • This post addresses financial statement worksheets.

    The benefits are that management is able to work from the worksheet to reconcile numbers to the financial statements. The first part of the worksheet is used when preparing the trial balance, from the debits and credits listed on the worksheet.

  • Analysis of Pledge Data

    In the Q.4-6 worksheet, insert a Total row.

  • Can any accounting step after a worksheet be skipped?

    351760 Can any accounting step after a worksheet be skipped? The worksheet often facilitates the end-of-period (monthly, quarterly, or annually) accounting and reporting process.

  • Financial Analysis with Microsoft Excel

    Each statement should be on a separate excel worksheet. Try to duplicate the formatting exactly. (must be in excel worksheet) b. On another excel worksheet, create a statement of cash flows for 2011.

  • Accounting Project in Excel

    Rename a duplicate copy of your worksheet (remember to add a footer with your name, worksheet name, and date in the duplicate copy).

  • Criterion Development Worksheet and Job Analysis Worksheet

    337165 Criterion Development Worksheet and Job Analysis Worksheet Please see attached file. 1.

  • A workbook can contain more than one worksheet.

    82290 A workbook can contain more than one worksheet. A workbook can contain more than one worksheet. Can you give an example of a spreadsheet application where it would be necessary to have more than one worksheet, can you explain how that works?

View More Related Solutions