Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Sector:    

Industry: 

 
USD
  
  
()
Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    
   
   

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock
Are you?
twitterstocktwits
Metrics

Valuation

Returns

Risk

Ranks

Dividends

Analyst Estimates

Financial Health

Technicals

Growth

Profitability

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

DEO Income Statement

Annual
Jun-13Jun-14Jun-15Jun-16Jun-17Jun-18Jun-19Jun-20Jun-21Jun-22
Total revenues17,192 M17,547 M16,957 M13,958 M15,698 M16,065 M16,335 M14,566 M17,609 M18,790 M
Cost of sales6,717 M6,892 M7,229 M5,659 M6,097 M6,121 M6,177 M5,768 M6,967 M7,263 M
Gross operating profit10,475 M10,655 M9,728 M8,299 M9,601 M9,944 M10,157 M8,797 M10,642 M11,527 M
Selling Gen & administrative expense5,334 M6,025 M5,341 M4,639 M4,965 M4,900 M4,976 M4,474 M5,482 M6,165 M
Research & development expense0000000000
Operating income5,141 M4,630 M4,386 M3,660 M4,637 M5,044 M5,181 M4,323 M5,160 M5,361 M
floaterest income0000000000
floaterest expense0000000000
Other income net0000000000
Pre-tax Income (EBT)4,650 M4,637 M4,600 M3,805 M4,637 M4,940 M5,376 M2,532 M5,125 M5,335 M
Income taxes771 M765 M731 M660 M954 M787 M1,140 M730 M1,254 M1,276 M
Net income from total operations3,879 M3,731 M3,869 M3,144 M3,611 M4,153 M4,236 M1,802 M3,871 M4,059 M
Minority floaterest0000000000
Total net income3,729 M3,987 M3,734 M2,987 M3,468 M3,991 M4,012 M1,746 M3,679 M3,951 M
Preferred dividendsN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
Net income available for common3,879 M3,873 M3,869 M3,144 M3,683 M4,153 M4,236 M1,802 M3,871 M4,059 M
Depreciation0000000000
Amortization0000000000
Operating income before depreciation (EBITDA)6,273 M6,707 M6,226 M5,181 M5,792 M6,226 M6,693 M5,672 M6,429 M6,952 M
Total Income available for floaterest expense (EBIT)0000000000
Basic EPS total6.046.145.964.775.526.436.642.986.36.82
Diluted EPS total66.115.934.745.56.46.612.976.276.8
Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today