/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Q21E (L09) (Worksheet) Presented belo... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

(L09) (Worksheet) Presented below are the selected accounts for Alvarez Company as reported in the worksheet at the end of May 2017.

ALVAREZ CO.

Worksheet

For The Month Ended May 31, 2017

Adjusted

Trial Balance

Income

Statement

Balance

Sheet

Accounts Titles

Dr.

Cr.

Dr.

Cr.

Dr.

Cr.

Cash

9,000

Inventory

80,000

Sales Revenue

450,000

Sales returns and allowances

10,000

Sales Discounts

5,000

Cost of Goods Sold

250,000

Instructions:

Complete the worksheet by extending the amounts reported in the adjusted trial balance to the appropriate columns in the worksheet. Do not total individual columns.

Short Answer

Expert verified

Cash (Balance sheet) =Dr.9,000

Inventory (Balance sheet) = Dr.80,000

Sales Revenue (Income Statement) = Cr.450,000

Sales Returns and Allowances (Income Statement) = Dr. 10,000

Sales Discount (Income Statement) = Dr.5,000

Cost of Goods Sold (Income Statement) = Dr.250,000

Step by step solution

01

Meaning of Balance Sheet

The term balance sheet represents the financial position of a company using various resources, liabilities, and owner's equity. It shows all the items briefly for a better understanding of the financial position.

02

Worksheet presentation

The worksheet for the month ended May 31, 2017, is as follows:

ALVAREZ CO.

Worksheet

For the Month Ended May 31, 2017

Adjusted Trial balance

Income

Statement
Balance Sheet

Account Titles

Dr.

Cr.

Dr.

Cr.

Dr.

Cr.

Cash

9,000

-------

------

-------

9,000

------

Inventory

80,000

-------

------

-------

80,000

------

Sales Revenue

------

450,000

------

450,000

-------

------

Sales Returns and Allowances

10,000

------

10,000

-------

-------

------

Sales Discount

5,000

------

5,000

-------

-------

------

Cost of Goods Sold

250,000

------

250,000

-------

-------

------

Note: Sales returns and allowances may also be shown as deductions from sales revenues.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91Ó°ÊÓ!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Midwest Enterprises made the following entry on December 31, 2017.

Interest Expense 10,000

Interest Payable 10,000

(To record interest expensedue on loan from Anaheim

National Bank)

What entry would Anaheim National Bank make regarding its outstanding loan to Midwest Enterprises? Explain why this must be the case.

The following are the trial balance and the other information related to Yorkis Perez, a consulting engineer.

YORKIS PEREZ, CONSULTING ENGINEER .
TRIAL BALANCE
DECEMBER 31, 2017

Debit

Credit

Cash

\( 29,500

Accounts Receivable

49,600

Allowance for Doubtful Accounts

\) 750

Supplies

1,960

Prepaid Insurance

1,100

Equipment

25,000

Accumulated Depreciation—Equipment

6,250

Notes Payable

7,200

Owner’s Capital

35,010

Service Revenue

100,000

Rent Expense

9,750

Salaries and Wages Expense

30,500

Utilities Expenses

1,080

Office Expense

720

\(149,210

\)149,210

  1. Fees received in advance from clients \(6,000, which were recorded as revenue.
  2. Services performed for clients that were not recorded by December 31, \)4,900.
  3. Bad debt expense for the year is \(1,430.
  4. Insurance expired during the year \)480.
  5. Equipment is being depreciated at 10% per year.
  6. Yorkis Perez gave the bank a 90-day, 10% note for \(7,200 on December 1, 2017.
  7. Rent of the building is \)750 per month. The rent for 2017 has been paid, as has that for January 2018, and recorded as Rent Expense.
  8. Office salaries and wages earned but unpaid December 31, 2017, \(2,510.

Instructions

  1. From the trial balance and other information given, prepare annual adjusting entries as of December 31, 2017. (Omit explanations.)
  2. Prepare an income statement for 2017, a statement of owner’s equity, and a classified balance sheet. Yorkis Perez withdrew \)17,000 cash for personal use during the year.

Jay Hawk, maintenance supervisor for Boston Insurance Co., has purchased a riding lawnmower and accessories to be used in maintaining the ground and corporate headquarters. He has sent the following information to the accounting department.

Cost of Mover and Accessories

\(4,000

Date Purchased

7/1/2017

Estimated Useful Life

5 yrs

Monthly Salary of Groundskeeper

\)1,100

Salvage Value

\(0

Estimated Annual Fuel Cost

\)150

Compute the amount of depreciation expense(related to the mover and accessories) that should be reported on Boston’s December 31, 2017, Income Statement. Assume straight-line depreciation.

E3-13 (Lo5,6) (Closing Entries) The adjusted trial balance of Lopez Company shows the following data pertaining to sales at the end of its fiscal year, October 31, 2017: Sales Revenue \(800,000, Delivery Expenses \)12,000, Sales Returns and Allowances \(24,000 and Sales Discounts \)15,000.

Instructions:

(b) Prepare separate closing entries for (1) Sales and (2) the contra accounts to sales.

Cooke Company has a fiscal year ending on September 30. Selected data from the September 30 worksheet are presented below.

COOKE COMPANY

Worksheet

For The Month Ended September 30, 2017


Trial Balance
Adjusted Trial Balance

Account Titles

Dr.

Cr.

Dr.

Cr.

Cash

37,400

37,400

Supplies

18,600

4,200

Prepaid Insurance

31,900

3,900

Land

80,000

80,000

Equipment

120,000

120,000

Accumulated Depreciation—Equipment

36,200

42,000

Accounts Payable

14,600

14,600

Unearned Service Revenue

2,700

700

Mortgage Payable

50,000

50,000

Common Stock

107,700

107,700

Retained Earnings, Sept. 1, 2017

2,000

2,000

Dividends

14,000

14,000

Service Revenue

278,500

280,500

Salaries and Wages Expense

109,000

109,000

Maintenance and Repairs Expense

30,500

30,500

Advertising Expense

9,400

9,400

Utilities Expenses

16,900

16,900

Property Tax Expense

18,000

21,000

Interest Expense

6,000

12,000

Totals

491,700

491,700

Insurance Expense

28,000

Supplies Expense

14,400

Interest Payable

6,000

Depreciation Expense

5,800

Property Taxes Payable

3,000

Totals

506,500

506,500

Instructions

(a) Prepare a complete worksheet.

(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 worksheet as a basis.

d) Journalize the closing entries using the worksheet as a basis.

(e) Prepare a post-closing trial balance.

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.