Question: 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 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
Get step-by-step solutions from verified subject matter experts
