View the step-by-step solution to:

Go to Doc Sharing for the detailed Course Project instructions and grading rubric. Complete your Title page on this tab. Please include your name,...

Create an Excel spreadsheet or use the Project template to show your computations for the first 12 ratios listed below. Supporting calculations must be shown either as a formula or as text typed into a different cell.

Required Ratios for Final Project Submission
1) Earnings per Share
2) Current Ratio
3) Gross Profit Rate
4) Profit Margin Ratio
5) Inventory Turnover Ratio
6) Days in Inventory
7) Receivables Turnover Ratio
8) Average Collection Period
9) Asset Turnover Ratio
10) Return on Assets Ratio
11) Debt to Total Assets Ratio
12) Times Interest Earned Ratio
13) Payout ratio
14) Return on Common Stockholders’ Equity Ratio
15) Free Cash Flow
16) Current Cash Debt Coverage Ratio
17) Cash Debt Coverage Ratio
18) Price/Earnings Ratio [For the purpose of this ratio, for both Kohl’s and J.C. Penney, use the market price per share on January 31, 2011]


A template is attached.

Complete your Title page on this tab. Please include your name, the course, the date, your instructor's name, and the title for the Project. Go to Doc Sharing for the detailed Course Project instructions and grading rubric.
Background image of page 1
used for the Profiles on the Bibliography tab. Complete one paragraph profiling each company's business including information such as a brief history, where they are located, number of employees, the products they sell, etc. Please reference any websites you used Tootsie Roll Industries began in a small candy store in New York in 1896. Tootsie Roll is now headquartered in Chicago with operations throughout North America and with distribution channels in over 75 countries. According to Yahoo Finance, Tootsie Roll has 2,200 full-time employees. Tootsie Roll sells the following branded candy: Tootsie Roll, Tootsie Roll Pop, Charms Blow Pop, Mason Dots, Andes, Sugar Daddy, Charleston Chew, Double Bubble, Razzles, Caramel Apple Pop, and Junior Mints. Tootsie Roll had 2009 net product sales of $496 million. Hershey Company was founded by Milton S. Hershey in 1893 and is headquartered in Hershey, Pennsylvania. According to Yahoo Finance, Hershey had 12,100 full-time employees. Hershey is famous for the Hershey Bar, Hershey's Kisses, Hershey's Bliss, Reese's, Twizzlers, Almond Joy, Kit Kat, and Ice Breakers. Hershey had net product sales of $5.3 billion for 2009.
Background image of page 2
Show entire document
Sign up to view the entire interaction

Top Answer

Hi Please find the... View the full answer

8406849.xls

Go to Doc Sharing for the detailed Course Project
instructions and grading rubric. Complete your Title page on this tab.
Please include your name, the course, the date,
your instructor's name, and...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online