Final Project WS

Duke Energy Corporation (NYS: DUK)

Income Statement

Fiscal year is January-December. All values USD Millions 12/31/2020

Currency USD

Audit Status Not Qualified

Consolidated Yes

Millions

Sales/Revenue 23868

Sales Growth -4.84%

Cost of Goods Sold 17003

COGS excluding D&A 12298

Depreciation & Amortization Expense 4704

Depreciation Nill

Amortization of Intangibles Nill

COGS Growth -5.80%

Gross Income 6863

Gross Incme Growth -2.32%

Gross Profit Margin 28.75%

Other Operating Expense 1336

EBIT 5526

Unusual Expense 983

Non Opertaing Expense/Income 430

Non Operating Interest Income 31

Equity in Affiliates 2004

Interest Expense 2161

Interest Expense Growth -1.90%

Gross Interest Expense 2161

Interest Capitalized Nill

Pretax Income 838

Pretax Income Growth -79.51%

Pretax Margin 3.52%

Income Tax -235

Income Tax-Current Domestic -289

Income Tax-Current Foreign 1

Income Tax-Deferred Domestic 62

Income Tax Credits 9

Consolidated Net Income 1074

Minority Interest Expense -294

Net Income 1369

Net Income Growth -63.51%

Net Margin 5.74%

Extraordinaries & Discountinued Operations 6

Extra Items & Gain/Loss Sales of Assets Nill

Discontinued Operations 6

Net Income After Extrapordinaries 1362

Preferred Dividends 106

Net Income Available to Common 1269

Basic EPS 1.71

EPS Growth -66.15%

Basic Shares Outstanding 736

Diluted EPS 1.72

EPS Growth -66.15

Diluted Shares Outstanding 737

EBITDA 10231

EBITDA Growth -0.36%

EBITDA Margin 42.86%

EBIT 5526

Balance Sheet Statement

Fiscal year is January-December. All values USD Millions 12/31/2020 12/31/2019

Total Assets 162387 158837

Total Liabilities Net Minority Interest 113203 110886

Total Equity Gross Minority Interest 49183 47950

Total Capitalization 103588 100837

Preferred Stock Equity 1961 1961

Common Stock Equity 46001 44861

Capital Lease Obligations 1341 2402

Net Tangible Assets 28660 27518

Working Capital -7622 -5589

Invested Capital 108738 105151

Tangible Book Value 26698 25556

Total Debt 64075 62692

Net Debt 62476 59980

Share Issued 768 732

Ordinary Shares Number 768 732

Preferred Shares Number 40000 40

Statement of Cash Flows

Fiscal year is January-December. All values USD Millions 12/31/2020

Operating Activities

Net Income before Extraordinaries 1081

Net Income Growth -69.68%

Depreciation Amortization & Depletion 4704

Depletion & Depreciation Nill

Amortization of Intangible Assets Nill

Deferred Taxes & Investment Tax Credit 53

Deferred Taxes 53

Other Funds 3678

Funds from Operations 9519

Changes in Working Capital -530

Receivables -55

Inventories 65

Account Payable -20

Other Accruals 116

Other Assets/Liabilities -636

Net Operating Cash Flow 8988

Net Operating Cash Flows Growth 9.50%

Net Operating Cash Flow/Sales 37.65%

Investting Activities

Capital Expenditures -9,906

Capital Expenditures (Fixed Assets) -9906

Capital Expenditures Growth 10.92%

Capital Expenditures / Sales -41.50%

Net Assets from Acquisitions Nill

Sale of Fixed Assets & Businesses 425

Purchase/Sale of Investments -431

Purchase of Investments -8380

Sale/Maturity of Investments 7948

Net Investing Cash Flow 7.23%

Net Investing Flow/Sales -43.10%

Financial Activities

Total Cash Dividends Paid -2811

Common Dividends -2811

Change in Capital Stock 2744

Sales of Common & Preferred Stock 2744

Proceeds from Stock Options 2744

Net Issuance/Reduction of Debt 1504

Change in Current Debt -318

Change in Long-Term Debt 1823

Issuance of Long-term Debt 6329

Reduction in Long-Term Debt -4505

Net Financing Cash Flow 1304

Net Financing Cash Flow Growth -54.80%

Net Financing Cash Flow / Sales 5.46%

12/31/2019 12/31/2018

USD USD

Not Qualified Not Qualified

Yes Yes

Millions Millions

25078 24522

2.28% 4.06

18050 17792

13502 13718

4547 4073

Nill Nill

Nill Nill

1.45% 8.88%

7027 6727

4.45% -6.84

Nill Nill

1306 1279

5720 5447

7 672

394 288

30 19

161 82

2203 2093

5.24% 5.43%

2203 2093

Nill Nill

4096 3072

33.31% -27.98%

Nill Nill

518 447

-288 -657

2 3

816 1112

10 9

3577 2624

-176 -21

3754 2646

41.86% -13.64%

Nill Nill

-6 19

Nill Nill

-6 19

3761 2627

40 Nill

3706 2665

5.08 3.76

35.03% -13.82%

728 707

5.08 3.76

35.03 -13.82

728 707

10268 9521

7.84% 0.05%

Nill Nill

5720 5447

12/31/2018

145391

101557

43833

94604

Nill

43816

336

24513

-5327

101420

24513

57938

57161

726

726

Nill

12/31/2019 12/31/2018

3570 2643

35.05% -13.71%

4547 4073

Nill Nill

Nill Nill

805 1078

805 1078

333 551

9081 8348

-872 -1162

-77 -344

-121 155

-164 479

-223 23

-440 -1475

8208 7185

14.23% 8.47%

32.72% 29.30%

-11,121 -9,388

-11121 -9388

-18.45% -16.60%

-44.34% -3828%

Nill Nill

842 40

328 430

3671 4177

3342 3746

-10% -19.17%

-44.31% -41.02%

-2667 -2470

-2667 -2470

2345 1837

2345 1837

2345 1837

3234 3563

-380 1170

3614 2392

7090 5298

-3475 -2905

2886 2960

-2.46% 66.11%

11.50% 12.06%