2. The following data refers to the 2022 year-end account balances for Mastermind. However, the Retained Earnings balance is as of 12/31/2021. The accounts are listed in alphabetical order. $ Accounts Payable 25,000 Accounts Receivable 8,500 Accumulated Depreciation 175,000 Cash 141,613 Common Stock 100,000 Fixed Assets (gross) 410,000 Inventory 135,000 Long Term Debt 111,000 Retained Earnings (2021) 51,992 Salary Payable 11,000 A. Prepare a classified Balance Sheet for Mastermind on Sheet 2 of your spreadsheet. Rename Sheet 2 “Balance Sheet”. Include working Excel formulas for all calculations. B. Calculate Mastermind’s Net Working Capital beneath the balance sheet.
2. The following data refers to the 2022 year-end account balances for Mastermind. However, the
$
Accounts Payable |
25,000 |
|
8,500 |
|
175,000 |
Cash |
141,613 |
Common Stock |
100,000 |
Fixed Assets (gross) |
410,000 |
Inventory |
135,000 |
Long Term Debt |
111,000 |
Retained Earnings (2021) |
51,992 |
Salary Payable 11,000
A. Prepare a classified
B. Calculate Mastermind’s Net
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![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 Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![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 Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)