Accounting Assignment

Directions
    ACC 120
    During the first month of operations, the following transactions were completed by ABC Corporation:
    Dec 1    Issued 25,000 shares of $3 par common stock for cash of $22 per share.
    Dec 3    ABC Company pays cash for Land and a building to be used in operations. The land cost $90,000 and the building cost $80,000.
    Dec 4    Purchased $8,000 of store fixtures on account.
    Dec 5    Purchased merchandise inventory from XYZ Company for $118,000, terms n/eom, FOB destination.
    Dec 6    ABC sold $50,000 of merchandise on account, 2/10, n/30, FOB shipping point. The cost of merchandise sold was $20,000.
    Dec 9    Paid adverting costs of $18,000 to promote new business.
    Dec 10    Purchased merchandise inventory from QRS Company for $85,000, terms n/30, FOB destination.
    Dec 11    Purchased 400 shares of treasury stock for $15 per share.
    Dec 12    ABC's Board of Directors declared a $38,000 cash dividend.
    Dec 13    Paid $750 for utilities.
    Dec 15    Paid cash dividends to common shareholders.
    Dec 16    Received payment for merchandise sold on Dec. 6th.
    Dec 23    ABC sold $75,000 of merchandise on account, 2/10, n/30, FOB shipping point. The cost of merchandise sold was $35,000.
    Dec 24    Sold 250 shares of treasury stock for $20 per share.
    Dec 31    Paid balance owed to XYZ Company for purchases on Dec 5.
    At the end of December, the following adjustment data were assembled.
    a    After a physical count of inventory, it was determined that $147,200 of inventory exists at December 31.
    b    Based on an analysis of A/R, ABC Company anticipates 3% of A/R to be uncollectible.
    c    Buildings are depreciated using the straight line method with no salvage value for 30 years. Round to the nearest dollar.
    d    Store Fixtures are depreciated using the straight-line method with no salvage value for 5 years. Round to the nearest dollar.
    Directions:
    1    Journalize the routine transactions above on the Journal-December tab.
    2    Journalize the adjusting entries above on the Journal-December tab (below the routine entries).
    3    Use the Adjusted Trial Balance provided to prepare financial statments for ABC Corporation. You are only responsible for preparing the Income Statement, Statement of Retained Earnings, and classified Balance Sheet. These should be completed on the Financial Statements tab.
    You should complete your final project in this Excel workbook using the following tabs: Journal-December and...