I cannot figure out or understand what she is asking for here - I cannot seem to access the parts of the companies she wants.

Module 01: fill in the numbers-this tab only. Complete PURPLE highlighted areas only. There are no ANALYSIS calculations in we may need to calculate some of the line items per the instructions in the labels I have provided for guidance. Module 04: Complete the Horizontal and Vertical Analysis cells in GREEN, consider completing the OPTIONAL information in the go to the Financial Ratios tab and complete the GREEN cells there. Table I Vertical Analysis 2016 Tootsie Roll Industries Income Statement Net Revenue (Total revenue) Cost of Goods (Product cost of goods sold) Gross Profit (Total gross margin) Total Operating Expenses (Sell, Marketing & Admin Ex Earnings from Operations Interest Expense Income Taxes (Provision for Income Taxes) Net Earnings 2016 521,100,000 320,290,000 199,791,000 107,377,000 92,414,000 0 30,593,000 67,510,000 2015 540,112,000 340,090,000 196,602,000 108,051,000 91,082,000 0 26,451,000 66,089,000 2014 543,525,000 340,933,000 201,645,000 117,722,000 83,923,000 0 28,434,000 63,298,000 100.00% 61.46% 38.34% 20.61% 17.73% 0.00% 5.87% 12.96% Balance Sheet Cash and cash equivalents Short term investments (Investments) Net Accounts Receivable (Accounts receivable trade) Inventory (Add: FG and WIP + RM & supplies lines) Current Assets (Total current assets) Net Fixed Assets (Net property, plant & Equipment) Total Assets Current Liabilities (Total current liabilities) Long Term Liabilities (Total noncurrent liabilities) Total liabilities (Add total current liab + total noncurre Stockholders Equity (Total equity) 119,145,000 67,513,000 42,964,000 57,531,000 299,300,000 180,905,000 920,101,000 63,561,000 145,002,000 208,563,000 711,538,000 126,145,000 42,155,000 51,010,000 62,263,000 293,806,000 184,586,000 908,983,000 72,062,000 138,373,000 210,435,000 698,548,000 100,108,000 39,450,000 43,253,000 70,379,000 264,621,000 190,081,000 910,386,000 64,459,000 154,791,000 219,250,000 691,136,000 12.95% 7.34% 12.95% 6.25% 32.53% 19.66% 100.00% 6.91% 15.76% 22.67% 77.33% Total liabilities + Shareholders Equity Prepared by your name Select numbers taken from financial statements Tootsie Roll Industries SEC Form 10-K Optional Information Any Preferred Stock Dividends paid Common shareholder Dividents paid to Preferred shareholder Outstanding Shares Common Stock Basic EPS (Earnings Per Share) Auditing Firm 920,101,000 908,983,000 910,386,000 100.00% YSIS calculations in week 1, though you ovided for guidance. AL information in the ORANGE cells, and Vertical Analysis 2015 Horizontal Analysis Change in balances from 2014 to 2016 100.00% 65.26% 37.73% 20.01% 16.86% 0.00% 5.08% 12.68% Items in place already are CHECK FIGURES for you. -4.13% Formulas: -6.05% Vertical Analysis = Item/Net Revenue. This means "Net Revenue" is our 100% number on the income statement, Total Assets is -0.92% Horizontal Analysis = (Current Year - Base Year)/Base Year. This shows the amount of change in an account from the designated -8.79% 10.12% If you double-click on any of the cells I have completed here, you will see the formulas used. Feel free to use these 0.00% as an example as you write your own formulas for the calculations of these items. 7.59% 6.65% 13.88% 4.64% 5.61% 6.85% 32.32% 20.31% 100.00% 7.93% 15.22% 23.15% 76.85% 19.02% 71.14% Notes & Helpers: -0.67% 1. Since the 100% figures for vertical analysis are always going to be Net Revenue and Total Assets (and thereby Total Liabilities -18.26% 2. Horizontal and Vertical analysis measure two COMPLETELY different things, so they cannot be compared to eachother. I shou 13.11% analysis paper/presentation next week like "The vertical analysis of X is 40%, but the horizontal analysis of X is -2%, so the verti -4.83% 3. An analysis statement for vertical analysis might read like this: 1.07% "The stockholder's equity is almost 77% of the total assets, meaning most of the assets are financed through ownership of -1.39% company's shares. This means TRI is in a good position to take on additional debt if they find the need to do so, but also means -6.32% there may be a large number of shareholders who are looking for dividend payments on their shares, so that's a consideration -4.87% 4. An analysis statement for a horizontal analysis might look like this: 2.95% "Earnings from operations has increased by almost 26%, while other financial measures like Total Liabilities have increased 100.00% 1.07% ways to finance operations without taking on additional debt, indicating they are keeping to their goals of having low liabilities for their shareholders." For Module 04, you want to identify these items. They can be found in the SEC Form 10-K that you've been working with. 0.7323572318 e statement, Total Assets is our 100% number on the balance sheet. Everything is relative to those two items. ccount from the designated base year to the current year. ee to use these and thereby Total Liabilities & Equity), they are poor analysis items to choose for your analysis. mpared to eachother. I should NOT see language in your lysis of X is -2%, so the vertical is better." NONONO.Nonsensical. :o) nced through ownership of the ed to do so, but also means that es, so that's a consideration that they need to be aware of." al Liabilities have increased only slightly. This shows that TRI has found oals of having low liabilities and remaining a less risky investment opportunity Table II Formula 2016 Competition or Industry Ratio** Ratio Benchmarks 2015 2016 Current Ratio *Current assets/current liabilities 14.48 4.08 Greater than 1. Acid Test Ratio *(cash+short term investments +accounts receivable)/current liabilities 3.61 3.04 Ideally greater than 1, usually is less than Current Ratio Inventory Turnover *Cost of Goods Sold/Average Inventory *(remember, Avg Inv is beginning of year inv + ending of year inv, result divided by 2.) 5.35 5.13 Depends on industry, higher is better Accounts Receivable Turnover Net Sales/Average Accounts Receivable 12.13 10.58 Ideally will agree with credit terms offered. Debt Ratio *Total Liabilities/Total Assets 6.91% 7.93% Less than 67% Debt to Equity Ratio *Total Liabilities/Total Equity 7.00% 8.00% Not too high, not too low. Times Interest Earned Ratio *Operating Income/Interest Expense 0.00 0.00 Tootsie Roll Industries TRI TRI Liquidity Ratios Asset Management Ratio Solvency Ratios Profitability Ratios Higher the better, unless 0.00 interest exp is 0. Gross Profit Percent *Gross profitet revenue 38.34% 37.73% Depends on industry, higher is better Profit Margin *Net Income/Net Sales 12.96% 12.68% Depends on industry, higher is better Return on Total Assets *Earnings from Operations/Total Assets 10.00% 10.00% Higher is better Return on Equity *Net Income/Average Equity 73.20% 77.30% Higher the better **Locate in research (on Earnings Per Share (EPS) Attributable to TRcompany income statement) $1.08 $1.02 Depends on company. Would want to see stay stable or increase, not decrease. Market Analysis Price Earning Ratio **Locate in research (on Internet) Depends on company. Remaining steady is good. Dividend Yield **Locate in research (on Internet) Depends on company. Remaining steady is good. *Calculated by Author **Researched information References. Your references can go in this green box. If you're more comfortable with it, you ca COMPLETE THIS TAB as part of your MODULE 04 ANALYSIS 1. Formula column is completed for you. 2. One * means you will do the calculations on your own Two ** means you will research the information from another source (cite that source) 4. For column E choose a competitor or the industry averages. Competitors include Hershey, Rocky Mountain Chocolate Co, etc. You do not need to calculate the competitor ratios, you can use pre-calculated ratios just remember to cite your source. (like the Mergent database) Formulas that result in "number of times" answers include: Current Ratio, Acid Test Ratio, Inventory Turnover, and Times Interest Earned Ratio. Formulas that result in "percentage" answer include: Debt Ratio, Gross Profit Percentage, and Return on Net Sales. Earnings per share results in a dollar amount answer and is located on the income statement. You can locate the market analysis ratios in the Mergent database or by searching online at a site such as Morningstar, ycharts, stocks-on-the-net, or other reputable resources. Remember to cite your sources! Cite your sources, and as long as your references are credible, you will be considered correct for the market analysis figures. s can go in this green box. If you need more space, you can resize the cell simply by grabbing the line between row 25 and 26 and dragging down. comfortable with it, you can create a new tab in the workbook to include your sources instead. Source: https://www.sec.gov/Archives/edgar/data/98677/000110465914014392/a13-25823_2ex13.htm *** Use the 2014 colum 4014392/a13-25823_2ex13.htm Use the 2014 column for your spreadsheet, but use the actual 10-K docum e actual 10-K document for your 2015 balance sheet info