| | | | | | | | | | | | | | | | | | | | | |
<?xml version="1.0" encoding="windows-1252"?> |
<InstanceReport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> |
| <Version> 1.0.0.3 </Version> |
| <hasSegments> false </hasSegments> |
| <ReportName> VALUATION AND QUALIFYING ACCOUNTS </ReportName> |
| <RoundingOption/> |
| <Columns> |
| | <Column> |
| | | <LabelColumn> false </LabelColumn> |
| | | <Id> 1 </Id> |
| | | <Labels> |
| <Label Id="1" Label="12 Months Ended"/> |
| <Label Id="2" Label="Dec. 31, 2009"/> |
| <Label Id="4" Label="USD / shares"/> |
| </Labels> |
| | | <CurrencySymbol> $ </CurrencySymbol> |
| | | <hasSegments> false </hasSegments> |
| | | <hasScenarios> false </hasScenarios> |
| | | <Segments/> |
| | | <Scenarios/> |
| | | <Units> |
| <Unit> |
| <UnitID> Shares </UnitID> |
| <UnitType> Standard </UnitType> |
| <StandardMeasure> |
| <MeasureSchema> http://www.xbrl.org/2003/instance </MeasureSchema> |
| <MeasureValue> shares </MeasureValue> |
| <MeasureNamespace> xbrli </MeasureNamespace> |
| </StandardMeasure> |
| <Scale> 0 </Scale> |
| </Unit> |
| <Unit> |
| <UnitID> USD </UnitID> |
| <UnitType> Standard </UnitType> |
| <StandardMeasure> |
| <MeasureSchema> http://www.xbrl.org/2003/iso4217 </MeasureSchema> |
| <MeasureValue> USD </MeasureValue> |
| <MeasureNamespace> iso4217 </MeasureNamespace> |
| </StandardMeasure> |
| <Scale> 0 </Scale> |
| </Unit> |
| <Unit> |
| <UnitID> USDPerShare </UnitID> |
| <UnitType> Divide </UnitType> |
| <NumeratorMeasure> |
| <MeasureSchema> http://www.xbrl.org/2003/iso4217 </MeasureSchema> |
| <MeasureValue> USD </MeasureValue> |
| <MeasureNamespace> iso4217 </MeasureNamespace> |
| </NumeratorMeasure> |
| <DenominatorMeasure> |
| <MeasureSchema> http://www.xbrl.org/2003/instance </MeasureSchema> |
| <MeasureValue> shares </MeasureValue> |
| <MeasureNamespace> xbrli </MeasureNamespace> |
| </DenominatorMeasure> |
| <Scale> 0 </Scale> |
| </Unit> |
| </Units> |
| | | </Column> |
| | </Columns> |
| <Rows> |
| | <Row> |
| | | <Id> 2 </Id> |
| | | <Label> SCHEDULE II VALUATION AND QUALIFYING ACCOUNTS </Label> |
| | | <Level> 0 </Level> |
| | | <ElementName> xel_ScheduleOfValuationAndQualifyingAccountsAbstract </ElementName> |
| | | <ElementPrefix> xel </ElementPrefix> |
| | | <IsBaseElement> false </IsBaseElement> |
| | | <BalanceType> na </BalanceType> |
| | | <PeriodType> duration </PeriodType> |
| | | <ElementDataType> string </ElementDataType> |
| | | <ShortDefinition> No definition available. </ShortDefinition> |
| | | <IsReportTitle> false </IsReportTitle> |
| | | <IsSegmentTitle> false </IsSegmentTitle> |
| | | <IsSubReportEnd> false </IsSubReportEnd> |
| | | <IsCalendarTitle> false </IsCalendarTitle> |
| | | <IsTuple> false </IsTuple> |
| | | <IsAbstractGroupTitle> true </IsAbstractGroupTitle> |
| | | <IsBeginningBalance> false </IsBeginningBalance> |
| | | <IsEndingBalance> false </IsEndingBalance> |
| | | <IsEPS> false </IsEPS> |
| | | <Cells> |
| <Cell> |
| <Id> 1 </Id> |
| <ShowCurrencySymbol> false </ShowCurrencySymbol> |
| <IsNumeric> false </IsNumeric> |
| <NumericAmount> 0 </NumericAmount> |
| <RoundedNumericAmount> 0 </RoundedNumericAmount> |
| <NonNumbericText/> |
| <NonNumericTextHeader/> |
| <FootnoteIndexer/> |
| <hasSegments> false </hasSegments> |
| <hasScenarios> false </hasScenarios> |
| </Cell> |
| </Cells> |
| | | <ElementDefenition> No definition available. </ElementDefenition> |
| | | <IsTotalLabel> false </IsTotalLabel> |
| | | </Row> |
| | <Row> |
| | | <Id> 3 </Id> |
| | | <Label> VALUATION AND QUALIFYING ACCOUNTS </Label> |
| | | <Level> 1 </Level> |
| | | <ElementName> us-gaap_ScheduleOfValuationAndQualifyingAccountsDisclosureTextBlock </ElementName> |
| | | <ElementPrefix> us-gaap </ElementPrefix> |
| | | <IsBaseElement> true </IsBaseElement> |
| | | <BalanceType> na </BalanceType> |
| | | <PeriodType> duration </PeriodType> |
| | | <ElementDataType> string </ElementDataType> |
| | | <ShortDefinition> No definition available. </ShortDefinition> |
| | | <IsReportTitle> false </IsReportTitle> |
| | | <IsSegmentTitle> false </IsSegmentTitle> |
| | | <IsSubReportEnd> false </IsSubReportEnd> |
| | | <IsCalendarTitle> false </IsCalendarTitle> |
| | | <IsTuple> false </IsTuple> |
| | | <IsAbstractGroupTitle> false </IsAbstractGroupTitle> |
| | | <IsBeginningBalance> false </IsBeginningBalance> |
| | | <IsEndingBalance> false </IsEndingBalance> |
| | | <IsEPS> false </IsEPS> |
| | | <Cells> |
| <Cell> |
| <Id> 1 </Id> |
| <ShowCurrencySymbol> false </ShowCurrencySymbol> |
| <IsNumeric> false </IsNumeric> |
| <NumericAmount> 0 </NumericAmount> |
| <RoundedNumericAmount> 0 </RoundedNumericAmount> |
| <NonNumbericText> <table style="font-size:10pt; font-family:'Times New Roman',times,serif;"> <tr> <td> <p style="FONT-FAMILY: times"><font size="4"><b>SCHEDULE II <br /></b></font></p> <p style="FONT-FAMILY: times" align="center"><font size="3">XCEL ENERGY INC. AND SUBSIDIARIES<br /> Valuation and Qualifying Accounts<br /> Years Ended Dec. 31, 2009, 2008 and 2007 </font></p> <p style="FONT-FAMILY: times" align="center"><font size="2"><i>(amounts in thousands of dollars) </i></font></p> <div style="PADDING-RIGHT: 0pt; PADDING-LEFT: 0pt; PADDING-BOTTOM: 0pt; MARGIN-LEFT: 10%; WIDTH: 67%; PADDING-TOP: 0pt; POSITION: relative"> <p style="FONT-FAMILY: times"><font size="2"><!-- COMMAND=ADD_TABLEWIDTH,"120%" --></font></p> <!-- User-specified TAGGED TABLE --> <div align="center"> <table cellspacing="0" cellpadding="0" width="120%" border="0"> <tr style="HEIGHT: 0px"><!-- TABLE COLUMN WIDTHS SET --> <td style="FONT-FAMILY: times" align="left"></td> <td style="FONT-FAMILY: times" width="12"></td> <td style="FONT-FAMILY: times" width="65"></td> <td style="FONT-FAMILY: times" width="12"></td> <td style="FONT-FAMILY: times" width="65"></td> <td style="FONT-FAMILY: times" width="12"></td> <td style="FONT-FAMILY: times" width="65"></td> <td style="FONT-FAMILY: times" width="12"></td> <td style="FONT-FAMILY: times" width="65"></td> <td style="FONT-FAMILY: times" width="12"></td> <td style="FONT-FAMILY: times" width="65"></td> <td style="FONT-FAMILY: times" width="12"></td><!-- TABLE COLUMN WIDTHS END --></tr> <tr style="HEIGHT: 0px" valign="bottom"> <th style="FONT-FAMILY: times" align="left"><font size="2"> </font><br /></th> <th style="FONT-FAMILY: times"><font size="2"> </font></th> <th style="FONT-FAMILY: times" align="left"><font size="2"> </font><br /></th> <th style="FONT-FAMILY: times"><font size="1"> </font></th> <th style="BORDER-BOTTOM: #000000 1pt solid; FONT-FAMILY: times" align="center" colspan="3"><font size="1"><b>Additions </b></font></th> <th style="FONT-FAMILY: times"><font size="1"> </font></th> <th style="FONT-FAMILY: times" align="left"><font size="1"> </font><br /></th> <th style="FONT-FAMILY: times"><font size="1"> </font></th> <th style="FONT-FAMILY: times" align="left"><font size="1"> </font><br /></th> <th style="FONT-FAMILY: times"><font size="1"> </font></th></tr> <tr style="HEIGHT: 0px" valign="bottom"> <th style="FONT-FAMILY: times" align="left"><font size="1"> </font><br /></th> <th style="FONT-FAMILY: times"><font size="1"> </font></th> <th style="BORDER-BOTTOM: #000000 1pt solid; FONT-FAMILY: times" align="center"><font size="1"><b>Balance at<br /> Jan. 1 </b></font></th> <th style="FONT-FAMILY: times"><font size="1"> </font></th> <th style="BORDER-BOTTOM: #000000 1pt solid; FONT-FAMILY: times" align="center"><font size="1"><b>Charged to<br /> costs and<br /> expenses</b></font></th> <th style="FONT-FAMILY: times"><font size="1"> </font></th> <th style="BORDER-BOTTOM: #000000 1pt solid; FONT-FAMILY: times" align="center"><font size="1"><b>Charged to<br /> other<br /> accounts<sup>(a)</sup> </b></font></th> <th style="FONT-FAMILY: times"><font size="1"> </font></th> <th style="BORDER-BOTTOM: #000000 1pt solid; FONT-FAMILY: times" align="center"><font size="1"><b>Deductions<br /> from<br /> reserves<sup>(b)</sup> </b></font></th> <th style="FONT-FAMILY: times"><font size="1"> </font></th> <th style="BORDER-BOTTOM: #000000 1pt solid; FONT-FAMILY: times" align="center"><font size="1"><b>Balance at<br /> Dec. 31 </b></font></th> <th style="FONT-FAMILY: times"><font size="1"> </font></th></tr> <tr style="HEIGHT: 0px" valign="top" bgcolor="#CCEEFF"> <td style="FONT-FAMILY: times" valign="bottom"> <p style="MARGIN-LEFT: 9pt; TEXT-INDENT: -9pt; FONT-FAMILY: times"><font size="2"><b>Reserve deducted from related assets:</b></font></p></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td></tr> <tr style="HEIGHT: 0px" valign="top" bgcolor="white"> <td style="FONT-FAMILY: times" valign="bottom"> <p style="MARGIN-LEFT: 9pt; TEXT-INDENT: -9pt; FONT-FAMILY: times"><font size="2">Allowance for bad debts:</font></p></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td></tr> <tr style="HEIGHT: 0px" valign="top" bgcolor="#CCEEFF"> <td style="FONT-FAMILY: times" valign="bottom"> <p style="MARGIN-LEFT: 9pt; TEXT-INDENT: -9pt; FONT-FAMILY: times"><font size="2">2009</font></p></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom" align="right"><font size="2">$64,239</font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom" align="right"><font size="2">$49,023</font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom" align="right"><font size="2">$21,869</font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom" align="right"><font size="2">$79,028</font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom" align="right"><font size="2">$56,103</font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td></tr> <tr style="HEIGHT: 0px" valign="top" bgcolor="white"> <td style="FONT-FAMILY: times" valign="bottom"> <p style="MARGIN-LEFT: 9pt; TEXT-INDENT: -9pt; FONT-FAMILY: times"><font size="2">2008</font></p></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom" align="right"><font size="2">49,401</font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom" align="right"><font size="2">63,407</font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom" align="right"><font size="2">16,468</font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom" align="right"><font size="2">65,037</font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom" align="right"><font size="2">64,239</font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td></tr> <tr style="HEIGHT: 0px" valign="top" bgcolor="#CCEEFF"> <td style="FONT-FAMILY: times" valign="bottom"> <p style="MARGIN-LEFT: 9pt; TEXT-INDENT: -9pt; FONT-FAMILY: times"><font size="2">2007</font></p></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom" align="right"><font size="2">36,689</font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom" align="right"><font size="2">57,434</font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom" align="right"><font size="2">18,052</font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom" align="right"><font size="2">62,774</font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td> <td style="FONT-FAMILY: times" valign="bottom" align="right"><font size="2">49,401</font></td> <td style="FONT-FAMILY: times" valign="bottom"><font size="2"> </font></td></tr></table></div> <!-- end of user-specified TAGGED TABLE --></div> <!-- COMMAND=ADD_LINERULETXT,NOSHADE COLOR="#000000" SIZE="1.0PT" WIDTH="100%" ALIGN="LEFT" --> <hr style="COLOR: #000000" align="left" width="100%" noshade="noshade" size="1" /> <dl compact="compact"> <dt style="MARGIN-BOTTOM: -9pt; FONT-FAMILY: times"><font size="1"><sup>(a)</sup></font></dt> <dd style="FONT-FAMILY: times"><font size="1">Recovery of amounts previously written off. </font></dd> <dt style="MARGIN-BOTTOM: -9pt; FONT-FAMILY: times"><font size="1"><sup>(b)</sup></font></dt> <dd style="FONT-FAMILY: times"><font size="1">Principally bad debts written off or transferred. </font></dd></dl></td></tr></table> </NonNumbericText> |
| <NonNumericTextHeader> SCHEDULE II XCEL ENERGY INC. AND SUBSIDIARIES Valuation and Qualifying Accounts Years Ended Dec. 31, 2009, 2008 and 2007 (amounts in thousands of dollars) </NonNumericTextHeader> |
| <FootnoteIndexer/> |
| <hasSegments> false </hasSegments> |
| <hasScenarios> false </hasScenarios> |
| </Cell> |
| </Cells> |
| | | <ElementDefenition> No definition available. </ElementDefenition> |
| | | <ElementReferences> No authoritative reference available. </ElementReferences> |
| | | <IsTotalLabel> false </IsTotalLabel> |
| | | </Row> |
| | </Rows> |
| <Footnotes/> |
| <ComparabilityReport> false </ComparabilityReport> |
| <NumberOfCols> 1 </NumberOfCols> |
| <NumberOfRows> 2 </NumberOfRows> |
| <HasScenarios> false </HasScenarios> |
| <MonetaryRoundingLevel> UnKnown </MonetaryRoundingLevel> |
| <SharesRoundingLevel> UnKnown </SharesRoundingLevel> |
| <PerShareRoundingLevel> UnKnown </PerShareRoundingLevel> |
| <HasPureData> false </HasPureData> |
| <SharesShouldBeRounded> true </SharesShouldBeRounded> |
| </InstanceReport> |