Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help calculating the financial analysis rations using the below information. I'm not sure how to calculate EBIT, Total Equity etc. I need to
I need help calculating the financial analysis rations using the below information. I'm not sure how to calculate EBIT, Total Equity etc. I need to calculate the following ratios:
1.Total Debt Ratio
2. Debt-Equity Ratio
3. Equity Multiplier
4. Times Interest Earned Ratio
5. Cash Coverage Ratio
6. Inventory Turnover
7. Day's Sales in Inventory
8. Receivable's Turnover
9. Day's Sales in Receivables
10. Total Asset Turnover
11. Profit Margin
12. Return on Assets
13. Return on Enquiry
14. Earnings Per Share
15. Price-Earnings Ratio
16. Market - to - Book Ratio
I need tbe ratios for 2016, 2015 and 2014 where applicable.
EXHIBIT 3 Avon Products, Inc. Consolidated Income Statements millions, except per share data Years Ended December 31 2016 2015 Net sales $5.578.8 $6,076.5 Other revenue 1389 84.0 Total revenue 5.717.7 6,160.5 201 $7.472.5 175.5 7.648.0 Costs, expenses and other: 2,257.0 3.0069 3.1388 2.445.4 3.543.2 4 2068 321.9 165,0 434.3 Cost of sales Selling, general and administrative expenses Impairment of goodwil Operating prolit Interest expense (Gain loss on extinguishment of debt Interest income Other expense, net Gain on sale of business 136.6 120.5 1088 (1.1) (15.8) 171.0 (14.8) 139.5 (125) 73.7 (449) 142.3 Total other expenses 233.5 290.7 312 (124.6) 200.8 (545.3 1934) (819.2) (796.5) (349.1) 344.5) (14.0) (40.4) (107.4) (1.145.6 Income from continuing operations, before taxes Income taxes Loss from continuing operations, net of tax Loss from discontinued operations, net of tax Net loss Net income attributable to noncontrolling interests Net loss attributable to Avon Loss per share: Basic from continuing operations Basic from discontinued operations 10.22 3.3) $11.148.9 (384.9) (3.7) $ 388.6) $ (107.6 $ (0.25) $ $ 10.19) 10.09) Basic attributable to Avon (0.03) 10.29) (0.25) (1.81) 10.79) (2.60) (181) 10.79) 10.88) Diluted from continuing operations $ $ $ 10.79) 10.09) Diluted from discontinued operations (0.03) Diluted attributable to Avon 10.29) (2.60) 10.88) Weighted average shares outstanding: Basic 435.2 437.0 437.0 434.5 434.5 4352 Diluted Source: Avon 2016 annual report. EXHIBIT 4 Avon Products, Inc., Consolidated Balance Sheets $ millions, except per share data) December 31 2015 2016 Assets Current Assets Cash, including cash equivalents of $79.4 and $123.2 Accounts receivable (less allowances of $131.1 and $86.7) $ 654.4 458.9 Inventories 586.4 2913 Prepaid expenses and other Current assets of discontinued operations Total current assets Property, plant and equipment, at cost $ 686.9 443.0 6240 296.1 291.1 2.341,1 1,992.3 Land Buildings and improvements Equipment 29.5 621.5 773.1 32.2 665.8 797.7 1.424.1 Less accumulated depreciation Property, plant and equipment, net Goodwill (712.8) 711.3 1.495.7 (728.8 766.9 92.3 490.0 93 6 Other assets 621.7 Noncurrent assets of discontinued operations 180.1 Total assets $3.418.9 $3.870.4 Liabilities and Shareholders' (Deficit) Equity Current Liabilities Debt maturing within one year $18.1 $ 55.2 774.2 Accounts payable 768.1 129.2 Accrued compensation 157.6 419.6 Other accrued liabilities 401.9 Sales and taxes other than income 147.0 10.7 Income taxes 174.9 23.9 100.0 Payable to discontinued operations Current abilities of discontinued operations 10.7 489.7 Total current liabilities 1,485.7 2,195.1 Long-term debt 1,875.8 2.150.5 Employee benefit plans 164.5 177.5 continued EXHIBIT 4 Continued December 31 2016 2015 78.6 65.1 205.8 78.4 Long-term income taxes Other liabilities Noncurrent liabilities of discontinued operations 260.2 Total liabilities 3.810.4 4,926.8 Commitments and contingencies (Notes 14 and 17) Series C convertible preferred stock 444.7 Shareholders' Deficit 188.8 Common stock, par value $.25 - authorized 1,500 shares; issued 754.9 and 751.4 shares Additional paid-in capital Retained earnings 2.273.9 2.3222 (1.033.21 (4,599.7) (848.0) 1879 2,254.0 2.448.1 (1.366.2) (4.594.1) (1.070.3) Accumulated other comprehensive loss Treasury stock, at cost (317.3 and 315.9 shares) Total Avon shareholders' deficit Nocontrolling interests Total shareholders' deficit Total abilities, series C convertible preferred stock and shareholders' deficit 11,8 139 1836.23 11.056.4) $3.418.9 $3,870.4 Source: Avon 2016 Annual Report. In August 2012, McCoy made her first C-level appointment: PR expert Cheryl Heinonen was recruited as chief communications officer and senior vice president of Corporate Relations. The company could clearly benefit from an image makeover. Soon after, McCoy appointed Jeff Benjamin and Scott Crum to lead the Legal and Human Resource departments, signaling the importance of legal compliance and personnel development in the new company environment. In December 2012, she appointed P&G veteran Patricia Perez-Ayala as chief marketing officer. Perez- Ayala had started her career with P&G in Venezuela and was an expert on Latin America. In 2013, more critical additions were made to the leadership team. Experienced transformation North American business. Brian Salsberg, an Asia- Pacific market expert from McKinsey, was recruited to head up Strategy. In 2015, James Scully joined the firm as its new CFO after 9 years at J.Crew, a multichannel appare retailer. He replaced company veteran Kimberly R who had resigned to pursue an external opportuni McCoy believed the company needed to evolve by ing on three critical areas: executing growth platf driving simplification and efficiency, and improving nizational effectiveness. She indicated that the con was making progress in these three areas and the new around would increase the prospects of future succes . In the area of growth platforms, the company h begun refining its consumer value proposition. imunlad clearly defining product categories an Step 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