Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with these please, 1-3 and with the information that is provided. Analysis of Financial Statements Balance Sheets EXHIBITS: INPUT DATA (XYZ) Table 1

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Need help with these please, 1-3 and with the information that is provided.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Cases An Active Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

2nd Edition

0130674842, 978-0130674845

Students also viewed these Accounting questions