Ask Experts Questions for FREE Help !
Ask
    BARDOUILLE2's Avatar
    BARDOUILLE2 Posts: 1, Reputation: 1
    New Member
     
    #1

    Dec 3, 2010, 02:00 AM
    Adjustments in 10 column work sheet.
    Cash... 4250
    Notes Receivable... 1690
    Account Receivables... 1535
    Supplies... 615
    Prepaid Insurance... 500
    Van... 23600
    Accumulated Depreciation: Van... 10200
    Equipment... 48000
    Accumulated Depreciation: Equipment... 2000
    Notes Payables... 10000
    Accounts Payables... 400
    Unearned Revenue... 1000
    Mortgage payable... 43000
    Carol Goren, Capital... 14590
    Carol Goren, drawings... 2600
    Revenue from Teaching... 750
    Revenue from Exercise Clinic... 6200
    Utilities Expense... 195
    Advertising Expense... 250
    Interest Expense... 760
    Wages expense... 2800
    Payroll Tax Expense... 170
    Gas and Oil Expense... 130
    Repair expense... 225
    Insurance Expense... 820
    Totals... 88140 88140

    Complete the ten column worksheet using word excel by first calculating the adjustments from the following data and enter them in the adjustments column of the work sheet. Label the adjustments a, b, c, and so on.
    a. The beginning inventory of supplies was $475. A purchase of supplies was made on June 21st for 4140, and ending inventory of supplies was $270.
    b. The insurance policy was purchased on April 1st of this year for $600. It prepaid the insurance for one year.
    c. The Van was purchased on January 2nd of last year. It has a useful life of five years and a salvage value of $2000. The equipment was purchased on February 5th of this year. It is expected to last eight years and will have no salvage value.
    d. June 30th falls on a Thursday. Wages of $100 a day are paid on each Friday. Record the wage expense for Monday through Thursday, June 27th to 30th.
    e. On June 1st , Carol received a check for $1000 from a local exercise firm to give ten aerobics lessons to its new instructors. Carol taught five of the lessons in June.
    f. On June 30th , services had been performed in the clinic totaling $1200 for which no payment had been received.
    (ii) Journalize the adjusting entries.
    Curlyben's Avatar
    Curlyben Posts: 18,514, Reputation: 1860
    BossMan
     
    #2

    Dec 3, 2010, 02:04 AM
    Thank you for taking the time to copy your homework to AMHD.
    Please refer to this announcement: https://www.askmehelpdesk.com/financ...-b-u-font.html
    Just Looking's Avatar
    Just Looking Posts: 1,610, Reputation: 480
    Ultra Member
     
    #3

    Dec 3, 2010, 04:10 AM

    This is similar to another question yesterday. See if this will help you get started.

    https://www.askmehelpdesk.com/accoun...ce-531015.html

    https://www.askmehelpdesk.com/accoun...ng-531019.html

    If you will attempt your journal entries, we can check them for you. Thanks.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

6 column work sheet [ 3 Answers ]

I have been working on a 6 column work sheet and the adjusted trial balance does not equal, can some one take a look at what I have completed and explain to me where I have went wrong. Here is a copy of the assignment Cash.. . $ 13,000 Accounts receivable.. . 0 Supplies.. . 5,500...

10 column work sheet [ 4 Answers ]

I am working on a 10 column work sheet and I am not sure I have done it correctly, I am particularly confused with the Income statement and owners equity portion of the work sheet. Can someone please look it over and let me know if I have done it correctly or explain to me where I have went wrong....

How to prepare a 10-column work sheet [ 1 Answers ]

Prepare a 10-column work sheet for fiscal year 2005, starting with the unadjusted trial balance and including adjustments based on these additional facts: a. The supplies available at the end of fiscal year 2005 had a cost of $3,200. b. The cost of expired insurance for the fiscal year is...

Adjusting journal entries from adjusting column of work sheet [ 2 Answers ]

How can I prepare necessary adjusting journal entries (a) through (e) by using the following information from the Adjustments columns of a 10-column work sheet. Interest recievable (d)$880 Office supplies ...

How do I prepare a 10-column work sheet? [ 1 Answers ]

I have to do a work sheet starting with an unadjusted trial balance and including adjustments. I have no clue where to start or how to do it on excel can anyone please point me in the right direction for some help and maybe some websites that can help??


View more questions Search