ࡱ> b  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry F raBWorkbookU_VBA_PROJECT_CUR" I 'I 'VBAI ' I ' g2ɀ\pDepartment of Treasury Ba= ThisWorkbook=xK:$8X@"1Arial1Arial1Arial1Arial1Arial1Arial1 Arial1$Arial1Arial1xArial1Arial12Calibri1 2Calibri12Calibri142Calibri1 2Calibri12Calibri12Calibri1,82Calibri182Calibri182Calibri1>21421<2Calibri1?2Calibri1h82Cambria12Calibri1 2Calibri"$"#,##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,;\ \-\-*%#,###,"(2)*"\ ;[Black]\-#,##0,;\ \-\-)$"*"\ #,##0,\ ;[Black]\-#,##0,;\ \-\-)$#,##0,\ ;[Black]"*"\ \-#,##0,;\ \-\-#,##0;\-#,##0;0;@#,##0;\-#,##0;@!#,##0,\ ;[Black]\-#,##0,;\ 02-"*"\ "[2]"\ \ #,##0,\ ;[Black]\-#,##0,;\ \-\-&!"*"\ #,##0,\ ;[Black]\-#,##0,;\ @#,##0,\ ;[Black]\-#,##0,""*"\ #,##0,\ ;[Black]\-#,##0,"* [2]"\ ;[Black]"* [2]"&!#,##0,\ ;[Black]\-#,##0,\ ;\ \-\-"#,##0,\ ;[Black]"*"\ \-#,##0,#,\ ;[Black]General#,\ ;[Black]\-##\ ;[Black]\-#,#\ ;[Black]\-#,##0,#,###\ ;[Black]General"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                                                                      ff + ) , *      P  P         `            a>  "  1"<@ @ 1"< @ 1"    (8  (    (8        1"4@ @      $  $  )8 )8 )8 )8 )8 !8 )8 )x )8  8  8   8@@ "8@ 8@ @ 8@ 8@ 8@ 8@@ 8@ 8@ "8@@ "8@ "8 @ (8 @ (0 8 @  (  ( 8 @ 8 1<@ "8@ *8@@ *8@ *8 @  (8  0 *8@ *8@ 1<@ 0@ 0@   8   8@ @ 8@      ,@7  ,@  $@  $@  ,@  ,  $  $ || Y}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef [$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L [$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A}  00_)23[$ -}A}! 00_)23 [$ -}A}" 00_)[$ -}A}# 00_)[$ -}A}$ 00_)[$ -}A}% 00_)[$ -}A}& 00_)[$ -}A}' 00_) [$ -}A}( 00_)[$ -}}) }00_)[$ -##0.  }}* 00_)[$ -???##0.??? ??? ???}-}/ 00_)}A}1 a00_)[$ -}A}2 00_)[$ -}A}3 00_)?[$ -}A}4 00_)23[$ -}-}5 00_)}}7 ??v00_)̙[$ -##0.  }A}8 }00_)[$ -}A}9 e00_)[$ -}x}:00_)[$##  }}; ???00_)[$???## ???  ??? ???}-}= 00_)}U}> 00_)[$## }-}? 00_)}(}400_) 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`SSheet1Controlled Foreign Corporations Total assetsNForeign corporations with current earnings and profits (+) before income taxes)Distributions out of earnings and profits%Receipts by foreign corporations from#Payments by foreign corporations to(1)(2)(3)(4)(5)(6)(7)(8)(9)(10)(11)(12)(13)(14)(15)(16)(17)(18)(21)(23)(24)#Raw materials and energy production"Oil and gas extraction UtilitiesGoods production#Construction #Manufacturing Food manufacturing 6Beverage and tobacco product manufacturing Beverage manufacturingTobacco manufacturingPaper manufacturing )Petroleum and coal products manufacturingChemical manufacturing)Pharmaceutical and medicine manufacturingOther chemical manufacturing*Plastics and rubber products manufacturing)Nonmetallic mineral product manufacturingPrimary metal manufacturing&Fabricated metal product manufacturingMachinery manufacturing-Computer and electronic product manufacturing:Electric equipment, appliance, and component manufacturing&Transportation equipment manufacturing,Other transportation equipment manufacturingMiscellaneous manufacturing(Distribution and transportation of goodsWholesale and retail trade!Wholesale trade Other wholesale trade"Retail trade Other retailersTransportation and warehousing Information8Finance, insurance, real estate, and rental and leasing #Nondepository credit intermediation$Services Basic chemical manufacturing=Soap, cleaning compound, and toilet preparation manufacturing&Communications equipment manufacturing;Semiconductor and other electronic component manufacturing ,Other computer and electronic manufacturing !Other miscellaneous manufacturing-Motion picture and sound recording industriesFinance and insurance,Credit intermediation and related activitiesInsurance carriers"Real estate and rental and leasing+Computer system design and related services'Management of companies and enterprises6Other professional, scientific, and technical services9Management, scientific, and technical consulting servicesHAdministration and support and waste management and remediation services#Arts, entertainment, and recreation-Other services (except public administration))Insurance carriers and related activities<Agencies, brokerages, and other insurance related activities0Professional, scientific, and technical services7NOTE: Detail may not add to totals because of rounding.b* Data should be used with caution because of the small number of returns on which they are based.%Support activities for transportation0Architectural, engineering, and related servicesAccommodation and food servicesAll industries X[All figures are estimates based on a sample--money amounts are in thousands of dollars]HMotor vehicle, vehicle body and trailer, and vehicle parts manufacturing*Paint, coating, and adhesive manufacturing/Computer and peripheral equipment manufacturing Real estate-Medical equipment and supplies manufacturing GMotor vehicle and motor vehicle parts and supplies merchant wholesalers>Machinery, equipment, and suppliers merchant wholesalers 2Drugs and druggists' sundries merchant wholesalers1Chemical and allied products merchant wholesalers5Petroleum and petroleum products merchant wholesalers'Publishing industries (except internet)WSecurities, commodity contracts, and other financial investments and related activities+Funds, trusts, and other financial vehicles3Advertising, public relations, and related servicesGProfessional and commercial equipment and supplies merchant wholesalers1Grocery and related products merchant wholesalersF[1] Includes "Nature of business not allocable," not shown separately.[2] Number of returns is not additive because some U.S. corporations had Controlled Foreign Corporations in more than one industrial sector. The industrial activity of the parent corporation filing the return often differs from that of the Controlled Foreign Corporations.Other manufacturing$Other transportation and warehousing(Other real estate and rental and leasing(19)(20)(22)YIndustrial sector and selected industrial subsector of Controlled Foreign Corporation [1]&Number of U.S. corporation returns [2]Number of foreign corporationsBeginning of year End of yearTotal receipts?Current earnings and profits (less deficit) before income taxes Income taxes>Current earnings and profits (less deficit) after income taxes0Current earnings and profits before income taxes/Current earnings and profits after income taxesTotal)Not previously taxed earnings and profits%Previously taxed earnings and profits.Dividends paid to controlling U.S. corporationTotal Subpart F income All sources All related parties, totalEAny foreign corporations controlled by U.S. corporation filing returnUnrelated partiesAll recipientsUnrelated parties Total section 964(a) E&P>Total previously taxed E&P (sections 959(c)(1) & (2) balances)(25)(26)(27)LTotal not previously taxed E&P (post-86 & pre-87 section 959(c)(3) balances)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 (28)(29)(30)-Agriculture, forestry, fishing, and hunting DOther mining, quarrying, and oil and gas extraction =Agriculture, construction, and mining machinery manufacturing"Industrial machinery manufacturing\Ventilation, heating, air-conditioning, and commercial refrigeration equipment manufacturingMHousehold appliances and electrical and electronic goods merchant wholesalers/Farm product raw materials merchant wholesalers1Tobacco and tobacco products merchant wholesalersNonstore retailers)Investment banking and securities dealing]Other securities, commodity contracts, and other financial investments and related activities!Offices of bank holding companies"Offices of other holding companiesRepair and maintenanceOther machinery manufacturingPeriodical publishers,Other publishing industries (except internetTable 1. U.S. Corporations and Their Controlled Foreign Corporations: Number, Assets, Receipts, Earnings, Taxes, Distributions, Subpart F Income, and Related Party Transactions, by Industrial Sector and Selected Industrial Subsector of Controlled Foreign Corporation, Tax Year 2014MiningOther informationData processing services2Other credit intermediation and related activities:Source: IRS, Statistics of Income Division, September 2017^6 f77E7}t8"93:h;<o>? A] 3C EG7fHIPJ]Kh,MN-QccNBOUj_ KU g2ɀ  qcvϲWk8S  dMbP?_*+%&?'?(?)?M MaryT!C odXXLetterDINU" P=N:SMTJHP LaserJet 4250 PCL6InputBinPrinterSelectRESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexNONEPaperSizeLETTERMediaTypeAutoCollateONOutputBinAutoHPImageShiftOffHPAutoDuplexScalingTrueColorMode24bppTextAsBlackFalseTTAsBitmapsSettingTTModeOutlineRETChoiceTrueHPBackSidePrintingFalseJPEGEnableBestSmoothingTruePrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL6HPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLobUsedhpmcpap6.xmlHPStaplingOpposedFalseHPPCL6PassThroughTrueHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPManualDuplexDialogItemsInstructionID_01_FACEDOWN-NOROTATEHPManualFeedOrientationFACEDOWNHPOutputBinOrientationFACEDOWNStaplingNoneHPManualDuplexDialogModelModelessHPManualDuplexPageOrderEvenPagesFirstHPMapManualFeedToTray1TrueHPPrintOnBothSidesManuallyFalseHPStraightPaperPathFalseHPSendPJLUsageCmdCURIHPCoversOther_PagesFront_Cover_from_Feeder_InputBinNoneBack_Cover_from_Feeder_InputBinNoneJRConstraintsJRCHDPartialJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffHPConsumerCustomPaperTruePSAlignmentobHPZLSwn7HPSmartHub_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} QG} H} E} UE} } } U} } *} } } } U} } *} } }  } } }  } } F} *} q @@ @@@ADII     I ]>^^^^^^^^^^^^^^^^^^^^^^^^^^^^ _Z>`^^^^^^^^^^^^^^^^^^^^^^^^^^^ os ot a>bbbbbbbbbbbbbbbbbbbbbbbbbbfb p ru kk cx c cy cz  c{  v  wx  j kl c c j kl j kkl j kkl c g ps cv cwd~ddd  c|  cz  c}  ~ c c dd c c c c c { t c c { t dhDqsdddddddddudddeuddd{tee|}ei mY B B C B B B B B  B  B  B  B  B C B B B B Bp Bq B Br B B B B B B N Dn<@@S'gBS/BS$yBSe8UBSH݌kBSQcBS $LBS;BS 3!BS  B S(c B SiM;'B S B She B SH8BS0 WBS2ASЮ;BS ҉AS|0ABSi @BS`;j$AS $LBS{1BS BS(CBSNEJBSlk*BS0I< BSL%CBSԑAShEB U @p@؄@ O?B OlB O,hB~ OnbL O8A~ ON-zS OuA O$XA~ OQ O$;?A$ O*gO&aPO] Oʀ  OsA O zA~ ON? O,hB OvA OA O;< B O/B O )JA O`I;A OHzhwB O&OrωP U s@d@ Os'o\B O `B O=GEB OwB OT{\B OP.B O0x,B O֫#B Of'kB O"B O(B O@$aB O~,A OЉGFB O}A Or?B O =B OٺA O=GEB O\p+B O(LB O9ſB Oܐ9&B~ P& OpA O@1A OkA O0A O@|XpA O dA O`+A O %A~ O OUA OJA OB OB OW@A Oܐ9&B OjB OI A O̦dD!B Op%B O7B OdA O\ B~ PV? O5?A U S@`|@ Oo3B Oj$)4B Oй|  Oh%1B O0TpB~ O^` OйBS؉*cBS(v̀BStCPBSJBSDB S40FB S lO9MB S~&B SyIB Sj86BS(hm1BSAOBS`VJBSoBS`8hBS$vgBS0־$BS(v̀BS .OYcBS\] WBSqwBSnRBS=DbBSnUBSKvBSdjBS\#U/B Un@@OPGBO$~BOH9MB~ PHxOŐA~ ONd O͠A OfA~  O۬\ O@- A O AOL3AO5WOzO9OM8AOsA~ OvOTOH9MBO  AO@Ӛ;AOXcDBO:OBO wKyAO}mAO]~B~ P"cO^ A U @2@OWBOABOܛBO`=CBOa9IBOB ObFB ONLB O|!B OZlIB OV\W6BOXH1BOg>BOpBOР BOhBORgBOٮ$BOܛBOGLcBO^&VBO r^rwBOȕBO,ʓbBO@UBOOQevBO}VBO1^/B V!o@P@OglCBOhABOWUDB~ OjWOP<BO3DA OBeA OdB O{DA O*A O PAONsAOaAOAOAO<$BO`<BO}xAOWUDBOHQoBO8KBOx`yABODBOL6 BOBO% @BOrťAOѶ1A V"U@Py@O IBOVRrLBOuhCBOOAOf BO A OXeB Od B O 'A OB OLRBOo BO@AOAOO8A~ O] OA OyA~  O\L O@(A O@92AO;AO&dO\FOO@DBO[#~BO AOM FBO&Y]!BOy;BOABOԣEBObA *BO LBOaC>B~ O懇OW|A V'}@@O@aBO@MaBOɽcQBOwaBOZ&BO@Y4A OT #B Oj(B O`3A O۴%B O sbBOsuBOpAO4J.AO&AOPwEBODBOPAOɽcQBO9BO|uO=!BOWAObAO'XBOX(J] BOP%vkBO+>#AO0ѭB~ OUO@DA W(^@@O@w6lVBOOXBOm@BO@cAOګBOA O8B O IB O)A OixB Oh%2d BO|BOՒAOkAO@8AOҳ?BO֍>BOCAOm@BO&v 1BOU"BO0BO^N=BOl50BO^,d|$BOLj]+BO ("gAO g%B X\E@z@OУBOzTBO,B~ OJQ'OFA~ OG O JA O A&A~  OfC O%V A OFAO2AO OVΊrO><O{dAO0A~ O*3O,BOAOPAO }BO@BO)AO)AO0BOԸA~ O:(9 W@A@`l@Ok BOHMf BOuB~ P )OOAO#A OjFA O`rA OA OA OgAO!ϷA~ OO(A~ OR)O04AO! A~ OA OuBOlAO~AO@9)BOfBO WOgAOvAO0k BOnEO*jh W)0p@@O/s`8BO!47BOե1BONAO솇BOA OgQA O8B O3dA OplA O0AO+A~ OkO$A~ O2_O>BO`BO@j8AOե1BO]OBO:BO7*BO9z 1BOH8W1BOBO " 'B~ O~O@6A V*t@؋@Or)+BOlx+BOj6(B~ Oz O6AO+ҸA O`%A O۔vA OGDA O@eA O@AOcCAOMFOVɫ|Ol#O`0 BO N BOAOj6(BOгmBO6G.BOBO漍'BOBOuBOfBO"OW_ V+T@p@O҅Xq+BO@S(BOyB~ Oj%iO^SA~ O&"Z O<\A O МA~  OQ O"A O ;$AO :HAOsP OO"ZAO`CtAOasAOyBOe0AO֍EAOT6BO,:BOlP1BOP{?AO'SB~ PW O@ ؛A V,d@v@OL\K%BOr($BOrޘ B~ P&OA+A~ OD OA O-WA~  O.B OA OἽAOɵAO8HPvX O"O3OO& AOrޘ BO඿6AO^AO( ϟBOF/O!BO>BOAO`!B~ P6:OFAD:lPPlBJH !"#$@%@&'()*+,-./0123I456789:;<=>? V- 0@@ O5B OaC”4B O0L+B~ O( O@,A OA OA O..A OrgA OA O@lA O@'oA~ OVt" O5:A~ O' O|7.B OO: B OA O0L+B Oh B OUB On[$B O*B O B OTB OiW#B~ O JCr OJE8A !V.!}@@!Oq.(B"O(_'B"O'B~ "OBPk"O@a<A"OI A" O~A" O A" OiA" OHA" O EmA"O&~O>z$PZ Ow("O"B"OA"O]A"O'B"OYB"O2 B"OiB"O(*&B"O8u#B"OSTB"OLB~ "OL5"O!%A #W# b@|@#O( B#O$ B#OkU B~ #Ob#OXA~ #O:"E# OvMA# O@A~ # O.D# O'^A$# OR{OdO>O&ONū#O?:A#OBA~ #O~=#OkU B#OA#O|A#O8~WB#OB#O@dA#OtA#O`B#POz~L $W$J@@o@$Op6B$OQAB$O(B~ $Ov $O!A~ $Oo$ OLJ^A$ O_AA~ $ OAn$ Ow]A$ OgA$O?A$OxJO OR$O)A$O |NA~ $O-$O(B$O@vSA$O`V A$O B$O0ȒB$OA$O`&#%A$O(B~ $O=wQ$On A %W%q@@@%OJ)B$B%Ot}#B%O7$] B~ %Ow%O@eXA%O@A% OVA% O`?(A% OA% OaA% O A%O (A%O7BO9O.%OXBB%OP4A%OR A%O7$] B%OB%O?A%ONB%Ob=͕ B%OB%OЭ-%A%O(TEB~ %Orq%OA &V/&@ @&OMj \B&O Q`B&O?]B&ODA&O#/B&OA& O* .B& O+]0B& O[A& O&[d/B& O :;B&O/l;A&O@E;A&O*7A&O֥WA&O/_RB&O?0QB&O4+A&O?]B&OI:B&OY$B&O@]='VB&O@:`ZB&Oip:B&O6`%B&O3SB&O]'mA&OpA 'W]'c@v@'OPS۔CB'ODFB'O7߭#8B~ 'OLxr'OH§B'OcA' O`B' O*8B' O aA' O"B' OApA~ 'OC0'PԌcA~ 'Pk 'OЙA'Omi3B'OË3B'O}uA'O7߭#8B'O0d} B'OGA'Os/B'OA5B'OB'OXaB'ODs,B~ 'O*'OJ\A (WA(^@@(OB(OTB(OxB~ (OTt(OU~A~ (O$h( O@*A( OuA~ ( O`( OA( O@FA~ (O~(OmA(Oz<OB&:1(O|DAA(O@ A(O6uA(OxB(O_B(O mA(OꙵB(O&s B(O{B(O`OA(OB~ (OJq(OA )WB)m@؈@)OT!MB)Ob#QB)O nTB)O!A)Ov>)B)O@H_YA) O4(B) O"屻)B) O@-A) OX I)B) OB)O_A)OA)ObA)OKA)O34yIB)O*IB)O@qA)O nTB)Opb*B)O?B)O@J!QB)O CRB)O=#/B)OY*B)OrLB)O?;5A)OA *WC*@b@}@*O+B*O7B*OaB~ *PV*O@pA~ *ONkP* OA* OgPA~ * OL* O@XA$* OJcOHOrO" O6*O@ lA*O A~ *O6G*OaB*OA*OVA*OFB*O{B*O 0A*O _wA*OhhB*P~jO> kF +V0+0@t@+O6B+ONm5B+O^3B+O A+Oл.B+OlA+ OTA+ O( iB+ O%A+ OYB+ OL1A+OA+OelOo@+Ox7A+OlK4B+O|i"!B+O2A+O^3B+Ox(~B+O,%B+Oj)B+O}[3B+O`B+OxZIB+OA/B+O,a6A+OsA ,V1, x@@,OJB,O9LIB,O_fRB,OMjA,O!B,O.-A, O N?-A, Oi B, O,DA, OHB, OA\A,OA~ ,O>],<A,OA,O |"B,O" B,O`^A,O_fRB,Oj#C9B,O1$B,OJOK B-O[IB-OA-O RdA .W2.\@w@.Op !B.OC!B.O$B~ .P"..O@A~ .Oa. O@A. O"A~ . O@\S. ONA$. O~NO2myIPNOnO溹.O)puB.O B~ .OB0O)lk3B0O@A0O(WB0O@{A0 Ox\B0 OyB0 O@͔A0 OMg7B0 OPA0OA0OXA0ODA0O?A0OH~"B0O&"B0OBA0O)lk3B0O4#B0OdUB0O6${#B0OuE-2B0O e!B0O9PlB0O^;"B0OA0O@cA 1WD1@B@1OBB1Ot@B1OtFm9B1O *A1OP<1B1O{A1 O;A1 OxUB1 OA1 O8[QB1 OLA1O`A1O.fA1OA1OzJA1O 4B1O}B1OlA1OtFm9B1O؇s] B1OB1O6FX1B1O;M98B1Oj B1Ox,&B1OXB@80B1O@݆2A1O hA 2Vm2pw@@2OYB2OxB2OB~ 2O.f2OA~ 2O]2 O,0A2 O@grA~ 2 O2]2 O A2 O(yA2OA2O* O. V+On22O`mA2O0A~ 2O~|2OB2OHe} B2O \A2OtB2O ˴B2O@m!A2O;A2O= B2O" O~Wm 3T43@@3SV.vB3Sn5 uB3S`(wB3SPQ4B3SA9B3S;9B3 SB5B3 Sd77B4 OB+B4OD!B4O B4O(A4OA4OUZTB4O@v":SB4OX}CB4O}uB4O@A8O7A8O_*A~ 8OW8OB8O&PB8O@{A8OJW9l7B8O(!B8O5NA8O|4B8O8z7B8OvB8O3ՍB8O_!/B8OrA8OA 9Xa9@"@9O;s8B9O86B9O 2B9Oa*A9O@#A9O]fA9 O5ʌA9 O dA9 O@A9 OeA9 O`tA9O@˅A9O&~OLYOr9OxTB9O.B9O`A9O 2B9OP憅B9OȉAyB9Ohs-B9O}JQ2B9O B9O:B9OZ,u#B9OA9O;A :Wb:U@@:OՔeVB:OSKWB:OqNEB:O9UPB:O[ B:OM[KA: ONFB: OBt!B: OA: O<* B: O'=B:Or A:OB~ :O\bq:OzA:O^C>B:Oľ;B:O(7B:OqNEB:O B.B:Ol(.+B:Oi#;B:OђEB:O_ 5B:Op,0B:O|5B:O`(B:ODT8B ;Wj;]@|@;OAB;O\%B;Od\UB~ ;PD';O/?A~ ;OabF; Op A; OXA~ ; O*E; OߵA; OA;OU4A;OMOJ5ZO^$*;O5A;OnA;OQ4eA;Od\UB;O޽YA;Ol8A;O4B;OsB;OA;O`A;Od^fB;P^*O6` <W<I@o@<Os7B<OBWB<O>0<OO.zOŸCOjt7 < OůA~ < OwB< OVoA$< OLjOF_hPqP :gO><ONA<O%A~ <OC<O>0<O:B<OybB<O 0)B<OЩà0B<O3B<O0IYB<OY(B<POh =Wc= d@@=O9$B=O.1T$B=O`+`(B=O A=OnGA=OA= OȟA= OVA= OPA= OdA= O iA=O\OƧTOb$Oh=OPA=OA=OSiA=O`+`(B=OЍA=O A=O·$B=ObE%B=O,{B=OH\B=O|'UB=On)4Or9 >Wd>Q@k@>O BB>OtuB>O?P@B>O21O&1On>O4 > OA~ > Ov2> OA> OA>O@.A~ >O^(>OUtxA~ >ON>O A>ԴA>3A>?P>$!> <+B>Owf8B>O`N@B>O0ˈ)B>OׯB>Od3B>P O c ?W?&@[@?Ow B?OH B?OD$B~ ?P Z?O{A?OA? O\A? O(A? O;^A? OR:A? OA?O(A?OnvO6OFd?OA?OPfA?OIoZA?OD$B?ObA?O NA?O"h"B?O4#B?O B?O \p B?O,B~ ?P)B2?O@AD@Bl  @AB@C@D@EFGIHIJKLMNIOPQRSTU@VWXYZ[\@]I^_ @W7@@/@@O8hVB@O@?VB@OTB@O+A@O|vB@OA@ OB@ O{^B@ O@>WA@ OĎB@ O~ B@OB@O`A@OjA@O@%A@O6B@O1 <@5B@O@A@OTB@O\oV3B@OX/.B@O݇bHPB@O!TB@O@B@Ol@6B@O\GB@ODA@OhXeB AV8A@@AO_֭3PBAO[VGBAO@K*KUBAO@AAOBAO2AA OxYBA O`BA O 8#gAA O$ BA OBAOVƉBAOAAO+,A~ AO޻dAOT[D#BAOJ"BAO@.gCAAO@K*KUBAO3,BAOĎBAOF*QBAOE{TBAO9L2BAO>-)BAO@N[WPBAO@+AAOH?B BWBm@x@BO3U;BBOlN$BBO=ޕ8BBO*ABO଑ABO%AB O 1AB OJ.AB O`*AB OlKAB O6ABOۚABOLABOIA~ BO^&BOp!BBOx3BBO,ABO=ޕ8BBO~n#BBOBBON.-BBO˔8BBOұ^ BBO8BBOo&%0BBO fABO`ߚA CW9C@@COԼBBCO#BBCOeKNBCOaACO?BCOrAC OKAC Ox8BC O ءAC OpRBC O.ACO@7A~ COf|}COlCOpBCOBCOFޥACOeKNBCOLԊkBCOPUBCOLBCOɤMBCO`9$BCODBCOe#kHB~ COJCO`A DU:D`@&@DO!=BDOɈq=BDO[m4B~ DOڷ9DO@)cADOuNAD O@>$AD O"1AD OAD O qAD O&ADOBf(B~ FO2,5FO$AFOGAF OAF OAC A~ F OfF OAF OqdAFOqdAFO&(Or6OڬxFOQAFO AFO@|~AFORD>f(BFO0MBFOAFOa"BFO'BFO BFO@H0AFO& BFOO qS GT;G@|@GS=]Z^BGS`L^BGSߛHBGS=AGSDܥBGS AG SЩBG S'zBG SO@,AG S4BG SpbBGSЄ;AGS XAGSE)AGS`%AGS1t3BGS;u0BGSRoBGSߛHBGS"BGS,4BGS3UDBGSiFBGS-BGSفBGSв'?BGSAGS 6A HUeHPr@X@HOXs6BHO :BHOp7(B~ HO2[HOuAHOVAAH O0K7AH O0OeUBH O=AH OJAH OAHOWi2AHO 4Oj'OcHOt-&BHO"Z$BHO`(}AHOp7(BHOPAHOAHO@3v%BHO*0$BHOAuBHO;cAHOCBHO\UKOw IVI@@`g@IOuAIO ÂAIO!ANIP6Oj=OBSO& -OMOO=O3hOZ>P*)P*&P¥IOZAIO{'.A~ IOaIO!AIOGO޾IOAIOAIOA~ IOIIOAIPZO~ JVJq@؎@JO5BJO>9BJO&B~ JOZJO`*2)AJOF0AJ OAJ OtAJ O>#AJ OAJ OAJObTON.OBOMbJO D%BJO6M$BJOJAJO&BJO AJO@cAJO:i$BJOP vh#BJOsBJO.FAJOy#BJO?EO&Kp KUEKN@8@KOXM/BKOֳBKO HB~ KO.pEKOjIA~ KOlPK OdAAK O@A~ K O QIK O_nsAK OUAKOvOOOΈON| KOAKOqdA~ KOVKO HBKO? AKOA~(AKOpE BKOPpk3BKOpڼAKO@6AKOpO BKP&9y(O]F^ LUL`o@8@LOa^BLO(|BLO BLO!OQFO?Oz L OdHA~ L OB:L OAL O A0LO̯nOFU"Ols,OޭrOlOE.OZ>LO BLO梨ALO^}ALO`}-ALOw"mBLO@lALO 9ALO0ALOZ ObL MUMx@@MOD$VBMOG*VBMOX>B~ MO Af*MO-BMO@RsAM Ow BM OK%BM OAM O;BM O ܃L8BN S|s-3BNSZP0BNS3BNSBNSu.oBNS:L[VBNSpPBNS>5BNS u*`BNS[ABNS*6BNS ě[BNSE`BNSO8HBNSCb:BNS{4gVBNSY)$BNSEX%.B OUFO@z@OOBOOwBOOJ_BOO(rT BOOȴ@9BOOzNn BO Ow5BO O=?BO OP BO OZ8f;BO O2BOOTAPOtpAPOqAPOAPO*0BPO%-BPOAPOfC9BPO0]BPO `APOa6BPOn^8BPOP*XBPOӹtBPO@3BPOfKAPOоjA QW=Qi@@QOnXE[BQO2\BQO[+B~ QOnUMQO&AQO;NAQ OAQ O eBQ O&]AQ O`4AQ O@AQO \AQOH5AQO8AQO AQOشF#BQOs, BQOP AQO[+BQO`QAQO|)AQO(BQO̊+BQOzzBQO(AQO.&B~ QO=QOvA RWR[@`z@RO$4`BRO0_BRO80.,'B~ ROj]/4ROhCARO@AR O~AR O5BR OפAR OЃAR OARO_A~ RO9ROhA~ ROcaRO@)BRO\BRO!iARO80.,'BRO%AROyARO$BRO8R%BRO٫BROgAROTS BRO@tpAROA SVfSx@@SOXq.BSO-=ceBSOKBSOHvBSO4s&BSOAS O"BS O򡘒*BS Od\AS O^>'BS OOBSO[BSO]ASOASOs`ASO&FJABSO7yS^BWOLdo;BWOAWOBWO>iAW OiAW OH:BW O@AW O/BW OGsAWOˈAWO@ AWO:AWOmAWO3BWOnBWO !EAWOLdo;BWOrFAWO AWOh:BWO[f;BWOp BWOsAWOx;78B~ WOynWOVA XWRX s@x@XO~LBXO}KBXO%BXO AXOFAXOG:AX OPƴEAX O0)AX O+7AX O@N3AX O'AXO(AXOZVO6QgXO@7AXO@fBXOvBXO~AXO%BXO@,"AXOOiAXOh46#BXO"#BXOP=AXO@pAXO s BXO;܅AXO@ A YZgY p@@YO~1"fBYOzOeBYOE:BYOSsAYO̍BYORAY OmO `ZO8]+ BZOmt BZOAZOO"BZOBZO1BZO+BZOIo!BZO0\ZBZO`]AZO -XBZO`2AZO@WzA [[^[@@[O:O1B[Ok*5B[OܗB~ [O[O`A[OâiA[ OA[ O/A[ OA[ OjA[ O%)A[O@sA[OzaOEXO>f?[OsYA[O A[OsA[OܗB[OȊA[O"OdA[O: yB[O) B[OB)A[OA[O`EB[OcA[O$ÖA \Vo\n@@\OSHc3B\O4B\O$pB~ \O޽ \O`A~ \O1i\ O. A\ OYxA~ \ O -d\ OMA\ O%A\OtOgO"y#O$A!\O`#Z^B\O:B\Oy"A\O$pB\O (A\OP{A\OtB\OPiB\O6A\O^A\OB\P@CS:A~ \O*s+u ]T><@]Sؓ{B]S,gfB]S`e|s~B]S@O6VPB]SC̈LYB]S߲}#B] SLpVB] SM/\B] SV_"B] S@l?4ZB] SBƯ PB]SJFB]Sv2B]SxА 'B]ST,K"B]SۡQqB]S@qAoB]S] ;B]S`e|s~B]S'dB]S]B]Sੑ^BuB]SA|B]SdB]SgZYB]S@qB]Sr֚DHB]SHEB ^US^@z@^O`nB^OoB^O@h]B^O_; B^OK1B^OϷB^ Odb-B^ O"5B^ ODB^ OT:02B^ O6 B^OdB^O` B^O`A^Oȧs B^OSMB^O<eLB^OfB^O@h]B^OEB^OZ6B^O'[GSB^O]LZ[B^ORDB^O!5B^OjKQB^O[A^O dB _ZW_y@ @_OB_ODB_OAp&B~ _Osx_OCA~ _OX_ O%'TA_ OnA~ _ O7L_ O 6 A_ Oo(qA_OA_O O!O~+_O`jA_O 迶A_O%A_OAp&B_O-A_OnA_O"B_OB_O7A_OzA_O\4B_Or=Oc[DBl r`abcdefghijklmnop `VJ`@@`Oǵ("bB`OBbB`O.PB`O25B`OLt['B`O$A` O y $B` O`|*B` O@A` OK'B` OB`O=B`O;QA B`OLA`OB`O`kQFB`O EEB`OA`O.PB`O3 9B`ON(B`O`CB`OTM"LB`O*p^:B`OH)B`O?B`O@A`OppCA aVMa@@aO#BaOxjo$BaOlBaO[AaOhAaO@7Aa O%Aa OoA~ a Of4xa O`:Aa O|AaO(%A~ aO8aOElA~ aO67aOͣAaOAaO-AaOlBaO@9BaO cAaOH BaOWY2BaOPֵAaOДHAaOh2BaOדA~ aOhNi bVhb@s@Τ@bOBD'BbO&BbOTb>B~ bOVP TbOEAbOM_Ab O@ɾAb O,wAb O&Ab OAb O^AbO&+AbOBS,O;4Od/bO6!AbO0AbOyAbOTb>BbOEAbOkAbO!BbO?q}BbOAbO@AAbO1BbOKAbOnA cVLch@@cOVPPBcO>QBcORABcO XAcOBcO /.OAc O`ISBc O0Bc OAc OcBc O <BcO8AcO@SAcOch O9A*h O *O6&PUO)OB3O nhOu~ hO&5hOYrAhOVAhOAhO5AhO@5AhO~AhOKAhOuAhPrOH iUXi_@@iO^#6BiO Ӿ4BiOnF&BiPc AiO pAiODAi O`y=EAi OAi OAi O `>Ai O "AiO\]A~ iOx*iOQͤA~ iON>#iO$ BiO`BiOlAiOnF&BiOAiOݮzAiOb'}%BiOb%BiOgAiO_yAiOpQda!B~ iO7siO`*cA jUj@e@@jOD|ևBjOȅcBjO# ;B~ jOl4jO RA~ jO^Exj O\Aj OY\A~ j Od9sj O4hAj O@AjO@dAjO0OP&O#jOAjO-aAjOg*AjO# ;BjOPAjOZ!AjO~ BjODHBjO` nAjO@AjOpo B~ jOf .PjO}A k\Pk`s@@kQt"BkQȌ'BkQ89B~ kR kQ,XA~ kQB6bk Q$Ak QiA~ k Q4_k QAk Q QjfNQj& kQa?AkQxA~ kQFbpkQ89BkQ{AkQAkQSieBkQdBBkQ hAkQ` 9^AkQ@BkQN%QTYK lyU@lzzzzzzzzzzzzzzzzzzzzzzzzzzzzM myk>mzzzzzzzzzzzzzKKKKKKKKKKKKKKK nl>n oJT>oLKKKKKKKKKKKKKKKKKKKKKKKKKKK pJ pKKKKKKKKKKKKK &@ RPPP>@ddKJA j-nn mm    ll   7 Sheet1ggD Module1fThisWorkbookSheet1 "Module2(  !#$%&'()*+,-./013456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^`abcdefghjlmnopqrsuvwyz{|~dkZxMEP "0@5L"$0 HX`h x $a4:D202 &%(!* $!,0 $!.B@0k oͰAttribute VB_Name = "Module1" Sub DeleteSummary_Rows()  For Each c In ActiveSheet.Range("a4:D202").CellsjrIfbStr(c.Value, "0") <> 0 Then)-c.Entire{.End IfNext  _l#xME (SLSS<N0{00020819-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2J#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2a  *\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}#_VBA_PROJECT26 dir_GPROJECTwminPROJECT k1.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 5LModule10J5b8263faModule1ZThisWorkbook0K5b8263fa3ThisWorkbook_l% Sheet10L5b8263fa5 Sheet1J0%Module20M5b8263fa6Module2UH hH0[}CU7 cȪ/.JꉥY9++;>\KE$- GMwe$"@) bExcel+VBAWin16~Win32Win64xMacVBA6#VBA7# VBAProjectstdole`OfficeuModule1b _EvaluateDeleteSummary_RowsRcZ ActiveSheet%NRange CellsValueK EntireRowDeletex ThisWorkbook|Sheet1Module2cformat_table_finalxo ActiveCellOffset SelectionZ NumberFormatR EntireColumnWorkbookk Worksheetl  3 5 7 HC0* pHd VBAProject4@j = | UxMEh 8DD`:dX5LD"   ,0 ` h p ,  `        r`h  x"$&(&0X `"h "     @   H ` x p@ PX px     format_table_final Macro% Macro recorded 6/18/2008 by jrmill00 Macro1 Macrox% Macro recorded 5/15/2008 by jrmill00tiZactivecell.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]@E5$(B@H <!, <%>!, <%>!, <%>!,b': <!,b <%>& <!, <!,0"* [2]" ;[Black]"* [2]" @(B: <!, e@#,##0, ;[Black]"*" -#,##0, @(Bd"*" #,##0, ;[Black]-#,##0, @(Bkd <!, <!,d"[2]" ;[Black]"[2]" @(BdH#,##0, ;[Black]-#,##0, @(Bxkk : ': <%>B@H : <%>B@H6 -  &%*B@H .H <!, <%>!, <%>!, <%>!, <%>!, <%>!, <%>!, <%>!,b" - <!,ESV <%>!,ESV <%>!,ESV <%>!,ESV <%>!,ESV <%>!,ESV6 <!DB@0$d <%>B@Hk @`oh`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("E5").SkDo Whil(e AOCOValue <> "P" OrIOCV0, 2). _U 4K 6 :x, G9 If1]9Then bs(F) < 500 A@tM0 `ion.NumberF""* [2]];[BlackDaElseK5c -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 r5m'FrESV/bw 'yu}koo]0E@ntireC}.DvteK}pX1_.]?6SNext b4Q r 5L 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`braryK Modul`e1GdDu1 2E HB1pB,BZ!B+BqThisWorkbookG @T@sisW rkbjo 2 $%q$_l"B#$SheetBAS@#eutAG2B#IJG^2O^J2J^2O^2OS-M^UI^B<Module1Module1ThisWorkbookThisWorkbookSheet1Sheet1Module2Module2ID="{686CDEE9-EB25-4197-BFDA-81289C7E163D}" Module=Module1 Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=Module2 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="2D2F3EBACEB6D2B6D2B6D2B6D2" DPB="252736C2D6BBD7BBD7BB" GC="1D1F0ECAFEC3FFC3FF3C" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Module1=22, 29, 1476, 763, C ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Module2=22, 29, 1480, 763, C Oh+'0HPd  cjohat00Department of TreasuryMicrosoft Excel@b@S嗴@bI 'SummaryInformation( tDocumentSummaryInformation8x CompObj}k՜.+,0 PX|  Internal Revenue Service Sheet1  Worksheets FMicrosoft Excel 2003 WorksheetBiff8Excel.Sheet.89q