Umbrella Corporation End-of-Period Spreadsheet For the Year Ended December 31, 2002 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 11,800 11,800 Accounts Receivable 37,500 11,300 48,800 Supplies 2,840 2,000 840 Prepaid Insurance 4,200 4,000 200 Land 98,000 98,000 Building Accumulated Depreciation - Building 450,000 450,000 230,000 11,000 241,000 Equipment 107,000 107,000 Accumulated Depreciation - Equipment 87,300 6,550 93,850 Accounts Payable 21,690 21,690 Wages Payable 5,900 5,900 Common Stock 75,000 75,000 Retained Earnings 145,000 145,000 Dividends 10,000 10,000 Fees Earned 363,700 11,300 375,000 Wages Expense 160,000 5,900 165,900 Advertising Expense 18,000 18,000 Insurance Expense 4,000 4,000 Utilities Expense 11,000 11,000 Supplies Expense 2,000 2,000 Depreciation Expense - Building 11,000 11,000 Repairs Expense 8,050 8,050 Depreciation Expense - Equipment 6,550 6,550 Miscellaneous Expense 4,300 4,300 922,690 922,690 40,750 40,750 957,440 957,440

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
Topic Video
Question

Umbrella Corporation provides consulting for virology and pharmaceutical research. Umbrella Corporation prepared the following end-of-period spreadsheet at December 31, 2002, the end of the fiscal year:

 

  1. Prepare an income statement for the year ended December 31.
  2. Prepare a retained earnings statement for the year ended December.31.
  3. Prepare a balance sheet as of December 31.
  4. Based upon the end-of-period spreadsheet, journalize the closing entries.
  5. Prepare a post-closing trial balance.

(I primarilly need help with #5 post closing trial balance).

Umbrella Corporation
End-of-Period Spreadsheet
For the Year Ended December 31, 2002
Unadjusted
Adjusted
Trial Balance
Adjustments
Trial Balance
Account Title
Dr.
Cr.
Dr.
Cr.
Dr.
Cr.
Cash
11,800
11,800
Accounts Receivable
37,500
11,300
48,800
Supplies
2,840
2,000
840
Prepaid Insurance
4,200
4,000
200
Land
98,000
98,000
Building
Accumulated Depreciation - Building
450,000
450,000
230,000
11,000
241,000
Equipment
107,000
107,000
Accumulated Depreciation - Equipment
87,300
6,550
93,850
Accounts Payable
21,690
21,690
Wages Payable
5,900
5,900
Common Stock
75,000
75,000
Retained Earnings
145,000
145,000
Dividends
10,000
10,000
Fees Earned
363,700
11,300
375,000
Wages Expense
160,000
5,900
165,900
Advertising Expense
18,000
18,000
Insurance Expense
Utilities Expense
4,000
4,000
11,000
11,000
Supplies Expense
2,000
2,000
Depreciation Expense - Building
11,000
11,000
Repairs Expense
8,050
8,050
Depreciation Expense - Equipment
6,550
6,550
Miscellaneous Expense
4,300
4,300
922,690
922,690
40,750
40,750
957,440
957,440
Transcribed Image Text:Umbrella Corporation End-of-Period Spreadsheet For the Year Ended December 31, 2002 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 11,800 11,800 Accounts Receivable 37,500 11,300 48,800 Supplies 2,840 2,000 840 Prepaid Insurance 4,200 4,000 200 Land 98,000 98,000 Building Accumulated Depreciation - Building 450,000 450,000 230,000 11,000 241,000 Equipment 107,000 107,000 Accumulated Depreciation - Equipment 87,300 6,550 93,850 Accounts Payable 21,690 21,690 Wages Payable 5,900 5,900 Common Stock 75,000 75,000 Retained Earnings 145,000 145,000 Dividends 10,000 10,000 Fees Earned 363,700 11,300 375,000 Wages Expense 160,000 5,900 165,900 Advertising Expense 18,000 18,000 Insurance Expense Utilities Expense 4,000 4,000 11,000 11,000 Supplies Expense 2,000 2,000 Depreciation Expense - Building 11,000 11,000 Repairs Expense 8,050 8,050 Depreciation Expense - Equipment 6,550 6,550 Miscellaneous Expense 4,300 4,300 922,690 922,690 40,750 40,750 957,440 957,440
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Financial Statements
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
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