ࡱ> d  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcefghijklmnopqrstuvwxyz{|}~Root Entry FH@{>Workbook_VBA_PROJECT_CUR".F@{H@{MsoDataStore.F@{H@{FXIKNEF515EM==2.F@{H@{Item PropertiesV3HY04QGIQQ==2.F@{H@{Item  PropertiesOVBAH@{H@{dirJ ZO\p Moulton Clay 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@    $   1"  $ 1"<@ @ 1"4@ @      , )8  ,@@  )8@ )8@ )8@  )8@ )8@  ,  ,  $  ,  (8  0 <@ @ <@ 8@ @ 8@ 8@@ 8@ 8 @ 8 @ 0 0 8@ <@ @ <@ "8@@  8@ 0@ 0@ *8@ *8@ 8@@ 8@ 1<@ 1<@ 1<@ 1<@ 8@ @ 8@ 8 @ 8@@ 8@ 8@ "8@ "8@@ "8@ "8 @  8 8 ||$A}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,\ ;\ \}<}`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 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, 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)IsraelTurkeyEastern Asia, totalChina, Peoples Republic of Hong KongKorea, Republic of SouthSoutheastern Asia, total"Other Southeastern Asian countries*Central, Southern, and Western Asia, total4Other Central, Southern, and Western Asian countriesb* Data should be used with caution because of the small number of returns on which they are based. 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 2016 :Source: IRS, Statistics of Income Division, September 2019Barbados Russia Northern Africa, total Thailand 4Eastern, Middle, and Western Africa, total \France (including Corsica, French Guiana, Guadeloupe, Martinique, Mayotte and Reunion) <5 T6$7X7(7^789:;M=> ? Ad B DDhGccJB{te,]e;" ZO \Klѧ   dMbP?_*+%&?'?(?)?M MaryT!C odXXLetterDINU" P=N:SMTJPIUPHdLetter o [none] [none]4Pd?VCGHB44dMicrosoft ExcelEXCEL.EXEC:\<Program Files\Microsoft Office\Root\Office16\EXCEL.EXE"dXX??&U} UN@} * F} U F} F} @} F} }  F}  F} F} U F} * F} F} @}  @}  @}  @}  @} @}  @} * @}  @} U @}  @}  @}  @} *} } U @\H AABEGG     GG >cccccccccccccccccccccccccccc hBcccccccccccccccccccccccccccc k^ o_ q>rrrrrrrrrrrrrrrrrrrrrrrrrrqr lp d` w d ft fN f  fQ  h  ij  w x f f s  w xx w xxx fu v lpp d f psnnn  fO  f  fP  } f fg nn fm fn fo f fR uS y f fR uS { nDmeeegetgggggg~ggggnggvzggv|gI C C C D C D Q Q  Q  Q  Q  Q  Q Q Q Q Q! Q" Qi Dj Q# Qk Q$ Q% Qp Qq Qr Qy Rw Ox KcW@aH@JBJ BJA՗BJhEZBJ@+oBJ0+B}8B J@QMlB J`ZqB Jk6B JXpB JxF_eBJ`d`BJR?DBJ1Z4BJn=C36BJCBJ7BJ@`SBJA՗BJ@uB}BJ§qBJQ\BJ\1BJH'BJl)B J@SB JnA#B JȹBJXBJ`AJ`)'AJ@'AJ =BJƇ~4BJ*!BJ;{^BJN-ABJK-BJSBJp~.BJ\VBJBJPWPB Z( ^@^@ S7]B SV\B S0"NB SnV>A SGB S[A Se]B S$EB SA SlҁB S0R- B SB S@,A S`A S A SOh3B S".(B SpDDB S0"NB S.Rs5B S.B S,QCB SMLB S1B Sh | B S CB SPA SPB ZT ^@^X@ S7 B S8@YB SB S➟5SS^`  SZEA~ Sj@^ SNA Su$A S6A SrlB Sd 8B S@A SA S(a B TftSA Z* ^@^@ S@c^B S Rf&:aB S/*KB S:A SGB SjA S :A SB SA S$7B SӼ|B S>tA SA S !LA SA SL"B S\SlK B S?A S/*KB SrZ"B SHS5B S'4>GB SM?KB S$B S,eB S;=FB SA S3A [+^Ȁ@^@SL!BS^BSB~ SNYS@aASA(A~  SJ"S SA SW iA SqA S0ASRRASZbS^#SeS ASAS0ASBS@vBASdAS@BSt6BSAS/ASBS)Sr [,^$@^f@S5ZaJBS`PBS0ʳ=B~ SCS`\?AS@"A SqA SXB S6A S A SASwAS@,ASBStlBSEBSaQW9BS~YASnA [-^P@^@S:HBShXJJBSn !B~ Sd>S ASEŇA S@A S`A SA S;4_A SBAS AS:(SSBlS4'S@' BS(? BS'bASn !BSpAS1ASBST BS{a ASPHwAS7BS]xASA [.^P@^@SX BSxuTBS. BS*( SG~SMZS#  SA~  S6]P SVA$ S =S^/A `:Z S<*A SA SA SASASZS0gSf#SXi1BSЮ>AS!ASLBS~AS/LAS"BSTыNBSbASuAS|BT"P}S"U Y0a@a0@J!~BJBJoBJ\.BJx GBJSB J+dDB JKB JPݨ B J͈,IB J9BJO{2BJ` :BJoiBJ%BJ`McBJ`bBJ>+oćEQ><>BJ[gBJTһoBJV uSBJ HrBBJoueBJk(BJ9BSsA SL/8B S,K:B SdA S$9B S~?!#BS(!BSey BSDASBBSW.WBSUBSw˴BS@6RBS9BSP'{&BS 2IBS#2-yPBSv5BS@!H)BSFBS(SNBS!B ZV^j@^q@S&BS h(BSPy5B~ Sz;> SgEAS u7Saz  S3A~  SaM SζA SaA~ SqS!ATjxSw,S u-#ASgA~ SwnSPy5BS`vUASAS.ASxBS}AS@GyAS@bToAS)7ASQ A Z&^@^w@S{kBS`M>!mBS]V@]BS(1BS)W!BS[HA S4e0B SVbe'B S@BA S0$B SN0hBS̔fBS&KASq{ASAS@'?BS j6=BS`AS]V@]BS[O;BSY BS1=VBSY?)]BSUf@BS>'BS|R5TBSh2BSB ZW^@@^@S+bBS`piBSKBS؈MBSX%B J"bB J`e:fB J$B J :dB J@;\BJUBJu*^u@^@S4BS8GHkBS@FB~ TnmSUA~ S%. SA SlA~  St- SHyA StASx#A~ S0SDA~ Sf[SaAS@c+AS@-OAS@FBSuERASAS.,BSPhBS@GvASGASz=B~ TdSdAD9lPTlBJH  !@"#$%@&@'@()*+,-./0123G4567G89:;<=>? [7 ^y@^@ S\d+B S+/B Si\ B~ SPQ SU_nA~ S6B S|A ShcA~ SEA S#=B!S_#B!S/B!SN!{4B!S 3(A!SPpgA "[8"^4@^n@"S@RmZB"SҼxYB"Sw1IB"SqjA"S= B"S`A" S UB" StB" SFA" S'6 B" SB"SA"SyIA"S]o"A"SA"S@"B"SptB"Sp7/A"Sw1IB"Shh-B"S"B"S-NnBB"S@$IB"Sw1B"St $B"S @B"S*A"SA #[?#^q@^y@#SlB#S&j^ B#S^nA~ #TF#SƇA~ #SrP# S@A# SjA~ # SR# SوyA# S@VA~ #S#SA~ #T#SRA#SA#S@WA~ #S2=+#S^nA#SmA#S@A#S͗9A#SoYB#S4A#S@A#S A#SyS6_ $[9$^p@^@$S@7h~B$S`?[B$S@ rwdB$SYKa0B$SjGB$S :A$ S{FB$ ShBHB$ SEA$ S9GB$ S? j8B$S4B$S B$SA$S-9B$SFx;gB$SfB$SZB$S@ rwdB$S#CB$SY48B$Se_B$S t,ybB$SLB$S*gwBB$Sr-VB$Sā"B$S\,7B %VY%^@^4@%S`46B%Sπ7B%S.D,B%S%A%S;3BA%SA% SwA% SxFA% SMA% SBbA% S%eA%S@%B%S7(Y+B%SlxB%S0X B%SN\"B%ShA%SA &V:&^@^ė@&S` B&SPG ÃB&S ŤQB&S/= B&Sk4B&S' VA& SY2B& S05B& S A& S4B& S O3B&SZ(+B&ShՁB&SOB&SX'B&SMnJB&S++GB&S B&S ŤQB&Sd o8B&S62B&S5JB&SY2SB&Sus>&K4&ճs((k5A(ЁA(ıA(&(ڰڴ(E1<B(SaB(SB(SquB(S`iA(S CB~ (S(S>A )[d)^p@^x@)S9&A)S6A)S0]A~ )S")S NA)SS}e ) S^A0) Sb?SzS;HSvT<$S>#Sj S^–)SA)SՑA~ )S^3)S0]A)S@+A)SahcA)S^7A)S.A)S@XA)SAA)S@KA)S&Swb: *[e*^@^t@*SaGB+SB$B+SzA+S8A+S0A+ SoA+ SpPA+ SA-Sw`A-S^9!B-S0nYB-S@TB-S8]B-S6Xf B-S(B-SȞaB-S4^6B-S׊VA-S@>!LA .ZZ.^,@^d@.S4plB.S@T nB.SXB.SׁB.SSB0B.S [A. S.B. SP1B. S$*pA. Sŭ0B. S4"B.S8B.S84B.SjA.SBA.SLRB.SBiQB.SB.SXB.ShhDB.S-K@B.SMB.S1aXB.SM+GB.SТ=B.SvEIB.S B.S|B /[=/^p@^0{@/S&R%B/S&B/SB~ /Sr2/SA/S0=2Sv / S= A~ / SJ:/ Sb>A$/ SFm(MS?S6L T4 S*/S`kA/S[[=A~ /SE/SB/S`KA/S` ,A/STA/S;HB/Sx]A/S? A/SB/S:1S2? 0[[0^@^@0SJ~eB0SIeB0S3pTB0SŽB0SͱX-B0S@z?A0 S՝+B0 S.B0 SՙA0 S,B0 S 4w!B0SYB0S B0SpDA0SL A0S<QB0S4PB0SWB0S3pTB0SȨL BB0S;B0S HB0S UB0S EB0SmMz9B0SAEB0SݡB0S8BkmB 1[1^}@^0@1SPKB1SB B1SdsZB~ 1T1S* A1SpA1 SA1 S`_A1 SPA1 S ~~.A1 S A1SwA1Sj*SSfl1S GA1SA~ 1S.)1SdsZB1S@>1B1SW"B1S=GhB1S\B1SpF B1S@3B1Sd$oB~ 1Tb 1S@EA 2[\2^@^@2S(BB2S&JB2SE)B2SA2SA~ 2S>"2 S A2 S*A~ 2 S. Z"2 S% A2 SWA2SG A2S SϭPSX2S7"A2SA2S"A2SE)B2S0dB2S _wA2S B2Su B2S07A2S A2S(B2S@A~ 2S^ ~ 3YA3a@aJ@3J6B3J 9B3J_G*B3JA3J /A3J5A3 JA3 JA3 J+A3 JA3 J A3J`qpA3JaxA3JGA3J@m2A3J8+ B3JP# B3J@(A3J_G*B3J(Ʀ B3JpaB3J|$B3Jظ)B3Jb B3JUB3JfS#B3J:&A3JA 4Z4^y@^@4Sz'B4S6\(B4S &FB4ShA4S No+A4S/EA~ 4SFSc4SA4SlB4SH^B4S <2A4S &FB4SA4SA4Se}B4S@ B4S_A4SA4SB4S A4SִtA 5Z5^j@^z@5S|B5Sx!B5SFvB5TfcSBMPS'ST( 5 SuA~ 5 Sj$5 S]EA$5 S*+$S SNS6S 5SA5S*{A~ 5S5SFvB5SDA5S@D]A5S0uA5S[B5S?A5S@{1A5S,A5T:cS  6ZB6^H@^`@6S$Ҷ B6S`Rf%B6S$:vB~ 6S$C6S`A~ 6S=g6 S@υA6 S@gkA~ 6 S&`6 S@y\A6 S@?A6SA6SNSf0S(R 6SiA6S)A~ 6SH-6S$:vB6SprA6S`TA6St堨B6S gZB6S [A6S !\A6S=B~ 6SaR6S45/A 7YC7a@a@7J~y~B7J@R@B7J rB7JL!B7J7;B7JU B7 JZ"%6B7 Jd?B7 JdHB7 JK2:B7 JڈB3B7JЬ0B7JB7J_B7J~gB7Jx2TB7J)ܠRB7JDB7J rB7J@ $WB7J<4HB7JOPiB7JP=&rB7J@[.w:[B7JCLB7JfB7J B7JX*B 8Z8^@^;@8SݖZ`GB8Sm4FHB8SPFB~ 8S:8S#cR B8SмM=A8 S(EB8 S?"B8 S@A8 ShSB8 SDKB8S9sB8SPA8SȶA8SH-kA8S\#B8Sn9!B8S`Q,A8SPFB8S*b1&6B8SxYB8S^S8B8SV`FB8S.B8SB8S1l=B~ 8S##8SP&0A 9[D9^,@^(@9SH`c5B9S$5B9S3B~ 9S:9S,FB9SA9 S0A@A9 SkB9 SHA9 S@A9 S&A9SV"A9SZ!A9S #A9Sa A9SL<B9Ss+B9S\A9S3B9Ss"B9Sp3 B9S0&B9S7>3B9SQфB9S( B9SG.B~ 9SҠ 9SWA :[z:^@@^@:Su+B:Sz5,B:STB~ :S6 :SA~ :S~ t: S^kA: S 1A~ : Sp: SP:A: SkA:S;>A~ :SF@$:SA~ :S&%#:S A:SF %A:SA:STB:SlB:SIۛA:SNB:S ;B:S@)A:S`GQA:SΗOB:SS \ ;[{;^w@^@;S:B;SpB;S3B~ ;TN ;S?A~ ;S=X; SdA; StlA~ ; SqQ; S@UA; SrA;S@PA;SSSA;S {1A;S_A~ ;Sj#;S3B;SB;S80tyB;S0CB;S"B;S A;SPӖA;SB~ ;T- ;S틘A <[<^0@^ܕ@<S 'B<SPZP}B<SH*B~ <S <SA~ <SFI< S@?tA< SśA~ < S6G< S4cA< SA<SЎA<S4S9deS-;<Sl^`A<S{A<S/A<SH*B<S5 B<S`9bA<Sp1B<S4U*B<S:!B<S\&A<SJB~ <TJ <Sr]A =Z|=^@^)@=Sp/sB=S`ͳuB=S`AdB=Sx!B=Sj-B=S\ B= S6u.'B= SK<1B= Sp\ B= SzT+B= Sҥ#B=SZ)!B=SнA=SMB=S0A=SAB=Sw*W?B=S,uXB=S`AdB=S/[FB=SS:B=S+9_B=S@gqbddB=S MB=Sq%@B=S @ZB=SwA!B=SwB >[}>^@^@>S@NWQB>S@RQB>SZPB>S@WA>SB>SP$A> SVB> SLfB> SA> S\DB> SHB>SS B>S{A>S&sA>SA>S^&B>SrN%B>S@ʳA>SZPB>S05B>S()B>SɋGB>S#lPB>S8B>S(Ț'B>S5{DB>SRLA>SX.;IB ?[~?^ę@^$@?S%GB?S( HHB?Sa!4B?S7A?Sx\B?S-A? SھB? SgB? S.A? S0!B? SkB?S0A?SA?SA?STA?S|n%B?SU!B?SBwB?Sa!4B?SP2A B?S4\lB?S:)B?So3B?S`o"B?Sd&OaB?Sʪ%B?S>A?S ׭ADBl @ABCDEFGHIGJKLGMGNOPQRSTUVWXYZ[ @[H@^@^`@@S aB@Sn4dB@S_BIB@S4^A@SNB@S0M A@ S@(IB@ SLB@ Sph A@ Se B@ SH&B@S,B@SA@S BA@SA@S(fB@S1B@SeA@S_BIB@SP B@SdYB@SBzEB@SIB@SL/B@S^$B@SHuAB@SDA@S0A A[A^x@^Ȏ@ASX(DBAS4ASpm)AASS>AA SAA SEAA ShAA SpoAA S`ʩAAS?AAS+.AASH FA~ ASܻmASк BASrBAS? AASp4BASP9BAS"KBASTiN/BAS4BASXABAS BASZ*B~ ASAS^A B[]B^}@^@BSd'.BBST30BBS0 cB~ BSl)BSf#ABS@qtAAB S-iuAB SgAB S@AB S[QAB StABS`JABSNO*S~SB:BSABStA~ BSvAD S6ADS]ADSFS2JS2 7DS BDSXmBDS`-FADSJG"BDS0ZBDSZADSUbBDSܕ!BDSpLBDS iADS_8B~ DS*DSA E[FE^p{@^(@ESBBES]BEṠB~ ESESq0A~ ES: \E S@fAE S:A~ E S1YE S@HAE SAES;BFSUAFS'KBFSz:"0BFSV*x$BFS,CBFS^KBFSFo5BFS+BFSx@BFS@AFS|!`B G[G^`@^P@GSTnBGSr:BGS4B~ GS. GS RyA~ GSXG SZbAG SWA~ G SnWG S ~20AG SS;AGSA~ GS GSA~ GSBGS0nvAGSp=%A~ GSX%TGS4BGSzBGSPAGS uBGSBGSBGS iAGS֛BGSBSN|r H[H^{@^ @HSz9!BHSB} BHS\B~ HTAHS {AHSRAH S@WAH SxAH Sn9?AH S JAH S kX}AHS 9AHSbS"`YSHS`c|BHSx/ B~ HS,0HS\BHS8/BHS}AHS`vBHSY%BHSBHS/AHS@B~ HT%~HSA IYIIa@a@IJg\UBIJQR;eTBIJ4=BIJp5fVAIJvBIJS>FAI JBI JdBI J@6AI J 吝 BI JKgBIJ BIJAIJ DڂAIJAIJx7@vBIJ8]BIJAIJ4=BIJHBIJs? BIJE _8BIJr=BIJ,p#BIJشBIJ .4BIJ5AIJҽB JZJJ^8@^@JS*YSBJS8RBJSXꭊ:BJS~AJSxv3BJSHAJ SaAJ SC BJ S@2?AJ SsBJ SH4ABJSgyBJSjAJSAJS@_JAJS BJSNBJS:eIAJSXꭊ:BJSDsBJSpb> BJS{v5BJS+}q:BJSBG!BJS%BJS1BJS@rAJSX B KZKK^@^@KS̳BKS(ajBKS@t6 B~ KS-c KSA~ KS?K S@UAK SuA~ K S <K SAK SxAKSYAKSH7GSNS,KSp5AKS J>AKS]KAKS@t6 BKS@M5AKS@AKS`O&ABKS  BKS@FAKS!yAKSHrūBKSnS6pP LYLLax@aH@LJ4BLJI"BLJB~ LX¥LJXLB~ LJ.]HL Jp'BL J=d&B~ L J:EL JBL JcBLJ8oBLJ@t^ALJX=/J;pLJALJFUA~ LJWYLJBLJq BLJ"1ALJXbBLJjM BLJtBLJ % BLJhRB~ LX&LJPKB M]MM_8@_@MURxX3BMU81BMUcm5B~ MU*MU۬AMUFAM U@8AM U_BM U@HAM U{AM UAMUAA~ MU`>MU؃A~ MUWMUhnBMUBMUuAMUcm5BMUX .%BMUmBMU =&BMUpʲ5BMUȈ%BMUhZBMUS%B~ MUڇ0MUA NbBNccccccccccccccccccccccccccccMM ObfBOccccccccccccccccccccccccccccMM PbbBPccccccccccccccccccccccccccccPM QbBQccccccccccccccccccccccccccccMMRM RMMSM SPMTM TMMUP UMMVMVNWFXFYFZL[L<r  TTTT >@ A *j-PP OOQQ   NN   7 Sheet1ggD This value indicates the number of saves or revisions. The application is responsible for updating this value after each revision.   !"$%&'()*+,-./012456789:;<=>? DocumentLibraryFormDocumentLibraryFormDocumentLibraryForm F0* 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\OFFICE16\MSO.0DLL#M 1@6.0 Ob LibraryKEi Module1Gdu1 2 HB1p~lB,B!B+BqThisWorkbookG @T@sisW rkbjo 2 $5$"B#$SheetBAS@#eutAG2B#IZUG^2O^2J^2O^2OO96I^B</iZ#xME Sheet1 #Module13OModule2 __SRP_0Q9(SLSS<N0{00020820-0000-0000-C000-000000000046}H(%H0(8v5LJxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2TxixME (6 L< "`k0x% Phh8@$l &8 @h 0@X 8@H P@8 P@( @ @ `א0`ؐ@@ xܐXxݐ@  ̐@@o h@ h@P@v5LJ$*\Rffff*055f5f8035*\R1*#400*\R1*#13e"$=00 HX `h x $a4:C195 &%(!*ic $!,0 $!.B@0Ok 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  K*rU~~~~~~~~j NѐCPzCƒ  a p  )a A!9!  i6xME(6 Lp 8`kBB`:z6%0@X@(<@&@ph @@X @@T @D @04 @H0 0P@ @ @` $@x @ @ ,T@ @ Data@8 entS@P ngle@ IsSi@ Data@ x Data@hh ta.S@X Da@T .TCI@D tion@4 ildi@$ ioni@@ iOf@X vent@ vent@ 63b-@( 0 E@p stem@ lick@8 1202@P erfa@ age@ @| rsio@l e0@\ (1@L X 1?@H @h8 @( @ @ ?@ @@ @X @ @( @ ?@ @p @ @ @p @` ?@H\ @`L @< @0, @ @ ?@x @ @ @ @ @P ?@h @  @8 @ @ @p @` @P =@@ @ 0 ?@, @ @( @@ ?@ =hXv5LJ$*\Rffff*065f5f8035*\R1*#400*\R1*#13e*\R1*#29dB"   ,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 jrmill0000Zactivecell.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 overv="C]@D5$(B@Hy Auth <!, <%>!, <%>!, <%>!,bI': <!,b <%> <!, <!,"* [2]" ;[Black]"* [2]" @(B <!, e#,##0, ;[Black]"*" -#,##0, @(Bd"*" #,##0, ;[Black]-#,##0, @(Bkd <!, <!,5"[2]" ;[Black]"[2]" @(BdX#,##0, ;[Black]-#,##0, @(B5Tk(k : ': <%>B@H : <%>B@Hk[t 9|ϋ  &%*B@H .H <!, <%>!, <%>!, <%>!, <%>!, <%>!, <%>!, <%>!,b/" - <!,ESV <%>!,ESV <%>!,ESV <%>!,ESV <%>!,ESV <%>!,ESVt/[ <!DB@0)Wd <%>B@Hk Υ7ooxp}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 A VBAProjectModule1 ThisWorkbookSheet1Module2FBC:\Program Files\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLLVBA Y 0F9C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXEExcel y !@0F C:\Windows\system32\stdole2.tlbstdole  PL-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE16\MSO.DLLOffice y)`DeleteSummary_Rows format_table_final a4:C195FFIq Range Cells Value 0EntireRow DeleteI D5 FF ."* [2]" ;[Black]"* [2]"NumberFormat 4#,##0, ;[Black]"*" -#,##0, 4"*" #,##0, ;[Black]-#,##0, &"[2]" ;[Black]"[2]" ,#,##0, ;[Black]-#,##0, Select ESV&rU  t__SRP_1nR__SRP_2p__SRP_3wg__SRP_4y rU~|  q!9i=:X%h$ @h8A(lh580lA8:X((H]@68(l=( 5( l?4lh8(krU $`nrU~| q 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\,D4X4$|`<,0 UkrU $`n/i#__SRP_5gThisWorkbook_VBA_PROJECT PROJECT xME (SLSS<N0{00020819-0000-0000-C000-000000000046}H(%H0(8v5LJxAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2a   *\G{000204EF-0000-0000-C000-000000000046}#4.2#9#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.9#0#C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXE#Microsoft Excel 16.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.8#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE16\MSO.DLL#Microsoft Office 16.0 Object Library v5LJiModule1055f5f8035Module1~ThisWorkbook025f5f752d3ThisWorkbook5 Sheet1035f5f752d5 Sheet1Z05Module2065f5f80356Module26Hh0HSlJ=lm)ͦbFO\bE\R{ND%듐24I1zK'%) 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@ID="{FAEAB1DF-D797-4345-913E-E42F1DBFD87C}" Module=Module1 Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=Module2 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="4C4E7B7F8F7D937D937D937D93" DPB="4644718191818A828A828A" GC="4042777878787887" [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 Module1Module1ThisWorkbookThisWorkbookSheet1Sheet1Module2Module2PROJECTwmnSummaryInformation(DocumentSummaryInformation8 CompObjl Oh+'0HPd|  cjohat00Moulton ClayMicrosoft Excel@ 8@b޳@f>@{ ՜.+,0 PX|  Internal Revenue Service Sheet 1  Worksheets F Microsoft Excel 2003 WorksheetBiff8Excel.Sheet.89q