/*! 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} Q7E E3-7 (L03) (Analyze Adjusted Dat... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

E3-7 (L03) (Analyze Adjusted Data) A partial adjusted trial balance of Piper Company at January 31, 2017, shows the following.

PIPER COMPANY

ADJUSTED TRIAL BALANCEJANUARY 31, 2017

Debit (\() Credit(\))Supplies \( 700Prepaid Insurance 2,400Salaries and Wages Payable \) 800UnearnedService Revenue 750Supplies Expense 950Insurance Expense 400Salaries and Wages Expense 1,800Service Revenue 2,000

InstructionsAnswer the following questions, assuming the year begins January 1.(a) If the amount in Supplies Expense is the January 31 adjusting entry, and \(850 of supplies was purchased in January,what was the balance in Supplies on January 1?(b) If the amount in Insurance Expense is the January 31 adjusting entry, and the original insurance premium was for oneyear, what was the total premium and when was the policy purchased?(c) If \)2,500 of salaries was paid in January, what was the balance in Salaries and Wages Payable at December 31, 2016?(d) If $1,600 was received in January for services performed in January, what was the balance in Unearned Service Revenueat December 31, 2016?

Short Answer

Expert verified

(a)Supplies on January 1 are $800

(b) Purchased the premium policy in August 2016.

(c) Salaries and wages payable on December 31, 2016, are $100

(d) Unearned service revenue on December 31 2016, was $350

Step by step solution

01

Meaning of Trial balance

A trial balance means a worksheet that lists all the ending balances of the ledger accounts on their respective debit or credit side.

02

Calculation of Supply balance on January 1

³§³Ü±è±è±ô²â b²¹±ô²¹²Ô³¦±ð J²¹²Ô³Ü²¹°ù²â 1 =³§³Ü±è±è±ô²â b²¹±ô²¹²Ô³¦±ð J²¹²Ô³Ü²¹°ù²â 31 +³§³Ü±è±è±ô¾±±ð²õ E³æ±è±ð²Ô²õ±ð²õ −±Ê³Ü°ù³¦³ó²¹²õ±ð²õ  =$700+$950−$850=$1650−$850=$800

The supply balance on January 1 is$800

03

Calculation of total insurance purchase

Calculation of insurance expense per year

±õ²Ô²õ³Ü°ù²¹²Ô³¦±ð E³æ±è±ð²Ô²õ±ð p±ð°ù y±ð²¹°ù (°Õ´Ç³Ù²¹±ô p°ù±ð³¾¾±³Ü³¾)=±õ²Ô²õ³Ü°ù²¹²Ô³¦±ð E³æ±è±ð²Ô²õ±ð p±ð°ù″¾´Ç²Ô³Ù³ó×12=$400×12=$4800

Calculation of prepaid insurance balance at the beginning of the year

±Ê°ù±ð±è²¹¾±»å i²Ô²õ³Ü°ù²¹²Ô³¦±ð b²¹±ô²¹²Ô³¦±ð (beginning)=±Ê°ù±ð±è²¹¾±»å i²Ô²õ³Ü°ù²¹²Ô³¦±ð+±õ²Ô²õ³Ü°ù²¹²Ô³¦±ð p°ù±ð³¾¾±³Ü³¾=$2,400+$400=$2,800

Calculation of Insurance purchased

±õ²Ô²õ³Ü°ù²¹²Ô³¦±ð p³Ü°ù³¦³ó²¹²õ±ð»å″¾´Ç²Ô³Ù³ó±ô²â= ±õ²Ô²õ³Ü°ù²¹²Ô³¦±ð e³æ±è±ð²Ô²õ±ð p±ð°ù y±ð²¹°ù−prepaidinsurance(beginning)±õ²Ô²õ³Ü°ù²¹²Ô³¦±ð e³æ±è±ð²Ô²õ±ð p±ð°ù″¾´Ç²Ô³Ù³ó=$4,800−$2,800$400=5″¾´Ç²Ô³Ù³ó²õ

Premium purchased for (Total premium) $4800

Premium purchased month is August 2016 (5 months before January which means August, September, October, November and December)

04

Calculation of salaries and wages payable on December 31, 2016

³§²¹±ô²¹°ù¾±±ð²õ a²Ô»å w²¹²µ±ð²õ p²¹²â²¹²ú±ô±ð a³Ù D±ð³¦±ð³¾²ú±ð°ù 31, 2016=³§²¹±ô²¹°ù¾±±ð²õ e³æ±è±ð²Ô²õ±ð²õ +°Â²¹²µ±ð²õ p²¹²â²¹²ú±ô±ð−³§²¹±ô²¹°ù¾±±ð²õ p²¹¾±»å=$1800+$800−$2500=$2600−$2500=$100

Salaries and wages payable on December 31, 2016, are$100

05

Calculation of unearned service revenue on December 31 2016

±«²Ô±ð²¹°ù²Ô±ð»å s±ð°ù±¹¾±³¦±ð r±ð±¹±ð²Ô³Ü±ð a³Ù D±ð³¦31,2016=°ä²¹²õ³ó r±ð³¦±ð¾±±¹±ð»å −³§±ð°ù±¹¾±³¦±ð r±ð±¹±ð²Ô³Ü±ð+±«²Ô±ð²¹°ù²Ô±ð»å s±ð°ù±¹¾±³¦±ð r±ð±¹±ð²Ô³Ü±ð´Ç²Ô J²¹²Ô 31=$1600−$2000+$750=−$400+$750=$350

Unearned service revenue on December 31 2016, was$350

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

Mason Advertising was founded in January 2013. Presented below are adjusted and unadjusted trial balances as of December 31, 2017.


MASON ADVERTISINGTRIAL BALANCEDECEMBER 31, 2017


UnadjustedAdjusted

Dr.

Cr.

Dr.

Cr.

Cash

\( 11,000

\) 11,000

Accounts Receivable

20,000

23,500

Supplies

8,400

3,000

Prepaid Insurance

3,350

2,500

Equipment

60,000

60,000

Accumulated Depreciation—Equipment

\( 28,000

\) 33,000

Accounts Payable

5,000

5,000

Interest Payable

–0–

150

Notes Payable

5,000

5,000

Unearned Service Revenue

7,000

5,600

Salaries and Wages Payable

–0–

1,300

Common Stock

10,000

10,000

Retained Earnings

3,500

3,500

Service Revenue

58,600

63,500

Salaries and Wages Expense

10,000

11,300

Insurance Expense

850

Interest Expense

350

500

Depreciation Expense

5,000

Supplies Expense

5,400

Rent Expense

4,000

4,000

\(117,100

\)117,100

\(127,050

\)127,050

Instructions

  1. Journalize the annual adjusting entries that were made. (Omit explanations.)
  2. 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.
  3. Answer the following questions.
    1. If the note has been outstanding 3 months, what is the annual interest rate on that note?
    2. If the company paid $12,500 in salaries and wages in 2017, what was the balance in Salaries and Wages Payable on December 31, 2016?

What differences are there between the trial balance before closing and the trial balance after closing with respect to the following accounts?

a) Accounts payable

b) Expense accounts

c) Revenue accounts

d) Retained Earnings account

e) Cash

Question: Presented below is the trial balance of the Crestwood Golf Club, Inc. as of December 31. The books are closed annually on December 31.


CRESTWOOD GOLF CLUB, INC.

TRIAL BALANCE

DECEMBER 31

Debit

Credit

Cash

\(15,000

Accounts receivables

13,000

Allowance for doubtful accounts

\)1,100

Prepaid insurance

9,000

Land

350,000

Building

120,000

Accumulated depreciation – building

38,400

Equipment

150,000

Accumulated depreciation – equipment

70,000

Common stock

400,000

Retained earnings

82,000

Dues revenue

200,000

Green fees revenue

5,900

Rent revenue

17,600

Utilities expenses

54,000

Salaries and wages expenses

80,000

Maintenance and repair expenses

24,000

\(815,000

\)815,000

Instructions

(a) Enter the balances in ledger accounts. Allow five lines for each account.

(b) From the trial balance and the information given below, prepare annual adjusting entries and post to the ledger accounts. (Omit explanations.)

(1) The buildings have an estimated life of 30 years with no salvage value (straight-line method).

(2) The equipment is depreciated at 10% per year.

(3) Insurance expired during the year \(3,500.

(4) The rent revenue represents the amount received for 11 months for dining facilities. The December rent has not yet been received.

(5) It is estimated that 12% of the accounts receivable will be uncollectible.

(6) Salaries and wages earned but not paid by December 31, \)3,600.

(7) Dues received in advance from members $8,900 were recorded as Dues Revenue.

(c) Prepare an adjusted trial balance.

(d) Prepare closing entries and post.

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.