ࡱ> (' ' \pLisa Schreiber Ba==Xl9 8X@"1Calibri1Calibri1Calibri1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1 Calibri1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1Calibri1Arial1Arial1Arial1Arial1xArial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0_);\(0\)""* "#,##0;"* "\-#,##0;"* "0;@$"** "#,##0;"** "\-#,##0;"* "0;@                                                                       ff + ) , *      P  P         `            a>  !X !X x x |  |  !X x@  |@  x@  x@  !X x  |  |  x  x  |  |  x  x  x  x  x  |  |  |  |  |  |  |  |  x  |  |  |    X X   x x x  )\ x x x x  20% - Accent1 20% - Accent2 20% - Accent3 20% - Accent4 20% - Accent5 20% - Accent6 40% - Accent1 40% - Accent2 40% - Accent3 40% - Accent4 40% - Accent5 40% - Accent6 60% - Accent1 60% - Accent2 60% - Accent3 60% - Accent4 60% - Accent5! 60% - Accent6 "Accent1 #Accent2 $Accent3 %Accent4 &Accent5 'Accent6(Bad) Calculation* Check Cell+,-./Explanatory Text0  1Good2 Heading 13 Heading 24 Heading 35 Heading 46 7Input8 Linked Cell 9Neutral :Note ;Output< =Title >Total? Warning Text`SIT_07FY_Table3IDX:" *'Table 3. Charitable Remainder Annuity Trusts: Book Value Balance Sheet Information, by Size of End-of-Year Book Value of Total Assets, Filing Year 2007W[All figures are estimates based on samples--money amounts are in thousands of dollars]ItemTotal.Size of end-of-year book value of total assetsUnder $500,000 [1]$500,000 under $1,000,000$1,000,000 under $3,000,000$3,000,000 under $10,000,000$10,000,000 or moreNumber of returnsTotal net assets [2]Total assets [3]Cash&Savings and temporary cash investments5Receivables due, inventories and prepaid expenses [4]Total investments SecuritiesGovernment obligationsCorporate stockCorporate bondsLand, buildings, and equipmentOther investments**Other assets [5]Total liabilities [6]8Accounts payable, accrued expenses, and deferred revenueOther liabilities [7]j* Estimate should be used with caution because of the small number of sample returns on which it is based.** Data are combined to prevent disclosure of individual taxpayer data. obever, the data are included in the appropriate totals.7[3] Taken from Form 5227, Part IV, line 37, column (b).[5] Calculated as the sum of "charitable purpose land, buildings, and equipment" (Form 5227, Part IV, line 35, column (b)) and "other assets" (line 36, column(b)).7[6] Taken from Form 5227, Part IV, line 43, column (b).[7] Includes "loans from officers, directors, trustees, and other disqualified persons" (Form 5227, Part IV, line 40, column (b)), "mortgages and other notes payable" (line 41, column (b)), and "other liabilities" (line 42, column (b)).YNOTE: Detail may not add to totals due to rounding and taxpayer reporting discrepancies.9SOURCE: IRS, Statistics of Income Division, October 2008.[1] Includes returns that did not report the end-of-year book value of total assets (Form 5227, Part IV, line 37, column (b)) from the balance sheet, or that reported the amount as zero. Often, these zero amounts are explained by trusts filing a final return. "[2] Taken from Form 5227, Part IV, line 46, column (b). This is the excess of total assets over total liabilities. This value may deviate from the calculated value of total assets ( line 37, column (b)) less total liabilities (line 43, column (b)) due to taxpayer reporting discrepancies.q[4] Calculated as the sum of "accounts receivable" (Form 5227, Part IV, line 27, column (b)), "receivables due from officers, directors, and other disqualified persons" (line 28, column(b)), "other notes and loans receivable" (line 29, column (b)), "inventories for sale or use" (line 30, column (b)), and "prepaid expenses and deferred charges" (line 31, column (b)).* R-kScc '  #$"<+,  dMbP?_*+%&?'?(?)?MnMicrosoft Office Document Imag/dXXLetterwidm"dXX333333?333333?U} '@} @ @} @} /@#@ @FKKK @ @ @ @ @@@@@@@K@@eeeeeweee kkkkkkk AAAAAAA h l nnnno im B B B B C j*DDDDDE G *H@H@H|@HX@Iu@J@S@ L *M6*MjMJbMMjNJ s O *Mj6M.mM8AMʁMP:AN<@/j  !!7ggD Oh+'0@H`x Lisa SchreiberLisa SchreiberMicrosoft Excel@Ah5@ga5՜.+,0 PX|  Department of the Treasury' SIT_07FY_Table3SIT_07FY_Table3!IDX  Worksheets Named Ranges  !"#$%&Root Entry FWorkbook,SummaryInformation(DocumentSummaryInformation8