Excel Steel Company
Get your Assignment in a Minimum of 3 hours
Our academic experts are ready and waiting to assist with any writing project you may have. From simple essay plans, through to full dissertations, you can guarantee we have a service perfectly matched to your needs.
Free Inquiry
Excel Steel Company |
|||||
Comparative Balance Sheet |
|||||
12/31/22 |
12/31/21 |
Change |
|||
Cash |
20,000.00 |
30,500.00 |
|||
Accounts receivable |
17,000.00 |
13,000.00 |
|||
Inventory |
25,000.00 |
20,000.00 |
|||
Supplies |
900.00 |
500.00 |
|||
Prepaid insurance |
800.00 |
2,000.00 |
|||
Equipment, net of accumulated depreciation |
36,000.00 |
40,000.00 |
|||
Total assets |
99,700.00 |
106,000.00 |
|||
Accounts payable |
35,000.00 |
41,000.00 |
|||
Salaries payable |
13,000.00 |
16,000.00 |
|||
Common stock, $10 par value |
25,000.00 |
25,000.00 |
|||
Additional paid-in capital |
14,000.00 |
14,000.00 |
|||
Retained earnings |
12,700.00 |
10,000.00 |
|||
Total liabilities and stockholders’ equity |
99,700.00 |
106,000.00 |
|||
Excel Steel Company, Inc. |
|||||
Income Statement |
|||||
Fiscal Year Ending 12/31/2022 |
|||||
Sales |
70,000.00 |
||||
Cost of goods sold |
30,000.00 |
||||
Gross profit |
40,000.00 |
||||
Salary expense |
10,000.00 |
||||
Supplies expense |
1,000.00 |
||||
Insurance expense |
20,000.00 |
||||
Depreciation expense |
4,000.00 |
||||
Total Operating Expenses |
35,000.00 |
||||
Net income |
5,000.00 |
||||
(A) Using the direct method, prepare the operating activities section of the statement of cash flows |
|||||
for the year ended December 31, 2022 (recommend using the chart in item B below) |
|||||
(B) Enter the appropriate amounts in the designated cells below. Indicate negative numbers using parenthesis such as (1,000). |
|||||
( C ) Show your calculations for each value you present in the chart below |
|||||
Cash flows from operating activities |
Amount |
||||
1. Cash received from customers |
|||||
2. Cash paid to purchase inventory |
|||||
3. Cash wages paid to employees |
|||||
4. Cash paid for supplies |
|||||
5. Cash paid for insurance |
|||||
6. Net cash flow from operating activities |
"Is this question part of your assignment? We Can Help!"
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper Now"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"
Get Started