Project 1 Key

Project 1 Key - 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
Name: BCOR 2200 Intro to Finance CU ID#: 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 1 0.5 1.43 1.89 Other expenses 1,538,000 1,244,000 Quick ratio 0.44 0 1 0.21 0.38 0.62 Depreciation 420,000 688,000 Cash ratio 1 1 0.08 0.21 0.39 EBIT 1,842,000 0 1 Interest 231,500 543,000 Total asset turnover 1 1 0.68 0.85 1.38 Taxable income 1 1 Inventory turnover (COGS) 1 1 4.89 6.15 10.89 Taxes (40%) 1 1 Receivables turnover 1 1 6.27 9.82 14.11 Net income 1 1 Total debt ratio 1 1 0.44 0.52 0.61 Dividends $289,890 400,000 Debt-equity ratio 1 1 0.79 1.08 1.56 Add to RE 1 1 Equity multiplier 1 1 1.79 2.08 2.56 Times interest earned 1 1 5.18 8.06 9.83 Current Assets Cash coverage ratio 1 1 5.84 8.43 10.27 Cash $234,000 103,800 Accounts rec. 421,000 971,000 Profit margin 1 1 4.05 6.98 9.87 Inventory 472,000 1,343,000 Return on assets 1 1 6.05 10.53 13.21 Total CA $1,127,000 0 1 Return on equity 1 1 9.93 16.54 26.15 Fixed assets $7,228,000 11,813,000 Retention ratio 1 1 Total Assets 1 1 Internal growth rate 1 1 Sustainable growth rate 1 1 Current Liabilities 15 17 Accounts Payable $497,000 539,000 Notes Payable 1,006,000 2,995,960 DuPont Framework ROE = PM x TATO x EM Total CL $1,503,000 0 1 4 Long-term debt $2,595,000 6,064,200 4 Industry 16.5 6.98 0.85 2.08 Shareholder Equity Common stock $100,000 110,000 Grading Criteria Retained earnings $4,157,000 3 Item Pts Score Comment Total Equity 1 1 Fin Statements 20 20 1 1 Ratios 40 40 Question 1 8 8 7 13 Question 2 8 8 Questions Note: be sure to include time series and industry comparisons in your response Question 3 8 8 1)
Background image of page 1

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

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

{[ snackBarMessage ]}

Page1 / 4

Project 1 Key - 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