/*! 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} Q8E E3-8 (L03) EXCEL (Adjusting Entr... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

E3-8 (L03) EXCEL (Adjusting Entries) Andy Roddick is the new owner of Ace Computer Services. At the end of August2017, his first month of ownership, Roddick is trying to prepare monthly financial statements. Below is some information relatedto unrecorded expenses that the business incurred during August.1. At August 31, Roddick owed his employees \(1,900 in wages that will be paid on September 1.2. At the end of the month, he had not yet received the month’s utility bill. Based on past experience, he estimated the billwould be approximately \)600.3. On August 1, Roddick borrowed \(30,000 from a local bank on a 15-year mortgage. The annual interest rate is 8%.4. A telephone bill in the amount of \)117 covering August charges is unpaid at August 31.InstructionsPrepare the adjusting journal entries as of August 31, 2017, suggested by the information above.

Short Answer

Expert verified

Journal entries are shown in step 2.

Step by step solution

01

Meaning of Adjusting Journal Entry

The adjusting journal entry means the unrecognized transactions are recorded in the books of accounts at the end of the accounting period.

02

Preparation of adjusting journal entries

Ace Computer Services

Adjusting Journal entries on

August 31, 2017

Date

Account and explanation

Debit $

Credit $

August 31

Wages expense

1900

Wages payable

1900

(To wages payable recorded)

August 31

Utilities expenses

600

Accounts payable

600

(To utility expenses recorded )

August 31

Interest expenses (refer working note)

200

Interest paayble

200

(To interest is paid on the borrowed money from the bank)

August 31

Telephone expenses

117

telephone payable

117

(To telephone expenses payable recorded)




Working note:

Calculation of interest amount per month

±õ²Ô³Ù±ð°ù±ð²õ³Ù a³¾´Ç³Ü²Ô³Ù p±ð°ù³¾´Ç²Ô³Ù³ó=$30,000×8100=$2,400 p±ð°ù²â±ð²¹°ù 12=$200

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

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.

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.

(LO5) (Closing Entries) Presented below is information related to Gonzales Corporation for the month of January 2017.

Cost of Goods sold \( 208,000 Salaries and wages expenses \)61,000

Delivery expenses \( 7,000 Sales discounts \) 8,000

Insurance expenses \( 12,000 Sales returns and allowances \)13,000

Rent expenses \( 20,000 Sales revenue \)350,000

Instructions:

Prepare the necessary closing entries.

A review of the ledger of Baylor Company at December 31, 2017, produces the following data pertaining to the preparation of annual adjusting entries.

  1. Salaries and Wages Payable \(0. There are eight employees. Salaries and wages are paid every Friday for the current week. Five employees receive \)700 each per week, and three employees earn \(600 each per week. December 31 is a Tuesday. Employees do not work weekends. All employees worked the last 2 days of December.
  2. Unearned Rent Revenue \)429,000. The company began subleasing office space in its new building on November 1. Each tenant is required to make a \(5,000 security deposit that is not refundable until occupancy is terminated. At December 31, the company had the following rental contracts that are paid in full for the entire term of the lease.

    Date

    Term (in months)

    Monthly Rent

    Number of Leases

    Nov. 1

    6

    \)6,000

    5

    Dec. 1

    6

    \(8,500

    4

  3. Prepaid Advertising \)13,200. This balance consists of payments on two advertising contracts. The contracts provide for monthly advertising in two trade magazines. The terms of the contracts are as shown below.

    Contract

    Due date

    Amount

    Number of magazine issue

    A650

    May 1

    \(6,000

    12

    B974

    Oct. 1

    7,200

    24

    The first advertisement runs in the month in which the contract is signed

  4. Notes Payable \)60,000. This balance consists of a note for one year at an annual interest rate of 12%, dated June 1.

    Instructions

    Prepare the adjusting entries at December 31, 2017. (Show all computations).


“A worksheet is a permanent accounting record, and its use is required in the accounting cycle. “Do you agree? Explain.

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.