accounting

    You will need to submit two excel spreadsheets (one for June and one for July) that contains sheets: journal entries, ledger accounts, balance sheet, income statement, trial balance and inventory count.
    You will need to write a memo to the owner giving June and July highlights and concerns that the owner should be aware of, also in the memo
    FOR PAIRS ONLY : you need to propose to the owner an accounting information system (computerized) along with associated costs and benefits.

    Instructions
    Requirement I: June Financial Statements
    Assume you are doing Tracy’s job:
    Analyze each of June’s transactions and prepare the journal entries
    Calculate the depreciation and amortization expenses for the month of June for the tangible and intangible assets
    Calculate Cost of Goods Sold assuming the company uses a periodic inventory system and FIFO for cost method
    Post the appropriate journal entries in T accounts
    Prepare a trial balance
    Prepare the Balance Sheet and Income Statement for the month of June.
    Requirment II: July Financial Statements
    Repeat the steps above for July:
    Analyze each of July’s transactions and prepare the journal entries
    Calculate the depreciation and amortization expenses for the month of July for the tangible and intangible assets
    Calculate Cost of Goods Sold assuming the company uses a periodic inventory system and FIFO for cost method
    Post the appropriate journal entries in T accounts
    Prepare a trial balance
    Prepare the Balance Sheet and Income Statement for the month of July

                                                                                                                                      Order Now