A) Interest Expense (D: 1575) and Interest Payable (C: 1575) PLEASE DOUBLE CHECK THIS ENTRY. B) Insurance Expense (D: 10,000) and Prepaid Insurance (C: 10,000) C) Rent Expense (D: 10,000) and Prepaid Expense (C: 10,000) D) Unearned Revenue (D: 2,000) and Consulting Revnue (C: 2,000) E) Supplies Expense (D: 44,277) and Supplies (C: 44,277). PLEASE DOUBLE CHECK THIS ENTRY

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

I need help to finish this worksheet. THANK YOU IN ADVANCE! I hope you are well and safe! :)

The adjusting entries are

A) Interest Expense (D: 1575) and Interest Payable (C: 1575) PLEASE DOUBLE CHECK THIS ENTRY.

B) Insurance Expense (D: 10,000) and Prepaid Insurance (C: 10,000)

C) Rent Expense (D: 10,000) and Prepaid Expense (C: 10,000)

D) Unearned Revenue (D: 2,000) and Consulting Revnue (C: 2,000)

E) Supplies Expense (D: 44,277) and Supplies (C: 44,277). PLEASE DOUBLE CHECK THIS ENTRY

F) Depreciation Expense (D: 75,000) and Accumulated Depreciation Equipment (C: 75,000)

G) Interest Receivable (D: 588) and Interest Revenue (C: 588)

H) Bad Debt Expense (D: 4,363) and Allownace for Doubtful Debt (C: 4,363)

I) Salaries and Wages Expense (D: 70,000) and Salaries and Wages Payable (C: 70,000)

J) Utilities Expense (D: 7,000) and Utilities Payable (C: 7,000)

 

This below is the AGING ANALYSIS

  Balance            December 31, 2020 Estimated % Uncollectible Estimated Amount Uncollectible  
Current                       187,616 2%    
1–30 days past due                       125,705 5%    
31–90 days past due                          35,345 10%    
Over 90 days past due                          30,290 25%    
Total Accounts Receivable  $                   378,956   $  
         

 

 

 

 

Although entries have been recorded all year, adjusting entries have not been recorded since December 31, 2018 when the financial statements were last prepared.
Refer to the Worksheet (1) tab for unadjusted account balance information as of December 31, 2019.
Use the following information to help in preparing adjusting entries for Rochester Enterprise.
a. On September 1, 2019, Rochester Enterprise had signed a 6.6% bank loan (refer to the worksheet) due in 4 years. This is the only outstanding note payable.
b. Prepaid insurance represents a 6-month insurance policy purchased on December 1, 2019.
On September 1, 2019, Rochester Enterprise paid $30,000 for a 5-month lease for office space.
с.
Unearned revenue represents a 12-month contract for consulting services that will be performed monthly. The payment from the customer was received on December 1,
d.
2019.
e.
A physical count revealed that supplies on hand at the end of the month total $6,777.
f. Equipment is depreciated on a straight-line basis; residual value is estimated to be $25,000 with an estimated service life of 5 years. The assets were held the entire year.
g.
On December 1, Rochester Enterprise accepted from Greene Supplies a 7-month note receivable at a 4.7% annual interest rate.
The company uses the percentage-of-receivables basis for estimating uncollectible accounts. The aging schedule of accounts receivable must be completed to determine
h.
management's desired balance for 2019.
i Accrued wages totaling $53,000 were unpaid and unrecorded at December 31, 2019.
j. Utility costs incurred but unrecorded for the month of December were estimated to be $5,000.
Transcribed Image Text:Although entries have been recorded all year, adjusting entries have not been recorded since December 31, 2018 when the financial statements were last prepared. Refer to the Worksheet (1) tab for unadjusted account balance information as of December 31, 2019. Use the following information to help in preparing adjusting entries for Rochester Enterprise. a. On September 1, 2019, Rochester Enterprise had signed a 6.6% bank loan (refer to the worksheet) due in 4 years. This is the only outstanding note payable. b. Prepaid insurance represents a 6-month insurance policy purchased on December 1, 2019. On September 1, 2019, Rochester Enterprise paid $30,000 for a 5-month lease for office space. с. Unearned revenue represents a 12-month contract for consulting services that will be performed monthly. The payment from the customer was received on December 1, d. 2019. e. A physical count revealed that supplies on hand at the end of the month total $6,777. f. Equipment is depreciated on a straight-line basis; residual value is estimated to be $25,000 with an estimated service life of 5 years. The assets were held the entire year. g. On December 1, Rochester Enterprise accepted from Greene Supplies a 7-month note receivable at a 4.7% annual interest rate. The company uses the percentage-of-receivables basis for estimating uncollectible accounts. The aging schedule of accounts receivable must be completed to determine h. management's desired balance for 2019. i Accrued wages totaling $53,000 were unpaid and unrecorded at December 31, 2019. j. Utility costs incurred but unrecorded for the month of December were estimated to be $5,000.
A
B
F
H
K
L
Rochester Enterprise
Note: With the exception of the Unadjusted Trial
Balance Columns, all cells must be formulas, not typed
in numbers.
2
End of Period Worksheet
For the Year Ended December 31, 2020
Unadjusted
Adjusted
Balance Sheet
DR
5 Account Title
Trial Balance
Adjustments
Trial Balance
Income Statement
6
DR
CR
DR
CR
DR
CR
DR
CR
CR
7 Cash
8 Accounts Receivable
9 Allowance for Doubtful Accounts
10 Interest Receivable
136,789
378,956
16,782
11 Note Receivable
12 Merchandise Inventory
13 Prepaid Insurance
14 Prepaid Rent
15 Supplies
16 Equipment
17 Accumulated Depreciation - Equipment
18 Accounts Payable
19 Salaries & Wages Payable
150,000
361,866
60,000
30,000
46,777
400,000
75,000
51,709
20 Unearned Revenue
24,000
21 Interest Payable
22 Utilities Payable
23 Note Payable (final payment due 2023)
350,000
270,600
424,500
24 Common Stock
25 Retained Earnings
26 Dividends
120,000
4,050,864
35,933
27 Sales
28 Consulting Revenue
29 Sales Returns and Allowances
300,000
100,000
1,950,000
1,200,000
30 Sales Discounts
31 Cost of Goods Sold
32 Salaries & Wages Expense
33 Depreciation Expense - Equipment
34 Bad Debt Expense
35 Insurance Expense
36 Rent Expense
37 Supplies Expense
38 Utilities Expense
65,000
39 Interest Revenue
40 Interest Expense
41
5,299,388
5,299,388
42 Net Income
43
44
45
Transcribed Image Text:A B F H K L Rochester Enterprise Note: With the exception of the Unadjusted Trial Balance Columns, all cells must be formulas, not typed in numbers. 2 End of Period Worksheet For the Year Ended December 31, 2020 Unadjusted Adjusted Balance Sheet DR 5 Account Title Trial Balance Adjustments Trial Balance Income Statement 6 DR CR DR CR DR CR DR CR CR 7 Cash 8 Accounts Receivable 9 Allowance for Doubtful Accounts 10 Interest Receivable 136,789 378,956 16,782 11 Note Receivable 12 Merchandise Inventory 13 Prepaid Insurance 14 Prepaid Rent 15 Supplies 16 Equipment 17 Accumulated Depreciation - Equipment 18 Accounts Payable 19 Salaries & Wages Payable 150,000 361,866 60,000 30,000 46,777 400,000 75,000 51,709 20 Unearned Revenue 24,000 21 Interest Payable 22 Utilities Payable 23 Note Payable (final payment due 2023) 350,000 270,600 424,500 24 Common Stock 25 Retained Earnings 26 Dividends 120,000 4,050,864 35,933 27 Sales 28 Consulting Revenue 29 Sales Returns and Allowances 300,000 100,000 1,950,000 1,200,000 30 Sales Discounts 31 Cost of Goods Sold 32 Salaries & Wages Expense 33 Depreciation Expense - Equipment 34 Bad Debt Expense 35 Insurance Expense 36 Rent Expense 37 Supplies Expense 38 Utilities Expense 65,000 39 Interest Revenue 40 Interest Expense 41 5,299,388 5,299,388 42 Net Income 43 44 45
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education