Question
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
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.
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 the title for the Project. 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 used for the Profiles on the Bibliography tab. 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. Use this Excel spreadsheet to compute ratios; show your computations for all ratios on this tab and also include your commentary. The financial statements used to calculate these ratios are available in Appendix A and Appendix B of your textbook. Interpretation and Comparison between the two companies' ratios (Reading the Appendix of Chapter 13 will help you prepare the commentary) Tootsie Hersheys The comparison of the ratios is an important part of the project. A good approach is to briefly explain what the ratio tells us. Indicate whether a higher or lower ratio is better. Then compare the 2 companies on this basis. Remember - each ratio below requires a comparison. Earnings per share Current ratio As given in the income statement $0.95 Basic Common $1.97 Current assets Current liabilities $211,878 $56,066 = 3.78 $1,385,434 $910,628 = 1.52 Gross Profit Ratio Gross profit Net Sales $176,947 $495,592 = 35.7% $2,053,137 $5,298,668 = 38.7% Profit margin ratio Net Income Net Sales $53,475 $495,592 = 10.8% $435,994 $5,298,668 = 8.2% Inventory Turnover Cost of Goods Sold Average Inventory $318,645 $55,986 5.7 times $3,245,531 $556,121 Days in Inventory 365 days Inventory turnover 365 5.7 = 64 days 365 5.8 = 63 days Receivable Turnover Ratio Net credit sales Average Net Receivables $495,592 $34,363 = 14.4 $5,298,668 $432,772 = 12.2 Average Collection Period 365 Receivable Turnover Ratio 365 14.4 = 25.3 days 365 12.2 = 29.8 Assets Turnover Ratio Net Sales Average Total Assets $495,592 $825,886 = 0.60 $5,298,668 $3,654,875 = 1.45 Return on Assets Ratio Net Income Average Total Assets $53,475 $825,886 = 6.5% $435,994 $3,654,875 = 11.9% Total Liabilities Total Assets $185,762 $838,247 = 22.2% $2,914,692 $3,675,031 = 79.3% Times Interest Earned Ratio Net Income + Int Expense + Tax Expense Interest Expense $64,422 $243 = 265.1 761,590 90,459 = 8.4 Payout ratio Cash dividend declared on common stock Net income $17,825 $53,475 = 33.3% $263,403 $435,994 = 60.4% Net income - Preferred stock dividend Average common stockholders' equity 53,475 643,627.50 = 8.3% $435,994 $555,142 = 78.5% Debt to Total Assets Ratio Return on Common Stockholders' Equity Free cash flow Cash provided by operations minus capital expenditures minus cash dividends paid $36,625 = $36,625 5.8 times $676,022 $676,022 = Current cash debt coverage ratio Cash provided by operations Average current liabilities $75,281 $57,344 = 1.31 $1,065,749 $1,090,420 = 0.98 Cash debt coverage ratio Cash provided by operations Average total liabilities $75,281 $182,259 = 0.41 $1,065,749 $3,099,734 = 0.34 Price/Earnings ratio Market price as of 12/31/2009 EPS as of 12/31/2009 $27.38 $0.95 = 29 $35.79 $1.97 = 18 You all get the chance to play the role of financial analyst below. The Summary should be a comparison of each company's performance for each major category of ratios (Liquidity, Solvency, and Profitability) listed below. Focus on major differences as you compare each company's performance. A nice way to conclude is to state which company you feel is the better investment and why. Liquidity: Tootsie Roll has the advantage for each of the liquidity ratios with the exception of the inventory turnover and days in inventory for which Hershey has a slight advantage. Tootsie Roll has a large advantage in liquidity as evidenced by the $3.78 in current assets they have for every in $1 in current liabilities while Hershey has only $1.52 in current assets for every dollar in current liabilities. Tootsie Roll also has a better current cash debt coverage ratio and the advantage for the receivables turnover and average collection period. Solvency: Tootsie Roll has the advantage for each of the solvency ratios with the exception of free cash flow. Tootsie Roll can cover their interest expense 265 times with income before interest and taxes while Hershey can only cover their interest expense 8 times with their income before interest and taxes. Hershey has $676 million in free cash flow while Tootsie Roll has approximately $37 million in free cash flow. Free cash flow can be used to undertake acquisitions, pay additional dividends, pay down debt, or by back stock. Profitability: Hershey has the advantage for each of the profitability ratios with the exception of the PriceEarnings and profit margin ratios. Hershey has a significant edge in asset turnover and return on common stockholders' equity. Hershey has $1.45 in sales for every dollar in assets while Tootsie Roll has 60 cents in sales for every dollar in assets. Hershey has a return on common stockholders' equity ratio of 78% compared to 8% for Tootsie Roll. Hershey also has a much larger payout ratio (60% to 33%). Conclusion: Tootsie Roll is the safer investment when you examine the liquidity and solvency ratios; however, Hershey has the edge for two significant profitability ratios. These ratios are return on common stockholders' equity and the payout ratio. That said, since I believe in the importance of fiscal strength, I would invest in Tootsie Roll; however, if I was looking for more growth potential, I would invest in Hershey because of their stronger profitability ratios. The Appendixes of your textbook and any information you use to profile the companies should be cited as a reference below. Big Charts (2011). Retrieved September 4, 2011 from http://bigcharts.marketwatch.com/historical/default.asp? symb=hsy&closeDate=12%2F31%2F09&x=0&y=0 Hershey's (2011). Retrieved September 4, 2011 from http://www.hersheys.com/pure-products.aspx HSY Profile (2011). Retrieved September 4, 2011 from http://finance.yahoo.com/q/pr?s=HSY+Profile Kimmel, P. D., Weygandt, J. J., & Kieso, D. E. (2011). Financial accounting: Tools for business decision making, 6th ed. Danvers, MA: Wiley & Sons, Inc. Tootsie Roll Industries (2011). Retrieved September 4, 2011 from http://www.tootsie.com/ TR Profile (2011). Retrieved September 4, 2011 from http://finance.yahoo.com/q/pr?s=TR+ProfileStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started