Need help with questions 4-6 for the assignment, please and thank you.
Analysis of Financial Statements Balance Sheets EXHIBITS: INPUT DATA (XYZ) Table 1 Balance Sheets 2013E 2012 2011 Assets Cash 9 85,632 $ 7,262 5 57,600 Accounts receivable 678,000 632,160 351,200 Inventories 1,716,480 1,267,360 715,200 Total current assets $2,680,112 $1,926,602 5 1,124,000 Gross fixed assets 1,197,160 1,202,950 491,000 Less: accumulated depreciation 380,120 263,160 146,200 Net fixed assets $ 617,040 $ 939,790 $ 344,600 Total assets $3,497,152 $2,666,592 3 1,466,600 Liabiiities and equity Accounts payable $ 436,600 $ 524,160 145,600 Notes payable 300,000 636,608 200,000 Accruals 408,000 489,600 136,000 Total current liabilities $1,144,600 61,650,568 481,600 Long-term bonds 400,000 723,432 323,432 Total debt $1,544,600 62,374,000 605,032 Common stock (100,000 shares) 1,721,176 460,000 460,000 Retained earnings 231,176 32,592 203,768 Total common equity $1,952,352 $ 492,592 663,758 Total liabilities and : - ul $3,497,152 $2,865,592 5 1,466,600 Analysis of Financial Statements Income Statements Table 2 Income Statements 20135 2012 Sales $7,035,600 $6,034,000 Cost 0" goods sold 5,375,992 5,526,000 Other expenses 550,000 519,966 Total operating exp. excl. depreciation and amortization $6,425,992 $6,047,966 EBITDA 6 609.606 $ (13,966) Depreciation and amortization 116.960 116.960 Earnings before interest and taxes (EBI'I') 5 492,646 $ (130,946) Interest expense 70,006 136,012 Earnings before taxes (EDT) 5 422,640 $ (266,960) Taxes (40%) 169,056 (106,764) Net Income 6 253.564 $ (160,176) Earnings per share (EPS) 5 1.014 $ (1.602) $ 0.660 Dividends per share (DPS) 6 0.220 6 0.110 6 0.220 Book value per share (BVPS) 5 7.609 $ 4.926 $ 6.636 Stock price 5 12.17 $ 2.25 $ 6.50 Shares outstanding 250,000 100,000 100,000 Tax rate 40.00% 40.00% 40.00% Lease payments 5 40,000 $ 40,000 $ 40,000 Sinking fund payments 0 0 0 Analysis of Financial Statements Ratio Analysis Current ratio Quick ratio Inventory turnover Days sales outstanding (D30) Fixed assets turnover Total assets turnover Debt-to-assets ratio Times interest eamed (TIE) Operating margin Profit margin Basic earning power (BEP) Rstum on assets (RDA) Return on equity (ROE) Prioafearnings (PIE) Marketlbook (W3) Book value per share (BVPS) 201 3E avvavvvwvvavvawv 2012 4.7 30.2 6.4 2.1 62.6% -1.0 -2.2% -2.7% 4.6% -5.6% -32.5% -1.4 0 5 54:93 2011 4.0 37.4 10.0 2.3 54.0% 4.3 5.6% 2.6% 13.0% 6.0% 13.3% 9.7 1 .3 $6.64 6.1 32.0 7.0 2.6 50.0% 6.2 7.3% 3.5% 19.1 % 9.1% 16.2% 1 4.2 2.4 ".8. {[115 pull-I15: [Hume tr! mu mum: margin. pmfil. nurngI. bash: emu; pen-er mail. return urn raters {Em and return an equier HEEL 5111.5 palatial-rule\" the zen pr'mfeerrng: ram. and marine-weal: ram. 5 [1.1.5 pull-Hail Use me amended Dui'mu equalhn tn prmde a eurn'urrur.I and mreniew n! M; flnanlm'urm u pmjmed Tar mu. lithium: I'll-rehabili- 5313 Debt $1,515 mermrremueeu Lam Her mam an Equ'tlf L551 Tntal arse-u $1.19? L'abiiu plus enum- $3.45!? rst. in! need mutt-ulna 11'1": rlm'lf HIE. Dsu: sale: .i 15.5 mergers: 511135.503 9' 355 Dam-53hr: $33,235.51 Target. HR: Dal-r sale he TargetDSD Target. Hit = 513.11% he 31
