Explore BrainMass

Explore BrainMass

    Sharp Co. for year-end 2007: accounting cycle problem

    Not what you're looking for? Search our solutions OR ask your own Custom question.

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

    The following information relates to Sharp Co. for year-end 2007.
    1. The allowance for bad debts should be 6% of accounts receivables.
    2. A physical count of supplies at year-end showed $3,200 on hand.
    3. The note receivable came from a customer on October 1. It was a six month note at 6% interest.
    4. On September 1 the company paid $12,000 for years rent on the office building.
    5. The useful life of the equipment is 10 years and the company uses the straight line method.
    6. Accrued wages at year-end amounted to $900.
    7. The note payable was taken out on June 1. It is a two year note at 8%.
    8. On October 1 the company received $6,000 for a customer for future work. As of year-end 2/3 of the amount has been earned.
    9. A count of year-end inventory showed $90,000 on hand.
    10. The investment in stock is long term and the year end value was equal to the cost of the investment.
    11. The land is held for future use.
    12. The company purchased a one year insurance policy on May 1 and recorded it in Prepaid Insurance.
    13. The company is 100,000 shares of common stock outstanding.
    1. Prepare the adjusted trial balance.
    2. Prepare an income statement, statement of retained earnings and a classified balance sheet.

    Unadjusted Trial balance:
    Cash: 36,000
    Accounts Receivable: 80,000
    Allowance for Bad Debts 2,000
    Supplies 3,000
    Inventory 110,000
    Note Rec 40,000
    Interest Rec
    Prepaid Rent
    Prepaid Insur 2,400
    Investments 10,000
    Equipment 120,000
    land 20,000
    Accum. Depr. 40,000
    Accts Pay 38,000
    Wages Pay.
    Notes Pay. 60,000
    Interest Pay.
    Unearned Rev. 6,000

    common stock: 100,000
    retained earns. 35,500
    dividends 4,000
    sales 348,000
    interest rev.
    cost of goods 140,000
    wage expense 42,000
    rent expense 12,000
    deprec. expense
    interest exp
    supplies ex 1,1,00
    insurance exp 6,000
    bad debt exp 3,000
    totals 629,500 629,500

    © BrainMass Inc. brainmass.com March 4, 2021, 11:26 pm ad1c9bdddf

    Solution Summary

    Your tutorial is in Excel and sets up an unadjusted trial balance, adjusting entries, the adjusted trial balance and the required financial statements. This is now a template for similar problems.