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
- 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)
- 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
- 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
- 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
Get step-by-step solutions from verified subject matter experts
