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

Sector:    

Industry: 

 
USD
  
  
()
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

Financials

DUK Balance Sheet

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Accounts payable701 M709 M753 M833 M842 M988 M954 M1,000 M988 M4,754 M
Accounts receivable805 M840 M918 M966 M943 M1,144 M4,415 M
Accrued expenses945 M950 M873 M1,078 M1,184 M1,261 M1,115 M1,193 M1,387 M6,102 M
Accumulated depreciation & depletion-11,894 M-12,700 M-13,521 M-14,365 M-15,063 M-15,496 M-16,525 M-17,453 M-17,854 M-52,100 M
Additional paid in capital1,384 M1,384 M1,384 M2,695 M2,670 M9,143 M9,143 M9,143 M9,149 M44,862 M
Cash and equivalents23 M13 M13 M14 M16 M33 M18 M21 M7 M409 M
CashCashEquivalentsAndShortTermInvestments67 M13 M13 M14 M16 M33 M18 M21 M7 M409 M
CashEquivalents307 M298 M98 M137 M138 M141 M222 M194 M170 M173 M
Common par12,127 M12,699 M11,618 M11,543 M12,130 M12,451 M14,553 M14,896 M15,632 M16,422 M
Common stock equity16,532 M17,530 M15,441 M10,772 M11,361 M14,254 M15,590 M16,237 M17,145 M15,442 M
CommonStock12,127 M12,699 M11,618 M11,543 M12,130 M12,451 M13,580 M13,923 M14,659 M15,449 M
CommonUtilityPlant3,595 M4,519 M4,485 M41,656 M43,360 M45,103 M49,168 M50,669 M51,976 M163,848 M
Cost in excess920 M920 M920 M920 M920 M3,655 M3,655 M3,655 M3,655 M19,303 M
CurrentAccruedExpenses97 M95 M95 M102 M108 M102 M115 M117 M125 M626 M
CurrentCapitalLeaseObligation208 M177 M184 M179 M
CurrentDeferredTaxesAssets1,373 M1,593 M80 M117 M117 M
CurrentDeferredTaxesLiabilities10,679 M11,801 M12,548 M-14,155 M-6,621 M-7,806 M-8,878 M-9,244 M-9,379 M-9,964 M
Deferred revenues676 M642 M621 M607 M566 M671 M627 M626 M536 M1,502 M
DerivativeProductLiabilities159 M185 M
EmployeeBenefits161 M111 M107 M97 M95 M99 M84 M73 M50 M832 M
Float term debt8,089 M7,546 M7,711 M1,753 M1,582 M1,434 M1,294 M1,217 M1,119 M1,016 M
GoodwillAndOtherIntangibleAssets920 M920 M920 M920 M920 M3,655 M3,655 M3,655 M3,655 M19,303 M
Gross fixed assets (Plant Property & Equipment)34,906 M9 M548 M41,656 M43,360 M46,853 M49,291 M50,779 M52,068 M164,890 M
IncomeTaxPayable147 M146 M25 M143 M234 M171 M46 M76 M274 M722 M
Intangibles487 M317 M277 M271 M276 M300 M305 M355 M264 M273 M
InterestPayable97 M95 M95 M102 M108 M102 M115 M117 M125 M626 M
Inventories1,065 M1,124 M1,276 M1,055 M971 M948 M996 M1,010 M1,026 M3,584 M
Invested capital24,921 M25,376 M23,452 M21,712 M21,541 M26,321 M28,026 M28,866 M18,967 M83,519 M
Leases1,606 M1,548 M1,465 M1,355 M1,294 M1,237 M
LongTermCapitalLeaseObligation1,504 M102 M97 M78 M876 M
LongTermDebtAndCapitalLeaseObligation8,389 M7,846 M8,011 M9,187 M8,598 M12,137 M11,244 M11,509 M781 M67,937 M
MaterialsAndSupplies1,901 M2,102 M2,343 M2,374 M2,293 M2,238 M2,297 M2,312 M2,309 M2,604 M
Minority interest4 M-32 M-22 M-13 M-3 M3 M3 M4 M3 M2,531 M
Net fixed assets (net PP&E)23,012 M-12,691 M-12,973 M27,291 M28,297 M31,357 M32,766 M33,326 M34,214 M112,790 M
NetUtilityPlant41,656 M43,360 M45,103 M49,168 M50,669 M51,976 M163,848 M
Non-current deferred income taxes5,916 M6,016 M6,345 M6,747 M3,645 M3,920 M4,152 M4,078 M3,921 M10,813 M
NonCurrentDeferredLiabilities5,916 M6,016 M6,345 M6,747 M3,645 M3,920 M4,152 M4,078 M3,921 M10,813 M
NonCurrentPensionAndOtherPostretirementBenefitPlans161 M111 M107 M97 M95 M99 M84 M73 M50 M832 M
Notes payable181 M84 M813 M297 M104 M439 M29 M506 M226 M1,233 M
NotesReceivable222 M150 M163 M66 M313 M164 M15 M
Number of employees27859.027859.027859.027859.027859.027859.027859.027859.027859.027859.0
Other current assets295 M715 M1,051 M238 M299 M520 M550 M473 M244 M3,747 M
Other fixed assets69,490 M9 M548 M121,397 M127,507 M1,750 M123 M110 M92 M1,042 M
Other non-current assets5,520 M9,075 M9,232 M7,375 M7,604 M8,042 M8,868 M9,160 M13,922 M32,316 M
Other non-current liabilities4,170 M6,138 M6,720 M6,813 M9,804 M9,658 M11,951 M11,621 M12,250 M25,537 M
Other receivable934 M851 M845 M163 M95 M182 M114 M124 M190 M390 M
OtherCurrentBorrowings839 M2,514 M3,633 M330 M2,163 M3,410 M3,135 M2,873 M3,304 M3,952 M
OtherCurrentLiabilities626 M868 M1,066 M1,098 M1,158 M1,590 M1,582 M1,782 M2,033 M5,174 M
OtherInventories1,065 M1,124 M1,276 M1,055 M971 M948 M996 M1,010 M1,026 M3,584 M
Payables848 M855 M778 M976 M1,076 M1,159 M1,000 M1,076 M1,262 M5,476 M
Preferred securities of subsidiary trust973 M973 M973 M973 M
PreferredStock973 M973 M973 M973 M
Prepaid expenses309 M77 M128 M37 M19 M72 M21 M20 M95 M1,067 M
RecievablesAdjustmentsAllowances-30 M-17 M-12 M-14 M-76 M-146 M-121 M-216 M
Retained earnings3,021 M3,447 M2,439 M-470 M-276 M5,125 M6,458 M7,102 M8,001 M2,497 M
Short term debt1,067 M3,105 M4,802 M743 M3,472 M3,855 M3,622 M3,885 M3,535 M9,339 M
Total assets32,734 M592 M1,154 M36,515 M37,720 M39,960 M44,053 M45,048 M47,162 M178,086 M
Total current assets2,892 M2,930 M3,476 M2,378 M2,240 M2,673 M2,665 M2,591 M3,006 M13,222 M
Total current liabilities3,314 M5,565 M7,362 M2,292 M3,651 M2,996 M2,884 M3,687 M3,523 M18,873 M
Total equity16,532 M17,530 M15,441 M10,772 M11,361 M14,254 M15,590 M16,237 M17,145 M15,442 M
Total liabilities22,016 M25,710 M29,445 M26,370 M28,522 M33,191 M34,377 M34,767 M25,105 M127,975 M
Total non-current assets29,842 M-2,338 M-2,322 M35,798 M36,882 M43,118 M45,372 M46,229 M51,886 M164,864 M
TotalDeferredCreditsAndOtherNonCurrentLiabilities18,702 M20,145 M22,083 M22,844 M22,142 M25,814 M27,431 M27,281 M17,614 M105,858 M
TotalEquityGrossMinority16,536 M17,498 M15,419 M11,807 M13,465 M14,257 M15,593 M16,241 M17,148 M51,853 M
TotalEquityGrossMinorityInterest16,536 M17,498 M15,419 M11,807 M13,465 M14,257 M15,593 M16,241 M17,148 M51,853 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest38,552 M43,208 M44,864 M36,515 M37,720 M39,960 M44,053 M45,048 M47,162 M178,086 M
TotalTaxPayable147 M146 M25 M143 M234 M171 M46 M76 M274 M722 M
UnearnedIncome181 M
Working capital-422 M-2,635 M-3,886 M86 M-1,411 M-323 M-219 M-1,096 M-517 M-5,651 M
debtc1,067 M3,105 M4,802 M743 M3,472 M3,855 M3,622 M3,885 M3,535 M9,339 M
ltinv390 M358 M499 M212 M61 M64 M83 M88 M95 M455 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