Explore BrainMass

Explore BrainMass

    Prepare Quarterly Adjustment Entries in Excel for Welch Rental Agency Inc.

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

    The ledger of Welch Rental Agency Inc. on March 31 of the current year includes the following selected accounts before adjusting entries have been prepared.
    Debit Credit
    Prepaid Insurance $ 3,600
    Supplies 2,800
    Equipment 25,000
    Accumulated
    Depreciation - Equipment $ 8,400
    Notes Payable 20,000
    Unearned Rent 12,000
    Rent Revenue 60,000
    Interest Expense -0-
    Wages Expense 14,000
    An analysis of the accounts shows the following.
    1. The equipment depreciates $300 per month.
    2. One-third of the unearned rent was earned during the quarter.
    3. Interest of $500 is accrued on the notes payable.
    4. Supplies on hand total $1,100.
    5. Insurance expires at the rate of $200 per month.

    Prepare the adjusting entries at March 31, assuming that adjusting entries are made quarterly. Additional accounts are: Depreciation Expense, Insurance Expense, Interest Payable, and Supplies Expense. Must use excel spreadsheet format.

    © BrainMass Inc. brainmass.com June 3, 2020, 7:38 pm ad1c9bdddf
    https://brainmass.com/business/journal-entries/prepare-quarterly-adjustment-entries-in-excel-for-welch-rental-agency-inc-106382

    Solution Preview

    Please see the attached file in Excel.
    Now that I'm done, it might be a good idea to insert a date column at the left and show March 31 for each entry.

    Journal ...

    Solution Summary

    Adjusting entries are presented together with explanations in plain text and in the attached Excel file.

    $2.19

    ADVERTISEMENT