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

DUK Stock Annual Balance Sheet. Download in Excel

Duke Energy Corporation (Holding Company) logo

Duke Energy Corporation (Holding Company)

Sector: Utilities   

Industry: Utilities - Regulated Electric

115.17
 
USD
  
-1.04
  
(-0.89%)
Previous close: 116.21  Open: 115.12  Bid: 113.75  Ask: 115.17
52 week range    
83.06   
   118.31
Mkt Cap: 89,560 M  Avg Vol (90 Days): 2,949,617
Peers   
XEL / 
SO / 
AEP / 
D / 
FE / 
PPL / 
PCG / 
AEE / 
Last updated: Friday 27th September 2024

Stock Rankings

77
MarketXLS Rank
100
Value
76
Technical
55
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Financials

DUK Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable709 M753 M833 M842 M988 M3,487 M1,000 M988 M1,472 M4,228 M
Accounts receivable805 M840 M918 M3,060 M943 M1,144 M1,266 M4,131 M
Accrued expenses950 M873 M1,078 M1,184 M1,261 M4,444 M1,392 M1,653 M1,820 M5,789 M
Accumulated depreciation & depletion-12,700 M-13,521 M-14,365 M-15,063 M-15,496 M-45,773 M-17,453 M-17,854 M-18,669 M-56,038 M
Additional paid in capital1,384 M1,384 M2,695 M2,670 M9,143 M40,881 M9,143 M9,149 M11,832 M44,920 M
Cash and equivalents13 M13 M14 M16 M33 M311 M21 M7 M44 M253 M
CashCashEquivalentsAndShortTermInvestments13 M13 M14 M16 M33 M18 M21 M7 M44 M253 M
CashEquivalents298 M98 M137 M138 M141 M
Common par12,699 M11,618 M11,543 M12,130 M12,451 M1,963 M14,896 M15,632 M17,183 M17,887 M
Common stock equity17,530 M15,441 M10,772 M11,361 M14,254 M46,822 M16,237 M17,145 M3,672 M49,112 M
CommonStock12,699 M11,618 M11,543 M12,130 M12,451 M1000000.013,923 M14,659 M16,210 M16,914 M
CommonUtilityPlant4,519 M4,485 M41,656 M43,360 M45,103 M50,669 M51,976 M54,650 M171,351 M
Construction in progress6,102 M
Cost in excess920 M920 M920 M920 M3,655 M19,303 M3,655 M3,655 M3,655 M19,303 M
CurrentAccruedExpenses95 M95 M102 M108 M102 M565 M117 M125 M120 M745 M
CurrentCapitalLeaseObligation177 M184 M179 M188 M
CurrentDeferredTaxesAssets1,593 M80 M117 M117 M
CurrentDeferredTaxesLiabilities11,801 M12,548 M-14,155 M-6,621 M-7,806 M-14,138 M-13,970 M-15,223 M-15,673 M
CurrentProvisions881 M13,004 M12,600 M12,728 M9,156 M
Deferred revenues642 M621 M607 M566 M671 M626 M536 M527 M1,393 M
DerivativeProductLiabilities159 M185 M217 M
ElectricUtilityPlant116,842 M
EmployeeBenefits111 M107 M97 M95 M99 M934 M73 M50 M38 M485 M
Float term debt7,546 M7,711 M1,753 M1,582 M1,434 M54,985 M11,509 M781 M689 M72,452 M
GoodwillAndOtherIntangibleAssets920 M920 M920 M920 M3,655 M19,303 M3,655 M3,655 M3,655 M19,303 M
Gross fixed assets (Plant Property & Equipment)9 M548 M41,656 M43,360 M46,853 M149,558 M50,779 M52,068 M54,728 M172,443 M
IncomeTaxPayable146 M25 M143 M234 M171 M
Intangibles317 M277 M271 M276 M300 M355 M264 M273 M296 M
InterestPayable95 M95 M102 M108 M102 M565 M117 M125 M120 M745 M
Inventories1,124 M1,276 M1,055 M971 M948 M3,232 M1,010 M1,026 M1,164 M4,292 M
Invested capital25,376 M23,452 M21,712 M21,541 M26,321 M52,540 M39,158 M18,629 M5,050 M194,016 M
Leases1,548 M1,465 M1,355 M1,294 M1,237 M
LongTermCapitalLeaseObligation1,504 M1,432 M97 M78 M876 M1,105 M
LongTermDebtAndCapitalLeaseObligation7,846 M8,011 M9,187 M8,598 M12,137 M56,417 M11,509 M781 M689 M72,452 M
LongTermProvisions12,437 M5,086 M5,052 M5,121 M8,560 M
MaterialsAndSupplies2,102 M2,343 M2,374 M2,293 M2,238 M2,883 M2,312 M2,309 M2,604 M3,086 M
Minority interest-32 M-22 M-13 M-3 M3 M1,129 M4 M3 M1000000.01,075 M
NaturalGasFuelAndOther9,839 M
Net fixed assets (net PP&E)-12,691 M-12,973 M27,291 M28,297 M31,357 M103,785 M33,326 M34,214 M36,059 M116,405 M
NetUtilityPlant41,656 M43,360 M45,103 M126,681 M50,669 M51,976 M54,650 M171,351 M
Non-current deferred income taxes6,016 M6,345 M6,747 M3,645 M3,920 M9,502 M4,078 M3,921 M4,453 M11,420 M
NonCurrentDeferredLiabilities6,016 M6,345 M6,747 M3,645 M3,920 M9,502 M4,078 M3,921 M4,453 M11,420 M
NonCurrentPensionAndOtherPostretirementBenefitPlans111 M107 M97 M95 M99 M934 M73 M50 M38 M485 M
Notes payable84 M813 M297 M104 M439 M506 M226 M1,233 M668 M
NotesReceivable150 M163 M66 M313 M15 M
Other current assets715 M1,051 M238 M299 M520 M2,560 M473 M244 M565 M3,760 M
Other equity adjustments-130 M
Other fixed assets9 M548 M121,397 M127,507 M1,750 M16,775 M110 M92 M78 M1,092 M
Other non-current assets9,075 M9,232 M7,375 M7,604 M8,042 M3,289 M9,160 M13,922 M11,670 M27,924 M
Other non-current liabilities6,138 M6,720 M6,813 M9,804 M9,658 M1,581 M6,835 M7,516 M5,783 M14,956 M
Other receivable851 M845 M163 M95 M182 M124 M190 M1,457 M1,273 M
OtherCurrentBorrowings2,514 M3,633 M330 M2,163 M3,410 M6,276 M2,873 M3,304 M3,952 M4,288 M
OtherCurrentLiabilities868 M1,066 M1,098 M1,158 M1,590 M3,151 M1,283 M1,282 M1,454 M4,284 M
OtherInventories1,124 M1,276 M1,055 M971 M948 M349 M1,010 M1,026 M1,164 M4,292 M
OtherPayable199 M266 M209 M
Payables855 M778 M976 M1,076 M1,159 M3,879 M1,275 M1,528 M1,700 M5,044 M
Preferred securities of subsidiary trust973 M973 M973 M973 M
PreferredStock973 M973 M973 M973 M
Prepaid expenses77 M128 M37 M19 M72 M20 M95 M8 M431 M
RecievablesAdjustmentsAllowances-17 M-12 M-14 M-76 M-146 M-121 M-216 M-205 M
RegulatoryAssets13,222 M
RegulatoryLiabilities15,264 M
Restricted cash556 M170 M82 M76 M
Retained earnings3,447 M2,439 M-470 M-276 M5,125 M4,108 M7,102 M8,001 M9,579 M2,229 M
Short term debt3,105 M4,802 M743 M3,472 M3,855 M6,276 M3,885 M3,535 M5,195 M7,756 M
Total assets592 M1,154 M36,515 M37,720 M39,960 M158,838 M45,048 M47,162 M50,346 M176,893 M
Total current assets2,930 M3,476 M2,378 M2,240 M2,673 M9,163 M2,591 M3,006 M4,175 M12,769 M
Total current liabilities5,565 M7,362 M2,292 M3,651 M2,996 M14,752 M3,687 M3,523 M5,651 M17,283 M
Total equity17,530 M15,441 M10,772 M11,361 M14,254 M46,822 M16,237 M17,145 M3,672 M49,112 M
Total liabilities25,710 M29,445 M26,370 M28,522 M33,191 M110,887 M34,767 M25,105 M27,542 M127,374 M
Total non-current assets-2,338 M-2,322 M35,798 M36,882 M43,118 M149,675 M46,229 M51,886 M51,463 M164,124 M
Total non-current liabilities96,135 M
TotalDeferredCreditsAndOtherNonCurrentLiabilities20,145 M22,083 M22,844 M22,142 M25,814 M39,718 M27,581 M18,099 M18,546 M108,152 M
TotalEquityGrossMinority17,498 M15,419 M11,807 M13,465 M14,257 M16,241 M17,148 M21,406 M50,187 M
TotalEquityGrossMinorityInterest17,498 M15,419 M11,807 M13,465 M14,257 M16,241 M17,148 M21,406 M50,187 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest43,208 M44,864 M36,515 M37,720 M39,960 M158,838 M45,048 M47,162 M50,346 M176,893 M
TotalNonCurrentLiabilitiesNetMinorityInteres96,135 M
TotalTaxPayable146 M25 M143 M234 M171 M392 M76 M274 M228 M816 M
Working capital-2,635 M-3,886 M86 M-1,411 M-323 M-4,117 M-1,096 M-517 M-1,476 M-4,514 M
debtc3,105 M4,802 M743 M3,472 M3,855 M6,276 M3,885 M3,535 M5,195 M7,756 M
ltinv358 M499 M212 M61 M64 M10,076 M88 M95 M79 M492 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