Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
