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



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

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord


AJG Income Statement

Amortization of intangibles-7 M6,127 M-1000000.09,489 M11,476 M
Basic EPS from continuing operations0.643.64.294.475.34.51
Basic EPS total1.982.072.332.673.473.64.294.475.34.51
Basic weighted shares outstanding165 M188 M191 M194 M183 M186 M191 M203 M210 M215 M
Cost of sales1,076 M1,392 M1,441 M1,636 M1,816 M1,353 M882 M1,173 M23 M-523 M
Depreciation69 M94 M104 M121 M128 M140 M145 M151 M145 M165 M
Depreciation unreconciled259 M334 M351 M386 M419 M474 M562 M566 M600 M697 M
DepreciationAndAmortization259 M334 M351 M386 M419 M474 M562 M566 M600 M697 M
Diluted EPS total1.972.062.322.643.43.524.24.375.194.42
Diluted normalized net income/share0.633.524.24.375.194.42
Diluted weighted shares outstanding166 M189 M192 M196 M199 M186 M191 M203 M210 M215 M
Dividends paid per share1.441.481.521.561.641.721.81.922.042.2
Earnings from equity interest7 M7 M7 M3 M
EarningsFromEquityInterestNetOfTax7 M7 M7 M3 M
GainOnSaleOfSecurity6 M-5 M-6 M-6 M3 M
GeneralAndAdministrativeExpense-140 M148 M154 M
Gross operating profit3,502 M3,939 M4,094 M4,446 M4,967 M5,842 M6,122 M7,036 M8,528 M10,595 M
ImpairmentOfCapitalAssets-11 M100000.052 M18 M2 M4 M
Income before tax292 M294 M357 M360 M479 M626 M871 M975 M1,327 M1,185 M
Income restructuring and M&A-9 M-12 M-65 M84 M22 M301 M
Income taxes-36 M-96 M-88 M-157 M-196 M-90 M13 M20 M211 M219 M
InterestExpenseNonOperating89 M103 M110 M124 M138 M180 M196 M226 M257 M297 M
InterestExpenseOperating-139 M
MinorityInterests-24 M-32 M-31 M-36 M-42 M-47 M-39 M-48 M-2 M4 M
MiscOtherSpecialCharges72 M70 M6,792 M350 M382 M-16 M431 M462 M
Net income from total operations303 M389 M445 M517 M676 M669 M819 M907 M1,114 M970 M
NetIncomeCommonStockholders303 M357 M414 M481 M7,426 M977 M1,056 M1,412 M1,541 M2,015 M
NetIncomeContinuousOperations328 M389 M445 M517 M676 M669 M819 M907 M1,114 M970 M
NetNonOperatingInterestIncomeExpense-48 M-49 M-56 M-124 M-138 M-180 M-196 M-226 M-257 M-297 M
Normalized income-6,828 M-7,305 M-9,339 M
Operating income332 M336 M407 M484 M618 M1,114 M1,305 M1,723 M2,011 M2,527 M
Operating income before depreciation (EBITDA)403 M419 M495 M517 M520 M853 M1,128 M1,270 M1,669 M1,587 M
OperatingExpense3,170 M841 M798 M829 M904 M1,069 M907 M1,072 M1,331 M1,690 M
Other income net-7 M-7 M-7 M-3 M-6,792 M-7,697 M-8,355 M16 M-9,825 M-11,042 M
Other special charges18 M-1,614 M
OtherGandA-140 M148 M154 M
OtherOperatingExpenses743 M841 M798 M829 M904 M1,069 M907 M1,072 M1,331 M1,690 M
RentAndLandingFees-140 M148 M154 M
RestructringAndMnAIncome-9 M-12 M-65 M84 M22 M301 M
Revenue per share190 M240 M247 M265 M291 M334 M417 M415 M455 M531 M
SalariesAndWages2,168 M2,429 M2,539 M2,747 M3,026 M3,340 M3,467 M3,928 M4,800 M5,681 M
Special income/charges-17 M1,634 M12 M14 M-101 M-24 M-304 M
Total Income available for interest expense (EBIT)381 M397 M467 M484 M479 M806 M1,067 M1,201 M1,584 M1,482 M
Total common shares outstanding165 M177 M179 M181 M184 M188 M194 M209 M212 M217 M
Total net income303 M389 M445 M517 M676 M669 M819 M907 M1,114 M970 M
Total ordinary shares219 M219 M219 M219 M219 M219 M219 M219 M219 M219 M
Total revenues4,578 M5,332 M5,535 M6,249 M6,934 M7,195 M7,004 M8,209 M8,551 M10,072 M
TotalExpenses1,820 M2,233 M2,238 M2,465 M2,720 M2,421 M1,789 M2,246 M1,354 M1,167 M
TotalRevenue4,578 M5,392 M5,595 M2,641 M6,934 M7,195 M7,004 M8,209 M8,551 M10,072 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu


I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.


Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University