Project 1 - Project 1: Ratios and Financial Planning at...

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

View Full Document Right Arrow Icon
Project 1: Name: Dan Grundman BCOR 2200 Intro to Finance CU ID#: 810-65-6101 2005 2006 forecast Industry Sales $12,870,000 14,000,000 2005 2006 forecast Low Median High COGS 9,070,000 10,250,600 Current ratio 0.75 0 0.68 1 0.5 1.43 1.89 Other expenses 1,538,000 1,244,000 Quick ratio 0.44 0 0.30 1 0.21 0.38 0.62 Depreciation 420,000 688,000 Cash ratio 0.16 1 0.03 1 0.08 0.21 0.39 EBIT 1,842,000 0 1,817,400 1 Interest 231,500 543,000 Total asset turnover 1.54 1 0.98 1 0.68 0.85 1.38 Taxable income $1,610,500 1 1,274,400 1 Inventory turnover (COGS) 19.22 1 7.63 1 4.89 6.15 10.89 Taxes (40%) 644,200 1 509,760 1 Receivables turnover 30.57 1 14.42 1 6.27 9.82 14.11 Net income $966,300 1 764,640 1 Total debt ratio 0.49 1 0.67 1 0.44 0.52 0.61 Dividends $289,890 400,000 Debt-equity ratio 0.96 1 2.07 1 0.79 1.08 1.56 Add to RE $676,410 1 364,640 1 Equity multiplier 1.96 1 3.07 1 1.79 2.08 2.56 Times interest earned 7.96 1 3.35 1 5.18 8.06 9.83 Current Assets Cash coverage ratio 9.77 1 4.61 1 5.84 8.43 10.27 Cash $234,000 103,800 Accounts rec. 421,000 971,000 Profit margin 7.51% 1 5.46% 1 4.05 6.98 9.87 Inventory 472,000 1,343,000 Return on assets 11.57%
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.

Page1 / 2

Project 1 - Project 1: Ratios and Financial Planning at...

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