The amounts of the assets and liabilities of Excalibur Travel Agency at December 31, 20Y5, the end of the year, and its revenue and expenses for the year follow. The capital of James Brewster, owner, was $650,000 on January 1, 20Y5, the beginning of the year. During the year, James withdrew $36,000. Accounts Amounts Accounts payable $68,000 Accounts receivable 267,000 Cash 183,000 Fees earned 897,600 Land 544,000 Miscellaneous expense 6,200 Rent expense 35,000 Supplies 5,200 Supplies expense 4,200 Utilities expense 27,000 Wages expense 508,000 Required: 1. Prepare an income statement for the year ended December 31, 20Y5.* 2. Prepare a statement of owner's equity for the year ended December 31, 20Y5.* 3. Prepare a balance sheet as of December 31, 20Y5.* 4. What item appears on both the statement of owner's equity and the balance sheet? *Be sure to complete the statement heading. Refer to the information given and the lists of Accounts, Labels, and Amount Descriptions provided for the exact wording of the answer choices for text entries.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
The amounts of the assets and liabilities of
Excalibur Travel Agency at December 31, 20Y5,
the end of the year, and its revenue and
expenses for the year follow. The capital of
James Brewster, owner, was $650,000 on
January 1, 20Y5, the beginning of the year.
During the year, James withdrew $36,000.
Accounts
Amounts
Accounts payable $68,000
Accounts receivable 267,000
Cash 183,000
Fees earned 897,600
Land 544,000
Miscellaneous expense 6,200
Rent expense 35,000
Supplies 5,200
Supplies expense 4,200
Utilities expense 27,000
Wages expense 508,000
Required:
1. Prepare an income statement for the year
ended December 31, 20Y5.*
2. Prepare a statement of owner's equity for the
year ended December 31, 20Y5.*
3. Prepare a balance sheet as of December
31, 20Y5.*
4. What item appears on both the statement of
owner's equity and the balance sheet?
*Be sure to complete the statement heading.
Refer to the information given and the lists of
Accounts, Labels, and Amount Descriptions
provided for the exact wording of the answer
choices for text entries.
Transcribed Image Text:The amounts of the assets and liabilities of Excalibur Travel Agency at December 31, 20Y5, the end of the year, and its revenue and expenses for the year follow. The capital of James Brewster, owner, was $650,000 on January 1, 20Y5, the beginning of the year. During the year, James withdrew $36,000. Accounts Amounts Accounts payable $68,000 Accounts receivable 267,000 Cash 183,000 Fees earned 897,600 Land 544,000 Miscellaneous expense 6,200 Rent expense 35,000 Supplies 5,200 Supplies expense 4,200 Utilities expense 27,000 Wages expense 508,000 Required: 1. Prepare an income statement for the year ended December 31, 20Y5.* 2. Prepare a statement of owner's equity for the year ended December 31, 20Y5.* 3. Prepare a balance sheet as of December 31, 20Y5.* 4. What item appears on both the statement of owner's equity and the balance sheet? *Be sure to complete the statement heading. Refer to the information given and the lists of Accounts, Labels, and Amount Descriptions provided for the exact wording of the answer choices for text entries.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.