For most of the problems where the solution is contained in one step, you can do your work in that yellow cell. Where multiple steps are required, use any of the cells around the solution cell to show work. You must show work for credit, meaning you can't just type a number in the solution cell with no calculations. Please do not place any values in the green shaded cells. Numbers in parentheses are points per question. Tax rate = 40% Year 1 Year 2 Change Income Statement Year 2 Cash 100 150 50 Sales 6,000 Accts Receivable 500 470 (30) Cost of Goods Sold 5.000 Inventory 800 900 100 Gross Profit 1,000 Current Assets 1,400 1,520 120 Selling, General & Admin. Exp (SG&A) 450 Gross PP&E 2,500 2.750 250 Depreciation Exp 50 Accum Depreciation (500) (550) (50) Earnings Before Interest & Taxes (EBIT) 500 Net PP&E 2,000 2,200 200 Interest Exp 50 Total Assets 3,400 3,720 320 Earnings Before Taxes 450 Income Tax Expense 180 Accounts Payable 400 480 80 Net Income 270 Accured Liabilities 100 90 (10) Dividends 40 Short-term Debt (int-bearing) 100 200 100 Current Liabilities 600 770 170 Long-term Debt 1.100 1,050 (50) Fill in the Operating section of the statement of cash flow: (8) Total Liabilities 1,700 1,820 120 Common Stock 400 370 (30) Operating Activities Year 2 Retained Earnings 1,300 1,530 230 Net Income 270 Total Stockholder's Equity 1,700 1,900 200 Depreciation Exp 50 Total Liab & Equity 3,400 3,720 320 Accts Receivable 1. Solve for Free Cash Flow: (8) Inventory Accts Payable Accrued Liabilities Cash Flow From Operations How much of the FCF did the stock (Equity) investors receive? (2) = FCF For most of the problems where the solution is contained in one step, you can do your work in that yellow cell. Where multiple steps are required, use any of the cells around the solution cell to show work. You must show work for credit, meaning you can't just type a number in the solution cell with no calculations. Please do not place any values in the green shaded cells. Numbers in parentheses are points per question. Tax rate = 40% Year 1 Year 2 Change Income Statement Year 2 Cash 100 150 50 Sales 6,000 Accts Receivable 500 470 (30) Cost of Goods Sold 5.000 Inventory 800 900 100 Gross Profit 1,000 Current Assets 1,400 1,520 120 Selling, General & Admin. Exp (SG&A) 450 Gross PP&E 2,500 2.750 250 Depreciation Exp 50 Accum Depreciation (500) (550) (50) Earnings Before Interest & Taxes (EBIT) 500 Net PP&E 2,000 2,200 200 Interest Exp 50 Total Assets 3,400 3,720 320 Earnings Before Taxes 450 Income Tax Expense 180 Accounts Payable 400 480 80 Net Income 270 Accured Liabilities 100 90 (10) Dividends 40 Short-term Debt (int-bearing) 100 200 100 Current Liabilities 600 770 170 Long-term Debt 1.100 1,050 (50) Fill in the Operating section of the statement of cash flow: (8) Total Liabilities 1,700 1,820 120 Common Stock 400 370 (30) Operating Activities Year 2 Retained Earnings 1,300 1,530 230 Net Income 270 Total Stockholder's Equity 1,700 1,900 200 Depreciation Exp 50 Total Liab & Equity 3,400 3,720 320 Accts Receivable 1. Solve for Free Cash Flow: (8) Inventory Accts Payable Accrued Liabilities Cash Flow From Operations How much of the FCF did the stock (Equity) investors receive? (2) = FCF
