Ben Olson Project 1 - Project 1 Ratios and Financial...

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

View Full Document Right Arrow Icon
Project 1: Ratios and Financial Planning at S&S Air Name: Ben Olson BCOR 2200 Intro to Finance CU ID#: 810084879 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.94 1 0.44 0.52 0.61 Dividends $289,890 400,000 Debt-equity ratio 0.61 1 7.71 1 0.79 1.08 1.56 Add to RE $676,410 1 364,640 1 Equity multiplier 1.96 1 18.10 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% 1 5.37% 1 6.05 10.53 13.21 Total CA $1,127,000 0 2,417,800 1 Return on equity 22.70% 1 97.23% 1 9.93 16.54 26.15 Fixed assets Net PP&E $7,228,000 11,813,000 Retention ratio 0.70 1 0.48 1 Total Assets $8,355,000 1 14,230,800 1 Internal growth rate 8.81% 1 2.63% 1 Sustainable growth rate 18.89% 1 86.45% 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 3,534,960 1 S&S 2005 22.70% 7.51% 1.54 1.96 4 Long-term debt $2,595,000 6,064,200 S&S 2006 97.23% 5.46% 0.98 18.10 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 676,410 3 Item Pts Score Comment
Image of page 1

Info icon This 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 ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern