Excalibur Corporation sells video games for personal computers. The unadjusted trial balance as of December 31, 2024, appears below. December 31 is the company's reporting year-end. The company uses the perpetual inventory system. Account Title Cash Accounts receivable Supplies Prepaid rent Inventory Office equipment Accumulated depreciation Accounts payable Salaries payable Notes payable (long-term) Common stock Retained earnings Dividends Sales revenue Cost of goods sold Interest expense Salaries expense Rent expense Supplies expense Utility expense Totals Debits $ 51,760 23,000 Credits 2,700 21,000 54,000 67,000 $ 8,710 26,600 3,200 28,800 80,000 15,300 6,000 215,000 112,500 0 34,750 0 0 4,900 $ 377,610 $ 377,610 Information necessary to prepare the year-end adjusting entries appears below. 1. The office equipment was purchased in 2022 and is being depreciated using the straight-line method over an eight-year useful life with no residual value. 2. Accrued salaries at year-end should be $4,800. 3. The company borrowed $28,800 on September 1, 2024. The principal is due to be repaid in 10 years. Interest is payable twice a year on each August 31 and February 28 at an annual rate of 10%. 4. The company debits supplies when supplies are purchased. Supplies on hand at year-end cost $420. 5. Prepaid rent expired during the period is $13,700. Cash dividends paid to shareholders during the year amounted to $6,000.
Excalibur Corporation sells video games for personal computers. The unadjusted trial balance as of December 31, 2024, appears below. December 31 is the company's reporting year-end. The company uses the perpetual inventory system. Account Title Cash Accounts receivable Supplies Prepaid rent Inventory Office equipment Accumulated depreciation Accounts payable Salaries payable Notes payable (long-term) Common stock Retained earnings Dividends Sales revenue Cost of goods sold Interest expense Salaries expense Rent expense Supplies expense Utility expense Totals Debits $ 51,760 23,000 Credits 2,700 21,000 54,000 67,000 $ 8,710 26,600 3,200 28,800 80,000 15,300 6,000 215,000 112,500 0 34,750 0 0 4,900 $ 377,610 $ 377,610 Information necessary to prepare the year-end adjusting entries appears below. 1. The office equipment was purchased in 2022 and is being depreciated using the straight-line method over an eight-year useful life with no residual value. 2. Accrued salaries at year-end should be $4,800. 3. The company borrowed $28,800 on September 1, 2024. The principal is due to be repaid in 10 years. Interest is payable twice a year on each August 31 and February 28 at an annual rate of 10%. 4. The company debits supplies when supplies are purchased. Supplies on hand at year-end cost $420. 5. Prepaid rent expired during the period is $13,700. Cash dividends paid to shareholders during the year amounted to $6,000.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Please see below
1. Complete the worksheet below.
2-a. Use the information in the worksheet to prepare an income statement for 2024.
2-b. Use the information in the worksheet to prepare a statement of shareholders’ equity for 2024.
2-c. Use the information in the worksheet to prepare a
3. Prepare the necessary closing entries assuming that
![Excalibur Corporation sells video games for personal computers. The unadjusted trial balance as of December 31, 2024, appears
below. December 31 is the company's reporting year-end. The company uses the perpetual inventory system.
Account Title
Cash
Accounts receivable
Debits
$ 51,760
Credits
23,000
2,700
Supplies
Prepaid rent
Inventory
Office equipment
Accumulated depreciation
Accounts payable
Salaries payable
Notes payable (long-term)
Common stock
Retained earnings
Dividends
Sales revenue
Cost of goods sold
Interest expense
Salaries expense
Rent expense
Supplies expense
Utility expense
Totals
21,000
54,000
67,000
$ 8,710
26,600
3,200
28,800
80,000
15,300
6,000
215,000
112,500
0
34,750
0
0
4,900
$ 377,610
$ 377,610
Information necessary to prepare the year-end adjusting entries appears below.
1. The office equipment was purchased in 2022 and is being depreciated using the straight-line method over an eight-year useful life
with no residual value.
2. Accrued salaries at year-end should be $4,800.
3. The company borrowed $28,800 on September 1, 2024. The principal is due to be repaid in 10 years. Interest is payable twice a
year on each August 31 and February 28 at an annual rate of 10%.
4. The company debits supplies when supplies are purchased. Supplies on hand at year-end cost $420.
5. Prepaid rent expired during the period is $13,700.
Cash dividends paid to shareholders during the year amounted to $6,000.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F782dc1ea-a325-438a-8439-b06822464c0e%2Fc6a5f1f1-8e86-4dc8-bf46-a441cf25e54e%2Fre0mnwb_processed.png&w=3840&q=75)
Transcribed Image Text:Excalibur Corporation sells video games for personal computers. The unadjusted trial balance as of December 31, 2024, appears
below. December 31 is the company's reporting year-end. The company uses the perpetual inventory system.
Account Title
Cash
Accounts receivable
Debits
$ 51,760
Credits
23,000
2,700
Supplies
Prepaid rent
Inventory
Office equipment
Accumulated depreciation
Accounts payable
Salaries payable
Notes payable (long-term)
Common stock
Retained earnings
Dividends
Sales revenue
Cost of goods sold
Interest expense
Salaries expense
Rent expense
Supplies expense
Utility expense
Totals
21,000
54,000
67,000
$ 8,710
26,600
3,200
28,800
80,000
15,300
6,000
215,000
112,500
0
34,750
0
0
4,900
$ 377,610
$ 377,610
Information necessary to prepare the year-end adjusting entries appears below.
1. The office equipment was purchased in 2022 and is being depreciated using the straight-line method over an eight-year useful life
with no residual value.
2. Accrued salaries at year-end should be $4,800.
3. The company borrowed $28,800 on September 1, 2024. The principal is due to be repaid in 10 years. Interest is payable twice a
year on each August 31 and February 28 at an annual rate of 10%.
4. The company debits supplies when supplies are purchased. Supplies on hand at year-end cost $420.
5. Prepaid rent expired during the period is $13,700.
Cash dividends paid to shareholders during the year amounted to $6,000.
![Complete the worksheet below.
Account Title
Unadjusted Trial
Balance
Adjusting Entries
Adjusted Trial
Balance
Income Statement
Balance Sheet
Debit
Credit
Debit
Credit
Debit
Credit
Debit
Credit
Debit
Credit
Cash
$ 51,760
Accounts receivable
23,000
Supplies
2,700
Prepaid rent
21,000
Inventory
54,000
Office equipment
67,000
Accumulated depreciation
$ 8,710
Accounts payable
26,600
Salaries payable
3,200
Notes payable (long-term)
28,800
Interest payable
0
Common stock
80,000
Retained earnings
15,300
Dividends
6,000
Sales revenue
215,000
Cost of goods sold
112,500
Interest expense
Salaries expense
34,750
Rent expense
Supplies expense
Utilities Expense
4,900
Depreciation expense
Net income
Totals
377,610 377,610
$
0 $
0 $
0 $
0
69
$
0 $
0 $
0 $
0 $
0 $
0 $
0 $
0](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F782dc1ea-a325-438a-8439-b06822464c0e%2Fc6a5f1f1-8e86-4dc8-bf46-a441cf25e54e%2Fknujt3o_processed.png&w=3840&q=75)
Transcribed Image Text:Complete the worksheet below.
Account Title
Unadjusted Trial
Balance
Adjusting Entries
Adjusted Trial
Balance
Income Statement
Balance Sheet
Debit
Credit
Debit
Credit
Debit
Credit
Debit
Credit
Debit
Credit
Cash
$ 51,760
Accounts receivable
23,000
Supplies
2,700
Prepaid rent
21,000
Inventory
54,000
Office equipment
67,000
Accumulated depreciation
$ 8,710
Accounts payable
26,600
Salaries payable
3,200
Notes payable (long-term)
28,800
Interest payable
0
Common stock
80,000
Retained earnings
15,300
Dividends
6,000
Sales revenue
215,000
Cost of goods sold
112,500
Interest expense
Salaries expense
34,750
Rent expense
Supplies expense
Utilities Expense
4,900
Depreciation expense
Net income
Totals
377,610 377,610
$
0 $
0 $
0 $
0
69
$
0 $
0 $
0 $
0 $
0 $
0 $
0 $
0
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education