ࡱ> b  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry Fc*&6@8Workbook _VBA_PROJECT_CUR"'p 'VBA'' g2Ʉ\pDepartment of 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@    $   1"  $ 1"<@ @ 1"4@ @      ,  , "8@@  8@  8  0  (8 <@ @ <@ <@ 8@@ 8 @ 8@ 8@ @ 8@ 8@ 8 "8@ 8@@ 8@ 8@ 0@ 0@ 1<@ 1<@ *8@ *8@ 1<@ 1<@ 8@ @ 8@ "8@@ "8@ "8 @ 8@@ 8@ 8 @ 8 @ 0 0 <@ @ )8@ )8 )8 )8@ )8@  )8@  $@  $  ,  ,@@  ,@  ,@  ,@  ,  ||vD.}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,\ ;\ \ 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`HSheet 1aControlled 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 Other South American countries#Other Western Hemisphere, total !Bahamas Bermuda #Europe, total European Union, total Austria Belgium Denmark Germany Ireland Luxembourg Netherlands Sweden Norway Czech RepublicHungaryPoland$Africa, total Southern Africa, total $Asia, total India Malaysia Philippines Singapore ;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 countriesBritish 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 corporationsHUnited 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 countriesPeru%Eastern Africa, total IsraelTurkeyEastern Asia, totalChina, Peoples Republic of Hong KongKorea, Republic of SouthSoutheastern Asia, total"Other Southeastern Asian 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 2014 ]France (including Corsica, French Guianna, Guadeloupe, Martinique, Mayotte and Reunion) *Central, Southern, and Western Asia, total4Other Central, Southern, and Western Asian countries:Source: IRS, Statistics of Income Division, September 2017b* Data should be used with caution because of the small number of returns on which they are based.t5 6$:77(7^89:;<=> ? Ad C VDDmFccJBOUj_ KU g2Ʉ Z5lu   dMbP?_*+%&?'?(?)?M MaryT!C odXXLetterDINU" P=N:SMTJHP LaserJet 4250 PCL6InputBinPrinterSelectRESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexNONEPaperSizeLETTERMediaTypeAutoCollateONOutputBinAutoHPImageShiftOffHPAutoDuplexScalingTrueColorMode24bppTextAsBlackFalseTTAsBitmapsSettingTTModeOutlineRETChoiceTrueHPBackSidePrintingFalseJPEGEnableBestSmoothingTruePrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL6HPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpap6.xmlHPStaplingOpposedFalseHPPCL6PassThroughTrueHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPManualDuplexDialogItemsInstructionID_01_FACEDOWN-NOROTATEHPManualFeedOrientationFACEDOWNHPOutputBinOrientationFACEDOWNStaplingNoneHPManualDuplexDialogModelModelessHPManualDuplexPageOrderEvenPagesFirstHPMapManualFeedToTray1TrueHPPrintOnBothSidesManuallyFalseHPStraightPaperPathFalseHPSendPJLUsageCmdCURIHPCoversOther_PagesFront_Cover_from_Feeder_InputBinNoneBack_Cover_from_Feeder_InputBinNoneJRConstraintsJRCHDPartialJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffHPConsumerCustomPaperTruePSAlignmentFileHPZLSwn7HPSmartHub_OnlinediagnostictoolsTRUEHPSmartHub_SupportandtroubleshootingTRUEHPSmartHub_ProductmanualsTRUEHPSmartHub_CheckfordriverupdatesTRUEHPSmartHub_ColorprintingaccessusageTRUEHPSmartHub_OrdersuppliesTRUEHPSmartHub_ShowmehowTRUEPSServices_PrintcolorusagejoblogTRUEHPSmartHubInet_SID_263_BID_514_HID_265PIUPHdLetter o [none] [none]4Pd?VCGHB44dMicrosoft ExcelEXCEL.EXEC:\<Program Files\Microsoft Office\Office14\EXCEL.EXE"dXX??&U} UN@} * F} U F} F} @} F} }  F}  F} F} U F} * F} F} @}  @}  @}  @}  @} @}  @} * @}  @} U @}  @}  @}  @} *} } U @ZH AABEGG     GG Z>[[[[[[[[[[[[[[[[[[[[[[[[[[[[ fhB[[[[[[[[[[[[[[[[[[[[[[[[[[[[ {^ ~_ X>YYYYYYYYYYYYYYYYYYYYYYYYYYXY |^ ]` `a ] ct cN c  cQ  x  yz  ` ba c c us vw ` bba ` bbb cu hv |^^ ] c ^kddd  cO  c  cP  s c cg dd cm cn co c cR oS m c cR oS q diD}___e_leeeeeetgeeeegdeepneeprejI C C C D C D R R  R  R  R  R  R R R R R! R" Ri Dj R# Rk R$ R% Rp Rq Rr Ry Sw Px Kc<@@J'gBJ/BJ$yBJe8UBJH݌kBJQݼ$9q=!0յa937<[BJZ֬AJLs B ( N@@ T8D`B T #p"`B T9СOB T€sA T_CB TpA TdB TTIB TA TDB TH>\B TA T@)A TA~ T T8B T530B T "!B T9СOB TJe/B TeB TT HB TJMB T$Vԟ.B TvgT B TFB TAA T06BA T @@@ T!B TMn!B TFrB~ T&2 T)A~ Tr TbA T\iA~ T g T*A TdA TNrA Tf1TBLTX Te{A TA T/QA TFrB TcB TbGA TƒB T|l<B TB TA T3B T%A T@Y;EA ) m@u@ T3!B T(~gB T A~ Tro0 T)KA~ TNv T:NA T@֕A~ T, TCA T) A TqdA TD T:(P-TM T3:A TBA TGA T A T@$A T;9A T kFA TrA T@YA TpA TC͝A T^%^Tj` U  |@t@ T |B T\fB TʗB~ Tj T@#A~ T8Z TA T?]R TʗB T4A T(A T@B T_B TňA T ۝A T8!B~ T%# TpzA * v@̸@ Tg\bB T@bbB TyRB TsA T B TpA T/j B TB B T A TPB T@6B Td B Tm`A T*A T%/A Tj},B T)B TLNA TyRB T3(B T B T{5,PB T@v RB T.B T{#B TqMB T!QA TB +@@T?BT7BTLrz B~ T.5 TN*AT@[nA TʉA TUA T.A TxA$ TrsTvYmTTT>T00ATZA~ TFJ5TLrz BT:eAT?ATPCBTrBTAT EXATzBTsATT ,@̢@T?fOBT)OBT NEBTATBT )A T`yA T(\ B TN=A TB T` AT ;RATATVzAT`AT@BTHBTAT NEBTMBT4BT_BBT@EBT, BT@HBTshuABTATA - @@THG MBTLBT8S#B~ TzVTATn'A TA T SA TRiA T\&A T .ATpzA~ Tj2-OTA֭AT@ATDYBT BThF7AT8S#BTP-DBT@AT\WBT b#BT:=BT6VATH{BTz AT`!f,A .Ѐ@@TCBTύBT/9BTz[ATVATA T)A T@bA TA TdA T97AT$NATRT^TT{PyATRTA~ T"$T/9BTmAT`B*ATfBT̿{BT*6ATATxBT ATiqA {t@{@T<"BTBT)B~ U.LT(AThA T`%A TA THA TzA TҵATeJAT~j[TTT0AT6A~ TG T)BT~ATAT(BTO(BT@fIAAT`zbAT0A~ U>7NThA /z@@T$RBTSBTjBTVͮTjTA~  Tj2 T`( >BTX/BT 4 "B Vpp@pw@TE$BTFͼ)BTYBT@AT,3A~ Tƛz Tt.IA T9A~  Tuv T6ԶA TMATxATTATHwA~ Tz$T B T|BT ρ BTATncATУ%ATM0BT[9(BTABTNBTJ4(BTWtBT7IBTxwNBTj)BTBT.HBT_hAT#B X0q@{@T-v[+BTb)+BTB~ T.tIT" A~ TdqY TG)A T@cA~  T(R TpA$ T^!dTVTN| T2HuMTHy7TxoBT\AT 1?ATBTxbATATԚATPmBT ATAT``[AT@A~ Tʫ9 3@@W -BJCBJ`vgBJ!oKBJh`BJp$'B JϿA"]B J|d6aB J%&B J`B JަkRBJWIBJ5BJFW_%BJ|"#BJXzBJ wBJjwCBJ`vgBJEPnBJ0gBJ4…BJh2gaATATY7T!bT0BTfBT^AT&`,BTR2BT%hBT`檗 BT$T+BTxzJBT{'BTluBTAT0A >u@p@T@g7BT^2BTXB~ U2T@\ A~ Tz9 TA TWA~  T7 T奴A T rATATzT*\TTEATA~ TU'TXBT`@AT/ATHoBT  BT`bAT@"RAT=B~ U'T&)AD:lPTlBJH  !@"#$%@&@'@()*+,-./012G3456G789:;<=>? 7 @@ T!()B Tj)B TXGqB~ TZt1 TgA~ T'@ TfA TBA~ TRh? T{kA$ T"4pTLTz$U— Tro TA T@jFA TvA TXGqB TPCwA T@QA ThB TXE[.B T08xA T}A T9B T6 'T:”S !!L@ҥ@!T(HeKB!T}JB!T@B!TA!T8aA!TrA! T`cA! TnB! T@A! TxA! T&/A!T LA~ !T9{k!TWA!TA!T .oB!T.B!T&7A!T@B!TD!B!T&2B!T>7!/?!V$!Z!<5B!Ty A!T`A "8"$@x@"T${ZB"TXB"T)dNB"TƜA"TB'TxqPB' T8 ;B' TjiN@B' TUB' T*>B' TSm4B'TVN)B'T8B'T([ B'TCB'T%[B'T@s$WB'T)B'T.#bB'TVPHB'TBB'T"YB'T ;a`B'T}y4GB'TM^>B'T([VB'T [2B'T>'B (@(@@(N )B(Nxk]'B(NEriB~ (N"(TοA~ (T|d( T A( T`AA~ ( T:a( TkA( T@+A(TA(TZT}ST ((T@؏A(T0IA(TcA(NEriB(TFB(T`,mA(T,kB(T;B(TMB(TnbA(TB~ (Tv(TpOA )d)o@w@)TB)Tx+A)TxAxB~ )T.)ThaA)Td #Tff_ ) TvA0) T Tj/sTA&UTI9UTnTR )TbA)TftA~ )Tp{+)TxAxB)T@AA)THPA)T0A)TB&B)T!A)T}A)TڑRA)TnsnTO *e*@@*TJI63A+T;A+Tf}$B+T"XvB+TB+TLBB+T5?$B+T6Xy B+TB!B+TVsB~ +TX+TA ,a,z@@,T=B,T_Z5B,T@nx;aB,Tnun$B,T`0B,TWA, TF7".B, Tq5B, TpprA, T)3B, T,*B,TRz&B,TʿA,TXikB,T0A,Tp;B,Tξ5B,TB,T@nx;aB,T5$AB,TlX)9B,TaZB,Trh`B,T(CB,T8B,Th1WB,T.^ B,TH"B -l-@@-TZSG5B-T54B-T)B-T@A-T%T=y- T8- T A~ - T a- T A- T$)A-TA-TreYT~H Ti) -TA-T>A-Tk2A-T)B-Tpa B-T@1 B-TL0P"B-T(9*B-TM B-TG B-T"B-T1A-T@A .Z.@ު@.TUAhB.T@zjB.T@YB.T?hB.T(B.T1A. T&B. T g+B. Tm;A. Tj(B. T\oB.T B.T)B.TA.T@yuA.TaPB.T,VNB.TiB.T@YB.T.]QCB.Th=B.TV3OPB.T4jXB.TЖsEB.T3;B.Ts sLB.TWA.THBB /=/q@z@/T8C`B/Txf?B/Ti B~ /T!a/T@(oA/T A/ TҒA/ TvA/ T]A/ TA/ T@IA/T.A~ /T>r/U#A~ /TK/T@A/T A~ /T>` /Ti B/TA/T9?A/T B/T`wl B/TfA/TQlA/T)gsB/TҐ+RTSl 0[0@Е@0T+I dB0TĆdB0TTUB0TA0T46#B0T fA0 T@0:"B0 Tǟ%B0 T`*AA0 T"#B0 TDB0TH. B0T0{B0T`I=A0T 3A0T NB0T KB0TCB0TTUB0T6@B0T>;80д0Uյ0ĐDK070ĸj00B1T\|=B1TXƄ#B1T0A1T\A 2A2Ȉ@@2JX7B2J<7B2Ji.B2J@A)|A2J@A2J%A2 J@.4A2 Jx'B2 JLA2 Jp6A2 J@ A2JqA2JFAA2J?A~ 2JG2J0j!B2J8{% B2JwA2Ji.B2J@-B2JPEA2J@`t()B2J樳-B2J40B2J0qB2J>%B2JNA2JA 3|30s@P@3T;B3T!B3TzuA3T8"A3T8A~ 3TjK3 T@KA3 T?A~ 3 TI3 TL:A3 T7A3TeA1A3T>A3TA~ 3T*E-3TP,A3TAA3T.A3TzuA3T YA3TA3T@A3T:A3T`n 5A3T2A3TPhA~ 3Tqp3TgCA 4B4|@@@4TP%!B4T@ B4T+Ҵ B~ 4T:D4TVhA~ 4Tm4 T6iA4 T0A~ 4 T&wi4 T%A4 T'A4TIA4T T):TU 4T%A4T OA~ 4T.T64T+Ҵ B4TMA4T@dA4T,eB4T{i B4T +B4ToA4T@*B~ 4T*Q4TiJ A 5z5@r@@@5T@ B5T*!B5T$B~ 5T 5Tc3A5TA5 T=A5 TPlA5 TpA5 T3 A5 TऻA5TA~ 5TFZ 5T1jA~ 5T&w05T0A5T īA~ 5TB5T$B5T [A5T|A5TE B5T| (B5TA5T[LA5T؛ B5U^ T6; 6C6@"@6J/}B6JX}B6J`|YB6 J?S8T@c A 9}9@@9T4'*B9TI)B9T8B~ 9Tj 9T@-?A~ 9Tf7r9 TrA9 TKA~ 9 T"_p9 TRA9 T ^|A9T:A9Tv*(TOTU'9T@A9T6A9T@{A9T8B9TB9T$& A9TB9Tx01B9T A9TRA9TH31 B~ 9T9TaA :~:u@@:TYB:T8 B:Tr B~ :T -:T%A~ :TeZ: T[A: T@YA~ : T,W: TA: TA:TA:T+ UETm:TA:TA~ :Tn\N:Tr B:T3sB:TiB:TLϚ.B:Tv[ B:TA:T0pr,A:TAB~ :T4*:TPA ;;X@4@;TB;T,B;T>!B~ ;T;T +BA~ ;T>0c; T@R#A; T~#VA~ ; T%`; TVzOA; T ;A;TJ4A;TrnMTOW@T*5tK;T6A;T 1 A;TmA;T>!B;Tca B;T:A;T' B;T6q B;TB;TVdA;Tt]B~ ;Uݽ;TA <<@3@<T0qtB<TMasB<T)eB<TPA<T@.B<TxaB< T@^(B< Tf1B< T B< T-B< T Ļ%B<Tpܸ.B<TW} B<T@A<TgB<T>B<TY[S;B<TxR B<T)eB<TanwFB<T;B<T<65`B<T 1geB<TiNB<T}AB<T [B<TPH>A<T*B ==.@a@=T qbPB=T@8PQB=T@,PB=T9A=T4B=T?A= TO B= Tlc{B= TA= TĻPB= T(DB=T_B=THFA=TxA=TIMA=T[$B=T0l#I#B=T]A=T@,PB=T*:4B=T&{)B=T.HB=TkPB=TE/17B=Tm(B=TEB=TtA=TŃB >> @@>T-BB>T謰EB>TY/ 5B>Te3A>TW!B>TJA> TОB> T8e]B> T@BA> T=yAB> Tp B>T.A>T`"VB>TA>TРG3B>T&^B>TDe.hB>TCA>TY/ 5B>T.B>TX-s B>T-,B>TU5*4B>TN$B>TjB>T&ӎ%B>T|oA>TXsA ?H?@h@?TvcB?T C!bB?THB?TA?TxfgB?T`eA? T@x>B? TmdB? T`A? T@BR B? Th}B?T`A?TA?TnA?T6A?TtB?TH B?TڃA?THB?TGqB?T4B?TuADB?T!XHB?TBa-B?Tlc"B?TY4AB?T5;A?TADvCl @ABCDEFGGHIJGKGLMNOPQRSTUVWXY @@`@@@@T%+FB@TI&EB@TY:B~ @T3]1@T=A@T+#A@ TkA@ TpvA@ TУA@ TPOA@ TGA@TyhA~ @TR^@TǃA~ @T:6@T8.SeB@TB@T@4A@TY:B@T42B@T'B@T=εN3B@T1*:B@Tw$B@Tka~B@T@>/B~ @T6z"@T0*A A]A@@@AT#0BAT|z.BATd3~ B~ ATfAT A~ ATqA TdAA T%A~ A TrGoA T[AA T@AAT'%A~ AToAT8A~ ATsMAT_AATвK3A~ AT DkATd3~ BATXQ!BATp^AAT4BAT=7 BATXBAT0AATB~ ATƝ2!AT@qA BB$@@BT(VYBBTw_\BBT PWBBT`4ABTB$BBT>AB TzR"BB Tԗe%BB T+AB Tق$BB Td<BBTT⾮BBT3ABT@'ABTABTq;ABBT2N@BBTldABT PWBBT@BBTosi3BBTYNBBTFUoVBBT2*DBBTT7BBTHBBT(ZBBTMrB CEC@@CTi%BCTRU%BCTW"B~ CT6wCT`^A~ CTD(iC TwAC T d}A~ C T.41fC T\KAC T`sACTACTrP!T|ZITCT@_BCTOvTB~ CT.`CTW"BCTt1BCT΍,BCTiGBCT6!C"BCT\vBCT0.dACT BCT(ACT ĀA DFDPx@X@DT(Wϻ BDTx2BDT3B~ DTCDT9jA~ DTGGD T 5AD TKS6A~ D TAD T@AD TlcADTt2ADT|xATvU8T"_DT*ADT~lA~ DTNWDT3BDT0wBDToADT@NBDTyBDTC*BDTADT "B~ DT)DT`voA EGE@z@ETeSBET@VBET5OBETAETZBET@tnAE T'BE T BE TgAE TLBE T BET(~BETAETLAET=pAETLjHDBHT@>AHTD BHTWAH T=BH THXBH T AH TP/BH T0BHTBHTRAHT`F]AHTLrAHT1^w-BHTzQ+BHTAHTA>D1ҿA73#'3cI TsAI T޷AITjTr++TFi&TrJg!ITP#BJJxQ#BJJY (AJJ{BJJP<BJJBWAJJ;BJJ4.ABJJPnBJJ;AJJP4̿BJBx4AJJ A KLMK@4@KV(BKV4٣)BKVZ*B~ KV>?KVAKVAK VWAK VclzAK VAK Vc3AK VT4sAKVVA~ KV_u;KV`A~ KV9KVhvMBKV08BKVMAKVZ*BKV<BKVAKV"BKV*BKV>BKVjqBKVpB~ KVKVӍTA L\BL[[[[[[[[[[[[[[[[[[[[[[[[[[[[NN M\fBM[[[[[[[[[[[[[[[[[[[[[[[[[[[[NN N\bBN[[[[[[[[[[[[[[[[[[[[[[[[[[[[QN O\BO[[[[[[[[[[[[[[[[[[[[[[[[[[[[NNPN PNNQN QQNRN RNNSQ SNNTNTOUFVFWFXMYM8^  TTTT >@ A j-LL   OO   NN MM7 Sheet1ggD Module1O__SRP_2 __SRP_3%gThisWorkbook '  !"#$&()*+,-./012345689:;<=>?@ABCDEFHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrtvwxyz{|}~TxixME (6 L< "`k0x% Phh8@$l ng&8@h @X @H @8 @( @ @ 0@@ X@  @@o hicO@ eheci@P@v5LJ$*\Rffff*055b814b38*\R1*#385*\R1*#125"$=00 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  rU~|  yY !Q=:X%h$ @h8A(lh580lA8:X((H]@68(l=( 5( l?4.lh8(krU $`n/i#xME (SLSS<N0{00020819-0000-0000-C000-000000000046}H(%H0(8v5LJxAttribute 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(%H0(8v5LJxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU~|  <%>!, <%>!, <%>!, <%>!, <%>!, <%>!, <%>!,b5Autor - <!,ESV <%>!,ESV <%>!,ESV <%>!,ESV <%>!,ESV <%>!,ESV de Ce <!DB@0ecd <%>B@Hk 07oxp}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 3 @h  @ 3 @0 3 @H 3 @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 Lh 8`kBB`:zio6%@P8(<@&@hh @X @T @D @(4 @@0 @ @ @X @p @ @ @ @ @0 @H @ @ @x @`h @xX 8@T 2 @D 2 @4 2 @$ 3 @8 (3 @P @3 @ X3 @ p3 @  3 @h  @ 3 @0 3 @H 3 @ 4 @ 4 @| 04 @l H4 @\ `4 1@L P 1 @H @`8 '@x( &@ 82n @ )@ @8 7 @P @  @  )@ 7 @ @h @ *n @ @p @` @@\ @XL @< @(, @ @ @p @ @ @ @ @H @` @ @0 @ @ @xp @` @P @@ @ 0 @, @ @ @8 @ =hXv5LJ$*\Rffff*065b814b38*\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 jrmill00at Macro1 Macrox% Macro recorded 5/15/2008 by jrmill00j0Zactivecell.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 overON]@D5$(B@Hy5ܦ <!, <%>!, <%>!, <%>!,bcacion': <!,b <%>e0"0 <!, <!,Vl"* [2]" ;[Black]"* [2]" @(B$ <!, e_+Oڟ#,##0, ;[Black]"*" -#,##0, @(Bud"*" #,##0, ;[Black]-#,##0, @(Bkd <!, <!,kp^"[2]" ;[Black]"[2]" @(BdX#,##0, ;[Black]-#,##0, @(Bdm#+k(k : ': <%>B@H : <%>B@H(,e avrk  &%*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~ dirI__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 v5LJiModule1055b814b38Module1~ThisWorkbook025b8148643ThisWorkbook5 Sheet1035b8148645 Sheet1Z05Module2065b814b386Module26H h0H؉q+0Gϧ.'q#3N-@r;_|D{~nOl7{L R''%) b Excel+ VBAWin16~Win32Win64xMacVBA6#VBA7# VBAProjectstdole`Officeu Module1b _Evaluate(DeleteSummary_RowsRcZ ActiveSheet%NRange CellsValueK EntireRowDeletex ThisWorkbook| Sheet1 Module2c(format_table_finalxo ActiveCellOffset SelectionZ NumberFormatR EntireColumnWorkbookk Worksheet_B_var_c_Defaultj_B_var_bl  3 5 7 H@E0* 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 HB1p~lB,B!B+BqThisWorkbookG@T@sisW rkbo 2 $5$"B#$`SheetBASe@#eutAG2gB#IZG^2O^2J^2O^2O O96I^B<K*rU~~~~~~~~j ۻtFضMe  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="0F0D3882388EFA92FA92FA92FA92" DPB="D5D7E2C86E8F6F8F6F8F" GC="9B99AC16731773178C" [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  Worksheets FMicrosoft Excel 2003 WorksheetCompObjkBiff8Excel.Sheet.89q