| | | | | | | | | | | | | | | | | | | | | |
<?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 Schedule </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="3" Label="USD / shares"/> |
| </Labels> |
| | | <CurrencySymbol> $ </CurrencySymbol> |
| | | <hasSegments> false </hasSegments> |
| | | <hasScenarios> false </hasScenarios> |
| | | <Segments/> |
| | | <Scenarios/> |
| | | <Units> |
| <Unit> |
| <UnitID> EPS </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> |
| <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> |
| </Units> |
| | | </Column> |
| | </Columns> |
| <Rows> |
| | <Row> |
| | | <Id> 2 </Id> |
| | | <Label> NOTES TO THE CONSOLIDATED FINANCIAL STATEMENTS </Label> |
| | | <Level> 0 </Level> |
| | | <ElementName> shpgf_NotesToTheConsolidatedFinancialStatementsAbstract </ElementName> |
| | | <ElementPrefix> shpgf </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 Schedule </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> <div style="font-size:12pt"><table style="border-collapse: collapse; margin-top: 20px;"><tr><td height="53" width="390" align="left"><b> </b></td><td height="53" width="82" align="right"><b>Beginning balance</b></td><td height="53" width="82" align="right"><b>Provision charged to income(1)</b></td><td height="53" width="82" align="right"><b>Costs incurred/ utilization(1)</b></td><td height="53" width="82" align="right"><b>Ending balance</b></td></tr><tr><td height="17" width="390" align="left"><b>Provision for sales rebates, returns and coupons</b></td><td height="17" width="82" align="right"><b>$’M</b></td><td height="17" width="82" align="right"><b>$’M</b></td><td height="17" width="82" align="right"><b>$’M</b></td><td height="17" width="82" align="right"><b>$’M</b></td></tr><tr><td height="17" width="390" align="left"> </td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td></tr><tr><td height="17" width="390" align="left">2009 :</td><td height="17" width="82" align="right"> </td><td height="17" width="82" align="right"> </td><td height="17" width="82" align="right"> </td><td height="17" width="82" align="right"> </td></tr><tr><td height="34" width="390" align="left">Accrued rebates – Medicaid and Health Maintenance Organizations (“HMOs”)</td><td height="34" width="82" align="right">222.5 </td><td height="34" width="82" align="right">630.8 </td><td height="34" width="82" align="right">(511.7)</td><td height="34" width="82" align="right">341.6 </td></tr><tr><td height="17" width="390" align="left">Sales returns reserve</td><td height="17" width="82" align="right">47.1 </td><td height="17" width="82" align="right">41.4 </td><td height="17" width="82" align="right">(25.8)</td><td height="17" width="82" align="right">62.7 </td></tr><tr><td height="17" width="390" align="left">Accrued coupons</td><td height="17" width="82" align="right">4.0 </td><td height="17" width="82" align="right">38.6 </td><td height="17" width="82" align="right">(38.8)</td><td height="17" width="82" align="right">3.8 </td></tr><tr><td height="17" width="390" align="left"> </td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td></tr><tr><td height="17" width="390" align="left"> </td><td height="17" width="82" align="right">273.6 </td><td height="17" width="82" align="right">710.8 </td><td height="17" width="82" align="right">(576.3)</td><td height="17" width="82" align="right">408.1 </td></tr><tr><td height="17" width="390" align="left"> </td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td></tr><tr><td height="17" width="390" align="left"> </td><td height="17" width="82" align="right"> </td><td height="17" width="82" align="right"> </td><td height="17" width="82" align="right"> </td><td height="17" width="82" align="right"> </td></tr><tr><td height="17" width="390" align="left">2008 :</td><td height="17" width="82" align="right"> </td><td height="17" width="82" align="right"> </td><td height="17" width="82" align="right"> </td><td height="17" width="82" align="right"> </td></tr><tr><td height="17" width="390" align="left">Accrued rebates – Medicaid and HMOs</td><td height="17" width="82" align="right">146.6 </td><td height="17" width="82" align="right">396.9 </td><td height="17" width="82" align="right">(321.0)</td><td height="17" width="82" align="right">222.5 </td></tr><tr><td height="17" width="390" align="left">Sales returns reserve</td><td height="17" width="82" align="right">39.5 </td><td height="17" width="82" align="right">38.2 </td><td height="17" width="82" align="right">(30.6)</td><td height="17" width="82" align="right">47.1 </td></tr><tr><td height="17" width="390" align="left">Accrued coupons</td><td height="17" width="82" align="right">9 </td><td height="17" width="82" align="right">32.5 </td><td height="17" width="82" align="right">(37.5)</td><td height="17" width="82" align="right">4.0 </td></tr><tr><td height="17" width="390" align="left"> </td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td></tr><tr><td height="17" width="390" align="left"> </td><td height="17" width="82" align="right">195.1 </td><td height="17" width="82" align="right">467.6 </td><td height="17" width="82" align="right">(389.1)</td><td height="17" width="82" align="right">273.6 </td></tr><tr><td height="17" width="390" align="left"> </td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td></tr><tr><td height="17" width="390" align="left"> </td><td height="17" width="82" align="right"> </td><td height="17" width="82" align="right"> </td><td height="17" width="82" align="right"> </td><td height="17" width="82" align="right"> </td></tr><tr><td height="17" width="390" align="left">2007 :</td><td height="17" width="82" align="right"> </td><td height="17" width="82" align="right"> </td><td height="17" width="82" align="right"> </td><td height="17" width="82" align="right"> </td></tr><tr><td height="17" width="390" align="left">Accrued rebates – Medicaid and HMOs</td><td height="17" width="82" align="right">126.4 </td><td height="17" width="82" align="right">263.5 </td><td height="17" width="82" align="right">(243.3)</td><td height="17" width="82" align="right">146.6 </td></tr><tr><td height="17" width="390" align="left">Sales returns reserve</td><td height="17" width="82" align="right">36.5 </td><td height="17" width="82" align="right">46 </td><td height="17" width="82" align="right">(43.0)</td><td height="17" width="82" align="right">39.5 </td></tr><tr><td height="17" width="390" align="left">Accrued coupons</td><td height="17" width="82" align="right">13 </td><td height="17" width="82" align="right">50.2 </td><td height="17" width="82" align="right">(54.2)</td><td height="17" width="82" align="right">9 </td></tr><tr><td height="17" width="390" align="left"> </td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td></tr><tr><td height="17" width="390" align="left"> </td><td height="17" width="82" align="right">175.9 </td><td height="17" width="82" align="right">359.7 </td><td height="17" width="82" align="right">(340.5)</td><td height="17" width="82" align="right">195.1 </td></tr><tr><td height="17" width="390" align="left"> </td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td><td height="17" width="82" align="right">__________</td></tr></table><p> (1) In the analysis above, due to systems limitations, it is not practical and has not been necessary to break out current versus prior year activity. When applicable, Shire has performed general ledger reviews of sales deduction provisions charged to income, and the utilization of these provisions in subsequent years. Shire has determined that adjustments made in each year as a result of changes to estimates that related to prior year sales, and adjustments made as a result of differences between prior period provisions and actual payments, did not have a material impact on the Company’s financial performance or position either in each individual year, or in the Company’s performance over the reported period. <br /></p></div> </NonNumbericText> |
| <NonNumericTextHeader> Beginning balanceProvision charged to income(1)Costs incurred/ utilization(1)Ending balanceProvision for sales rebates, returns and </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> |