1. **DUE SUNDAY 5/29/16 @ 3pm**

Tootsie Roll Industries Inc

In this module, you will complete and submit your final project for Tootsie Roll Industries Inc. You will perform a vertical and horizontal analysis and a ratio analysis. Then you will interpret these analyses for your audience, as well as researching competitor information. Lastly, you will use the information from your analysis and research this week as well as the information you gathered during the weekly Financial Accounting Projects to come to a decision about whether you would recommend investment in the company or not.

This week's submission will include the following:

1. Workbook Spreadsheet from Module 02:* ATTACHED*Please go over and correct vertical and horizontal (Page 1) and complete Page 2

Page 1^-Completethe vertical and horizontal analysis calculations for the figures you collected in the Module 02 Financial Accounting Project.

Page 2-Completethe financial ratios on the second page of the workbook you started in Module 02.

2. Research Paper:

*Introduce your company TOOTSIE ROLL INDUSTRIES to your audience. Share company history, values, goals, product lines, industry challenges, and any other interesting facts you find. Share what industry or industries your company operates in. Who are their major competitors?

*Analyze the horizontal and vertical analysis you completed in the workbook. Choose three items from each analysis that you feel are important to highlight, positive or negative. Share what these items mean in terms of the company's performance and your recommendation to invest or not to invest based on these figures.

*Analyze the ratio analysis you completed in the workbook. Address each area of ratio analysis: liquidity, solvency, profitability, and market analysis. Interpret these ratios, and explain what they mean for your company, supporting your explanation with your calculations.

*Locate or calculate at least 5 key ratios from your company's main competitor ( just choose one) Compare your company to the competition and explain which company is performing better. Support your explanation with your calculations or research of the competition.

*Advise your audience as to whether to invest in Tootsie Roll Industries Inc. Remember to support your recommendation with the figures calculated in your analysis. Your work should support your recommendation.Prepare a clear and concise professional business report. Use proper APA formatting, including a cover page, in-text citations, and a reference page. Your finished research paper should be 4-6 pages long. Please answer all questions and do not make general statements. This project and needs to be descriptive

Submit two files to the drop box:

1. 1. Research paper in Word.
   2. CompanyanalysisinyourExcelWorkbook.
   3. **DUE SUNDAY 5/29/16 @ 3pm**

Complete blue highlighted areas only for week 1. There are no calculations this week. Keep a copy of this spreadsheet for use in w Table I Vertical and Horizontal Analysis Vertical Analysis year 1 Tootsie Roll Industries (TR) Income Statement Revenue (Net Product Sales) Cost of Goods (Product Cost of Goods Sold) Product Gross (Profit) Margin Total Operating Expenses (selling, mkting, admin) Earnings from Operations Interest Expense Income Taxes Net Earnings (after tax) Year 1 (enter the years used) Year 2 539,895 340,933 198,962 117,772 83,923 99 28,434 62,860 Vertical Analysis Year 2 Year 3 539,627 350,960 188,667 119,133 72,353 91 23,634 60,849 $545,985 365573 180,412 133,842 69,479 137 22,160 52,004 100% 63% 37% 22% 16% 1% 5% 12% 100% 65% 35% 22% 13% 1% 4% 11% 7% 11% 4% 8% 26% 21% 100% 7% 17% 24% 76% 100% 7% 10% 4% 1% 26% 22% 100% 7% 17% 23% 77% 100% Balance Sheet Cash/cash equivalents (cash) Investments (short term) Net Accounts Receivable (Trade) Inventory (materials, WIP, FG) Total Current Assets Net Fixed Assets(PPE, net) Total Assets Total Current Liabilities Total Noncurrent Liabilities Total Liabilities Total Stockholders Equity Total liabilities + Stockholders Equity 62,860 100,198 39,450 70,379 264,621 190081 910,386 64,459 154,791 219,250 690,809 910,386 60,849 88,283 33,572 11,063 240,111 196916 888,409 60,121 147,983 208,104 680,305 888,409 63862 18746 42108 62383 197241 201290 846737 60765 136157 196922 649815 846737 Other Information Stock Price at end of year Dividends paid Common shareholder Outstanding Shares Common Stock 29.02 1.18 60,562 30.73 1.11 61,399 25.16 1.0682673969 61347 Basic EPS (Earnings Per Share) Treasury Stock Auditing Firm 1.05 1992 PWC Prepared by your name HEATHER BENNETT Select numbers taken from financial statements Include the source here 0.99 1992 PWC 0.72 1992 PWC eadsheet for use in week 8. Horizontal Analysis 1% -3% 5% -1% 16% 9% 20% 3% 3% 13% 18% 536% 10% -3% 2% 7% 5% 6% 67% 2% Table 2 Ratio Analysis Tootsie Roll Industries Inc. Formula Liquidity And Efficiency Ratios Current Ratio Accounts Receivable Turnover Inventory Turnover Total Asset Turnover 1. Complete the formu 2. Use the numbers on 3. One * means you did Two ** means you g 4. For column E choose You do not need to c just remember to cit Solvency Ratios Debt to Equity Ratio Debt Ratio Times Interest Earned Ratio Profitability Ratios Profit Margin Ratio Gross Profit Margin Ratio Return on Total Assets Return on Common Stockholder's Equity EPS** Market Analysis Price Earning Ratio** Dividend Yield** *Calculated by Author ** Information from give souce Prepared by Ratio for Ratio for Type in year 1 Type in year 2 Type in Comparison Company here and it ratios** Year Net Incomeet revenue Gross profitet revenue 1. Complete the formula column. See example. 2. Use the numbers on the previous page to complete the ratios-Use Excel formulas. 3. One * means you did the calculations Two ** means you got the information from another source (cite that source) 4. For column E choose a competitor or the Industry. You do not need to calculate the competitor ratios, you can use pre-calculated ratios just remember to cite your source. (like a database)