Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Morningstar Inc. logo

Morningstar Inc.

Sector: Financial Services   

Industry: Financial Data & Stock Exchanges

290.98
 
USD
  
3.64
  
(1.27%)
Optionable: Yes  Market Cap: 12,082 M  90-day average vol: 127,740

Previous close: 287.34  Open: 288.76  Bid: 283.92  Ask: 296.34
52 week range    
180.48   
   316.06
Peers   
ENV / 
MSCI / 
TRI / 
FDS / 
VALU / 
DNB / 
MCO / 
FOX / 
TRI-CA / 
Last updated: Friday 3rd May 2024
46
MarketXLS Rank
35
Value
30
Technical
73
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

MORN Balance Sheet

Annual
Invalid dateDec-13Dec-20Dec-21Dec-22Dec-23
"""debtc"""489 M396 M1,147 M1,009 M
Accounts payable42 M65 M77 M76 M78 M
Accounts receivable114 M205 M269 M308 M344 M
Accrued expenses114 M65 M77 M76 M78 M
Accumulated depreciation & depletion-106 M-452 M-529 M-611 M-714 M
Additional paid in capital540 M671 M689 M758 M789 M
Cash and equivalents168 M423 M484 M377 M338 M
CashCashEquivalentsAndShortTermInvestments299 M464 M546 M415 M389 M
CashEquivalents168 M
Common par5000.0
Common stock equity690 M1,271 M1,416 M1,207 M1,328 M
CommonStock5000.0
Cost in excess326 M1,205 M1,207 M1,572 M1,579 M
CurrentAccruedExpenses71 M
CurrentCapitalLeaseObligation19 M40 M36 M37 M36 M
CurrentDeferredAssets4 M
CurrentDeferredRevenue149 M307 M377 M456 M518 M
CurrentDeferredTaxesAssets4 M73 M78 M137 M184 M
CurrentDeferredTaxesLiabilities46 M167 M-162 M-172 M-179 M
Deferred revenues149 M307 M377 M456 M518 M
DividendsPayable0.0-52 M-56 M-62 M-65 M
Float term debt138 M136 M177 M151 M
GoodwillAndOtherIntangibleAssets430 M1,585 M1,535 M2,120 M2,063 M
Gross fixed assets (Plant Property & Equipment)211 M755 M850 M1,002 M1,086 M
Intangibles104 M380 M328 M549 M484 M
InterestPayable228000.0
Invested capital690 M1,858 M1,911 M2,493 M2,454 M
LineOfCredit449 M359 M1,078 M940 M
LongTermCapitalLeaseObligation138 M136 M177 M151 M
LongTermDebtAndCapitalLeaseObligation138 M136 M177 M151 M
LongTermProvisions8 M35 M16 M21 M24 M
Minority interest1 M
Net fixed assets (net PP&E)105 M303 M321 M391 M372 M
NetOtherUnrealizedGainLoss51 M
NetUnrealizedGainLossForeignCurrency-26 M-41 M-99 M-86 M
NetUnrealizedGainLossInvestments4 M6 M-100000.0
Non-current deferred income taxes24 M109 M102 M63 M36 M
NonCurrentDeferredAssets13 M13 M11 M15 M
NonCurrentDeferredLiabilities48 M142 M138 M96 M62 M
NonCurrentDeferredRevenue34 M36 M34 M26 M
NonCurrentDeferredTaxesAssets10 M13 M13 M11 M15 M
Number of employees10767.010767.010767.010767.010767.0
Other current assets26 M27 M33 M52 M47 M
Other equity adjustments-22 M-35 M-99 M-86 M
Other fixed assets303 M321 M391 M372 M
Other non-current assets10 M33 M43 M46 M38 M
Other non-current liabilities14 M69 M31 M64 M18 M
Other receivable1,390 M1,699 M1,871 M2,039 M
OtherCurrentBorrowings32 M32 M
OtherCurrentLiabilities7 M180 M276 M231 M216 M
OtherEquityInterest5 M
OtherPayable3 M
Payables42 M65 M77 M76 M78 M
Prepaid expenses32 M31 M37 M35 M
RecievablesAdjustmentsAllowances-4 M-4 M-7 M-6 M
Retained earnings595 M1,389 M1,527 M1,535 M1,611 M
Short term debt449 M359 M1,110 M972 M
TaxesReceivable4 M2 M9 M600000.0
Total assets1,031 M2,696 M2,863 M3,475 M3,403 M
Total current assets447 M730 M888 M811 M816 M
Total current liabilities270 M627 M784 M883 M881 M
Total equity690 M1,271 M1,416 M1,207 M1,328 M
Total liabilities339 M1,425 M1,447 M2,268 M2,076 M
Total non-current assets584 M1,966 M1,975 M2,664 M2,588 M
Total non-current liabilities70 M384 M321 M358 M255 M
TotalEquityGrossMinority691 M1,271 M1,416 M1,207 M1,328 M
TotalEquityGrossMinorityInterest691 M1,271 M1,416 M1,207 M1,328 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest1,031 M2,696 M2,863 M3,475 M3,403 M
TotalNonCurrentLiabilitiesNetMinorityInteres70 M384 M321 M358 M255 M
Treasury stock-449 M-767 M-764 M-987 M-985 M
UnrealizedGainLoss-22 M-35 M-99 M-86 M
Working capital177 M104 M104 M-72 M-65 M
ltinv39 M33 M63 M96 M100 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

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