Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Aon plc Class A (UK) logo

Aon plc Class A (UK)

Sector: Financial Services   

Industry: Insurance Brokers

333.79
 
USD
  
3.87
  
(1.17%)
Optionable: Yes  Market Cap: 65,422 M  90-day average vol: 1,010,029

Previous close: 329.92  Open: 331.63  Bid: 324.43  Ask: 335.0
52 week range    
284.85   
   347.37
Peers   
MMC / 
AXS / 
ACGL / 
Last updated: Thursday 28th March 2024
63
MarketXLS Rank
40
Value
69
Technical
81
Quality

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

Financials

AON Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""783 M562 M336 M299 M251 M712 M448 M1,164 M945 M1,204 M
Accounts payable1,805 M9,932 M8,959 M9,625 M1,943 M1,939 M2,016 M2,192 M2,114 M2,262 M
Accounts receivable2,815 M2,564 M2,106 M2,478 M2,760 M3,112 M3,070 M3,094 M3,035 M3,254 M
Accrued expenses1,805 M9,932 M8,959 M9,625 M1,943 M1,939 M2,016 M2,192 M2,114 M2,262 M
Accumulated depreciation & depletion-1,546 M-1,616 M-1,196 M-1,169 M-1,145 M-1,159 M-1,268 M-1,318 M-1,391 M-1,498 M
Additional paid in capital5,097 M5,409 M5,577 M5,775 M5,965 M6,152 M6,312 M6,624 M6,864 M6,944 M
Cash and equivalents374 M384 M426 M756 M656 M790 M884 M544 M690 M778 M
CashCashEquivalentsAndShortTermInvestments768 M740 M716 M1,285 M828 M928 M1,192 M836 M1,142 M1,147 M
CashEquivalents374 M384 M82 M756 M91 M110 M102 M
Common par3 M3 M3 M2 M2 M2 M2 M2 M2 M2 M
Common stock equity6,571 M6,002 M5,475 M4,583 M4,151 M3,375 M3,495 M1,061 M-529 M-826 M
CommonStock3 M3 M3 M2 M2 M2 M2 M2 M2 M2 M
Cost in excess8,860 M8,448 M7,410 M8,358 M8,171 M8,165 M8,666 M8,434 M8,292 M8,414 M
CurrentCapitalLeaseObligation355 M318 M303 M186 M204 M194 M163 M159 M
CurrentDeferredRevenue408 M394 M199 M311 M251 M270 M296 M321 M250 M270 M
CurrentDeferredTaxesAssets1,267 M1,444 M1,428 M841 M949 M1,156 M1,231 M1,079 M1,404 M1,749 M
CurrentDeferredTaxesLiabilities-1,226 M-1,181 M-1,204 M-579 M-569 M-710 M-769 M-714 M725 M1,080 M
DefinedPensionBenefit858 M1,060 M1,133 M1,216 M1,280 M1,366 M652 M618 M
DividendsPayable-273 M-323 M-345 M-364 M-382 M-410 M-412 M-447 M-463 M-490 M
EmployeeBenefits2,141 M1,795 M1,760 M1,789 M1,636 M1,738 M1,763 M1,375 M1,186 M1,225 M
Float term debt4,799 M5,138 M5,869 M5,667 M5,993 M7,571 M7,281 M9,000 M10,518 M10,636 M
GoodwillAndOtherIntangibleAssets11,380 M10,628 M9,300 M10,091 M9,320 M8,948 M9,306 M8,926 M8,739 M8,648 M
Gross fixed assets (Plant Property & Equipment)2,311 M2,381 M1,746 M1,733 M1,733 M2,709 M2,778 M2,633 M2,648 M2,786 M
IncomeTaxPayable64 M94 M77 M139 M83 M93 M80 M149 M193 M291 M
Intangibles2,520 M2,180 M1,890 M1,733 M1,149 M783 M640 M492 M447 M234 M
InterestPayable-255 M-273 M-282 M-282 M-278 M-307 M
Invested capital16,169 M16,278 M17,213 M15,917 M16,137 M17,573 M18,954 M18,289 M19,814 M19,805 M
Leases100 M89 M63 M43 M26 M
LineOfCredit95 M58 M90 M96 M83 M73 M79 M75 M74 M86 M
LongTermCapitalLeaseObligation184 M166 M136 M153 M169 M944 M897 M772 M693 M641 M
LongTermDebtAndCapitalLeaseObligation4,799 M5,138 M5,869 M5,667 M5,993 M7,571 M8,178 M9,000 M10,518 M10,636 M
LongTermProvisions12 M13 M10 M18 M24 M27 M29 M26 M8 M13 M
Minority interest60 M57 M57 M65 M68 M74 M88 M97 M100 M84 M
Net fixed assets (net PP&E)765 M765 M550 M564 M588 M1,550 M1,510 M1,315 M1,257 M1,288 M
Non-current deferred income taxes313 M37 M101 M127 M181 M199 M262 M401 M99 M115 M
NonCurrentAccruedExpenses256 M223 M288 M529 M585 M525 M561 M609 M795 M827 M
NonCurrentDeferredAssets144 M300 M325 M389 M561 M645 M724 M766 M824 M1,195 M
NonCurrentDeferredLiabilities313 M37 M101 M127 M181 M199 M262 M401 M99 M115 M
NonCurrentDeferredRevenue167 M159 M49 M49 M65 M62 M76 M70 M37 M33 M
NonCurrentDeferredTaxesAssets144 M300 M325 M389 M561 M645 M724 M766 M824 M1,195 M
NonCurrentPensionAndOtherPostretirementBenefitPlans2,141 M1,795 M1,760 M1,789 M1,636 M1,738 M1,763 M1,375 M1,186 M1,225 M
NonCurrentPrepaidAssets933 M1,033 M858 M
Number of employees50000.050000.050000.050000.050000.050000.050000.050000.050000.050000.0
Other current assets602 M329 M1,365 M289 M618 M12,436 M14,422 M716 M646 M17,303 M
Other equity adjustments-3,134 M-3,423 M-3,912 M-3,496 M
Other fixed assets765 M765 M550 M564 M588 M1,550 M1,510 M1,315 M1,257 M1,288 M
Other non-current assets12,365 M10,524 M11,395 M9,932 M10,614 M570 M610 M14,898 M16,409 M506 M
Other non-current liabilities12,512 M2,541 M719 M1,102 M1,097 M877 M895 M15,296 M16,924 M17,381 M
Other receivable9,998 M10,770 M11,013 M11,066 M12,193 M12,479 M13,376 M
OtherCurrentBorrowings783 M562 M336 M299 M251 M712 M448 M1,164 M945 M1,204 M
OtherCurrentLiabilities788 M819 M3,200 M2,831 M11,102 M12,920 M14,969 M1,331 M1,347 M1,878 M
OtherDeferredCosts250 M210 M183 M
OtherPayable-479 M-290 M-879 M-1,029 M-240 M-225 M
Payables1,805 M9,932 M8,959 M9,625 M1,943 M1,939 M2,016 M2,192 M2,114 M2,262 M
Prepaid expenses164 M130 M102 M126 M97 M97 M111 M137 M109 M100 M
RecievablesAdjustmentsAllowances-74 M-58 M-56 M-59 M-62 M-70 M-98 M-90 M-76 M-79 M
Restricted cash169 M105 M82 M96 M91 M110 M102 M160 M115 M120 M
Retained earnings1,471 M590 M-105 M-1,194 M-1,816 M-2,779 M-2,819 M-5,565 M-7,395 M-7,772 M
SecuritySoldNotYetRepurchased-2,250 M-1,550 M-1,257 M2,399 M
Short term debt783 M562 M336 M299 M251 M712 M448 M1,164 M945 M1,204 M
TaxesReceivable53 M74 M35 M
Total assets29,772 M26,883 M26,615 M26,088 M26,422 M29,405 M32,114 M31,917 M32,704 M33,959 M
Total current assets4,185 M3,633 M4,187 M4,052 M4,206 M16,476 M18,684 M19,032 M20,723 M21,704 M
Total current liabilities3,376 M11,313 M12,495 M12,755 M13,296 M15,571 M17,433 M19,073 M20,306 M21,651 M
Total equity6,571 M6,002 M5,475 M4,583 M4,151 M3,375 M3,495 M1,061 M-529 M-826 M
Total liabilities23,141 M20,824 M21,083 M21,440 M22,203 M25,956 M28,531 M30,759 M33,133 M34,701 M
Total non-current assets25,587 M23,250 M22,428 M22,036 M22,216 M12,929 M13,430 M27,271 M27,881 M12,255 M
Total non-current liabilities19,765 M9,511 M8,588 M8,685 M8,907 M10,385 M11,098 M26,072 M28,727 M29,357 M
TotalEquityGrossMinority6,631 M6,059 M5,532 M4,648 M4,219 M3,449 M3,583 M1,158 M-429 M-742 M
TotalEquityGrossMinorityInterest6,631 M6,059 M5,532 M4,648 M4,219 M3,449 M3,583 M1,158 M-429 M-742 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest29,772 M26,883 M26,615 M26,088 M26,422 M29,405 M32,114 M31,917 M32,704 M33,959 M
TotalNonCurrentLiabilitiesNetMinorityInteres19,765 M9,511 M8,588 M8,685 M8,907 M10,385 M11,098 M26,072 M28,727 M29,357 M
Treasury stock-2,250 M-1,550 M-1,257 M-2,415 M11,000 M13,000 M18,300 M3,543 M24,200 M2,700 M
UnearnedPremiums-116 M-139 M-134 M
Working capital809 M-7,680 M-8,308 M-8,703 M-9,090 M905 M1,251 M-41 M417 M53 M
ltinv143 M135 M119 M57 M54 M53 M74 M64 M60 M45 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.

We respect your privacy and will never share your email.
MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

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.

Dave

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