Go to Doc Sharing for the detailed Course Project instructions


Question Description:

30

Hi would like to get some help with the attached. Required Ratios for Final Project Submission Earnings per Share of Common Stock Current Ratio Gross Profit Margin Rate of Return on Sales (Net Profit Margin) Inventory Turnover Days’ Inventory Outstanding (DIO) Accounts Receivable Turnover Days’ Sales Outstanding (DSO) Asset Turnover Rate of Return on Total Assets (ROA) Debt Ratio Times Interest Earned Ratio Dividend Yield (For the purposes of this ratio, use Yahoo Finance to look up current dividend yield and stock price; just note the date that you looked up this information.) Rate of Return on Common Stockholders’ Equity (ROE) Free Cash Flow Price/Earnings Ratio (Multiple) (For the purpose of this ratio, for Oracle, use the market price per share on May 30, 2011 and for Microsoft, use the market price per share on June 30, 2011.) ATTACHMENT PREVIEW Download attachment 504 template.xlsx 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 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 2012 net product sales of $549.9 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 $6.6 billion for 2012. 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. Oracle Interpretation and comparison between the two companies’ ratios (reading the Appendix of Chapter 13 will help you prepare the commentary). Microsoft 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 two companies on this basis. Remember—each ratio below requires a comparison. Earnings per Share of Common Stock (basic – common) Current Ratio As given in the income statement $ 1.69 $ 3.01 Current assets Current liabilities $39,174,000 $14,192,000 = 2.76 $2,113,485 $1,471,110 = 1.44 Gross Profit Margin Gross profit Net Sales $27,224,000 $35,622,000 = 76.4% $2,859,882 $6,644,252 = 43.0% Rate of Return (Net Profit Margin) on Sales Net Income Net Sales $8,547,000 $35,622,000 = 24.0% $660,931 $6,644,252 = 9.9% Cost of Goods Sold Average Inventory $8,398,000 $281,000 29.9 times $3,784,370 $641,108 365 days Inventory turnover 365 29.9 = 12 days 365 5.9 = 62 days Accounts Receivable Turnover Net credit sales Average Net Accounts Receivable $35,622,000 $6,106,500 = 5.8 $6,644,252 $430,441 = 15.4 Days’ sales outstanding (DSO) 365 Receivable Turnover Ratio 365 5.8 62.6 days 365 15.4 = 23.6 days Net Sales Average Total Assets $35,622,000 $67,556,500 = 0.53 $6,644,252 $4,580,967 = 1.45 Rate of return on sales times …

Answer

30