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

NWS Stock Annual Balance Sheet. Download in Excel

News Corporation logo

News Corporation

Sector: Consumer Cyclical   

Industry: Broadcasting - TV

30.70
 
USD
  
0.24
  
(0.79%)
Previous close: 30.46  Open: 30.51  Bid: 12.3  Ask: 33.48
52 week range    
23.99   
   32.87
Mkt Cap: 17,692 M  Avg Vol (90 Days): 678,043
Peers   
DIS / 
TRI / 
NYT / 
LEE / 
GCI / 
Last updated: Monday 23rd December 2024

Stock Rankings

60
MarketXLS Rank
65
Value
53
Technical
63
Quality
How are these ranks calculated?
Search for a stock

Financials

NWS Balance Sheet

Annual
Jun-15Jun-16Jun-17Jun-18Jun-19Jun-20Jun-21Jun-22Jun-23Jun-24
Accounts payable238 M217 M222 M605 M411 M351 M321 M411 M440 M314 M
Accounts receivable1,283 M1,229 M1,276 M1,612 M1,544 M1,203 M1,498 M1,502 M1,425 M1,503 M
Accrued expenses1,363 M1,588 M1,426 M1,945 M1,739 M1,370 M1,660 M1,647 M1,563 M1,545 M
Accumulated depreciation & depletion-2,493 M-2,524 M-3,339 M-3,352 M-3,524 M-3,667 M-4,460 M-3,933 M-4,359 M-4,396 M
Additional paid in capital12,433 M12,434 M12,395 M12,322 M12,243 M12,148 M12,057 M11,779 M11,449 M11,254 M
Cash and equivalents1,951 M1,832 M2,016 M2,034 M1,643 M1,517 M2,236 M1,822 M1,833 M1,960 M
CashCashEquivalentsAndShortTermInvestments1,951 M1,832 M2,016 M2,034 M1,643 M1,517 M2,236 M1,822 M1,833 M1,960 M
CashEquivalents1,951 M2,147 M2,016 M2,034 M1,643 M1,517 M2,236 M
Common par4 M2 M4 M4 M4 M4 M4 M4 M4 M4 M
Common stock equity11,943 M11,560 M10,787 M9,289 M9,142 M7,580 M8,209 M8,220 M8,064 M8,120 M
CommonStock4 M2 M4 M4 M4 M4 M4 M4 M4 M4 M
Construction in progress125 M111 M92 M145 M169 M115 M179 M220 M275 M215 M
Cost in excess3,063 M3,714 M3,838 M5,218 M5,147 M3,951 M4,653 M5,169 M5,140 M5,186 M
CurrentAccruedExpenses1,125 M1,371 M1,204 M1,340 M1,328 M1,019 M1,339 M1,236 M1,123 M1,231 M
CurrentCapitalLeaseObligation118 M143 M139 M112 M117 M
CurrentDeferredRevenue346 M388 M426 M516 M428 M398 M473 M604 M622 M551 M
CurrentDeferredTaxesAssets63 M38 M69 M62 M78 M93 M115 M122 M131 M147 M
CurrentDeferredTaxesLiabilities-506 M-486 M464 M-451 M-297 M-592 M-563 M-428 M-375 M-372 M
Deferred revenues346 M388 M426 M516 M428 M398 M473 M604 M622 M551 M
DefinedPensionBenefit1,787 M1,723 M1,701 M1,480 M1,484 M1,513 M1,549 M1,083 M946 M886 M
DividendsPayable-30 M-147 M-152 M-158 M-161 M-158 M-163 M-175 M-174 M-172 M
EmployeeBenefits305 M350 M319 M245 M266 M277 M211 M155 M134 M125 M
Float term debt369 M276 M1,490 M1,004 M2,329 M3,401 M3,723 M4,068 M3,882 M
GoodwillAndOtherIntangibleAssets5,266 M5,921 M6,119 M7,889 M7,573 M5,815 M6,832 M7,840 M7,629 M7,508 M
Gross fixed assets (Plant Property & Equipment)5,183 M4,929 M4,963 M5,912 M6,078 M6,984 M7,767 M6,927 M7,437 M7,268 M
IncomeTaxPayable27 M33 M39 M17 M30 M18 M16 M
Intangibles2,203 M2,207 M2,281 M2,671 M2,426 M1,864 M2,179 M2,671 M2,489 M2,322 M
Inventories319 M218 M208 M376 M348 M348 M253 M311 M311 M296 M
Invested capital11,943 M12,298 M11,339 M12,269 M11,150 M11,092 M13,895 M14,719 M15,072 M14,857 M
Land & improvements161 M153 M153 M150 M146 M123 M131 M120 M121 M121 M
LongTermCapitalLeaseObligation1,146 M1,116 M947 M1,128 M1,027 M
LongTermDebtAndCapitalLeaseObligation369 M276 M1,490 M1,004 M2,329 M3,401 M3,723 M4,068 M3,882 M
Machinery furniture & equipment2,972 M2,872 M2,985 M3,131 M1,792 M1,680 M1,809 M1,278 M1,302 M945 M
Minority interest191 M238 M304 M1,206 M1,167 M807 M935 M921 M881 M891 M
Net fixed assets (net PP&E)2,690 M2,405 M1,624 M2,560 M2,554 M3,317 M3,307 M2,994 M3,078 M2,872 M
NetOtherUnrealizedGainLoss-25 M-2 M
Non-current deferred income taxes166 M171 M61 M389 M295 M258 M260 M198 M163 M119 M
NonCurrentAccountsReceivable39 M
NonCurrentDeferredAssets602 M525 M279 M269 M332 M378 M422 M393 M332 M
NonCurrentDeferredLiabilities166 M171 M61 M389 M295 M258 M260 M198 M163 M119 M
NonCurrentDeferredTaxesAssets1,929 M602 M525 M279 M269 M332 M378 M422 M393 M332 M
NonCurrentNoteReceivables345 M338 M370 M
NonCurrentPensionAndOtherPostretirementBenefitPlans305 M350 M319 M245 M266 M277 M211 M155 M134 M125 M
NotesReceivable338 M370 M
Other current assets780 M513 M315 M372 M515 M393 M469 M458 M484 M613 M
Other equity adjustments-582 M-1,026 M-964 M-874 M-1,126 M-1,331 M-941 M
Other fixed assets2,690 M2,405 M1,624 M2,560 M2,554 M3,317 M3,307 M2,994 M3,078 M2,872 M
Other non-current assets467 M396 M442 M831 M930 M1,039 M1,447 M1,384 M1,341 M1,170 M
Other non-current liabilities318 M349 M351 M430 M495 M326 M519 M483 M446 M492 M
Other receivable72 M86 M8,139 M9,024 M10,074 M9,008 M9,358 M10,385 M9,879 M10,085 M
OtherCurrentLiabilities401 M466 M497 M372 M724 M838 M1,073 M975 M953 M905 M
OtherInventories299 M218 M208 M376 M348 M348 M253 M311 M311 M296 M
OtherPayable308 M256 M256 M364 M572 M438 M886 M1,501 M17 M38 M
Payables238 M217 M222 M605 M411 M351 M321 M411 M440 M314 M
Preferred securities of subsidiary trust25 M25 M12 M
PreferredStock25 M25 M12 M
Prepaid expenses263 M240 M233 M
RecievablesAdjustmentsAllowances-220 M-43 M-42 M-46 M-46 M-73 M-71 M-67 M-57 M-65 M
RedeemablePreferredStock79 M
Restricted cash315 M
Retained earnings-494 M-876 M-1,612 M-3,037 M-3,105 M-4,572 M-3,852 M-3,563 M-3,391 M-3,140 M
Short term debt103 M462 M449 M76 M28 M293 M27 M54 M
Total assets15,035 M15,483 M14,552 M16,346 M15,711 M14,261 M16,771 M17,221 M16,921 M16,684 M
Total current assets4,014 M3,889 M3,815 M4,394 M4,050 M3,461 M4,456 M4,093 M4,053 M4,372 M
Total current liabilities2,110 M2,442 M2,452 M3,295 M3,340 M2,682 M3,234 M3,519 M3,165 M3,055 M
Total equity11,943 M11,560 M10,787 M9,289 M9,142 M7,580 M8,209 M8,220 M8,064 M8,120 M
Total liabilities2,899 M3,681 M3,459 M5,849 M5,400 M5,872 M7,625 M8,078 M7,976 M7,673 M
Total non-current assets11,021 M11,594 M10,737 M11,952 M11,661 M10,800 M12,315 M13,128 M12,868 M12,312 M
Total non-current liabilities789 M1,239 M1,007 M2,554 M2,060 M3,190 M4,391 M4,559 M4,811 M4,618 M
TotalEquityGrossMinority12,134 M11,798 M11,091 M10,495 M10,309 M8,387 M9,144 M9,141 M8,945 M9,011 M
TotalEquityGrossMinorityInterest12,134 M11,798 M11,091 M10,495 M10,309 M8,387 M9,144 M9,141 M8,945 M9,011 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest15,033 M15,479 M14,550 M16,344 M15,711 M14,261 M16,771 M17,221 M16,921 M16,684 M
TotalNonCurrentLiabilitiesNetMinorityInteres789 M1,239 M1,007 M2,554 M2,060 M3,190 M4,391 M4,559 M4,811 M4,618 M
UnearnedIncome219 M602 M
Working capital1,904 M1,447 M1,363 M1,099 M710 M779 M1,222 M574 M888 M1,317 M
debtc103 M462 M449 M76 M28 M293 M27 M54 M
ltinv2,379 M2,270 M2,027 M393 M335 M297 M351 M488 M427 M430 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