Get XCEL Energys two most recent 10-Ks from the SEC*: the 2021 10-K filed on...
50.1K
Verified Solution
Question
Finance
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 |
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Best
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.