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.
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...
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.