Prepare Quarterly Adjustment Entries in Excel for Welch Rental Agency Inc.
Not what you're looking for?
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.
Purchase this Solution
Solution Summary
Adjusting entries are presented together with explanations in plain text and in the attached Excel file.
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 ...
Purchase this Solution
Free BrainMass Quizzes
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
Motivation
This tests some key elements of major motivation theories.
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.