Module 09 Course Project - Stock Performance and Equity Investments
RATIO ANALYSIS
Ratio Analysis for L’Oreal SA and Avon Products Inc.
Name: Rodney Wheeler
Instructor: Latricia Roundtree
Course: B230/FIN1000
Date: 08/28/15
Ratio Analysis
Ratio analysis is a tool that is used to determine the financial strength or the financial weakness of an organization (Drake & Fabozzi, 2010). Below is an analysis of 2014 financial statements for L’Oreal SA and Avon Products Inc. Computations are available in an excel work sheet attached.
|
Liquidity Ratios |
|
|
|
|
Current Ratio |
Current Assets/Current Liabilities |
0.945671269 |
1.44807542 |
|
|
|
|
|
|
Quick Ratio |
Current Assets-Inventories/(Current Liabilities) |
0.701790121 |
1.046453693 |
|
|
|
|
|
|
Activity Ratios |
|
|
|
|
Inventory Turnover |
Sales/Inventory |
9.95713465 |
10.47908052 |
|
|
|
|
|
|
Fixed Asset Turnover |
Net Sales/(Gross Fixed Asset-Accumulated Depreciation) |
21.43455099 |
6.999106418 |
|
|
|
|
|
|
Total Asset Turnover |
Net Sales/Average Total Assets |
0.178990466 |
0.359322218 |
|
|
|
|
|
|
Profitability Ratios |
|
|
|
|
Gross Profit Margin |
Gross Profit/Net Sales |
0.711490325 |
0.621177126 |
|
|
|
|
|
|
Operating Profit Margin |
Operating Profit/Net Sales |
0.172674419 |
0.046437401 |
|
|
|
|
|
|
Net Profit Margin |
Net Profit /Net Sales |
0.217850169 |
0.045102659 |
|
|
|
|
|
|
Return on Assets |
Net Income/ total Assets |
0.153092349 |
0.070022559 |
|
|
|
|
|
|
Return on Equity |
Net Income/Shareholders Equity |
0.243179375 |
0.34672552 |
|
|
|
|
|
|
Leverage Ratios |
|
|
|
|
Debt Worth |
Total Liabilities/ Stockholders Equity |
0.588270556 |
17.03278689 |
|
|
|
|
|
|
Debt ratio |
Total Liabilities/Total Assets |
0.370342763 |
0.944458594 |
|
|
|
|
|
|
Coverage Ratios |
|
|
|
|
Time Interest Earned |
EBIT/Total Interest |
123.6923077 |
2.478847885 |
Current Ratio: This ratio show the ability of the company to pay back its liabilities using its current assets and a ratio under 1 means the company is unable to pay its liabilities. The ratio of L’Oreal SA is 0.9456 meaning the company’s liabilities are slightly higher than the assets therefore it’s not in good financial condition. Avon's company assets can meet its liabilities as its ratio is more than one.
Quick Ratio: This ratio measures the company’s ability to meet its liabilities using its liquid assets. It excludes inventory as it cannot be quickly converted to cash. A higher quick ratio indicates that the company is in a good liquid position. L’Oreal has a low liquidity and its cash cannot pay all its liabilities. Avon has a high liquidity and its cash can pay its liabilities.
Inventory Turnover: A low turnover indicates poor sales. Both companies have a high turnover meaning they do not experience costs of unsold stock. Avon products have higher sales with a turnover of 10.48 while L'Oreal has 9.95
Fixed Asset Turnover: This ratio shows the ability of the company to generate sales using its fixed asset. L'Oreal has a high asset turnover of 21.43 meaning it is able to utilize few assets to generate more sales. Avon has a low turnover meaning a lot of its assets are not effectively utilized to generate sales or it could have overinvested in fixed assets.
Total Asset Turnover: This ratio also measures the efficiency of the company in utilizing its assets and the higher the ratio the better the company’s performance. Avon has a higher asset turnover of 0.4 than L’Oreal with 0.2.
Gross Profit Margin, Operating Profit Margin and Net Profit Margin
These ratios measure the ability of the company to generate profits from its sales. Both companies have very high gross profit margins of 71% and 62 % for L’Oreal and Avon respectively meaning their sales can generate profit. Operating Profit margin shows the efficiency of the company in generating profits before deducting tax while the net profit margin excludes interest and tax. L’Oreal has a high Operating profit margin and net profit margin of 14% and 21% meaning the company is operating efficiently. Avon has low margins of 4%
Return on Assets: This ratio measures the ability of the company to effectively use its assets to generate income. Avon Products has a low return on assets of 7% meaning its assets are not fully exploited while L’Oreal has a higher return on assets of 15% meaning it utilizes its assets to generate more income.
Return on Equity: It measures the ability of the firm to generate profits from shareholders investments. The firms have low return to equity meaning the shareholders investments are not generating adequate profits.
Debt/Net Worth: This ratio indicates the percentage of company financing that comes from creditors and investors. Avon has a high ratio meaning it has more creditors financing than equity. L’Oreal has more equity financing.
Debt Ratio: This ratio indicates the company's ability to pay off its liabilities with its asset. Avon is more leveraged and therefore considered as risky by lenders since it has a high ratio of 0.9
Times-Interest-Earned: Both companies have the ability to meet their debt obligations but L’Oreal has very high TIE meaning it has an undesirable lack of debt or it is paying down too much of its debt with earnings that could be used for other projects.
Reference
Drake, P. P., & Fabozzi, F. J. (2010). Financial ratio analysis. Handbook of Finance.
3