please help.

File Home Insert Page Layout Formulas Data | - 10-AN = Paste * Cut Ca Copy Format Painter Clipboard D23 Font UBLIC 1 Homework Assignment 2 Data Sheet Assumptions 2017 2016 650 935 50 25 5 Accounts payables 885 6 Accounts receivables 950 7 Net Sales 7,800 5,500 8 Common stock 350 350 9 Operating costs 5,243 3,756 10 Gross fixed assets 4,500 3,500 11 Interest expense 12 Long-term debt 2,000 1,800 13 Depreciation & amortization 250 180 14 Notes Payable 576 550 15 Cash and equivalents 100 16 Accruals 17 Taxes Rate 40% 40% 18 Inventories 2,000 1,500 19 Dividends (20) (15) 20 Retained earnings Calc 1,500 21 Accumulated depreciation Calc 675 22 Common shares outstanding...100.000...100.000 23 200 60 Cut Arial -10 AAL A La Copy Paste Format Painter Clipboard AE BIU- Font Alic E90 1 Homework Assignment 2 (In thousands) 2017 2016 4 BALANCE SHEET 5 Asests 6 Cash and equivalents 7 Accounts receivables 8 Inventories 9 Total current assets 10 11 Gross Fixed assets 12 Less: Accumulated depreciation 13 Net fixed assets (plant & equip) 15 Total assets 16 17 Liabilities and Equity 18 Accounts payables 19 Accurals 20 Notes Payable 21 Total current liabilities 22 Long-term debt 23 Total liabilities 24 Common stock (100,000) 25 Retained earnings 26 Total common equity 28 Total liabilities and equity 0 0 0 31 INCOME STATEMENT 32 Net Sales 33 Operating costs except depr. & amort. 34 Depreciation and amortinzation 35 Total operating costs 36 Operating Income (EBIT) 37 less Interest aynense HEMBS IS Assumptions Sheet1 Select destination and press ENTER or choose Paste when printing - when we get pri Paste B / U. A. Format Painter Clipboard E90 1 Homework Assignment 2 In thousands) 2017 2016 30 31 INCOME STATEMENT 32 Net Sales 33 Operating costs except depr. & amort. 34 Depreciation and amortinzation 35 Total operating costs 36 Operating Income (EBIT) 37 Less Interest expense 38 Earnings before taxes (EBT) 39 Taxes (40%) 40 Net Income 1.55 2.75 0 0.00 0.00 41 Dividends 42 Income after dividends 43 44 Per-Share data: 45 Common Stock Price 46 Earnings per share (EPS) 47 Dividends per share (DPS) 48 Book value per shasre (BVPS) 49 50 51 STATEMENT OF CASH FLOW 52 Operating Activities 53 Net Income 54 Depreciation & amortization 55 Change in working capital: 56 Chg in accounts receivable 57 Chg in accounts inventory 58 Chg in accounts payable 59 Chg in accruals 60 Net cash provided by operating activities 61 62 Investing Activities B S IS Assumptions Sheet1 Select destination and press ENTER or choose Paste B when wege 10 AA Be Copy Paste Format Painter Clipboard .A BI U. 3 Font E90 B co 2017 2016 1 Homework Assignment 2 (In thousands) 51 STATEMENT OF CASH FLOW 52 Operating Activities 53 Net Income 54 Depreciation & amortization 55 Change in working capital: 56 Chg in accounts receivable 57 Chg in accounts inventory 58 Chg in accounts payable 59 Chg in accruals 60 Net cash provided by operating activities 62 Investing Activities 63 Fixed assets 65 Finance Activitites 66 Chg in notes payable 67 Chg in Long Term note 68 Chg in common stock 69 Payment of cash didends 70 Net cash provided by financing activities 71 72 Net change in cash 73 Cash at beginning of year 74 Cash at end of year 2017 2016 0.0 0.0 0.0 76 77 78 FINANCIAL RATIOS (see p.123) 79 Current ratio 80 Quick ratio 81 Inventory turnover 82 Days sales outstanding (DSO) 83 Total asset turnover 84 Total debt to total capital 85 Profit Margin B S IS Assumptions Sheet1 Select destination and press ENTER or choose Paste 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 H e 9 when printing pourt calenk when we get wanants ent