Question

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

please help.

Answer 1

Homework Assignment
(In thousands)	2017	2016
BALANCE SHEET
Assets
Cash and equivalents	100	60
Accounts receivables	935	950
Inventories	2000	1500
Total current assets	3035	2510
Gross Fixed assets	4500	3500
Less: Accumlated depreciation	925	675
Net fixed assets (plant & equip)	3575	2825
Total assets	6610	5335
Liabilities and equity
Accounts payables	650	885
Accruals	200	250
Notes Payable	576	550
Total current liabilities	1426	1685
Long-term debt	2000	1800
Total Liabilities	3426	3485
Common stock (100,000)	350	350
Retained earnings	2834.2	1500
Total common equity	3184.2	1850
Total Liabilites and equity	6610.2	5335
INCOME STATEMENT
Net Sales	7800	5500
operating cost except depr & amort	5243	3756
Depreciation and amortisation	250	180
Total operating costs	5493	3936
Operating Income (EBIT)	2307	1564
Less Interest expense	50	25
Earnings before taxes(EBT)	2257	1539
Taxes(40%)	902.8	615.6
Net Income	1354.2	923.4
Dividends	20	15
Income after dividends	1334.2	908.4
Per-share data:
Common stock price	2.75	1.55
Earnings per share(EPS)	0.013542	0.009234
Dividends per share(DPS)	0.0002	0.00015
Book value per share(BVPS)	0.031842	0.0185
STATEMENT OF CASH FLOW
Operating activities:
Net Income	1354.2
Depreciation & amortization	250
Change in working capital:
chg in accounts receivable	15
chg in accounts inventory	-500
chg in accounts payable	-235
cha in accruals	-50
Net cash provided by operating activities	834.2
Investing activities
Fixed assets	-1000
Finance Activities
Cng in notes payable	26
Chg in Long term note	200
Chg in common stock	0
Payment of cash dividends	-20
Net cash provided by financing activities	206
Net change in cash	40.2
Cash at beginning of year	60
Cash at end of year	100.2
Financial ratios:
Current ratio	2.128331	1.489614
Quick ratio	0.725806	0.599407
Inventory turnover	0.25641	0.272727
Days sales outstanding(DSO)	43.75321	63.04545
Total asset turnover	0.847436	0.97
Total debt to total capital	0.628101	0.972973
Profit margin(%)	17.36154	16.78909