Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A1 1 2 File Home Insert Draw Page Layout Formulas Data 11 B General fx Spark Mindset Cash Flow Analysis A B Spark Mindset Cash
A1 1 2 File Home Insert Draw Page Layout Formulas Data 11 B General fx Spark Mindset Cash Flow Analysis A B Spark Mindset Cash Flow Analysis Spring 2022 Actual Year 2021 3 4 Revenues - high school students 5 Revenues - adult learners 6 7 8 9 Accounts receivable - high schools Accounts receivable - adult learners Commissions expense Commissions payable Projected Year 2022 88,200 110,300 571,200 745,000 7,400 10,200 47,600 73,000 21,400 27,800 900 1,200 10 Salaries and benefits expense 638,900 947,000 11 Rent expense 12,000 12,400 12 Prepaid rent 1,200 1,200 13 Prepaid insurance 2,800 3,000 14 High school expenses (Cost of Sales) 49,400 65,300 15 Adult learner expenses (Cost of Sales) 68,500 98,700 16 Long-term debt 0 0 17 Depreciation expense 10,000 18,000 18 Other operating expenses 50,000 55,000 19 Accounts payable 14,800 15,700 20 Salaries and benefits payable 26,600 37,500 21 Payroll taxes payable 2,700 3,800 22 Income tax expense 0 0 Fixed assets, net of accumulated 35,000 45,000 23 depreciation 24 Retained earnings (Accumulated deficit) (96,000) 25 Common and preferred stock 400,000 400,000 26 Cash 255,000 75,000 27 Interest expense 0 Question 1 5 pts From the 2021 Statement of Operations (Income Statement), what is Gross Profit? 541,500 Question 2 5 pts From the 2022 Statement of Retained Earnings, what is the Beginning Retained Earnings (Accumulated Deficit)? There is not enough information given to answer this question. $2,800 0 None of the other answers is correct. Question 3 From the 2021 Balance Sheet, what are Current Assets? 314,000 5 pts Question 4 From the 2022 Statement of Cash Flows, what is Cash Provided (Used) by Operating Activities? Question 5 From the 2022 Statement of Cash Flows, what is Cash Provided (Used) by Investing Activities? 5 pts 5 pts
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started