Explore BrainMass

Explore BrainMass

    Noah's Ark: Prepare a complete work sheet

    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!

    I am having problems with journalizing.

    4. (Work Sheet, Balance Sheet, Adjusting and Closing Entries) Noah's Ark has a fiscal year ending on September 30. Selected data from the September 30 work sheet are presented below.


    Trial Balance Adjusted Trial Balance
    Dr. Cr. Dr. Cr.

    Cash 37,400 37,400
    Supplies 18,600 1,200
    Prepaid Insurance 31,900 3,900
    Land 80,000 80,000
    Equipment 120,000 120,000
    Accumulated Depreciation 36,200 43,000
    Accounts Payable 14,600 14,600
    Unearned Admissions Revenue 2,700 1,700
    Mortgage Payable 50,000 50,000
    N. Y. Berge, Capital 109,700 109,700
    N. Y. Berge, Drawing 14,000 14,000
    Admissions Revenue 278,500 279,500
    Salaries Expense 109,000 109,000
    Repair Expense 30,500 30,500
    Advertising Expense 9,400 9,400
    Utilities Expense 16,900 16,900
    Property Taxes Expense 18,000 21,000
    Interest Expense 6,000 12,000

    Total s 491,700 491,700

    Insurance Expense 28,000
    Supplies Expense 17,400
    Interest Payable 6,000
    Depreciation Expense 6,800
    Property Taxes Payable 3,000
    Totals 507,500 507,500

    a. Prepare a complete work sheet.
    b. Prepare a classified balance sheet. (Note: $10,000 of the mortgage payable is due
    for payment in the next fiscal year.)
    c. Journalize the adjusting entries using the work sheet as a basis.
    d. Journalize the closing entries using the work sheet as a basis.
    e. Prepare a post-closing trial balance.

    © BrainMass Inc. brainmass.com December 15, 2022, 4:58 pm ad1c9bdddf

    Solution Preview

    First of all, do you know how to prepare a worksheet? I have attached a problem that I use in my classes. The students first copy the accounts and balances to the worksheet from the trial balance, then determine what adjusting entries are to be made and make them directly in the adjustments columns on the worksheet - then move over all of the amounts from the trial balance + or - the adjustments to the adjustments columns. Then, once everything is totalled and in balance, you can move over the income statement columns and the balance sheet columns. In the case of the example I have provided you move over the withdrawing account to the balance sheet, as it will be closed directly to owner's equity.

    If you can do that part, then you have the numbers necessary to prepare a classified balance sheet. Remember the classified balance sheet is just about the same as a regular balance sheet - there are just more divisions; for the classified balance sheet you generally have a separate breakout for current assets and noncurrent ...

    Solution Summary

    You will find the answer to this puzzling question inside...