Get XCEL Energy’s 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 rating: 100% (QA)

The movement of the current quick O CF FC F O CF IC F inventory ... View the full answer