Final Project WS

Duke Energy Corporation (NYS: DUK)

Income Statement

Fiscal year is January-December. All values USD Millions

Currency

Audit Status

Consolidated

Sales/Revenue

Sales Growth

Cost of Goods Sold

COGS excluding D&A

Depreciation & Amortization Expense

Depreciation

Amortization of Intangibles

COGS Growth

Gross Income

Gross Incme Growth

Gross Profit Margin

Other Operating Expense

EBIT

Unusual Expense

Non Opertaing Expense/Income

Non Operating Interest Income

Equity in Affiliates

Interest Expense

Interest Expense Growth

Gross Interest Expense

Interest Capitalized

Pretax Income

Pretax Income Growth

Pretax Margin

Income Tax

Income Tax-Current Domestic

Income Tax-Current Foreign

Income Tax-Deferred Domestic

Income Tax Credits

Consolidated Net Income

Minority Interest Expense

Net Income

Net Income Growth

Net Margin

Extraordinaries & Discountinued Operations

Extra Items & Gain/Loss Sales of Assets

Discontinued Operations

Net Income After Extrapordinaries

Preferred Dividends

Net Income Available to Common

Basic EPS

EPS Growth

Basic Shares Outstanding

Diluted EPS

EPS Growth

Diluted Shares Outstanding

EBITDA

EBITDA Growth

EBITDA Margin

EBIT

Balance Sheet Statement

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

Total Assets 162387

Total Liabilities Net Minority Interest 113203

Total Equity Gross Minority Interest 49183

Total Capitalization 103588

Preferred Stock Equity 1961

Common Stock Equity 46001

Capital Lease Obligations 1341

Net Tangible Assets 28660

Working Capital -7622

Invested Capital 108738

Tangible Book Value 26698

Total Debt 64075

Net Debt 62476

Share Issued 768

Ordinary Shares Number 768

Preferred Shares Number 40000

Statement of Cash Flows

Fiscal year is January-December. All values USD Millions

Operating Activities

Net Income before Extraordinaries

Net Income Growth

Depreciation Amortization & Depletion

Depletion & Depreciation

Amortization of Intangible Assets

Deferred Taxes & Investment Tax Credit

Deferred Taxes

Other Funds

Funds from Operations

Changes in Working Capital

Receivables

Inventories

Account Payable

Other Accruals

Other Assets/Liabilities

Net Operating Cash Flow

Net Operating Cash Flows Growth

Net Operating Cash Flow/Sales

Investting Activities

Capital Expenditures

Capital Expenditures (Fixed Assets)

Capital Expenditures Growth

Capital Expenditures / Sales

Net Assets from Acquisitions

Sale of Fixed Assets & Businesses

Purchase/Sale of Investments

Purchase of Investments

Sale/Maturity of Investments

Net Investing Cash Flow

Net Investing Flow/Sales

Financial Activities

Total Cash Dividends Paid

Common Dividends

Change in Capital Stock

Sales of Common & Preferred Stock

Proceeds from Stock Options

Net Issuance/Reduction of Debt

Change in Current Debt

Change in Long-Term Debt

Issuance of Long-term Debt

Reduction in Long-Term Debt

Net Financing Cash Flow

Net Financing Cash Flow Growth

Net Financing Cash Flow / Sales

12/31/2020 12/31/2019 12/31/2018

USD USD USD

Not Qualified Not Qualified Not Qualified

Yes Yes Yes

Millions Millions Millions

100.00% 100.00% 100.00%

71.24% 71.24% 71.24%

51.53% 51.53% 51.53%

19.71% 19.71% 19.71%

NM NM NM

NM NM NM

0.00% 0.00% 0.00%

28.75% 28.75% 28.75%

0.00% 0.00% 0.00%

0.00% 0.00% 0.00%

5.60% 5.60% 5.60%

23.15% 23.15% 23.15%

4.12% 4.12% 4.12%

1.80% 1.80% 1.80%

0.13% 0.13% 0.13%

8.40% 8.40% 8.40%

9.05% 9.05% 9.05%

0.00% 0.00% 0.00%

9.05% 9.05% 9.05%

NM NM NM

3.51% 3.51% 3.51%

0.00% 0.00% 0.00%

0.00% 0.00% 0.00%

-0.98% -0.98% -0.98%

-1.21% -1.21% -1.21%

0.00% 0.00% 0.00%

0.26% 0.26% 0.26%

0.04% 0.04% 0.04%

4.50% 4.50% 4.50%

-1.23% -1.23% -1.23%

5.74% 5.74% 5.74%

0.00% 0.00% 0.00%

0.00% 0.00% 0.00%

0.03% 0.03% 0.03%

NM NM NM

0.03% 0.03% 0.03%

5.71% 5.71% 5.71%

0.44% 0.44% 0.44%

5.32% 5.32% 5.32%

0.01% 0.01% 0.01%

0.00% 0.00% 0.00%

3.08% 3.08% 3.08%

0.01% 0.01% 0.01%

-0.28% -0.28% -0.28%

3.09% 3.09% 3.09%

42.86% 42.86% 42.86%

0.00% 0.00% 0.00%

0.00% 0.00% 0.00%

23.15% 23.15% 23.15%

12/31/2020 12/31/2019 12/31/2018

USD USD USD

Not Qualified Not Qualified Not Qualified

Yes Yes Yes

Millions Millions Millions

100.00% 100.00% 100.00%

69.71% 69.81% 69.85%

30.29% 30.19% 30.15%

63.79% 63.48% 65.07%

1.21% 1.23% NM

28.33% 28.24% 30.14%

0.83% 1.51% 0.23%

17.65% 17.32% 16.86%

-4.69% -3.52% -3.66%

66.96% 66.20% 69.76%

16.44% 16.09% 16.86%

39.46% 39.47% 39.85%

38.47% 37.76% 39.32%

0.47% 0.46% 0.50%

0.47% 0.46% 0.50%

24.63% 0.03% NM