Question: Below you can find the three basic statements contained in the annual report are the balance sheet, the income statement, and the statement of cash

  1. Below you can find the three basic statements contained in the annual report are the balance sheet, the income statement, and the statement of cash flows. First Generate the statement of stockholders equity, then examine these statements and determine the following (for the 2 consecutive years), and comment on each of them:

1- Operating current assets

2- Operating current liabilities

3- Long term assets

4- Long term liabilities

5- Owner equity

6- Net operating working capital

7- Operating long-term assets

8- Total net operating capital

9- NOPAT is net operating profit after taxes.

10- Return on Invested Capital (ROIC)

11- Free cash flow (FCF)

12- Market Value Added (MVA)

13- Economic Value Added (EVA)

  1. Begin Ratio Analysis

Compute the following set of ratios (for the 2 consecutive years), and comment on each of them:

1- Liquidity ratios

2- Asset Management Ratios

3- Debt Management Ratios

4- Profitability Ratios

5- Market Value Ratios

  1. Perform the following (for the 2 consecutive years), and comment on each of them:

1- Trend Analysis,

2- Common Size Analysis, and

3- Percentage Change Analysis

Duke Energy Financial Analysis

  1. Financial Statements
Balance Sheet 12/31/2022 12/31/2021
Assets
Cash & Equivalents 409 343
Receivables 4,415 3,610
Notes Receivable 0 0
Inventories 3,584 3,199
Other Current Assets 4,814 2,788
Total Current Assets 13,222 9,940
Net Property & Equipment 111,748 111,408
Investments & Advances 455 970
Other Non-Current Assets 0 0
Deferred Charges 23,282 22,888
Intangibles 19,303 19,303
Deposits & Other Assets 9,034 3,812
Total Assets 178,086 169,587

Liabilities & Shareholders Equity 12/31/2022 12/31/2021
Notes Payable 3,952 3,304
Accounts Payable 4,754 3,629
Current Portion Long-Term Debt 4,154 3,387
Current Portion Capital Leases 0 0
Accrued Expenses 626 533
Income Taxes Payable 722 749
Other Current Liabilities 4,665 4,329
Total Current Liabilities 18,873 15,931
Mortgages 0 0
Deferred Taxes/Income 10,813 10,212
Convertible Debt 0 0
Long-Term Debt 67,061 60,448
Non-Current Capital Leases 0 0
Other Non-Current Liabilities 28,610 30,786
Minority Interest (Liabilities) 0 0
Total Liabilities 126,233 118,451

Shareholders Equity 12/31/2022 12/31/2021
Preferred Stock 1,962 1,962
Common Stock (Par) 1 1
Capital Surplus 44,862 44,371
Retained Earnings 2,637 3,265
Other Equity 2,391 1,537
Treasury Stock 0 0
Total Shareholder's Equity 51,853 51,136
Total Liabilities & Shareholder's Equity 178,086 169,587
Total Common Equity 49,891 49,174
Shares Outstanding 770.00 769.30
Book Value Per Share 64.79 63.92

Fiscal Year End for Duke Energy Corporation falls in the month of December.

All items in Millions except Per Share data.

Income Statement 12/31/22 12/31/21
Sales 28,768 25,097
Cost Of Goods 15,792 13,002
Gross Profit 12,976 12,095
Selling & Adminstrative & Depr. & Amort Expenses 6,964 6,722
Income After Depreciation & Amortization 6,012 5,373
Non-Operating Income 505 671
Interest Expense 2,439 2,280
Pretax Income 4,078 3,764
Income Taxes 300 192
Minority Interest (95) (329)
Investment Gains/Losses 0 0
Other Income/Charges 0 0
Income From Cont. Operations 3,778 3,572
Extras & Discontinued Operations (1,323) 7
Net Income (GAAP) 2,550 3,908

Depreciation Footnote 12/31/22 12/31/21
Income Before Depreciation & Amortization 11,855 11,036
Depreciation & Amortization (Cash Flow) 5,843 5,663
Income After Depreciation & Amortization 6,012 5,373

Earnings Per Share Data 12/31/22 12/31/21
Average Shares 770.00 769.00
Diluted EPS Before Non-Recurring Items 5.27 5.24
Diluted Net EPS (GAAP) 3.17 4.94

Fiscal Year end for Duke Energy Corporation falls in the month of December.

All items in Millions except EPS data.

Cash Flow Statement

12/31/2022 12/31/2021
Cash Flow From Operations, Investments & Financial Activities
Net Income (Loss) 2,455.00 3,579.00
Depreciation/Amortization & Depletion 5,843.00 5,663.00
Net Change from Assets/Liabilities (3,271.00) (690.00)
Net Cash from Discontinued Operations 0.00 0.00
Other Operating Activities 900.00 (262.00)
Net Cash From Operating Activities 5,927.00 8,290.00
Property & Equipment (11,367.00) (9,715.00)
Acquisition/ Disposition of Subsidiaries (4,243.00) (6,098.00)
Investments 4,275.00 5,167.00
Other Investing Activities (638.00) (289.00)
Net Cash from Investing Activities (11,973.00) (10,935.00)

Uses of Funds 12/31/2022 12/31/2021
Issuance (Repurchase) of Capital Stock 9.00 5.00
Issuance (Repayment) of Debt 7,478.00 3,758.00
Increase (Decrease) Short-Term Debt 574.00 479.00
Payment of Dividends & Other Distributions -3,179.00 -3,114.00
Other Financing Activities 1,247.00 1,481.00
Net Cash from Financing Activities 6,129.00 2,609.00
Effect of Exchange Rate Changes 0.00 0.00
Net Change In Cash & Equivalents 83.00 -36.00
Cash at Beginning of Period 520.00 556.00
Cash at End of Period 603.00 520.00
Diluted Net EPS 3.17 4.94

Fiscal Year End for Duke Energy Corporation falls in the month of December.

All data in Millions except Per Share data.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!