Part B: Financial Statement Ratio Analysis of Diageo and Two Competitors For this part of the business report, prepare a financial statement ratio analysis for Diageo and two of its competitors, Brown-Forman Corporation and The Boston Beer Company, Inc.

qfinancial_statement_ratio_and_analysis___excel_spreadsheet_01.10.2018__2_.xlsx

Home >Business & Finance homework help >Part B: Financial Statement Ratio Analysis of Diageo and Two Competitors For this part of the business report, prepare a financial statement ratio analysis for Diageo and two of its competitors, Brown-Forman Corporation and The Boston Beer Company, Inc.

Ratio Analysis

			Diageo
			Financial Statement Ratio Analysis
			For the years-ended
					Diageo		Brown-Forman	Boston Beer Company
	Ratio Analysis			June 30, 2017		June 30, 2016	April 30, 2017	December 31, 2016
1. Current Ratio:
	Current Assets
	Current Liabilities
		Current Ratio (Liquidity)
2. Inventory Turnover:
	Cost of Sales
	Inventories				£ 4,684
		Inventory Turnover (Liquidity and Efficiency)			- 0
3. Days Costs in Inventories:
	Days
	Inventory Turnover
		Days Costs in Inventories (Liquidity and Efficiency)
4. Trade Receivables Turnover:
	Sales
	Trade Receivables				£ 4,684
		Trade Receivables Turnover (Liquidity and Efficiency)			- 0
5. Trade Receivables Collection Period:
	Days
	Trade Receivables Turnover
		Trade Receivables Collection Period (Liquidity and Efficiency)
6. Trade Payables Turnover:
	Cost of Sales
	Trade Payables				£ 1,227
		Trade Payables Turnover (Liquidity and Efficiency)			- 0
7. Days Costs in Trade Payables:
	Days
	Trade Payables Turnover
		Days Costs in Trade Payables (Liquidity and Efficiency)
8. Trade Cycle (In Days):
	Trade Receivables Collection Period
	Days Costs in Inventories
	Days Costs in Trade Payables
		Trade Cycle (In Days) (Liquidity and Efficiency)
9. Property, Plant and Equipment Turnover:
	Sales
	Property, Plant and Equipment
		Property, Plant and Equipment Turnover (Profitability and Efficiency)
10. Asset Turnover:
	Sales
	Total Assets
		Asset Turnover (Profitability and Efficiency)
11. Gross Profit Margin (%):
	Gross Profit
	Sales
		Gross Profit Margin (Profitability)
12. Net Profit Margin (%):
	Net Income (Profit)
	Sales
		Net Profit Margin (Profitability)
13. Return on Assets (%):
	Net Income (Profit)
	Total Assets
		Return on Assets (Profitability)
14. Quality of Earnings Ratio:
	Net Cash from Operating Activities
	Net Income (Profit)
		Quality of Earnings Ratio (Liquidity)
15. Free Cash Flow:
	Net Cash from Operating Activities
	Capital Expenditures
	Dividends Paid
		Free Cash Flow (Solvency)
		Free Cash Flow - % of Sales
16. Sales per Employee:
	Sales
	Average Number of Employees
		Sales per Employee (In Thousands) (Profitability)
		Sales per Employee in US dollars (In Thousands)			$ -