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

Answer & Explanation Solved by verified expert
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!
Become a Member

Other questions asked by students