please show work

3 After each question you'll see a yellow pre-formatted cell where your final solution will appear. 4 For most of the problems where the solution is contained in one step, you can do your work in that yellow cell. 5 Where multiple steps are required, use any of the cells around the solution cell to show work. 6 You must show work for credit, meaning you can't just type a number in the solution cell with no calculations. 7 Please do not place any values in the green shaded cells. 8 Numbers in parentheses are points per question 9 Tax rate 40% 10 Year 1 Year 2 Change Income Statement Year 2 11 Cash 100 150 50 Sales 6,000 12 Accts Receivable 500 470 (30) Cost of Goods Sold 5,000 13 Inventory 800 900 100 Gross Profit 1.000 14 Current Assets 1,400 1,520 120 Seling. General & Admin Exp (SG&A) 450 15 Gross PP&E 2,500 2.750 250 Depreciation Exp 50 16 Accum Depreciation (500) (550) (50) Earnings Before Interest & Taxes (EBIT) 500 17 Net PP&E 2,000 2,200 200 Interest Exp 50 18 Total Assets 3,400 3,720 320 Earnings Before Taxes 450 19 Income Tax Expense 180 20 Accounts Payable 400 480 80 Net Income 270 21 Accured Liabilities 100 90 (10) Dividends 40 22 Short-term Debt (int-bearing) 100 200 100 23 Current abilities 600 770 24 Long-term Debt 1,100 1,050 (50) Fill in the Operating section of the statement of cash flow: (B) 25 Total abilities 1,700 1,820 120 25 Common Stock 400 370 (30) Operating Activities Year 2 27 Retained Earnings 1.300 1.530 230 Net Income 270 28 Total Stockholder's Equity 1,700 1,900 200 Depreciation Exp 50 29 Total Liab & Equity 3,400 3.720 320 30 Accts Receivable 31 1. Solve for Free Cash Flow; (8) Inventory 32 Acets Payable 33 Accrued Liabilities 34 35 Cash Flow From Operations 36 FCF How much of the FCF did the stock (Equity) investors receive? (2) 37 38 170 FCF Ratios 1 Ratios 2 TVM Bonds + Ready 3 After each question you'll see a yellow pre-formatted cell where your final solution will appear. 4 For most of the problems where the solution is contained in one step, you can do your work in that yellow cell. 5 Where multiple steps are required, use any of the cells around the solution cell to show work. 6 You must show work for credit, meaning you can't just type a number in the solution cell with no calculations. 7 Please do not place any values in the green shaded cells. 8 Numbers in parentheses are points per question 9 Tax rate 40% 10 Year 1 Year 2 Change Income Statement Year 2 11 Cash 100 150 50 Sales 6,000 12 Accts Receivable 500 470 (30) Cost of Goods Sold 5,000 13 Inventory 800 900 100 Gross Profit 1.000 14 Current Assets 1,400 1,520 120 Seling. General & Admin Exp (SG&A) 450 15 Gross PP&E 2,500 2.750 250 Depreciation Exp 50 16 Accum Depreciation (500) (550) (50) Earnings Before Interest & Taxes (EBIT) 500 17 Net PP&E 2,000 2,200 200 Interest Exp 50 18 Total Assets 3,400 3,720 320 Earnings Before Taxes 450 19 Income Tax Expense 180 20 Accounts Payable 400 480 80 Net Income 270 21 Accured Liabilities 100 90 (10) Dividends 40 22 Short-term Debt (int-bearing) 100 200 100 23 Current abilities 600 770 24 Long-term Debt 1,100 1,050 (50) Fill in the Operating section of the statement of cash flow: (B) 25 Total abilities 1,700 1,820 120 25 Common Stock 400 370 (30) Operating Activities Year 2 27 Retained Earnings 1.300 1.530 230 Net Income 270 28 Total Stockholder's Equity 1,700 1,900 200 Depreciation Exp 50 29 Total Liab & Equity 3,400 3.720 320 30 Accts Receivable 31 1. Solve for Free Cash Flow; (8) Inventory 32 Acets Payable 33 Accrued Liabilities 34 35 Cash Flow From Operations 36 FCF How much of the FCF did the stock (Equity) investors receive? (2) 37 38 170 FCF Ratios 1 Ratios 2 TVM Bonds + Ready