Explore BrainMass

Explore BrainMass

    Worksheet

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com June 3, 2020, 7:25 pm ad1c9bdddf
    https://brainmass.com/business/accounting/worksheet-97642

    Attachments

    Solution Summary

    The solution explains how to prepare a six column worksheet.

    $2.19

    ADVERTISEMENT