Use the Income Statement and Selected Balance Sheet info below to complete Accounting Detective's statement of cash flow. There were no NON CASH investing or financing activities, and you do not need the detail of those activities to complete this problem. This will be required to be written out on your PDF upload in the proper format. You may use the worksheet I provided. Accounting Detectives Income Statement For the year ending December 31, 2021 Net Sales 200,000 Cost of Goods Sold 125,000 Gross Profit 75,000 Operating Expenses General & Admin expenses 40,000 Selling & Marketing expenses 20,000 Amortization expense 3,000 Partial comparative balance sheet with select information needed: Depreciation expense 15,000 Total Operating Expenses 78,000 12/31/21 12/31/20 Loss from Operations (3,000) Cash 10,000 25,000 Other expenses Accounts Receivable, Net 45,000 10,000 Loss on sale of equipment 2,000 Inventory 8,000 6,000 Total other expenses 2,000 Property, Plant & Equipment 48,000 18,000 Accounts Payable Net Loss (5,000) 10,000 6,000 Unearned Revenue 3,000 20,000 Partial comparative balance sheet with select information need Loan Payable (long term) 150,000 Treasury Stock (12,000) (7,000) Retained Earnings 100,000 105,00 You may enter the subtotal for Operating Activities to get an idea of your score.
Use the Income Statement and Selected Balance Sheet info below to complete Accounting Detective's statement of cash flow. There were no NON CASH investing or financing activities, and you do not need the detail of those activities to complete this problem. This will be required to be written out on your PDF upload in the proper format. You may use the worksheet I provided. Accounting Detectives Income Statement For the year ending December 31, 2021 Net Sales 200,000 Cost of Goods Sold 125,000 Gross Profit 75,000 Operating Expenses General & Admin expenses 40,000 Selling & Marketing expenses 20,000 Amortization expense 3,000 Partial comparative balance sheet with select information needed: Depreciation expense 15,000 Total Operating Expenses 78,000 12/31/21 12/31/20 Loss from Operations (3,000) Cash 10,000 25,000 Other expenses Accounts Receivable, Net 45,000 10,000 Loss on sale of equipment 2,000 Inventory 8,000 6,000 Total other expenses 2,000 Property, Plant & Equipment 48,000 18,000 Accounts Payable Net Loss (5,000) 10,000 6,000 Unearned Revenue 3,000 20,000 Partial comparative balance sheet with select information need Loan Payable (long term) 150,000 Treasury Stock (12,000) (7,000) Retained Earnings 100,000 105,00 You may enter the subtotal for Operating Activities to get an idea of your score.
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter22: Master Budget (master)
Section: Chapter Questions
Problem 2R: Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas...
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 1 images
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
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College