/*! 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} 5E  EXCEL (Adjusting Entries) The ... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

EXCEL (Adjusting Entries) The ledger of Duggan Rental Agency 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 Revenue \)9,300

Rent Revenue \(60,000

Interest Expenses -0-

Salaries and Wages Expenses \)14,000

An analysis of accounts shows the following.

  1. The equipment depreciates \(250 per month.

  2. One-third of the unearned rent was recognized as revenue during the quarter.

  3. Interest of \)500 is accrued on the notes payable.

  4. Supplies on hand total \(850

  5. Insurance expires at the rate of \)300 per month.

Instructions

Prepare the adjusting entries at March 31, assuming that adjusting entries are made quarterly. Additional accounts are Depreciation Expenses, Insurance Expenses, Interest Payable, and Supplies expenses. (Omit Explanations)

Short Answer

Expert verified

The amount of accumulated depreciation calculated is $750.

Step by step solution

01

Meaning of Adjusting Entries

Adjusting entries are those journal entries that are made on the last day of an accounting period. Adjusting entries helps a company calculate exact revenue and expenses and it also helps to update the financial statements and fix an error.

02

Adjusting entries on March 31

Date

Accounts Titles and Explanations

Debit

Credit

Mar 31

Depreciation Expenses

$750



Accumulated Depreciation- Equipment


$750


(Adjusting entries for quarterly depreciation on equipment)







Mar 31

Unearned Rent Revenue

$3100



Rent Revenue


$3100


(Adjusting entries for rent revenue earned)







Mar 31

Interest expenses

$500



Interest payable


$500


(Adjusting entries for accrued interest expenses)







Mar 31

Supplies Expenses

$1950



Supplies


$1950


(Adjusting entries for supplies consumed)







Mar 31

Insurance Expenses

$900



Prepaid Insurance


$900


(Adjusting entries for expired insurance for the quarter)



03

Explanations:

  1. Depreciation Expenses = ($250 × 3) =$750

*[quarterly depreciation = 3 months]

  1. Unearned rent revenue = ($9300 × 1/3) = $3100

  2. Insurance expenses = $500 (Given)

  3. Supplies expenses (Supplies used in production) = ($2800 - $850) = $1950

  4. Insurance expenses = ($300 × 3months) = $900

*[quarterly insurance = 3months]

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

Becker Ltd. is planning to adopt IFRS and prepare its first IFRS financial statements at December 31, 2018. What is the date of Becker’s opening balance sheet, assuming one year of comparative information? What periods will be covered in Becker’s first IFRS financial statements?

Santo Design was founded by Thomas Grant in January 2011. Presented below is the adjusted trial balance as of December 31, 2017.

SANTO DESIGN

ADJUSTED TRIAL BALANCE

DECEMBER 31, 2017


Dr.

Cr.

Cash

\( 11,350

Accounts Receivable

21,500

Supplies

5,000

Prepaid Insurance

2,500

Equipment

60,000

Accumulated Depreciation—Equipment

\) 35,000

Accounts Payable

5,000

Interest Payable

150

Notes Payable

5,000

Unearned Service Revenue

5,600

Salaries and Wages Payable

1,300

Common Stock

10,000

Retained Earnings

3,500

Service Revenue

61,500

Salaries and Wages Expense

11,300

Insurance Expense

850

Interest Expense

150

Depreciation Expense

7,000

Supplies Expense

3,400

Rent Expense

4,000

\(127,050

\)127,050

Instructions

a. Prepare an income statement and a statement of retained earnings for the year ending December 31, 2017, and an unclassified balance sheet at December 31.

b. Answer the following questions.

1.If the note has been outstanding for 6 months, what is the annual interest rate on that note?

2.If the company paid $17,500 in salaries in 2017, what was the balance in Salaries and Wages Payable on December 31, 2016?

The adjusted trial balance of Anderson Cooper Co. as of December 31, 2017, contains the following.

ANDERSON COOPER CO.

ADJUSTED TRIAL BALANCE

DECEMBER 31, 2017

Dr.

Cr

Cash

\(19,472

Accounts Receivable

6,920

Prepaid Rent

2,280

Equipment

18,050

Accumulated Depreciation—Equipment

\) 4,895

Notes Payable

5,700

Accounts Payable

5,472

Common Stock

20,000

Retained Earnings

11,310

Dividend

3,000

Service Revenue

11,590

Salaries and Wages Expense

6,840

Rent Expense

2,260

Depreciation Expense

145

Interest Expense

83

Interest Payable

83

\(59,050

\)59,050

Instructions

(a) Prepare an income statement.

(b) Prepare a statement of retained earnings.

(c) Prepare a classified balance sheet.

Indicate whether each of the following items is a real or nominal account and whether it appears in the balance sheet or the income statement.

(a) Prepaid Rent.

(b) Salaries and Wages Payable.

(c) Inventory.

(d) Accumulated Depreciation—Equipment.

(e) Equipment.

(f) Service Revenue.

(g) Salaries and Wages Expense.

(h) Supplies.

BE3-9 (L03) Prepare the following adjusting entries at August 31 for Walgreens. (a) Interest on notes payable of \(300 is accrued. (b) Services performed but unbilled total \)1,400. (c) Salaries and wages earned by employees of \(700 have not been recorded. (d) Bad debt expense for year is \)900. Use the following account titles: Service Revenue, Accounts Receivable, Interest Expense, Interest Payable, Salaries and Wages Expense, Salaries and Wages Payable, Allowance for Doubtful Accounts, and Bad Debt Expense.

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.