Question

Using the information from the Excel workbook from Week 3’s submission, complete a worksheet using the...

Using the information from the Excel workbook from Week 3’s submission, complete a worksheet using the following information for accounting adjustments. Complete the columns for the below adjusting entries, income statement, and balance sheet. Also, record the required closing entries. Add any lines as necessary.

1. Expired insurance, $553.

2. Ending store supplies inventory, $2,632.

3. Ending office supplies inventory, $504.

4. Depreciation of store equipment, $567.

5. Depreciation of office equipment, $329.

I have completed my adjustment entries. What would the required closing entries be?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

closing entries:

1. Adjusting entry that would have been posted

Dr. Cr.

insurance expense 553

Prepaid insurance 553

closing entry for this transaction

Dr. Cr.

Income summary 553

insurance expense 553

Insurance expense will be transferred to Profit and loss statement for the current year and insurance expense account will be closed. insurance expense will lead to decrease in profits and therefore income summary account is debited.

2.

Adjusting entry Dr. Cr.

Supplies expense XXX

store supplies XXX.

closing entry Dr. Cr.

Income summary XXX

Supplies expense XXX

(Supplies expense account transferred to income statment and supplies expense balance closed)

Supplies expense will be calculated as

opening balance in supplies account

add: purchases during the year

less: ending balance in supplies account.

whatever supplies are used during the year will be transferred to supplies expense account and the supplies asset balance will be reduced for the same amount.

3.

Adjusting entry Dr. Cr.

Supplies expense XXX

office supplies XXX.

closing entry Dr. Cr.

Income summary XXX

Supplies expense XXX

(Supplies expense account transferred to income statment and supplies expense balance closed)

Supplies expense will be calculated as

opening balance in supplies account

add: purchases during the year

less: ending balance in supplies account.

whatever supplies are used during the year will be transferred to supplies expense account and the supplies asset balance will be reduced for the same amount.

4.   

Dr. Cr.

Depreciation 567

accumulated dep of Store equipment 567

(depreciation expense created for the current period)

Closing entries

Dr. Cr.

Income summary 567

Depreciation expense 567

(depreciation transferred to income statement leading to decraese in income and depreciation account closed)

5.

Dr. Cr.

Depreciation 329

accumulated dep of office equipment 329

(depreciation expense created for the current period)

Closing entries

Dr. Cr.

Income summary 567

Depreciation expense 567

(depreciation transferred to income statement leading to decraese in income and depreciation account closed)

  

Add a comment
Know the answer?
Add Answer to:
Using the information from the Excel workbook from Week 3’s submission, complete a worksheet using the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 22. Use the following information to complete the partial worksheet for Bill's Company. Record the appropriate...

    22. Use the following information to complete the partial worksheet for Bill's Company. Record the appropriate adjusting entries using the data below and extend the balances over to the adjusted trial balance columns. Please Note: because this is a partial trial balance, your adjusted trial balance columns will not equal. (15 pts) $10 3 Merchandise inventory-ending Store supplies on hand Depreciation on store equipment Accrued salaries Bill's Company Partial Worksheet For the Year Ended December 31, 200x Trial Balance Adjustments...

  • Complete the worksheet using the excel file. Add your adjusting journal entries and complete the adjusted...

    Complete the worksheet using the excel file. Add your adjusting journal entries and complete the adjusted trial balance. Do not do the financial statements, closing entries, or post-close trial balance. The information for the adjusting journal entries are at the bottom of the tab- "adjusting entries" Adjusting Journal Entries Info. Insurance that expired during December was $275.00 A physical count of the supplies indicated that $715.00 were on hand. Depreciation on office equipment for the period was $330.00 Salaries worked...

  • Required: 2. Complete the worksheet by making the following adjustments: supplies on hand at the end...

    Required: 2. Complete the worksheet by making the following adjustments: supplies on hand at the end of the month, $7,200; expired insurance, $7,000; depreciation expense for the period, $3,100. Analyze: How does the insurance adjustment affect Prepaid Insurance? Complete this question by entering your answers in the tabs below. Partial Worksheet Analyze Complete the worksheet by making the following adjustments: supplies on hand at the end of the month, $7,200; expired insurance, $7,000; depreciation expense for the period, $3,100. NEAL...

  • PROBLEM 1 -Worksheet The worksheet for Gibler Rental Company appears below. Using the adjustment data below,...

    PROBLEM 1 -Worksheet The worksheet for Gibler Rental Company appears below. Using the adjustment data below, complete the worksheet. Add any accounts that are necessary. Adjustment data: A physical count of supplies indicates $3 on hand at August 31. The amount of insurance that expired in the month of August was $2. Depreciation on equipment for August was $5. Interest accrued on the note payable was $1. GIBLER RENTAL COMPANY Worksheet For the Month Ended August 31, 2010 Trial Balance...

  • Content Tasks Communication Resources Table of Contents > Weekly Assignments > Week 3 Assignment > Week...

    Content Tasks Communication Resources Table of Contents > Weekly Assignments > Week 3 Assignment > Week 3 Practice Week 3 Practice < Homework for this week is to complete exercise E3-29 on page 167 of your textbook. Utilize the attached workpapers to complete the following steps: 1. Record the journal entries for a.d. 2. Post the journal entries to the ledger (T-accounts). 3. Prepare the adjusted trial balance. 4. Upload your completed workpapers to the DropBox in D2L. General Journal...

  • The adjusted trial balance of University Book Store as of November 30, 2019, after the firm's...

    The adjusted trial balance of University Book Store as of November 30, 2019, after the firm's first month of operations, appears below. Appropriate adjustments have been made for the following items: a. Supplies used during the month, $4,700. b. Expired rent for the month, $5.900. c. Depreciation expense for the month, $1,950. UNIVERSITY BOOK STORE Adjusted Trial Balance November 30, 2019 Account Name Cash Accounts Receivable Supplies Prepaid Rent Equipment Accumulated Depreciation Equipment Accounts Payable Ruby Darbandi, Capital Ruby Darbandi,...

  • Homework: CH 3 Using a worksheet Score: 0 of 5 pts E3-29 (similar to) 3 of...

    Homework: CH 3 Using a worksheet Score: 0 of 5 pts E3-29 (similar to) 3 of 3 (1 complete) HW Score: 11.11%, 1 of 9 pts Question Help The worksheet of Next Job Employment Service follows but is incomplete. Click the loon the view the worksheet) The folowing data at April 30, 2018 we given for Nextjob Employment Service Click the loon to view the additional information) Read the requirements Requirements 1 and 2. Calculate and enter the w e...

  • 50 125 24. Prepare closing entries from the following information on the Warner Books worksheet adjustedt...

    50 125 24. Prepare closing entries from the following information on the Warner Books worksheet adjustedt balance columns. (12 pts) Adjusted Trial Balance Debit Credit 60 Cash Accounts Receivable 22 Merchandise Inventory Supplies Equipment Accumulated Depreciation - Equipment Accounts Payable Unearned Revenue Werner, Capital Werner, Withdrawals Income Summary Sales Sales Ret. and Allow. Sales Discounts Purchases Pur. Ret. and Allow. Pur. Discount Freight In Sales Salaries Expense Office Salaries Expense _Total 0 + 384

  • 2. Use the following adjustment information to complete the Adjustments columns of the work sheet. a....

    2. Use the following adjustment information to complete the Adjustments columns of the work sheet.a. Depreciation on equipment, $8b. Accrued salaries, $11C. The $17 of unearned revenue has been earnedd. Supplies available at December 31, $40e. Expired insurance, $203. Extend the balances in the Adjusted Trial Balance columns of the work sheet to the proper financial statement columns. Compute totals for those columns including net income.

  • Homework for this week is to complete exercise E3-29 on page 167 of your textbook. Utilize...

    Homework for this week is to complete exercise E3-29 on page 167 of your textbook. Utilize the attached workpapers to complete the following steps: 1. Record the journal entries for a.d. 2. Post the journal entries to the ledger (T-accounts). 3. Prepare the adjusted trial balance. 4. Upload your completed workpapers to the DropBox in D2L. Help IQJiMr-P3-29 Workpapers.pdf (page 1 of 4) Q Sear General Journal Account Titles Debit Credit 1924 13 W A ile Edit View Go Tools...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT