ࡱ> b  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry Fm4̀Ỳ/Workbook_VBA_PROJECT_CUR" ỲỲVBA،Ỳ،Ỳ g2Ʉ\pDepartment of Treasury Ba= ThisWorkbook=H09#8X@"1Arial1Arial1Arial1Arial1Arial1Arial1 Arial1$Arial1Arial1xArial1Arial1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri"$"#,##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,\ ;[Black]\-#,##0,;\ \-\-'"#,##0,"*"\ ;[Black]\-#,##0,;\ \-\-)$"*"\ #,##0,\ ;[Black]\-#,##0,;\ \-\-+&\ #,##0,\ ;[Black]"*"\ \-#,##0,;\ \-\-!#,##0,\ ;[Black]\-#,##0,;\ 0-(\ #,##0,\ ;[Black]"*"\ \-#,##0,\ ;\ \-\-(##,##0,\ ;[Black]\-#,##0,\ ;\ \-\-\ -("*"\ #,##0,\ ;[Black]\-#,##0,\ ;\ \-\-\ #,##0,\ ;[Black]\-#,##0,""*"\ #,##0,\ ;[Black]\-#,##0,&!#,##0,\ ;[Black]\-#,##0,\ ;\ \-\-"* [2]"\ ;[Black]"* [2]"#,###\ ;[Black]General                                                                      ff + ) , *      P  P         `            a>    "  "<@ @ 1"<@ @ 1"     8 @  ,@ @   ,@ @ (8@ )8@  )8@  )8@   )8@  )8@  ,@    $   1"  $  $@  1"<@ @ 1"4@ @  ,@   ,  $  $  $@   ,@   $@   $@   ,@ 7   ,@ 7   ,7  8@ @ 8@ 8@ 8@@ 8@ 8@ "8@@  8@  8  0  (8 <@ @ <@ <@ 8@@ 8 @ 8@ 8 1<@ 1<@ *8@ *8@ 1<@ 1<@ 8@ @ 8@ "8@ 8 @ 0 0 <@ @ "8@@ "8@ "8 @ 8@@ 8@ 8 @ 0@ 0@ ||}A} \ \-\- \ef;_(@_) }A} \ \-\- \ef;_(@_) }A} \ \-\- \ef;_(@_) }A} \ \-\- \ef;_(@_) }A} \ \-\- \ef;_(@_) }A} \ \-\- \ef ;_(@_) }A} \ \-\- \L;_(@_) }A} \ \-\- \L;_(@_) }A} \ \-\- \L;_(@_) }A} \ \-\- \L;_(@_) }A} \ \-\- \L;_(@_) }A} \ \-\- \L ;_(@_) }A} \ \-\- \23;_(@_) }A} \ \-\- \23;_(@_) }A} \ \-\- \23;_(@_) }A} \ \-\- \23;_(@_) }A}  \ \-\- \23;_(@_) }A}! \ \-\- \23 ;_(@_) }A}" \ \-\- \;_(@_) }A}# \ \-\- \;_(@_) }A}$ \ \-\- \;_(@_) }A}% \ \-\- \;_(@_) }A}& \ \-\- \;_(@_) }A}' \ \-\- \ ;_(@_) }A}( \ \-\- \;_(@_) }}) }\ \-\- \;_(@_)    }}* \ \-\- \;_(@_) ??? ??? ??? ???}-}/ \ \-\- \}A}1 a\ \-\- \;_(@_) }A}2 \ \-\- \;_(@_) }A}3 \ \-\- \?;_(@_) }A}4 \ \-\- \23;_(@_) }-}5 \ \-\- \}}7 ??v\ \-\- \̙;_(@_)    }A}8 }\ \-\- \;_(@_) }A}9 e\ \-\- \;_(@_) }x}:\ \-\- \;_(  }}; ???\ \-\- \;_(??? ???  ??? ???}-}= \ \-\- \}U}> \ \-\- \;_( }-}? \ \-\- \}<}N\ \-\- \;_(}<}O\ \-\- \;_(}<}P\ \-\- \;_(}<}Q\ \-\- \;_(}<}Y4\ \-\- \4;_(}<}\4\ \-\- \4;_(}<}]4\ \-\- \4;_(}<}^4\ \-\- \4;_(}<}_4\ \-\- \4;_(}<}`4\ \-\- \4;_(}<}a4\ \-\- \4;_(}<}b4\ \-\- \4;_(}<}c4\ \-\- \4;_(}(}d4\ \-\- \}(}e4\ \-\- \}(}f4\ \-\- \ 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text %0 : Followed Hyperlink 1Good;Good  a%2 Heading 1G Heading 1 I}%O3 Heading 2G Heading 2 I}%?4 Heading 3G Heading 3 I}%235 Heading 49 Heading 4 I}%6( Hyperlink 7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  e%"Normal :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent =Title1Title I}% >TotalMTotal %OO? Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16`WLSheet 1Controlled Foreign Corporations Total assetsTotal receipts Income taxesNForeign corporations with current earnings and profits (+) before income taxes)Distributions out of earnings and profits.Dividends paid to controlling U.S. corporationTotal Subpart F income%Receipts by foreign corporations from#Payments by foreign corporations toBeginning of year End of yearTotal All sources Unrelated partiesAll recipients)Not previously taxed earnings and profits(1)(2)(3)(4)(5)(6)(7)(8)(9)(10)(11)(12)(13)(14)(15)(16)(17)(18)(21)(23)(24)CanadaLatin America, totalMexicoGuatemala Panama (including Canal Zone) Barbados!South America, total Argentina Brazil Chile Colombia Venezuela Other South American countries#Other Western Hemisphere, total !Bahamas Bermuda Netherland Antilles #Europe, total European Union, total Austria Belgium Denmark Finland Germany Greece Ireland Luxembourg Netherlands Sweden Norway RussiaCzech RepublicHungarySlovakiaPoland$Africa, total "East Africa, total Southern Africa, total $Asia, total !Middle East, total Cyprus%Southern and Southeastern Asia, totalIndia Malaysia Philippines Singapore Thailand /Other Southern and Southeastern Asian countries"Eastern Asia, total China Hong Kong ;Japan (including Okinawa and Ryukyu Islands) $Oceania, total !Australia New Zealand "Other countries of Oceania *Puerto Rico and U.S. Possessions, total 0OPEC countries, total (countries included above)?Current earnings and profits (less deficit) before income taxes0Current earnings and profits before income taxes/Current earnings and profits after income taxes>Current earnings and profits (less deficit) after income taxesAll related parties, totalEAny foreign corporations controlled by U.S. corporation filing return6Central America and Caribbean countries, total Honduras.Other Central American and Caribbean countriesEcuadorUruguayBritish Virgin IslandsCayman Islands"Other Western Hemisphere countriesItalyOther European countries, total SwitzerlandOther European countriesOther Eastern Asian countriesCSelected country of incorporation of Controlled Foreign Corporation&Number of U.S. corporation returns [1]Number of foreign corporationsEFrance (including Corsica, Guadeloupe, Martinique, and Reunion) HUnited Kingdom and Northern Ireland (including Gibraltar) /Central, Northern, and Southwestern Asia, total7NOTE: Detail may not add to totals because of rounding.South Korea All geographic regions/Portugal (including Azores) 3Spain (including Canary Isles) [1] Number of returns is not additive because some U.S. corporations had Controlled Foreign Corporations in more than one country.%Previously taxed earnings and profitsX[All figures are estimates based on a sample--money amounts are in thousands of dollars] Table 2. U.S. Corporations and Their Controlled Foreign Corporations: Number, Assets, Receipts, Earnings, Taxes, Distributions, Subpart F Income, and Related Party Transactions, by Selected Country of Incorporation of Controlled Foreign Corporation, Tax Year 2010 (19)(20)(22)4Other European Union countries Total section 964(a) E&PLTotal not previously taxed E&P (post-86 & pre-87 section 959(c)(3) balances)>Total previously taxed E&P (sections 959(c)(1) & (2) balances)(25)(26)(27)3End of year accumulated earnings and profits (E&P) Dividend incomejDividends received from foreign corporations or partnerships controlled by U.S. corporation filing return dDividends paid to foreign corporations or partnerships controlled by U.S. corporation filing return (29)(30)(28)Other African countries5Source: IRS, Statistics of Income Division, June 201438 K9$9O:(:^:;<=x>Ql?E@hA qCJ /D Et GG fI?JccJBOUj_ KU g2Ʉ  dl#i  dMbP?_*+%&?'?(?)?M*\\MTB0120PPSOI06\BolinLC odXXLetterDINU"(d `$D(SMTJHP Universal Printing PCL 5InputBinFORMSOURCERESDLLUniresDLLHPDocUISUITrueESPRITSupportedTrueResolution600dpiPrintQualityGroupPQGroup_3FastRes8bppOrientationPORTRAITHPOrientRotate180FalseDuplexNONEHPColorSmartAutomaticHPColorSmart_ColorOptions_EdgeControlNormalHPCOLORRETHPRETPJLHPColorSmart_ColorOptions_RGBColorNoCmdHPColorSmart_ColorOptions_HalftoneNoCmdHPColorSmart_Text_NeutralGraysBlackOnlyHPColorSmart_Text_HalftoneDetailHPColorSmart_Text_RGBColorDefault(sRGB)HPColorSmart_Graphics_NeutralGraysBlackOnlyHPColorSmart_Graphics_HalftoneDetailHPColorSmart_Graphics_RGBColorDefault(sRGB)HPColorSmart_Photo_NeutralGrays4-ColorHPColorSmart_Photo_HalftoneDetailHPColorSmart_Photo_RGBColorDefault(sRGB)HPPrintOnBothSidesManuallyFalsePaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateONHPOutputBinOrientationFACEUPPunchingNoneStaplingNoneHPStaplingOpposedFalseEconomodeFalseTextAsBlackFalseGraphicsModeHPGL2MODEAlternateLetterHeadFalseHPSmartHubInet_SID_263_BID_514_HID_265OutputBinAutoHPDocPropResourceDatahpchl130.cabHPMediaTypeTreeviewPopupTrueHPColorModeCOLOR_MODEColorMode24bppTTAsBitmapsSettingTTModeOutlineHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNT_GROUPNAMEHPJobAccWoPinTrueHPBornOnDateHPBODHPColorPlaneHPCPHPJobByJobOverrideJBJOHPXMLFileUsedhpcu1305.xmlHPSmartDuplexSinglePageJobTrueHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueRGBColorNoCmdJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffHPNUseDiffFirstPageChoiceTRUEHPPageExceptionsFileHPCPE130HPPageExceptionsInterfaceShowPageExceptionsHPPageExceptionsLowEndHPPageExceptionsLowEndVerHPPageExceptionsCoverInsertionHPBestGlossDEFAULTPSAlignmentFileHPCLS130IUPH!xAkA/*YǢZQdj]ۂPڍ@BՃHK*^K?'?L6M㡲- o佝مf7 LXK%RvF|-&"lDaOw_-/ϴcB<_,(.JӘ1 K7F<;w&=+J4cbPq_U/F:nR0/#v)v:C}1qR"=L??"D I5!DH m9r`!~8]F9צmo_Q#ه3^1ӧ9N|lq!D|BO!]/g|Ĵ9gZ&gVd[{%飊x0^şLg6Љ>}K5Th1hg&⺁8hUlV8xFŤʽ` *{קifOgz`B!B!owO"dXX??&U} =@} $ F} I F} mF} @} mF} }  F}  F} F} I F} $ F} F} m @}  @} m @}  @}  @} @}  @} $ @}  @} I @}  @}  @}  @} $} m} I @dH AABEGG     G o>pppppppppppppppppppppppppppp xBpppppppppppppppppppppppppppp s t m>nnnnnnnnnnnnnnnnnnnnnnnnnnmn s ru uv r g g` g  gc     u wv g g   u wwv u www g j ss r g shhh  ga  g  gb   g g hh g g g g gd {e y g gd {e } hkDtttitiiiiiiiiiihii|zii|~ilI C C C D C D Z Z  Z  Z  Z  Z  Z Z Z Z Z! Z" Z D Z# Z Z$ Z% Z Z Z Z [ W M{L#@L@@JT BJ)SBJmBS-ZBJ53gBJ)ݤ:B J{dB J, kB Jר9B JvgB J@y5\ZBJB%SBJ:X B a"B aਢ,B a@caB apP&B alu[Ba4IBaAa(YBa֘AaoT{8BaW{r6BaxXHBaf]BaE<B bMB buA bv]rB~ b*Q ^ZA P) Yd@Y@o@ bA bpyCA b )A cN)bڨ6wbf|Qbv,b  b~A0 bbVjqb*2_b5"b6 b bA b[xb{ b )A bVA bA b@,A b0GEA b%.A bA b@u[A cvO^M Pg YP@Y`@ b]A bf9A b@.A` c@b)bι'bNb^!bbʓb.b.bctb bFX)%bbbRR b@.A b+A bRA bɏqA b@ slA bpA~ bBwk b)A c) A_B, P* Yn@Y@w@ b \B b+B bB~ bB  b;A~ bJ4 b0A biƒA~ b+ bWPA$ bQobOb(bJb& b QIA b!1A bA bB b BA bA bph&ZA b ݌B bt_A bv)A bA b{'^n7K PhY v@Yȅ@b\! Bb;BbB~ cfQb]sAb$3b2v|  bM"{A~  b~ / b] A$ b+!Gb6Bb.b!aby99b#IAb? A~ bgbBbAb@YԃAb]Bb+UBb@%?AboAbPCBbJ^:# O,Yl@Y@b@-5UBbXBblNBbBAAbh.Bb0KeA brUB bi!B bQA bB b2BbP BbTAbrbAb-oAbn\&&BbVp%Bb 0VAblNBby%Bb,{Bb3IBbW@MBbWCm(Bb7Bb,Q#GBb_A^A P-Y@Y@@b0%EBb,'BbJ B~ b0b@Ab9(A b` A bA b@&A bM`LA b@BvAbcAb bbzZb:bSAbѨA bWDA b'A b A b ۥA b}Ab`gA~ b^!b8A~ b9$KbBb00BbAbMKBbsAb`^;Abh@Bbp`Bb*>Ab@TAb?[BbUkA^A P0Yw@Y@bp6BbzBbȯB~ bnla bBf`A~ bo bdA b@8-A~  bw%n b@սA bm%Ab`I{Abfb5zbL b|\7Ab~tA~ bb9bȯBb@jAb7tAbs> BbP Bb`{AbAbxBb^ ^5v@ PiY\@Ye@b^9AbkZAb7ANc s>AbpF?bMb"-bbGb޳b(D6b"t#b "ciYbc=,Ab ?7Ab\j A~ bXTAb7Ab@oAbKAb@-B}Ab-AbdAb Abc1Acn^vjJ PjYc@Yj@b? AbAbqANc LAbƒLbKb6zDbQ\b^Pb$Ub+bV c9 b""bbAbPObnAbqAbRA~ b2 ib lAb@̿Ab\A~ b)jrbAcFy_bJ P1Yq@Yy@b Bb #$ Bb w B~ cFb@gAbA b&A b,pA bTA blA b,AbȹA~ c気b/'oA~ b:ۖb F{eAb@ӌA~ bYgb w BbnA~ bZ Wb2T Bb BbAbWJAbBcN^B( P2Ys@Y|@b0dd Bb^Bb{%B~ c~ZbǰnAbA b~bA b m(c&j%c!b–-bf(`n#9bk;bڀAb@DA~ bZY'b@I+Ab AbA~ b*1bɅAc^V O5Yx@Y`@b cBbbBb@#poWBbyGBb-%5Bb -A bll3B bW5B b wA bL;M4B b 3Bb20Bb] Bb@/Ab7!Ab"8(FBbXmDBb"i Bb@#poWBbZ =Bb1$Bbޚ?PBbMBb.pwABbQ~97Bbvg/ O&Yl@Y;@b 0HnBbZa TnBbUdBbaBb'BbX@GB b #B b+D,B b@B b0'B b!BbO[7Bb AbSbBb`֩Ab!=Bbط:BbiBbUdBb CBb^sjb$Bb@)`Bb,zcBbsdHm c^gA'cR b{'b Ab.AbAb 1 AbbmA~ b&qbDAbYTAbA~ bJ&b~6>AcJH_>UD7lPTlBJH`r\ !G"#$%&'()@*+,-./0123456789:;<=G>? Om Yc@Y@m@ bpA bA bAN cNbaHbb0bvۄVbOb>bbKb bbާ? bh7A bA~ bZ> bA bPEb涄 bGA bSIA b$A~ b6H/ b.A c@`A^g !N7!\@\@!abO(NB!a$B!a߸ĄB!a"QIB!a˓XB!atVA$B! a2UB! a '[B! a#B! aLaYB! a+ZMIB!a|E,@B!aA2B!a af-B!aa$B!anB!a@40gjB!aQAB!a߸ĄB!atEiB!aLbB!aHP}B!aCB!a jB!a@`B!a@YxB!a\=B!]>^i;B "Q8"YC@YT@"bH\᧟B"b@7٠B"brׁB"bvGB"b@9UB"bk!B" bKSB" bJ&mSXB" bY B" b n7VB" bJ/pFB"bS ?A$ bVA$ b1A$ b A$ bRA$bSAVA$bz DbFc|?$b5A$bA$bnbA$b iPA$bdi+B$b`u&B$b kUB$b~JN; B$b|)B$bXw<B$b8LB$bPB~ $bf«u$^gA %PN%Y@\@Yb@%b!nB%b@q+; B%blA~ %c6=%bA~ %b % bWA% b`A~ % b$ % bׅTA% b@[+A%b:A%bd=b*b/%bA%bDOA~ %b ;%blA%b=EA~ %bi%bA%bP:A%bpb?A%bnA%bJA~ %b.%_@A &PE&Y0x@Y(@&b&b5B&bYA&b`m:A&bXϤkB&b0+̫ B&b@dA&b%A&bH@B&cb^ \ 'P;'Y`y@Y@'btnq6#B'bf6B'bݗB'b`7HA'bಇA~ 'b_6' b`A' b@H=mA~ ' b0' b0:A' bPHMA'b?A'bkA'b_FQA~ 'b'beA'b'A'bA'bݗB'bplA'b@.RA'bX\B'b0 +B'b  B'bA'bƧNB'b ҪA'^ iA (P<(Y@p@Y w@(bB(bDB(b}A~ (bBM(blA(b bFFt ( bӾ\A~ ( b( b'A$( b(Unb.UbAcڶObS(bA(bA~ (b )(b}A(bA(b+wA(bwNA(b5xA(bA(bA(b A(b<^аe )Pv)Y@Y*@)b@sAQB)b@xPB)b?O@B)b OA)b`%B)bA) b/A) b KEB) b 3EA) bXB) b@4A)bUίA)b{DA)b9A)b\^A)b B)b:zB)bPCA)b?O@B)btܿ*#B)bр B)bi7B)bBq"?B)bzu #B)b<B)bư`6B)bP?A)^=(JA *P=*Y@Y @*bbӼ[B*b@vGJZB*bvJB*bOA*bPJB*bs!A* b({B* b5B* b*A* bq B* bLBB*bp"A*bBA*bA*b@A*b=?B*b>YB*b|A*bvJB*bI*B*b0_%B*bY mDB*b[[JB*bU0B*btP0*B*bO5AB*bA*^A +P>+Y`g@Yq@+bh~B+bC:B+bpMAN+c`^r bd'` xbQbCtb*@4b<^bPcB8b b~Վ+b;[A+b1wbר +bpMA+bA+b(A+b"A+b0jB+b`A+bA+bP.)A+b ^jMS ,PF,YPs@Y{@,bS4B,bG(3B,bWB,bA,b~A~ ,b.# , b`2|A, b :,YA~ , b4, b VoA, bMA,bۦpA,b-A~ ,br"*,b /A,bA,b`^A~ ,bVt,bWB,bH)B,bpA,b `A,b@jB,bbA,bǪRA,bkB,bA,^ A -P?-YЄ@Y@-b ADiB-b`!lB-b&vPB-b7B-bp2B-bxA- b;1B- bI4B- b@{A- b<3B- b"B-bpA-bCB-bdA-b !A-bRCKB-bUKIB-bY+ B-b&vPB-b6B-bwz-$B-b@(EB-bzJB-b:A&7B-bٸ 'B-b)?B-b5A-^ݱ B .Pn.Y@Y@.bzVE 8B.bi>9B.b0B.bT6A.b0fA.bADA. b*lA. b0MA. bA. bA. bv8A.b4A.bFjt`bjC?.b+wA.b1B.b0PB1bǃ_A1bbB1bTs¬B1b0s_A1b0A1bl#%B~ 1bκ&1^6,A 2P|2Y@o@Y0y@2b܀B2b0&B2bx4cB2b ؜^A2b"A~ 2br-/2 b`ܬA2 b@NlA~ 2 b4,2 b !ǜA2 bS=A~ 2bJf~2bA~ 2b#2b/A2bzA2bc2A2b@A2bx4cB2b PA2b ~[A2bp%rB2b0B2bgA2b`wA2b A2byuA2^U.PA 3PG3Y@b@Y`h@3b`3A3bdPA3bp81A`3cfirb&Ybr? bLbVpbY bdbцbnxcVYcܨb^ b5bb*b: 3bp81A3b6L>A3b@ A3bqօA3b0(A3b6A3b@$A3b 4A3cNG^& 4P}4Y@Y@4b&:lCB4b3zAB4bm@B4bzB4bhYB4bq#9A4 bjA4 b 9PB4 b@A4 bPk{B4 bCB4b8=8B4b [A4b@]A4b )A4bAB4b B4b@~A4bm@B4bv˼}!B4b`cB4b"R/`7B4bgר>B4b[E!B4b6GB4b6 6B4bA4^ ԍA 5PB5YX@Y@5bVg5B5bdy1B5b!B5bA5b@A5bA~ 5 bN95 b>A5 bT)A5 b&&'A5 b$@,A5b@/^CA~ 5bZ.5b4WA~ 5b\75bp9EOA5b(A5b@BA5b!B5b 1B5b; A5bHB5bBto3"B5b%O B5b,.B5b\^MB5b5A5^A 6Pw6Y@Y@6bplB6b_^B6b:f^B6b +B6bF'B6bH;B6 b"#B6 bY/B6 b HB6 bZ`+B6 bƏao!B6b<B6b@B6b|vB6b &A6bt3B6bv+B6b𝦑B6b:f^B6b>B6b2B6b~WB6b![]B6b(q AB6bꩢ94B6bPwUB6b#5 B6^<@ B 7P7Yu@Yp@7b8]B7bB B7bxXB~ 7bQP7b A7b^%bdDz 7 biA~ 7 b?$7 bJA$7 b6GbNi:b b~7bJ`7b9A7bA~ 7b~07bxXB7b-A7b:+A7b89HB7bJoB7b`4A7bnA7b,ZB7bM^2BI- 8Oo8Y@YV@8b;bB8b $_dB8bnkWB8b 7uB8bn*B8bV_!A8 bķ'B8 bk,B8 bA8 bfS)B8 bB8b B8b(\B8b@3!A8bpRA8bT5GB8b`DB8bDB8bnkWB8bFAB8b)c;B8bПMB8b@ ,UB8bBB8b6B8b(VHB8bPIB8^0ںs B 9PC9Yo@Yz@9boB9buB9bB~ 9br&9b OA9b@%A9 b9`A9 b0A9 b:A9 b`_A9 b2A9bpA~ 9b*9b A~ 9b0#9b@[`A9bY'A~ 9b: '(9bB9bA9b0sA9bB9bx[UK B9bA9b>A9b"B9b,^N\ :PD:Yw@Y@:b~B:bnB:bt]B~ :cƝ(:b U7A:b{)(A: b`KA: bA: bdA: bA: b颷A:bA:bd bR :b?:b A:bA~ :brS':bt]B:bA:b@NPA:bP0VB:bT B:blB:bƆB:b)B~ :c :^jA ;Pp;Y0@Y@;b ]B;b?`B;bvQSB;b B;bL:1%B;b !mA; b:^#B; b %B; bx3A; b1$B; b >B;b8>B;b0B;b`A;bøA;buiIEB;bPvCB;b1B;bvQSB;bl݁>B;b=6B;b1hAHB;b@)URB;b'7@B;b89_3B;bsDB;bcB;^+KB <Pq<Ys@Y@<b*Ѭ4B<b-C4B<b&B<b A<b`3A~ <b@G4< b`A< b A~ < bӻ1< bOA< bjmA<bA<brEbW@9b& *<bB<bPB<btXA<b&B<b@.A<bA<b2B<býG B<b1A<b@) A<b7B<b@A<^c4~A =NI=\X@\@=aW1B=a$S3B=aBJCk'B=aXA=aPxA=aZmA= a`ʝA= a`A4B= aGA= apA= auA=aAA~ =aY=aA~ =aX=aB=aA'B=a@.jA=aBJCk'B=ak{xB=aA=az0"B=aX%B=a}@B=ajϷA=aB=aBA=],lA >OJ>Ys@Y |@>!/>{>bR:>b@_A~ >b;(> b@ǠgA> b@dA~ > b~͆*> b͘A> bA>ղA>Q:#>>ǓA>Uഡ>A>bP RA>bC?9A>bfA>b`~A>b6^2A>bA>b`A~ >F>Ĥi0@bMB@bO5A@b@iA@bP_g B@bh\B@b6SA@b`A@b023B@ca^# ANLA\@\@Aa98vBAaV;zBAa3CoBAa AAaBx7BAak&BA a{2BA a[;BA aHֳBA aW6BA a\a'BAa! $BAa@˱AAa8BAaƎAAaXKBAaK.IBAa<BAa3CoBAaSBAa%uGBAa\ΟeBAamBAa FUBAa~֪nGBAa`(YcBAa&4AA]bB BOxBY0s@Y@BbpHbBBb_BBbrB~ BczBBbpABbbVAB b@]AB b@hAB bƆAB b#AB bb-ABb:,ABbN}0bVbOBb ABb!ABbABbrBBb@q _ABbƂABb̼0BBblPRBBbPNABbБABb|8AlB~ Bb>B^:A COMCY|@Y@Cbbg"BCb"Q%BCbBO$B~ Cb$&CbOzA~ CbEC b_JAC b}-7A~ C b@C b2iAC bACb0]ACbf%b~(2bZSxACbP-BCb|BCbACbBO$BCb4BCb صACbx@BCb$$BCbMslBCb0ACb B~ CbC^9A DOODYN@Yv@Db+KQBDbt+VBDbSBDbHGADb:$]!BDb0C=AD bӹBD bs"BD b5VAD bp$ BD b`OOBDb*BDb%ADbADb@ZADbQs6BDb5BDbP8ADbSBDb6a>0+Qp;+E)=AIbAIbAI bWAI b)A~ I b5~I b@lAI b7 AIb6aAIbZ b|br \Ib`2AIb2&A~ IbvHIbXk:BIbO7BIb( BIbx{BIbXBBIbH$&BIboAIbX7BIb'^ R"L JPUJY@v@Y@JbBJbmcBJbInB~ Jcn GJbИSyAJbAJ bݑAJ b@AJ bcfAJ b-8AJ b i[AJb h:A~ Jb"4Jb A~ Jb&Jb'MAJb@ߞuA~ Jb45JbInBJb`3AJb@sAJbdABJbh8BJb`)AJb`pAJbC B~ Jb'$J^]6A KOVKY:@Y@Kb0ApBKbkazsBKb2ycBKbϜAKbJ[+BKbBK b*|((%BK b]/BK by2BK bzM)BK b_d!BKbȭBKb@AKbh5NBKb@PBKb.XBKbDiAK^ B LPWLY@Y@LbyABLb_%FBLbRFBLbbALb\qx BLbFƧAL b0BL bҢBL bAL b} BL bgEALb0c#A~ Lbnx.Lb@A~ LbВJLb8iBLbDBLbJALbRFBLbhPT-BLbt{BLb 3O=>#6%>?*ϴiBMb|/BMbx.lAMbH BMbHbAM bBM b>BM beAM b`8>bBM b AAMb@G%AMb AMbNLAMb(AMbp*sBMbT BMb AMb|/BMb+BMb@f"BMbop%BMb+_/BMb謅BMb5BMb8B BMbAM^@hA NPYNY@Y@Nb@bBNb`peBNb5GOBNb@pYANbtG|BNb%[AN b4BN b$IBN b`RAN b0BN b`Ȣ BNbɉBNbd+ANb@IANbANbZ"!BNbx!BNb NwBNb5GOBNbi/BNbg̒)BNbBGBNbNBNb:BNbJ/s/BNb-ABNbpAN^x0B OPzOY@Y@ObOS@BOb})CBObZ6B~ ObA8Ob͆BObi8AAO bP*AO b%{BO b7AO biAO bu˺AObm1A~ ObrbObLA~ ObXOb\BOb$BObIAObZ6BOb‘BObA]BObK2BObXX5BOb@mBOb BObz0B~ Ob2O^pA PPrPY@Y@Pb`7BPb|:BPbWix#B~ Pb:C,Pb;TA~ Pb'uP b@ AP bSDA~ P bZj)nP b{AP bAPbHA~ PbPbA~ Pb6'Pb0Qgx BPb؍B~ PbamPbWix#BPbsEBPbtAPbD@BPb c#BPbgBPbQ+APbș'B~ PcBiP^`c A QNZQ\l@\@QakXBQaؿ[BQaCBQa@K AQa BQa@$AQ alBQ a}pBQ a%AQ a"BQ a(7 BQaإBQa4AQa0AQa@ZUAQap۽,BQa0&+BQa_EqAQaCBQaBQa< BQa. ABQao?CBQa~;%BQalBQa[8GْhA(Sիݴ<UgBUa\)BUa p$AUa@pc AUah-H BUaھ$]ۥi VR_Vd@dL@Ve&W>"BVed!!"BVeBq'B~ VeVe0(RAVe OAV eE9AV eA1AV eAV e2AV e AVeꭹA~ Ve&&VetrA~ Ve"BVePDBVe5"4BVe+AVeBq'BVe|!BVe`eAVeb~BVe`&BVeBVePoAVeuB~ VeVVf|A Wq~BWppppppppppppppppppppppppppppUU XqyBXppppppppppppppppppppppppppppUU YqBYppppppppppppppppppppppppppppXUZU ZUU[U [UU\U \XU]X ]UU^U ^UU_F_VD1l \ TTT`abc`FaFbTcT x< >@ A I b,   YY WW  XX 7 Sheet1ggD dirGSheet1 Module1fModule2,  !"#$%&'()*+-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijkmnopqrstuvwxyz{}~C0* pHd VBAProject4@j = r v5LJ J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\syst em32\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\OFFICE14\MSO.0DLL#M 1q Ob Li`braryKi Modul`e1GdDu1 2E HB1pB,B!B+BqThisWorkbookG @T@sisW rkbjo 2 $%q$"B#$SheetBAS@#eutAG2B#IZG^2O^J2J^2O^2O}S-M^6I^B<iZ#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2dkixMEP "0@v5LJ"$0 HX`h x $a4:C195 &%(!*}` $!,0 $!.B@0k oͰAttribute VB_Name = "Module1" Sub DeleteSummary_Rows()  For Each c In ActiveSheet.Range("a4:C195").CellsjrIfbStr(c.Value, "0") <> 0 Then)-c.Entire{.End IfNext  |w i6xMEh 8BB`:Xv5LJB"   ,0 ` h p ,  `      rPX  h"$&& H P"X "    0   8 P h `0 @H `h  p   format_table_final Macro% Macro recorded 6/18/2008 by jrmill00 Macro1 Macrox% Macro recorded 5/15/2008 by jrmill00z/EZactivecell.offset(x,y) allows for referring to cells relative to the current selected cell e.g., activecell.offset(2,3) would reference the cell 2 rows down and three columns over; (0,1) would be same row one column over$]@D5$(B@Hb5I <!, <%>!, <%>!, <%>!,b$EL': <!,b <%>03 <!, <!,er.de/"* [2]" ;[Black]"* [2]" @(B  <!, ef#,##0, ;[Black]"*" -#,##0, @(Bvd"*" #,##0, ;[Black]-#,##0, @(BÌkd <!, <!,r"[2]" ;[Black]"[2]" @(BdX#,##0, ;[Black]-#,##0, @(Bk(k : ': <%>B@H : <%>B@HHv 1x  &%*B@H .H <!, <%>!, <%>!, <%>!, <%>!, <%>!, <%>!, <%>!,b00  - <!,ESV <%>!,ESV <%>!,ESV <%>!,ESV <%>!,ESV <%>!,ESVU  <!DB@0Ud <%>B@Hk U0oxp}Attribute VB_Name = "Module2" Sub format_table_final() 'h Mac ro6 recorded 6/18/2008 by jrmill00N O31C5/15C'activecell.offset(x,y) allowsferring (to (slathe current seplectZe @e.g., 22,3) would0ence C%E 2 r?down and re3olumns over; @ (0,1)!be s on Dim x As Integer Range("D5").ShDo While ABNCANValue <> ""( OrIOT0, 2). _U v4K 6 5x@, G If1@\9TheFn bs(F) < 500 AsrM0 `ion.Numbe rFՁ""* [2]];[BlackD0ElseK5c -4992 #,##@;`-4O&az` X ,If A!?5`+\?5354$8w$#E#l+%ix + 1hX$|1, 0˅aLoop'-xCG @_ b _1 To 5  @Sheet.A7s(b, 3O!,' 2.) 3$ 4 5m'FESV/bbw 'yup}ko?o]0En tireC}.DvteKpX>1_.]?6SNext b4QP i#xME ThisWorkbook l_VBA_PROJECT|' PROJECT PROJECTwmn(SLSS<N0{00020819-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2a  *\G{000204EF-0000-0000-C000-000000000046}#4.1#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.7#0#C:\Program Files\Microsoft Office\Office14\EXCEL.EXE#Microsoft Excel 14.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\system32\stdole2.tlb#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.5#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE14\MSO.DLL#Microsoft Office 12.0 Object Library v5LJiModule101554722c7Module1ThisWorkbook02554722c73ThisWorkbook% Sheet103554722c75 Sheet1Z0%Module204554722c76Module26H} hH0gmsFLg)~}u)QBu|ޱD8{[ㆃv*?AM#!) bExcel+VBAWin16~Win32Win64xMacVBA6#VBA7# VBAProjectstdole`OfficeuModule1b _EvaluateDeleteSummary_RowsRcZ ActiveSheet%NRange CellsValueK EntireRowDeletex ThisWorkbook|Sheet1Module2cformat_table_finalxo ActiveCellOffset SelectionZ NumberFormatR EntireColumnWorkbookkl  3 5 7 HID="{FAEAB1DF-D797-4345-913E-E42F1DBFD87C}" Module=Module1 Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=Module2 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="BFBD884BF8B5B3B9B3B9B3B9B3B9" DPB="7E7C490CB7747775777577" GC="3D3F0AC9768977897776" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Module1=22, 29, 1480, 763, C ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Module2=0, 0, 1458, 734, C Module1Module1ThisWorkbookThisWorkbookSheet1Sheet1Module2Module2Oh+'0HPd  cjohat00Department of TreasuryMicrosoft Excel@ 8@b޳@{ỲSummaryInformation( DocumentSummaryInformation8 CompObjk՜.+,0 PX|  Internal Revenue Service Sheet 1  Worksheets FMicrosoft Excel 2003 WorksheetBiff8Excel.Sheet.89q