Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please include all cell references used to complete the table. please use the same cells to complete this question please show which cells to use
Please include all cell references used to complete the table.
please use the same cells to complete this question
please show which cells to use when calculating answers
A C D E G H 1 1 19 $ $ 35.00% 2,000 4,000 OUTPUT 2018 Change Source Use Operating Investing Financing $ $ $ $ 's 2019 10,000 $ 6,000 5 8,000 $ 8,000 $ 32,000's 6,000 1,500 10,000 9,000 26,500 20 21 Additional Data for 2019 22 Effective Tax rate 23 Stock dividends paid 24 Depreciation Expertise 25 26 Balance Sheet 27 Assets 28 Cash 29 Accounts Receivable 30 Inventory 31 Net Property, Plant & Equipment 32 Total Assets 33 34 Liabilities & Stockholders' Equity 35 Accounts Payable 36 Accrued Expenses 37 long term Note Payable Total Debt 19 Preferred Stock 40 Common Stock 41 Retained Earings 42 Total Liabilities & Stockholders' Equity 43 44 45 Income Statement 2019 46 Sales 47. Cost of Goods Sold 4 Gross Profit 49 Operating Expenses (including depreciation) 50 EMY 51 Interest Expense 52 EBT 53 Tax 54 Net Income from continuing operations SS $ $ $ $ $ $ $ $ 4,000 $ 1,000 5 10,000 $ 15,000 $ 800$ 10,000 6.2005 32 000 $ 5,800 2.000 10,000 17.00 700 5.000 3.000 26,500 change in cash OFI OFF $ $ $ $ $ $ $ $ $ 135,000 10.000 27.000 16.000 11.000 3.000 8.000 2.800 5.200 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