finance - Case 1: Ratios and Financial Planning at S&S Air...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Case 1: Name: Xiaohan Cui CU ID#: 830336985 Note: Complete this after completing financial statements 2010 actual % 2011 forecast % Industry Statement of Cash Flows 2010-11 Sales $15,444,000 100.0% $20,255,000 100.0% 2010 2011 forecast Median COGS 10,884,000 70.5% 15,168,000 74.9% Current ratio 0.75 0.49 1.43 1 CF Operating Activities 217,680 Other expenses 1,845,600 12.0% 2,975,000 14.7% 1 Quick ratio 0.44 0.32 0.38 1 Net Income (2011) 773,040 2 Depreciation 504,000 3.3% 665,000 3.3% 1 Cash ratio 0.16 0.02 0.21 1 Depreciation (2011-Inc Stmt) 665,000 2 EBIT 2,210,400 14.3% 1,447,000 7.1% Change in A/R (1,168,800) 2 Interest 277,800 1.8% 627,800 3.1% 1 Total asset turnover 1.54 1.30 0.95 1 Change in inventory (348,260) 2 Taxable income 1,932,600 12.5% 819,200 4.0% 2 Inventory turnover (COGS) 19.22 16.58 6.15 1 Change in payables 296,700 2 Taxes (40%) 773,040 5.0% 327,680 1.6% 2 Receivables turnover 30.57 12.10 12.82 1 Net income 1,159,560 7.5% 491,520 2.4% 2 CF Investing Activities (2,178,400) Total debt ratio 0.49 0.49 0.50 1 Change in net capital spending (2,178,400) Dividends 347,868 375,000 Debt-equity ratio 0.96 0.97 1.01 1 Add to RE 811,692 116,520 1 Equity multiplier 1.96 1.97 2.01 1 CF Financing Activities 7,628,580
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/26/2011 for the course FIN 2200 taught by Professor Thomasnelson during the Spring '11 term at Colorado.

Page1 / 2

finance - Case 1: Ratios and Financial Planning at S&S Air...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online