ࡱ> b  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry FtQzqC8Workbook_VBA_PROJECT_CUR"!!VBA!B! g2Ʉ\p Clay Moultonf Treasury Ba= ThisWorkbook=h9#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"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)"#,##0,\ ;[Black]"*"\ \-#,##0,+&"*"\ #,##0,\ ;[Black]\-#,##0,\ ;\ \-\-                                                                      ff + ) , *      P  P         `            a>    "  "<@ @ 1"<@ @ 1"     8 @   ,@ @ (8@ )8@  )8@  )8@   )8@  )8@  ,@    $   1"  $ 1"<@ @ 1"4@ @  ,@ 7      8@ @ 8@ 8@ 0@ 0@ *8@ *8@ <@ @ <@ <@ <@ @ "8@@ "8@ "8 @ "8@ 8@@ 8@ 8@@ 8@ 8 @ 8 @ 0 0 "8@@  8@ 8 @  (8  0 1<@ 1<@ 1<@ 1<@ 8@ @ 8@ 8@@ 8@ 8@  8 8  $@   $@   $@   ,@   $@  $@  ,@  ,  ,@  , ||HLj}A} 0,\ ;\ \ef[$ -}A} 0,\ ;\ \ef[$ -}A} 0,\ ;\ \ef[$ -}A} 0,\ ;\ \ef[$ -}A} 0,\ ;\ \ef[$ -}A} 0,\ ;\ \ef [$ -}A} 0,\ ;\ \L[$ -}A} 0,\ ;\ \L[$ -}A} 0,\ ;\ \L[$ -}A} 0,\ ;\ \L[$ -}A} 0,\ ;\ \L[$ -}A} 0,\ ;\ \L [$ -}A} 0,\ ;\ \23[$ -}A} 0,\ ;\ \23[$ -}A} 0,\ ;\ \23[$ -}A} 0,\ ;\ \23[$ -}A}  0,\ ;\ \23[$ -}A}! 0,\ ;\ \23 [$ -}A}" 0,\ ;\ \[$ -}A}# 0,\ ;\ \[$ -}A}$ 0,\ ;\ \[$ -}A}% 0,\ ;\ \[$ -}A}& 0,\ ;\ \[$ -}A}' 0,\ ;\ \ [$ -}A}( 0,\ ;\ \[$ -}}) }0,\ ;\ \[$ -##0.  }}* 0,\ ;\ \[$ -???##0.??? ??? ???}-}/ 0,\ ;\ \}A}1 a0,\ ;\ \[$ -}A}2 0,\ ;\ \[$ -}A}3 0,\ ;\ \?[$ -}A}4 0,\ ;\ \23[$ -}-}5 0,\ ;\ \}}7 ??v0,\ ;\ \̙[$ -##0.  }A}8 }0,\ ;\ \[$ -}A}9 e0,\ ;\ \[$ -}x}:0,\ ;\ \[$##  }}; ???0,\ ;\ \[$???## ???  ??? ???}-}= 0,\ ;\ \}U}> 0,\ ;\ \[$## }-}? 0,\ ;\ \}<}M0,\ ;\ \[$}<}N0,\ ;\ \[$}<}O0,\ ;\ \[$}<}P0,\ ;\ \[$}(}Z40,\ ;\ \}<}40,\ ;\ \4[$}<}0,\ ;\ \[$}<}0,\ ;\ \[$}<}40,\ ;\ \4[$ 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`,KSheet 1|Controlled 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, totalMexicoPanama (including Canal Zone) !South America, total Argentina Brazil Chile Colombia Venezuela Other South American countries#Other Western Hemisphere, total !Bahamas Bermuda #Europe, total European Union, total Austria Belgium Denmark Finland Germany Greece Ireland Luxembourg Netherlands Sweden Norway RussiaCzech RepublicHungaryPoland$Africa, total Southern Africa, total $Asia, total CyprusIndia Malaysia Philippines Singapore Thailand ;Japan (including Okinawa and Ryukyu Islands) $Oceania, total !Australia "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 .Other Central American and Caribbean countriesUruguayBritish 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) 7NOTE: Detail may not add to totals because of rounding.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](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 countries 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 2012 PeruRomania%Eastern Africa, total *Central, Western, and Southern Asia, totalIsraelTurkey*Other Central and Southern Asian countriesEastern Asia, totalChina, Peoples Republic of Hong KongKorea, Republic of SouthSoutheastern Asia, total"Other Southeastern Asian countries:Source: IRS, Statistics of Income Division, September 20157 8$f99(9^<:*;;<H= >u!?@ AF BI DD *FbGHjIccJBOUj_ KU g2Ʉ  akf  dMbP?_*+%&?'?(?)?M~Lexmark Universal v2 XLC odLetter,DINU"FSMTJLexmark Universal v2 XLInputBinFORMSOURCERESDLLUniresDLLPaperSizeLETTEROrientationPORTRAITMediaTypeAUTOResolutionLxk600dpiColorModeColorPrintInBWOFFJobColorSaverAUTOJobEnhanceFineLinesAUTOJobPixelBoostUSEPRINTERPageRotate180OFFCollateONMirrorOFFReverseOrderPrintingStandardPageScalingACTUALSIZEPagePosterEnabledOFFPagePoster1PagePosterCropMarksOFFJobNUpPresentationDirectionRightBottomJobDuplexSupportUSEPRINTERDuplexNONEOutputBinUSEPRINTERJobStapleAllDocumentsUSEPRINTERJobJobOffsetUSEPRINTERTrueTypeFormatOUTLINEKMXL-ArialHF-ArialHFUseSameSize,,,,,"dXX??&U} =@} * F} U F} F} @} F} }  F}  F} F} U F} * F} F} @}  @}  @}  @}  @} @}  @} * @}  @} U @}  @}  @}  @} *} } U @aH AABEGG     GG >xxxxxxxxxxxxxxxxxxxxxxxxxxxx pBxxxxxxxxxxxxxxxxxxxxxxxxxxxx qe df t>uuuuuuuuuuuuuuuuuuuuuuuuuutu re gg lv g ]| ]T ]  ]W  n  op  l mv ] ] h{ ij l mmv l mmm ]} ~ ree g ] e`___  ]U  ]  ]V  } ] ]o __ ]u ]v ]w ] ]X bY y ] ]X bY { _Dsfff^fa^^^^^^~k^^^^k_^^cz^^c|^I C C C D C D X X  X  X  X  X  X X X X X! X" Xq Dr X# Xs X$ X% Xx Xy Xz X Y V LkKk@`~@R.ƛoBREWBRoBR@X#ZBR`{FjBRؙ*u>B R`@LgB R nB R=B R@#jB R s[BR RXTBR6f=BR5BR%c-BRKBRݦpBR}qMBRoBR]%4 |BR@%rBRt7^BRbABRy:~BRH3rBRجꯏBRkMBJ(~Z:RB M'~@@RYtkBR`֝ nBR !_aBRP8ARP `n6A x A A~ f2  A~ 2 J\A  [A &[A B (QB CgA  ;B ~^B (B |NA tB ,|A~ [ްf O) o@v@ HB p{B Py+vA~ ΰ|s A~ f ϗA OA~ F0 A rpA JA ]3)dU ͙A ,BA  A Py+vA dA aRA ,A ewA  fA 9  `^A tUuA~ nD yB  $qA fA 0 B |zB A `||A X B r[jm7 N* H@n@ 3_B DŽ_B QQB =A  %=SB `,B XV<B |>!B kA h;B @A B ( B 0RA ]ZA oXA V/B f -B `A QQB L(B v9 B MB @PB b++B o1B 0*KB  A [P^A O+H@h@ -BƔBl"B~ WFAA A `A WA P+A$ jz'ډ%vl /~A"AwvA~ #l"BeB`?FLABX!B`AAKA=2!B [  O,4@D@D̉OBBHPBABB-PA`kB`;A 0-0B 7;B A 07 B h BPBqXAuA~ b5BV]BAABBKB$aB?B BBbIB]wBtz=B4QA[\A O-`@X@CBQXAB{$B{dA PAKA A 4A A PA !%A@A~ &C]A~ ri5B(<BA{$BpA BAB!B@y#BdA AT+bB@}KA[@6A O. {@0@$B$!{BMYB~ ~  /A]BA 'A ^^A~  Vy @A$ Nlc2+Xq 0OA A~ zMYB A@#AcVB,sBmEA@A B*[Vi/ O`t@@z@  BRԗBB~ .8&nAMeA @KS)A A 5A A$ ^3HxF/ *ifA@BA~ 'BaAA+qBľhB@!A8O/A@dA2{[n!( O\c@k@`AD޸A ANT|A.3JD:#ƌ j eN3AJtA? AA~ l`/ARzA{A9A|A\ O/ n@w@@y BdH{BB~ $a?A A <+A @=yA UA  LA AZ|wAN  A]A~ J)}B-(A~ v&w8%[Bp@ B@EARAEB&x<[6(l O0@g@s@ോAp' A*A~ lA&^z}  lA~  & eA$ Q'&+&&b6x } 5 A5A~ ~qc*A TA%6]AALQAUAu0ASAAA[) M1 @@R3L BR(JBRP_itBRQ9BR HBR B RljEB RAKB R8΋B RzO`GB R;BR:5BRZ3BRrBRPf8 BR6O{`BRZ1^BRƛ&&BRP_itBRCPWBR^im EBR{mBRZrBRBVBR-LEBR`m(jBR'(BJ3-&2B N2@Q@u@OAB?IDB+BBt>0Bd,A (hB 4B @}A `+@B ~AClAUCoAVA~ [;<9!BŪA B8A+B,Bv\B {x!B L#B.B3f>AB B~ \үM N30y@@`eBgB-h\QBG1Bu7BxB G 5B I8B B :o5B v$W-B|;#'B _ B !A/An~LB=kJB.*B-h\QBl ;j@B%5'BTXDBM wKB/^/ A$ ΅d6*K[( B%`LAgKA{A;B!#EAXA8 ?BוB+gAFAVB= [NDd9lPTlBJHv  !"#$%@&'()*+,-./0123456789G:;<=G>? O7 @@ 3cDB EvEB @#*B *A *A )/A ګA BA UaA @SA |A @{A A  &Z;? ؘ^qB 0㸏A @8LA @#*B B  UB pB {)B BB "RB #B  A [@Y/A !OH! `@ e@!IzB!3B! CAN!֪0M' J3?~r1i.| R[NFv4S%u !@n/A!A~ !VA%B! CA!2gJ! PA!@`A!A~ !D\!LaA!? \  "OB"v@@":JB"x,VB"8B~ "o"V`A~ ".Y4" Q?A" wA~ " T1" @7mA$" w\5rҳI}B"CA";A~ "-"8B"`JA"nA"B" B"A"@];A"_YB"ꃏ[B[g #O8#x@0@#+B#o*B#IGB~ #r;E#A~ #@66# A# A~ # 2# `A$# W*AXM^J 2*=#A#0A#.yA#IGB#IA#A#^AB#P B#@A#5A#hB#s5[( $O9$0p@w@$`P{B$ؚB$ZAN$V6)IBdms5Ɓrbj[g_ރv=28 :h$`vA$>sA~ $1$ZA$@oA$d1GA$pԢA$XtA$-A$AA$ -A$jB[h/ %Oh%Е@X@%@ÆPB%ejNB%C5@B%@A%`cB%BA% `i)A% '0 B% )A% S&B% A%A%A\A%f2A%>A%öB%pfB%IAA%C5@B%$7&$B%lS!B%}p6B%;?B%6$B%B%>5B%A%[2A &O:&@&@&[ߌYB&S4!S[B&P(9JB&@s A& B&bA& (XB& JB& A& 걬B& 4B&F?A&F*A&@A&cOA&)B&\K_B&z'A&P(9JB&'B&a$B&f8EB&3JB&@ŗ,B&ޜ%B& PCB&03A&[0-uA 'O;'f@@q@'kOA'@JOA'4[A`' m  WIyv4J/Eb<fk~xe?& '4[A'A'z$A'pA'`%A'n~A'rA'gIA'tA[g (OC( r@z@('^~3B(fT/B(1pB(jA(XA~ ('+( L_A( ?A~ ( jQ%( A( @AA(A(@_A~ (s(TA(^$A(@4A(p(A(1pB(8B(pAA(nSB($2^B(aB(;A(h B( A([<@A )O<)@@) !qB) rB)@ ^B)c 5B)`a=B) )A) /=B) gG$z?B) ɲA) P>B) s<B) A)F*A)13A)bzA)$`VB)hUB)> B)@ ^B)nT6B)z~^'B)pXB)=lTB)9B)F*B)5MB)VA)[`,A *O`* @@*n:B*?j9B*K+B*=A*"A*=cA* GA* `wA* mA* @*>A* E A*@ueA*?AA* SH.*XtA*@ rA*- LA*K+B*\8B*(K B* E#B*+B*$a:B*l&B*J^D!B*A*[mTA +O=+h@@+puxB+Hh{B+*@kVB+)$B+ؘV-B+ЧTpA+ *B+ f/B+ tA+ RR -B+ 6O&B+„B+ıB+0\bB+dA+=dCB+hn>B+HB+*@kVB+y-9B+.M5B+@W(|PB+ES IUB+}L@B+nd,6B+ZרJB+`eB+[) B ,O>,@Ԭ@,CoB,ؘ߁B,VK^B,4B,'/BB,x B, c@B, *CB, 8F B, ZՂAB, 4B,"j)B,kB,Į6B,B,[HKVB,=!TB,xFq&B,VK^B,@FB,~BB, UB,@Y)]B,WFB,GA~ - T- MA- BA-~WA-".l&& vk)-#A-\A-;5A-\PB-@_:B-y8A-QaB-FmB-wA-ֵA-DxB-B[֞j .Ol.o@x@.`B. AĻ,0db$ݎQ%#&ɻ.׈l< /`7A/@A/lA/EcA/l^A/ A/CdA/ϐA/L.[^"! 0Om0@|@0aXuA0 쐻A0xߞA~ 0v.c0A~ 0,90C B0|q B0=fA0F1B0NB0(ÊQB0'B00B0GhB0$!4B0%B05A0[MA 1O?1@x@11$;j&B4 J<B4<B4YB4sA4NA4KB4)madIB4B4xYB4WaCB4(>B4z9'PB4#.WB4|EB4̑;B4toIB4A4[xKEB 5O@5p@z@5_B5<B5,B5@A5@f"A53A5 @GA5 @fsA5 @jA5 vA5 @ӔA5>A~ 5"85,A~ 5f`95A5`9`A~ 5:45,B54A5!A5ŒB5G$ B5A5FA5B57{ [^? 6OA6x@P@6d+?#B6(B6"B~ 6ư6 0A6^OA6 ]5A6 !0A6 YA6 A6 @^A6\A6) TDR? 6iA65A~ 6y 6"B6ȎlSB6B6e&B6.!B6 jk B6`HB6Dj^B~ 66[qOA 7Ob7l@@7 ҒaB7`aB71gJUB70%B71U#B7NA7 !B7 `$B7 smA7 "B7 2W B7-A7@V@B7%A7p|A7UPwIB7}?GB7FB71gJUB7J@B7?C8B7YeJB7JS>SB7UXYCB7M6z7B70nSDB7A7[0&B 8Oc8u@@8v,B8$I0B8]PB~ 8, 8A~ 8j<8 @6A8 °A~ 8 ;8 JlA8 o]A8w8A8)+߲lꙴ-8UB8VHB8aA8]PB8PA8zGA8NAnB8Z B8kA8 ZA85B8>[ P 9ME9P@6@9RvJ8B9RaMf7B9RS[1B9RA9R$A9RA9 RA9 R(OB9 R'A9 RPDA9 RA9R`V/A9RdA9RA~ 9R)L9Rx B9RB9R@YA9RS[1B9R B9R4O!B9RpV,B9R:}0B9R4:೚A:A:A:8XB:@A:`sݬA:4DZA:lA:FA: ]A:PA:gA~ :[rw ;NF;~@p@;q7B;B;&$B~ ;"oQ;#A;~%A; dA; ooA; A; 6OA; ՝eA;fA;&~BLq;iA;0A~ ;fF7;&$B;@A; NA; %%"B;V#B;cB;A;koB~ ;VJ}Z;[A <N< p@@<]!B<!B<$9B~ <2<ؘoA<-*A< `A< svA< A< @LzA< `0A< .2rA~ < <O[A~ <ؒ<PYcA<&A~ <)<$9B<lA<VʉA<8 B<8q&B<ELnA< 9A<P$ B<[ =MG=c@"@=RYzB=R࣎|B=RnrB=R`sB=R, 7B=RsB= RXJ1B= Rp;B= R AB= R` ՞6B= RjA-B=R*B=R0WA=RHɚB=RP=A=RsXOB=RZLB=RB=RnrB=RF̘WB=RDKB=R @hjB=RDrB=RV"YB=RQBOB=Rp@AhB=R3J B=J(^$B >N>(@l@>s@B>>&DB>äAB~ >.w8>O. B>@(?A> B> N<B> ,mA> R B> B>ИB>%aA>,A>"A>$ B>IFB>˓ A>äAB>-B>d{B>TrR4B>"woAB>lyx$B>B>8B~ >\4>[eB ?OI?ț@@?TkY.B?-=1B?C0B~ ?\q?K;A?sA? A? pT{B? iA? uA? @A?jA?Z #}&mU?B?B?@SA?C0B?PB?>&B?B˴#B?6t-B?HB?PA?fh)B?f"[r~FuD@lrdd@ABCDEFGHIJKLMNOGPQRGSGTUVWXYZ[\]^_ @O@@p@@* B@m)B@ .*B~ @r.#@@YA~ @YpK@ 2]A@ ^A~ @ :VgK@ @$A@ ~A@A@{`zV{fR(9@@NA@*A@A@ .*B@0-*1B@`Q=MA@ B@4RB@HPB@\`B@Sb B~ @#@[ A AOAr@~@A¬BAzRBA@,B~ AZA7A~ AjQA gAA RUqA~ A COA Y}AA AZAAzVAA~"iAAA@A~ AZsA@,BABA@[BAiBA\ BA"AAaoAAB~ AA[ A BOB@@BBBBBnB~ B%B`A~ B&x1SB AB cBA~ B *>bPB QAB ˟ABQ=5AB{#+aB`,ABAB1ABnBB)BBM3ABDHBBBBH] BB]&ABEF B~ B!B[A CNCC@@CP6%rBCΏ YtBCfBC}IACvnɛ(BCHbb BC U !BC ~˛.BC @ BC @K'BC J BCphBC`ACC3ACYACp/[?BC`);BCvBCfBCwGGBC =BC7aBCCMɐfBC|%MBCBBCZ^BCkBC[RLB DOD@d@DC;IBD WLBD/LBDg}AD{ BDf{ZAD BD Se=BD 7nAD H<BD nAD`BE;@BEz61BEAE NBE?iAE AE `l BE nAE 2BE P%AEeAEXA~ EEAE+mAE KBE@BEAEz61BEBE@K BE[u&BEZ0BEбDBEl BEK$BELAE[ QtA FONF@@F}cBF 0eBFCBRBF}AF@ BFAF bBF =BF =KIAF " BF hnpBFqTAF0AF6OGAFTKAF8CBF NeBFzAFCBRBF`f *BFv$BFFMBF@\\QBF6BF6pX +BFQHBF,|AF[9&A GOGX@@G0xEBGEBGFv|uJ&zA~ JAJ3BJB~ JF+MJf BJ`#BJ"AJXmhBJvwh BJp !BJ AJB~ J(-J[I8xA KOKKPw@@Kph%ZBK}XBKhQB~ Kcu K@鴉A~ KڴfK AK `(+A~ K  =cK #AK AK@.A~ KKSxA~ K* KO2AK@A~ K>meMKhQBKFT BK AK8BKQ#BK D_AK.TAKB~ Kj5K[4 zA LOLLĕ@~@LDOBLQBL.X LBLʧAL^eBL[AL BL ׉0BL AL 5BL BL`~sAL["ALYALg"MAL=0BLx0BL ~AL.X LBL#I`U6BLT/,BLp#ABLu]JBLd@56BL)BLv?BLZwAL[*A MOMM}@@MTWoBMe*%BM"B~ M`M=;IAM>j@AM AM `X.AM M5AM AM JAMzrA~ MnM_A~ Mnt MAM38A~ Mn]M"BM n0BM@cAMDBM" "BMqBMpAM0UBMrl [+JA NONx@Ȅ@NkBNtUeBNpdB~ NrN#AN AN AN AN AN cAN AN/|AN #A$ANpefAN0$A~ NVlNpdBN BN@ANyBNTKBNHANANxjB~ NNvN[dA OMOO,@̫@OR\BORni i^BORݥIBOR,& BORBMBORc˯AO RӴBO RlBBO R0qU~AO R$BO Rx|zBOR@ݽBOR1AOR`AOR9 AOR/$0BORT8-BORPAORݥIBOR9BOR,&BORkEBORHGBORX'BOR"Y< !BOR9ABORP7AOJ f`A PNPP$@@Pd[BP ]BPI\GBPB) BP`BP4 AP ÀBP /BP 6AP VBP _BP ;APAPeAPμ?AP0.BP۟a,BPrAPI\GBPXEWBPZ,BPڀS"DBPoAEBP`2%BPLBP5i@BP0AP[A QNQQ~@X@QBQGMBQ µ B~ Qu:QVɰAQBlJk Q MrA~ Q r`HQ h(AQ -AQ3AQAe2CִGQ!AQUAQAQ µ BQ(AQ7AQBQݴ BQ$tCAQGAQP"B~ QʘBQ[1`A RMRRpw@@RR&BRR >0BRR -OB~ RS RR𭍼B~ RRrn<R RpDBR R<B~ R R;R RxBR RF݇ARR(A~ RRD4RRTA~ RR'RR[YxBRR<BRR(7ARR -OBRR8ؼ BRR')ARRlBRR JBRRxydBRR@ARRv6BR6-wA SQSSZ0@Z@SJ#BS,9 &BSpW)B~ S"2RSASAS 91AS h_BS RAS AS Tb?ASVA~ S3S@n A~ SZSH/BSXBSGASpW)BSeBSkASսp!BSc 'BSxp&\BSpVAS iB~ S^M SEA TwnBTxxxxxxxxxxxxxxxxxxxxxxxxxxxxTT UwjBUxxxxxxxxxxxxxxxxxxxxxxxxxxxxTT VwBVxxxxxxxxxxxxxxxxxxxxxxxxxxxxWTWT WTTXT XTTYT YWTZW ZTT[T [TT\F\U]F^F_SD,l TTT ``S>@ A MMMb,UU VV TT     7 Sheet1ggD Module1G__SRP_2 __SRP_3%gThisWorkbook '  !"#$&()*+,-./012345689:;<=>?@ABCDEFHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrtvwxyz{|}~LpixME (6 L< "`xkp%H``0@$l Ap&aR1)@h G@xX @H @8 S~1@( t@ ict@ e:(]GZo*@8 Pe@  px80`p@o p0`@ `H@v5LJ$*\Rffff*0557bd526e*\R1*#385*\R1*#125"$=00 HX `h x $a4:C195 &%(!* L $!,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  rU~|  yY !Q=:X%h$ @h8A(lh580lA8:X((H]@68(l=( 5( l?4lh8(krU $`n'i#xME (SLSS<N0{00020819-0000-0000-C000-000000000046}@(%H@0v5LJxAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2'iZ#Sheet1 7Module2__SRP_4G __SRP_5sgxME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0v5LJxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU~| >!, <%>!, <%>!, <%>!, <%>!, <%>!, <%>!,bU  - <!,ESV <%>!,ESV <%>!,ESV <%>!,ESV <%>!,ESV <%>!,ESV0 <!DB@0d <%>B@Hk f6қoxp}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 @` @x @( @@ @yY y9     (T'X%:h%$ TTT$ (TaD:h]<4(X%(%0$ (0a:]<(%(x%$ (XTTa4:D]<$(%(%$ (a:]<|)T0T6DX4+pz+T$ (TaD:h]@T5DS(h%( %T$ (TD00a4:]@)T06D4aT$ (TaD4(h]c0$ (0a(X]<')T06DU%:h%T $ TT+T$ (TaD(h ]gT5D%:h%T $ TT%:h %T $ TTaT$ (TaD4(h]c0$ (0a(X]<')T06D_%:h %T $ TT%:h %T $ TT kzpzE(h%( %T$ (TD00)T05DNGkzDh%( %T$ (TD00)T05D*( l(XhL 6l @(X%T$ @T4  T54T$ (TaD:h]<4(X%(%0$ (0a:]<(%(x%$ (XTTa4:D]<$(%(%$ (a:]<|(8%(%H$ (Ha:]<(%(%$ (`\\a<:L]<,(%(%$ (a:]<(p%(P%$ (0,,a :]<)T0TH\,6DX4`<0  T$ (TaD:h]/4(X%(%0$ (0a:]/(%(x%$ (XTTa4:D]/$(%(%$ (a:]/|(8%(%H$ (Ha:]/(%(%$ (`\\a<:L]/,)T0TH\6DX4`<6T$ (TaD00u)T05D E(h%( %T$ (TD00)T05Dv l~L@ 0\Ll-T0TH  i6xME(6 L` 8`kBB`:z6%@xH0(<@& u9hg9@`h u9@X u9@T u9@D u9@ 4 u9@80 @ @ @P ce@h @ an@ @ 0.@ .2@( rv@@ io@ @ CU@x @Xh 0.@pX .9@T ga@D Pe@4 @$ 35@0 @H 0.@ .1@ dr@ @` @x @( @@ @ @ @| @l @\ 1@L H 1@H @X8 @p( @ @ @ @0 @H @ @ @ @ @` @x @ @p @` @8\ @PL @< @ , @ @ @h @ @ @ @ @@ @X @ @( @ @ @pp @` @P @@ @ 0 @, @ @ @0 @ =`Xv5LJ$*\Rffff*0657bd526e*\R1*#385*\R1*#125*\R1*#253B"   ,0 ` h p ,  `     ( rP+X  Sh"a$%.&%&% H P"aX %"%     EG0   8 6P Uh `60 @EH `h  p   format_table_final Macro% Macro recorded 6/18/2008 by jrmill00 Macro1 Macrox% Macro recorded 5/15/2008 by jrmill00hIoZactivecell.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 overServ]@D5$(B@Hrities <!, <%>!, <%>!, <%>!,<Ĭ': <!,b <%>ʕb <!, <!,"* [2]" ;[Black]"* [2]" @(BẦ <!, ek#,##0, ;[Black]"*" -#,##0, @(Bd"*" #,##0, ;[Black]-#,##0, @(Bkd <!, <!,!Y鬶"[2]" ;[Black]"[2]" @(BdX#,##0, ;[Black]-#,##0, @(BZj}k(k : ':  <%>B@H : <%>B@Hc  0  *  &%*B@H .H <!, <%\,D4X4$|`<,0 UkrU $`na  *\G{000204EF-0000-0000-C000-000000000046}#4.1#9#C:\PROGRA~1\COMMON~1\MICROS~1\_VBA_PROJECTu~ dirG__SRP_0 )__SRP_1RVBA\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 v5LJiModule10557bd526eModule1vThisWorkbook0257bd4cb83ThisWorkbook- Sheet10357bd4cb85 Sheet1Z0-Module20657bd526e6Module26HhH0stdole 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 HB1[plB,BT!B+BqThisWorkb@ookG@TA@sisW rPkbo 2 $-q$"B#$SheetBAS@#eutAG2B#IZG^2O^J2J^2O^2ORO96I^B<K*rU~~~~~~~~j ^Kq3C   a p  )a A  ) VBAProjectModule1 ThisWorkbookSheet1Module2F /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLLVBA Y 0F4C:\Program Files\Microsoft Office\Office14\EXCEL.EXEExcel Qy@0FC:\Windows\system32\stdole2.tlbstdole aPL-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE14\MSO.DLLOffice a`DeleteSummary_Rows format_table_final a4:C195FF1Y Range Cells Value 0EntireRow Delete1 D5 FF ."* [2]" ;[Black]"* [2]"NumberFormat 4#,##0, ;[Black]"*" -#,##0, 4"*" #,##0, ;[Black]-#,##0, &"[2]" ;[Black]"[2]" ,#,##0, ;[Black]-#,##0, Select ESV&rU  tModule1Module1ThisWorkbookThisWorkbookSheet1Sheet1Module2Module2ID="{FAEAB1DF-D797-4345-913E-E42F1DBFD87C}" Module=Module1 Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 ModulPROJECTwmnPROJECTSummaryInformation(DocumentSummaryInformation8 e=Module2 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="CFCDF8FC080C0410041004100410" DPB="C7C5F00410040905090509" GC="BFBD880C78FC71FD71FD8E" [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 Oh+'0HPd  cjohat00Department of TreasuryMicrosoft Excel@ 8@b޳@!՜.+,0 PX|  Internal Revenue Service Sheet 1  WorksheetsCompObjk FMicrosoft Excel 2003 WorksheetBiff8Excel.Sheet.89q