50.1K
Verified Solution
Link Copied!
Get XCEL Energys two most recent 10-Ks from the SEC*: the 2021 10-K filed on 2/23/22 and the 2020 10-K filed on 2/17/21.
Get the 2021 and 2020 balance sheet information from the 2021 10-K. Get the 2019 balance sheet information from the 2020 10-K.
Get the 2021, 2020, and 2019 income and cash flow statement information from the 2021 10-K.
List the information for 2019-2021
| Accounts receivable |
| Inventory |
| Current assets |
| Total assets |
| Current liabilities |
| Long-term debt |
| Total liabilities |
| SHE |
| Sales |
| COGS |
| Net income |
| OCF |
| ICF |
| FCF |
1. Use the information to find the ratios:
| Current |
| Quick |
| OCF |
| FCF |
| OCF+ICF |
| Inventory T/O |
| AR T/O |
| TATO |
| DEBT |
| D-E |
| NPM |
| ROA |
| ROE |
Analyze these ratios:
| | Movement of concern including years | Problem indicated by movement of concern |
| Current | | |
| Quick | | |
| OCF | | |
| FCF | | |
| OCF+ICF | | |
| Inventory T/O | | |
| AR T/O | | |
| TATO | | |
| DEBT | | |
| D-E | | |
| NPM | | |
| ROA | | |
| ROE | | |
Answer & Explanation
Solved by verified expert
