STRATEGY STUDIO / PUBLIC DATA EXPLORER

ROSE AHLBRAND CHARITABLE TRUST: Form 990PF, tax year 2017

View the entire original 990 at ProPublica ↗

Organization
ROSE AHLBRAND CHARITABLE TRUST (EIN 35-1843668)
Tax period
2017-01-01 to 2017-12-31
Filed
2018-05-11
IRS object ID
201821319349100807
Schema version
2017v2.2
Source
Download XML · Original 990 at ProPublica

Every field in the e-filed return. Faint text is the IRS element name, for citing.

Return header ReturnHeader

FieldValueIRS element (for citing)
Return2018-05-11T09:39:26-05:00ReturnTs
Tax Period End2017-12-31TaxPeriodEndDt

Preparer Firm PreparerFirmGrp

FieldValueIRS element (for citing)
Preparer Firm EIN370818432PreparerFirmEIN

Preparer Firm Name PreparerFirmName

FieldValueIRS element (for citing)
Business Name Line1KEMPER CPA GROUP LLPBusinessNameLine1Txt

Preparer US Address PreparerUSAddress

FieldValueIRS element (for citing)
Address Line1726 WASHINGTON ST SUITE 200AddressLine1Txt
CityCOLUMBUSCityNm
State AbbreviationINStateAbbreviationCd
ZIP472011912ZIPCd
FieldValueIRS element (for citing)
Return Type990PFReturnTypeCd
Tax Period Begin2017-01-01TaxPeriodBeginDt

Filer Filer

FieldValueIRS element (for citing)
EIN351843668EIN

Business Name BusinessName

FieldValueIRS element (for citing)
Business Name Line1ROSE AHLBRAND CHARITABLE TRUSTBusinessNameLine1Txt
FieldValueIRS element (for citing)
Business Name ControlROSEBusinessNameControlTxt
Phone8123761981PhoneNum

US Address USAddress

FieldValueIRS element (for citing)
Address Line1125 3RD STREETAddressLine1Txt
CityCOLUMBUSCityNm
State AbbreviationINStateAbbreviationCd
ZIP47201ZIPCd

Business Officer BusinessOfficerGrp

FieldValueIRS element (for citing)
PersonWILLIAM HELMBRECHTPersonNm
Person TitleTRUSTEEPersonTitleTxt
Phone8123761981PhoneNum
Signature2018-05-10SignatureDt
Discuss With Paid PreparerYes (1)DiscussWithPaidPreparerInd

Preparer Person PreparerPersonGrp

FieldValueIRS element (for citing)
Preparer PersonERIN BUSHOUSE CPAPreparerPersonNm
PTINP00259374PTIN
Phone8123763061PhoneNum
Preparation2018-05-09PreparationDt
FieldValueIRS element (for citing)
Tax2017TaxYr
Build TS2022-09-23 18:48:47ZBuildTS

Form 990-PF IRS990PF

FieldValueIRS element (for citing)
Address ChangeYes (X)AddressChangeInd
Organization501c3 Exempt PFYes (X)Organization501c3ExemptPFInd
FMV Assets EOY$1,690,103FMVAssetsEOYAmt
Method Of Accounting CashYes (X)MethodOfAccountingCashInd

Analysis Of Revenue And Expenses AnalysisOfRevenueAndExpenses

FieldValueIRS element (for citing)
Schedule B Not RequiredYes (X)ScheduleBNotRequiredInd
Dividends Rev And Expnss$30,516DividendsRevAndExpnssAmt
Dividends Net Invst Incm$30,516DividendsNetInvstIncmAmt
Net Gain Sale Ast Rev And Expnss$49,723NetGainSaleAstRevAndExpnssAmt
Gross Sales Price$379,264GrossSalesPriceAmt
Cap Gain Net Incm Net Invst Incm$49,723CapGainNetIncmNetInvstIncmAmt
Other Income Rev And Expnss$385OtherIncomeRevAndExpnssAmt
Other Income Net Invst Incm$385OtherIncomeNetInvstIncmAmt
Total Rev And Expnss$80,624TotalRevAndExpnssAmt
Total Net Invst Incm$80,624TotalNetInvstIncmAmt
Comp Ofcr Dir Trst Rev And Expnss$20,286CompOfcrDirTrstRevAndExpnssAmt
Comp Ofcr Dir Trst Net Invst Incm$20,286CompOfcrDirTrstNetInvstIncmAmt
Comp Ofcr Dir Trst Dsbrs Chrtbl$0CompOfcrDirTrstDsbrsChrtblAmt
Accounting Fees Rev And Expnss$1,438AccountingFeesRevAndExpnssAmt
Accounting Fees Net Invst Incm$0AccountingFeesNetInvstIncmAmt
Accounting Fees Chrtbl Prps$1,438AccountingFeesChrtblPrpsAmt
Taxes Rev And Expnss$499TaxesRevAndExpnssAmt
Taxes Net Invst Incm$499TaxesNetInvstIncmAmt
Taxes Dsbrs Chrtbl$0TaxesDsbrsChrtblAmt
Tot Opr Expenses Rev And Expnss$22,223TotOprExpensesRevAndExpnssAmt
Tot Opr Expenses Net Invst Incm$20,785TotOprExpensesNetInvstIncmAmt
Tot Opr Expenses Dsbrs Chrtbl$1,438TotOprExpensesDsbrsChrtblAmt
Contri Paid Rev And Expnss$79,340ContriPaidRevAndExpnssAmt
Contri Paid Dsbrs Chrtbl$79,340ContriPaidDsbrsChrtblAmt
Total Expenses Rev And Expnss$101,563TotalExpensesRevAndExpnssAmt
Total Expenses Net Invst Incm$20,785TotalExpensesNetInvstIncmAmt
Total Expenses Dsbrs Chrtbl$80,778TotalExpensesDsbrsChrtblAmt
Excess Revenue Over Expenses-$20,939ExcessRevenueOverExpensesAmt
Net Investment Income$59,839NetInvestmentIncomeAmt

Form990 PF Balance Sheets Form990PFBalanceSheetsGrp

FieldValueIRS element (for citing)
Cash BOY$884CashBOYAmt
Cash EOY-$5,104CashEOYAmt
Cash EOYFMV-$5,104CashEOYFMVAmt
Sav And Temp Cash Invst BOY$20,774SavAndTempCashInvstBOYAmt
Sav And Temp Cash Invst EOY$47,686SavAndTempCashInvstEOYAmt
Sav And Temp Cash Invst EOYFMV$47,686SavAndTempCashInvstEOYFMVAmt
Corporate Stock BOY$1,426,972CorporateStockBOYAmt
Corporate Stock EOY$1,385,109CorporateStockEOYAmt
Corporate Stock EOYFMV$1,647,521CorporateStockEOYFMVAmt
Total Assets BOY$1,448,630TotalAssetsBOYAmt
Total Assets EOY$1,427,691TotalAssetsEOYAmt
Total Assets EOYFMV$1,690,103TotalAssetsEOYFMVAmt
Total Liabilities BOY$0TotalLiabilitiesBOYAmt
Total Liabilities EOY$0TotalLiabilitiesEOYAmt
Organization Follows SFAS117Yes (X)OrganizationFollowsSFAS117Ind
Permanently Restricted BOY$1,448,630PermanentlyRestrictedBOYAmt
Permanently Restricted EOY$1,427,691PermanentlyRestrictedEOYAmt
Tot Net Ast Or Fund Balances BOY$1,448,630TotNetAstOrFundBalancesBOYAmt
Tot Net Ast Or Fund Balances EOY$1,427,691TotNetAstOrFundBalancesEOYAmt
Total Liabilities Net Ast BOY$1,448,630TotalLiabilitiesNetAstBOYAmt
Total Liabilities Net Ast EOY$1,427,691TotalLiabilitiesNetAstEOYAmt

Chg In Net Assets Fund Balances ChgInNetAssetsFundBalancesGrp

FieldValueIRS element (for citing)
Tot Net Ast Or Fund Balances BOY$1,448,630TotNetAstOrFundBalancesBOYAmt
Excess Revenue Over Expenses-$20,939ExcessRevenueOverExpensesAmt
Other Increases$0OtherIncreasesAmt
Subtotal$1,427,691SubtotalAmt
Other Decreases$0OtherDecreasesAmt
Tot Net Ast Or Fund Balances EOY$1,427,691TotNetAstOrFundBalancesEOYAmt

Cap Gains Loss Tx Invst Incm Detail CapGainsLossTxInvstIncmDetail

Cap Gains Loss Tx Invst Incm CapGainsLossTxInvstIncmGrp (253 entries)

PropertyPropertyDescHow AcquiredHowAcquiredCdGross Sales PriceGrossSalesPriceAmtCost Or Other BasisCostOrOtherBasisAmtGain Or LossGainOrLossAmtGains Minus Excess Or LossesGainsMinusExcessOrLossesAmtAcquiredAcquiredDtSoldSoldDt
CAPITAL GANS DISTRIBUTIONP$7,232$4,406$2,826$2,826
ABBOTT LABORATORIESP$135$132$3$32017-02-152017-03-08
APPLE COMPUTER INCORPORATEDP$811$586$225$2252016-02-172017-02-15
BAIRD CORE PLUS BONDP$756$785-$29-$292016-08-182017-02-15
BAIRD CORE PLUS BONDP$548$571-$23-$232016-08-182017-03-08
BROWN ADVISORY SMALL-CAPP$353$362-$9-$92017-02-152017-03-08
CISCO SYSTEMSP$137$132$5$52017-02-152017-03-08
FORTUNE BRANDSP$116$124-$8-$82016-07-272017-03-08
GOLDMAN SACHS TRP$102$105-$3-$32016-09-202017-02-15
GOLDMAN SACHS TRP$127$130-$3-$32016-09-202017-03-08
ISHARES PHLX SEMICONDUCTORP$656$535$121$1212016-08-182017-02-15
ISHARES PHLX SEMICONDUCTORP$133$107$26$262016-08-182017-03-08
ISHARES RUSSELL 2000P$686$698-$12-$122017-02-152017-03-08
METROPOLITAN WESTP$769$807-$38-$382016-08-182017-02-15
METROPOLITAN WESTP$540$568-$28-$282016-08-182017-03-08
OSHKOSH TRUCK CORPP$761$621$140$1402016-09-202017-02-15
OSHKOSH TRUCK CORPP$70$56$14$142016-09-202017-03-08
PRINCIPAL REAL ESTATEP$428$436-$8-$82016-05-242017-03-08
STARBUCKS COFFEEP$112$114-$2-$22017-03-032017-03-08
ACCENTURE PLCP$1,971$1,201$770$7702013-04-222017-03-03
ACCENTURE PLCP$124$75$49$492013-04-222017-03-08
ACCENTURE PLCP$958$668$290$2902014-11-072017-02-15
ACCENTURE PLCP$3,695$2,507$1,188$1,1882014-11-072017-03-03
APPLE COMPUTER INCORPORATEDP$139$98$41$412016-02-172017-03-08
AT&T INCP$940$891$49$492013-04-222017-02-15
AT&T INCP$125$116$9$92013-04-222017-03-08
BANKUNITED INCP$675$637$38$382015-10-202017-02-15
BANKUNITED INCP$80$75$5$52015-10-202017-03-08
BLACKROCK INCP$1,177$748$429$4292013-04-222017-02-15
BLACKROCK MULTI-ASSET INCOMEP$471$491-$20-$202015-03-062017-02-15
BLACKROCK MULTI-ASSET INCOMEP$326$341-$15-$152015-03-062017-03-08
BLACKROCK STRATEGIC INCP$2,914$3,062-$148-$1482014-09-032017-01-03
BLACKROCK STRATEGIC INCP$311$325-$14-$142014-09-032017-02-15
BLACKROCK STRATEGIC INCP$213$222-$9-$92014-09-032017-03-08
CANADIAN NATIONAL RAILWAYP$500$335$165$1652013-04-222017-02-15
CANADIAN NATIONAL RAILWAYP$72$48$24$242013-04-222017-03-08
CHURCH & DWIGHT INCP$682$484$198$1982014-04-162017-02-15
CHURCH & DWIGHT INCP$99$69$30$302014-04-162017-03-08
CREDIT SUISSE COMMP$787$1,120-$333-$3332013-10-162017-02-15
CREDIT SUISSE COMMP$261$387-$126-$1262013-10-162017-03-08
DREYFUS INTERNATIONAL BONDP$146$167-$21-$212013-04-222017-02-15
DREYFUS INTERNATIONAL BONDP$106$122-$16-$162013-04-222017-03-08
ECOLAB INCP$370$250$120$1202013-04-222017-02-15
ECOLAB INCP$124$83$41$412013-04-222017-03-08
GENERAL ELECTRIC COMPANYP$635$448$187$1872013-04-222017-02-15
GENERAL ELECTRIC COMPANYP$89$64$25$252013-04-222017-03-08
GOLDMAN SACHS GROUPP$502$427$75$752015-06-162017-02-15
GOLDMAN SACHS SMALL/MID CAPP$41,476$44,535-$3,059-$3,0592015-02-062017-01-03
HARBOR INTERNATIONALP$1,243$1,435-$192-$1922008-04-212017-02-15
HARBOR INTERNATIONALP$904$1,051-$147-$1472008-04-212017-03-08
JP MORGAN CHASE & COP$997$521$476$4762013-04-222017-02-15
JP MORGAN CHASE & COP$185$95$90$902013-04-222017-03-08
JOHNSON & JOHNSON COMPANYP$585$502$83$832015-07-232017-02-15
JOHNSON & JOHNSON COMPANYP$124$100$24$242015-07-232017-03-08
LAZARD INTL STRATEGIC EQUITYP$463$535-$72-$722015-07-232017-03-08
LOWES COMPANIES INCORPORATEDP$462$227$235$2352013-04-222017-02-15
LOWES COMPANIES INCORPORATEDP$81$38$43$432013-04-222017-03-08
MERCK & CO INCP$456$335$121$1212013-04-222017-02-15
MERCK & CO INCP$66$48$18$182013-04-222017-03-08
MICROSOFT CORPORATIONP$967$466$501$5012013-04-222017-02-15
MICROSOFT CORPORATIONP$129$62$67$672013-04-222017-03-08
NATIONAL RETAIL PPTYSP$748$626$122$1222014-09-042017-02-15
NATIONAL RETAIL PPTYSP$87$74$13$132014-09-042017-03-08
NUCOR CORPORATIONP$766$668$98$982014-09-042017-02-15
NUCOR CORPORATIONP$122$111$11$112014-09-042017-03-08
OCCIDENTAL PETROLEUMP$201$233-$32-$322013-04-222017-02-15
OCCIDENTAL PETROLEUMP$64$78-$14-$142013-04-222017-03-08
OPPENHEIMER DEVELOPINGP$852$858-$6-$62013-04-222017-03-08
PAYCHEX INCP$653$393$260$2602013-04-222017-02-15
PAYCHEX INCP$124$71$53$532013-04-222017-03-08
PEPSICO INCORPORATEDP$744$680$64$642015-07-232017-02-15
PEPSICO INCORPORATEDP$109$97$12$122015-07-232017-03-08
PFIZER INCORPORATEDP$634$662-$28-$282015-07-232017-02-15
PFIZER INCORPORATEDP$102$105-$3-$32015-07-232017-03-08
PROCTER & GAMBLE COMPANYP$363$326$37$372013-04-222017-02-15
PROCTER & GAMBLE COMPANYP$90$81$9$92013-04-222017-03-08
RIDGEWORTH SEIX FLOATINGP$199$206-$7-$72013-06-042017-02-15
RIDGEWORTH SEIX FLOATINGP$158$163-$5-$52013-06-042017-03-08
ROBECO BOSTON PRTNSP$984$886$98$982014-01-022017-02-15
ROBECO BOSTON PRTNSP$428$385$43$432014-01-022017-03-08
S & P 500 DEPOSITARYP$28,394$18,923$9,471$9,4712013-04-222017-02-15
SCHLUMBERGER LTDP$327$286$41$412013-04-222017-02-15
SCHLUMBERGER LTDP$80$72$8$82013-04-222017-03-08
STRYKER CORPORATIONP$755$385$370$3702013-04-222017-02-15
STRYKER CORPORATIONP$129$64$65$652013-04-222017-03-08
TJX COSP$547$331$216$2162013-04-222017-02-15
TJX COSP$78$47$31$312013-04-222017-03-08
UNITED PARCEL SERVICEP$436$333$103$1032013-04-222017-02-15
UNITED PARCEL SERVICEP$10,285$8,086$2,199$2,1992013-04-222017-03-03
UNITED TECHNOLOGIESP$672$650$22$222014-11-072017-02-15
UNITED TECHNOLOGIESP$112$108$4$42014-11-072017-03-08
VISA INC CL AP$1,048$490$558$5582013-04-222017-02-15
VISA INC CL AP$178$82$96$962013-04-222017-03-08
WALT DISNEY COP$772$432$340$3402013-04-222017-02-15
WALT DISNEY COP$111$62$49$492013-04-222017-03-08
WELLS FARGO & COP$586$369$217$2172013-04-222017-02-15
WELLS FARGO & COP$118$74$44$442013-04-222017-03-08
BAIRD CORE PLUS BONDP$1,288$1,314-$26-$262016-08-182017-06-09
GOLDMAN SACHS TRP$300$300$0$02016-09-202017-06-09
METROPOLITAN WESTP$1,262$1,303-$41-$412016-08-182017-06-09
CREDIT SUISSE COMMP$584$593-$9-$92016-11-292017-06-09
CISCO SYSTEMSP$314$310$4$42016-07-272017-06-09
CISCO SYSTEMSP$220$230-$10-$102017-02-152017-06-09
ISHARES PHLX SEMICONDUCTORP$149$107$42$422016-08-182017-06-09
OSHKOSH TRUCK CORPP$202$169$33$332016-09-202017-06-09
STARBUCKS COFFEEP$496$455$41$412017-03-032017-06-09
CREDIT SUISSE COMMP$3,098$3,117-$19-$192016-11-292017-07-21
CELEGENE CORPP$551$474$77$772017-06-052017-07-21
ISHARES PHLX SEMICONDUCTORP$600$428$172$1722016-08-182017-07-21
NEWELL BRANDS INCP$688$690-$2-$22017-06-052017-07-21
OSHKOSH TRUCK CORPP$556$452$104$1042016-09-202017-07-21
STARBUCKS COFFEEP$637$626$11$112017-03-032017-07-21
BAIRD CORE PLUS BONDP$2,364$2,375-$11-$112017-07-212017-11-20
BLACKROCK STRATEGIC INCP$907$908-$1-$12017-07-212017-11-20
DREYFUS INTERNATIONAL BONDP$484$484$0$02017-07-212017-11-20
GOLDMAN SACHS TRP$541$546-$5-$52017-07-212017-11-20
METROPOLITAN WESTP$2,318$2,318$0$02017-07-212017-11-20
VIRTUS SEIX FLOATINGP$666$669-$3-$32017-07-212017-11-20
BLACKROCK MULTI-ASSET INCOMEP$1,584$1,586-$2-$22017-07-212017-11-20
CELEGENE CORPP$308$355-$47-$472017-06-052017-11-20
INTEL CORPORATIONP$852$758$94$942017-10-182017-11-20
NEWELL BRANDS INCP$141$265-$124-$1242017-06-052017-11-20
STARBUCKS COFFEEP$340$341-$1-$12017-03-032017-11-20
NEWELL BRANDS INCP$4,727$8,971-$4,244-$4,2442017-06-052017-11-21
GENERAL ELECTRIC COMPANYP$12,151$9,287$2,864$2,8642013-04-222017-06-05
OCCIDENTAL PETROLEUMP$7,751$10,009-$2,258-$2,2582013-04-222017-06-05
BLACKROCK STRATEGIC INCP$496$516-$20-$202014-09-032017-06-09
BROWN ADVISORY SMALL-CAPP$812$677$135$1352015-10-272017-06-09
DREYFUS INTERNATIONAL BONDP$264$282-$18-$182013-04-221970-06-09
HARBOR INTERNATIONALP$2,344$2,446-$102-$1022008-04-212017-06-09
LAZARD INTL STRATEGIC EQUITYP$637$662-$25-$252015-07-232017-06-09
LAZARD INTL STRATEGIC EQUITYP$515$538-$23-$232015-07-232017-06-09
OPPENHEIMER DEVELOPINGP$1,164$1,048$116$1162013-04-222017-06-09
OPPENHEIMER DEVELOPINGP$953$863$90$902013-04-222017-06-09
PRINCIPAL REAL ESTATEP$549$543$6$62016-05-242017-06-09
PRINCIPAL REAL ESTATEP$441$439$2$22016-05-242017-06-09
VIRTUS SEIX FLOATINGP$364$376-$12-$122013-06-042017-06-09
BLACKROCK MULTI-ASSET INCOMEP$770$793-$23-$232015-03-062017-06-09
ROBECO BOSTON PRTNSP$994$895$99$992014-01-022017-06-09
AT&T INCP$347$349-$2-$22013-04-222017-06-09
ABBOTT LABORATORIESP$518$478$40$402014-11-072017-06-09
APPLE COMPUTER INCORPORATEDP$601$391$210$2102016-02-172017-06-09
BANKUNITED INCP$279$300-$21-$212015-10-202017-06-09
BLACKROCK INCP$417$249$168$1682013-04-222017-06-09
CANADIAN NATIONAL RAILWAYP$317$192$125$1252013-04-222017-06-09
CHURCH & DWIGHT INCP$316$208$108$1082014-04-162017-06-09
WALT DISNEY COP$317$185$132$1322013-04-222017-06-09
ECOLAB INCP$267$167$100$1002013-04-222017-06-09
FORTUNE BRANDSP$380$326$54$542015-11-182017-06-09
GOLDMAN SACHS GROUPP$446$427$19$192015-06-162017-06-09
ISHARES RUSSELL 2000P$1,708$1,326$382$3822014-10-212017-06-09
JP MORGAN CHASE & COP$434$237$197$1972013-04-222017-06-09
JOHNSON & JOHNSON COMPANYP$263$201$62$622015-07-232017-06-09
LOWES COMPANIES INCORPORATEDP$549$265$284$2842013-04-222017-06-09
MERCK & CO INCP$449$335$114$1142013-04-222017-06-09
MICROSOFT CORPORATIONP$560$248$312$3122013-04-222017-06-09
NATIONAL RETAIL PPTYSP$264$258$6$62014-09-042017-06-09
NUCOR CORPORATIONP$298$278$20$202014-09-042017-06-09
PAYCHEX INCP$177$107$70$702013-04-222017-06-09
PEPSICO INCORPORATEDP$462$389$73$732015-07-232017-06-09
PFIZER INCORPORATEDP$389$418-$29-$292015-07-232017-06-09
PROCTER & GAMBLE COMPANYP$176$163$13$132013-04-222017-06-09
S & P 500 DEPOSITARYP$244$156$88$882013-04-222017-06-09
SCHLUMBERGER LTDP$139$143-$4-$42013-04-222017-06-09
STRYKER CORPORATIONP$428$193$235$2352013-04-222017-06-09
TJX COSP$294$189$105$1052013-04-222017-06-09
UNITED TECHNOLOGIESP$241$217$24$242014-11-072017-06-09
VISA INC CL AP$379$163$216$2162013-04-222017-06-09
WELLS FARGO & COP$321$221$100$1002013-04-222017-06-09
ACCENTURE PLCP$251$150$101$1012013-04-222017-06-09
BROWN ADVISORY SMALL-CAPP$2,179$1,798$381$3812015-10-272017-07-21
HARBOR INTERNATIONALP$6,201$6,366-$165-$1652008-04-212017-07-21
PRINCIPAL REAL ESTATEP$40$40$0$02016-05-242017-07-21
OPPENHEIMER DEVELOPINGP$33,185$28,952$4,233$4,2332013-04-222017-07-21
ABBOTT LABORATORIESP$761$652$109$1092014-11-072017-07-21
APPLE COMPUTER INCORPORATEDP$900$586$314$3142016-02-172017-07-21
BANKUNITED INCP$558$637-$79-$792015-10-202017-07-21
BLAKP$856$499$357$3572013-04-222017-07-21
CANADIAN NATIONAL RAILWAYP$490$287$203$2032013-04-222017-07-21
CHURCH & DWIGHT INCP$583$380$203$2032014-04-162017-07-21
CISCO SYSTEMSP$730$653$77$772016-07-052017-07-21
WALT DISNEY COP$642$371$271$2712013-04-222017-07-21
ECOLAB INCP$665$417$248$2482013-04-222017-07-21
FORTUNE BRANDSP$659$543$116$1162015-11-182017-07-21
GOLDMAN SACHS GROUPP$441$427$14$142015-06-162017-07-21
ISHARES RUSSELL 2000P$4,273$3,314$959$9592014-10-212017-07-21
JP MORGAN CHASE & COP$818$426$392$3922013-04-222017-07-21
JOHNSON & JOHNSON COMPANYP$811$602$209$2092015-07-232017-07-21
LOWES COMPANIES INCORPORATEDP$588$303$285$2852013-04-222017-07-21
MERCK & CO INCP$626$479$147$1472013-04-222017-07-21
MICROSOFT CORPORATIONP$1,100$466$634$6342013-04-222017-07-21
ACCENTURE PLCP$773$450$323$3232013-04-222017-07-21
AT&T INCP$693$736-$43-$432013-04-222017-07-21
NATIONAL RETAIL PPTYSP$594$552$42$422014-09-042017-07-21
NUCOR CORPORATIONP$604$556$48$482014-09-042017-07-21
PAYCHEX INCP$513$322$191$1912013-04-222017-07-21
PEPSICO INCORPORATEDP$699$583$116$1162015-07-232017-07-21
PFIZER INCORPORATEDP$634$662-$28-$282015-07-232017-07-21
PROCTER & GAMBLE COMPANYP$531$489$42$422013-04-222017-07-21
S & P 500 DEPOSITARYP$493$313$180$1802013-04-222017-07-21
SCHLUMBERGER LTDP$266$286-$20-$202013-04-222017-07-21
STRYKER CORPORATIONP$875$385$490$4902013-04-222017-07-21
TJX COSP$411$284$127$1272013-04-222017-07-21
UNITED TECHNOLOGIESP$493$433$60$602014-11-072017-07-21
VISA INC CL AP$1,097$449$648$6482013-04-222017-07-21
WELLS FARGO & COP$596$405$191$1912013-04-222017-07-21
MICROSOFT CORPORATIONP$6,607$2,640$3,967$3,9672013-04-222017-10-18
VISA INC CL AP$6,680$2,533$4,147$4,1472013-04-222017-10-18
PEPSICO INCORPORATEDP$4,819$3,970$849$8492015-08-242017-10-18
HARBOR INTERNATIONALP$3,877$3,939-$62-$622008-04-212017-01-20
LAZARD INTL STRATEGIC EQUITYP$2,902$2,763$139$1392015-07-232017-11-20
PRINCIPAL REAL ESTATEP$1,784$1,694$90$902016-05-242017-11-20
BROWN ADVISORY SMALL-CAPP$1,473$1,137$336$3362015-10-272017-11-20
CREDIT SUISSE COMMP$930$1,357-$427-$4272013-10-162017-11-20
OPPENHEIMER DEVELOPINGP$3,227$2,604$623$6232013-04-222017-11-20
ROBECO BOSTON PRTNSP$2,108$1,824$284$2842014-01-022017-11-20
AT&T INCP$415$465-$50-$502013-04-222017-11-20
BANKUNITED INCP$318$337-$19-$192015-10-202017-11-20
BLACKROCK INCP$474$249$225$2252013-04-222017-11-20
CANADIAN NATIONAL RAILWAYP$319$192$127$1272013-04-222017-11-20
CHURCH & DWIGHT INCP$314$242$72$722014-04-162017-11-20
CISCO SYSTEMSP$508$433$75$752016-07-272017-11-20
WALT DISNEY COP$309$185$124$1242013-04-222017-11-20
ECOLAB INCP$264$167$97$972013-04-222017-11-20
FORTUNE BRANDSP$454$432$22$222016-07-272017-11-20
GOLDMAN SACHS GROUPP$238$213$25$252015-06-162017-11-20
ISHARES PHLX SEMICONDUCTORP$358$214$144$1442016-08-182017-11-20
JOHNSON & JOHNSON COMPANYP$554$401$153$1532015-07-232017-11-20
LOWES COMPANIES INCORPORATEDP$407$189$218$2182013-04-222017-11-20
MERCK & CO INCP$322$287$35$352013-04-222017-11-20
NATIONAL RETAIL PPTYSP$381$331$50$502014-09-042017-11-20
NUCOR CORPORATIONP$331$334-$3-$32014-09-042017-11-20
OSHKOSH TRUCK CORPP$429$282$147$1472016-09-202017-11-20
PAYCHEX INCP$390$214$176$1762013-04-222017-11-20
PFIZER INCORPORATEDP$388$383$5$52015-07-232017-11-20
PROCTER & GAMBLE COMPANYP$353$326$27$272013-04-222017-11-20
S & P 500 DEPOSITARYP$258$156$102$1022013-04-222017-11-20
SCHLUMBERGER LTDP$184$215-$31-$312013-04-222017-11-20
STRYKER CORPORATIONP$620$257$363$3632013-04-222017-11-20
TJX COSP$357$237$120$1202013-04-222017-11-20
UNITED TECHNOLOGIESP$351$325$26$262014-11-072017-11-20
VISA INC CL AP$441$163$278$2782013-04-222017-11-20
WELLS FARGO & COP$324$221$103$1032013-04-222017-11-20
ACCENTURE PLCP$580$300$280$2802013-04-222017-11-20
ISHARES RUSSELL 2000P$2,682$2,210$472$4722016-08-182017-11-20
ABBOTT LABORATORIESP$552$435$117$1172016-07-272017-11-20
APPLE COMPUTER INCORPORATEDP$510$293$217$2172016-02-172017-11-20
JP MORGAN CHASE & COP$591$284$307$3072013-04-222017-11-20
MICROSOFT CORPORATIONP$577$217$360$3602013-04-222017-11-20
PEPSICO INCORPORATEDP$346$277$69$692015-08-242017-11-20
ISHARES PHLX SEMICONDUCTORP$8,148$4,819$3,329$3,3292016-08-182017-11-21
OSHKOSH TRUCK CORPP$5,412$3,558$1,854$1,8542016-09-202017-11-21
HARBOR INTERNATIONALP$47,249$47,504-$255-$2552008-04-212017-11-22
FieldValueIRS element (for citing)
Capital Gain Net Income$49,723CapitalGainNetIncomeAmt

Qlfy Und Sect4940e Reduced Tax QlfyUndSect4940eReducedTaxGrp

FieldValueIRS element (for citing)
Liable Section4942 Tax0LiableSection4942TaxInd
Adjusted Qlfy Distri Yr1$81,698AdjustedQlfyDistriYr1Amt
Net Vl Noncharitable Assets Yr1$1,525,542NetVlNoncharitableAssetsYr1Amt
Distribution Yr10.053553DistributionYr1Rt
Adjusted Qlfy Distri Yr2$84,259AdjustedQlfyDistriYr2Amt
Net Vl Noncharitable Assets Yr2$1,599,353NetVlNoncharitableAssetsYr2Amt
Distribution Yr20.052683DistributionYr2Rt
Adjusted Qlfy Distri Yr3$85,180AdjustedQlfyDistriYr3Amt
Net Vl Noncharitable Assets Yr3$1,662,067NetVlNoncharitableAssetsYr3Amt
Distribution Yr30.051249DistributionYr3Rt
Adjusted Qlfy Distri Yr4$78,153AdjustedQlfyDistriYr4Amt
Net Vl Noncharitable Assets Yr4$1,590,853NetVlNoncharitableAssetsYr4Amt
Distribution Yr40.049126DistributionYr4Rt
Adjusted Qlfy Distri Yr5$72,647AdjustedQlfyDistriYr5Amt
Net Vl Noncharitable Assets Yr5$1,493,642NetVlNoncharitableAssetsYr5Amt
Distribution Yr50.048637DistributionYr5Rt
Total Distribution0.255248TotalDistributionRt
Average Distribution0.051050AverageDistributionRt
Net Vl Noncharitable Assets$1,611,213NetVlNoncharitableAssetsAmt
Adj Net Vl Noncharitable Assets$82,252AdjNetVlNoncharitableAssetsAmt
Net Investment Income Pct$598NetInvestmentIncomePctAmt
Adj Nonchrtbl Net Invst Incm Pct$82,850AdjNonchrtblNetInvstIncmPctAmt
Qualifying Distributions$80,778QualifyingDistributionsAmt

Excise Tax Based On Invst Incm ExciseTaxBasedOnInvstIncmGrp

FieldValueIRS element (for citing)
Investment Income Excise Tax$1,197InvestmentIncomeExciseTaxAmt
Tax Under Section511$0TaxUnderSection511Amt
Subtotal$1,197SubtotalAmt
Subtitle A Tax$0SubtitleATaxAmt
Tax Based On Investment Income$1,197TaxBasedOnInvestmentIncomeAmt
Estimated Plus Ovpmt Incm Tx$400EstimatedPlusOvpmtIncmTxAmt
Extsn Request Income Tax Paid$0ExtsnRequestIncomeTaxPaidAmt
Backup Withholding Withheld$0BackupWithholdingWithheldAmt
Total Payments And Credits$400TotalPaymentsAndCreditsAmt
Es Penalty$0EsPenaltyAmt
Tax Due$797TaxDueAmt

Statements Regarding Acty StatementsRegardingActyGrp

FieldValueIRS element (for citing)
Legislative Political Acty0LegislativePoliticalActyInd
More Than100 Spent0MoreThan100SpentInd
Form1120 POL Filed0Form1120POLFiledInd
Section4955 Organization Tax$0Section4955OrganizationTaxAmt
Section4955 Managers Tax$0Section4955ManagersTaxAmt
Tax Reimbursed$0TaxReimbursedAmt
Activities Not Previously Rpt0ActivitiesNotPreviouslyRptInd
Changes To Articles Or Bylaws0ChangesToArticlesOrBylawsInd
Unrelated Bus Incm Over Limit0UnrelatedBusIncmOverLimitInd
Organization Dissolved Etc0OrganizationDissolvedEtcInd
Section508e Rqr SatisfiedYes (1)Section508eRqrSatisfiedInd
At Least5000 In AssetsYes (1)AtLeast5000InAssetsInd
Org Report Or Register StateINOrgReportOrRegisterStateCd
Form990 PF Filed With Atty GenYes (1)Form990PFFiledWithAttyGenInd
Private Operating Foundation0PrivateOperatingFoundationInd
New Substantial Contributors0NewSubstantialContributorsInd
Own Controlled Entity0OwnControlledEntityInd
Donor Advised Fund0DonorAdvisedFundInd
Comply With Public Insp RqrYes (1)ComplyWithPublicInspRqrInd
Website AddressN/AWebsiteAddressTxt
Individual With BooksFIRST FINANCIAL BANKIndividualWithBooksNm
Phone8123761981PhoneNum

Location Of Books US Address LocationOfBooksUSAddress

FieldValueIRS element (for citing)
Address Line1125 3RD STREETAddressLine1Txt
CityCOLUMBUSCityNm
State AbbreviationINStateAbbreviationCd
ZIP47201ZIPCd
FieldValueIRS element (for citing)
Foreign Accounts Question0ForeignAccountsQuestionInd

Statements Regarding Acty4720 StatementsRegardingActy4720Grp

FieldValueIRS element (for citing)
Sale Or Exch Disqualified Prsn0SaleOrExchDisqualifiedPrsnInd
Brrw Or Lend Disqualified Prsn0BrrwOrLendDisqualifiedPrsnInd
Furn Goods Disqualified Prsn0FurnGoodsDisqualifiedPrsnInd
Pay Comp Disqualified Prsn0PayCompDisqualifiedPrsnInd
Transfer Ast Disqualified Prsn0TransferAstDisqualifiedPrsnInd
Payment To Government Official0PaymentToGovernmentOfficialInd
Uncorrected Prior Acts0UncorrectedPriorActsInd
Undistributed Income PY0UndistributedIncomePYInd
Business Holdings0BusinessHoldingsInd
Jeopardy Investments0JeopardyInvestmentsInd
Uncorrected PY Jeopardy Invst0UncorrectedPYJeopardyInvstInd
Influence Legislation0InfluenceLegislationInd
Influence Election0InfluenceElectionInd
Grants To Individuals0GrantsToIndividualsInd
Grants To Organizations0GrantsToOrganizationsInd
Noncharitable Purpose0NoncharitablePurposeInd
Rcv Fnds To Pay Prsnl Bnft Cntrct0RcvFndsToPayPrsnlBnftCntrctInd
Pay Premiums Prsnl Bnft Cntrct0PayPremiumsPrsnlBnftCntrctInd
Prohibited Tax Shelter Trans0ProhibitedTaxShelterTransInd

Officer Dir Trst Key Empl Info OfficerDirTrstKeyEmplInfoGrp

Officer Dir Trst Key Empl OfficerDirTrstKeyEmplGrp

FieldValueIRS element (for citing)
PersonFIRST FINANCIAL BANKPersonNm

US Address USAddress

FieldValueIRS element (for citing)
Address Line1125 3RD STREETAddressLine1Txt
CityCOLUMBUSCityNm
State AbbreviationINStateAbbreviationCd
ZIP47201ZIPCd
FieldValueIRS element (for citing)
TitleTRUSTEETitleTxt
Average Hrs Per Wk Devoted To Pos10.00AverageHrsPerWkDevotedToPosRt
Compensation$20,286CompensationAmt
Employee Benefit Program$0EmployeeBenefitProgramAmt
Expense Account Other Allwnc$0ExpenseAccountOtherAllwncAmt
FieldValueIRS element (for citing)
Comp Of Hghst Pd Empl Or NONENONECompOfHghstPdEmplOrNONETxt
Other Employee Paid Over50k0OtherEmployeePaidOver50kCnt
Comp Of Hghst Pd Cntrct Or NONENONECompOfHghstPdCntrctOrNONETxt
Contractor Paid Over50k0ContractorPaidOver50kCnt

Summary Of Direct Chrtbl Acty SummaryOfDirectChrtblActyGrp

FieldValueIRS element (for citing)
Description1CASH CONTRIBUTIONS TO SCHNECK MEDICAL CENTERDescription1Txt
Expenses1$15,868Expenses1Amt
Description2CASH CONTRIBUTIONS TO IMMANUEL LUTHERAN CHURCH FOUNDATIONDescription2Txt
Expenses2$19,835Expenses2Amt
Description3CASH CONTRIBUTIONS TO LUTHERAN COMMUNITY HOME FOUNDATIONDescription3Txt
Expenses3$19,835Expenses3Amt
Description4CASH CONTRIBUTIONS TO CONCORDIA SEMINARY AND THE LCMS FOUNDATIONDescription4Txt
Expenses4$23,802Expenses4Amt

Sum Of Program Related Invst SumOfProgramRelatedInvstGrp

FieldValueIRS element (for citing)
Total$0TotalAmt

Minimum Investment Return MinimumInvestmentReturnGrp

FieldValueIRS element (for citing)
Average Monthly FMV Of Sec$1,608,930AverageMonthlyFMVOfSecAmt
Average Monthly Cash Balances$26,819AverageMonthlyCashBalancesAmt
FMV All Other Noncharitable Ast$0FMVAllOtherNoncharitableAstAmt
Total FMV Of Unused Assets$1,635,749TotalFMVOfUnusedAssetsAmt
Reduction Claimed$0ReductionClaimedAmt
Acquisition Indebtedness$0AcquisitionIndebtednessAmt
Adjusted Total FMV Of Unused Ast$1,635,749AdjustedTotalFMVOfUnusedAstAmt
Cash Deemed Charitable$24,536CashDeemedCharitableAmt
Net Vl Noncharitable Assets$1,611,213NetVlNoncharitableAssetsAmt
Minimum Investment Return$80,561MinimumInvestmentReturnAmt

Distributable Amount DistributableAmountGrp

FieldValueIRS element (for citing)
Minimum Investment Return$80,561MinimumInvestmentReturnAmt
Tax Based On Investment Income$1,197TaxBasedOnInvestmentIncomeAmt
Total Tax$1,197TotalTaxAmt
Distributable Before Adj$79,364DistributableBeforeAdjAmt
Recoveries Qualfied Distri$0RecoveriesQualfiedDistriAmt
Distributable Before Ded$79,364DistributableBeforeDedAmt
Deduction From Distributable$0DeductionFromDistributableAmt
Distributable As Adjusted$79,364DistributableAsAdjustedAmt

Qualifying Distri Part XII QualifyingDistriPartXIIGrp

FieldValueIRS element (for citing)
Expenses And Contributions$80,778ExpensesAndContributionsAmt
Program Related Invst Total$0ProgramRelatedInvstTotalAmt
Qualifying Distributions$80,778QualifyingDistributionsAmt
Pct Sect4940e Org Net Invst Incm$0PctSect4940eOrgNetInvstIncmAmt
Adjusted Qualifying Distri$80,778AdjustedQualifyingDistriAmt

Undistributed Income UndistributedIncomeGrp

FieldValueIRS element (for citing)
Distributable As Adjusted$79,364DistributableAsAdjustedAmt
Undistributed Income PY$19,417UndistributedIncomePYAmt
Total For Prior Years$0TotalForPriorYearsAmt
Total Excess Distribution Cyov$0TotalExcessDistributionCyovAmt
Qualifying Distributions$80,778QualifyingDistributionsAmt
Applied To Year1$19,417AppliedToYear1Amt
Applied To Prior Years$0AppliedToPriorYearsAmt
Treated As Distri From Corpus$0TreatedAsDistriFromCorpusAmt
Applied To Current Year$61,361AppliedToCurrentYearAmt
Remaining Distri From Corpus$0RemainingDistriFromCorpusAmt
Excess Distri Cyov App CY Corpus$0ExcessDistriCyovAppCYCorpusAmt
Excess Distribution Cyov App CY$0ExcessDistributionCyovAppCYAmt
Total Corpus$0TotalCorpusAmt
Prior Year Undistributed Incm$0PriorYearUndistributedIncmAmt
Prior Year Deficiency Or Tax$0PriorYearDeficiencyOrTaxAmt
Taxable1$0Taxable1Amt
Taxable2$0Taxable2Amt
Undistributed Income CY$18,003UndistributedIncomeCYAmt
Corpus Distri170b1 E Or4942g3$0CorpusDistri170b1EOr4942g3Amt
Excess Distri Cyov From Yr5$0ExcessDistriCyovFromYr5Amt
Excess Distri Cyov To Next Yr$0ExcessDistriCyovToNextYrAmt

Supplementary Information SupplementaryInformationGrp

FieldValueIRS element (for citing)
Only Contri To PreselectedYes (X)OnlyContriToPreselectedInd

Grant Or Contribution Pd Dur Yr GrantOrContributionPdDurYrGrp (5 entries)

Address Line1RecipientUSAddress/AddressLine1TxtCityRecipientUSAddress/CityNmState AbbreviationRecipientUSAddress/StateAbbreviationCdZIPRecipientUSAddress/ZIPCdRecipient RelationshipRecipientRelationshipTxtRecipient Foundation StatusRecipientFoundationStatusTxtGrant Or Contribution PurposeGrantOrContributionPurposeTxtAmtAmt
CONCORDIA SEMINARY FOR THE R AHLBRAND SCHOLARSHIP FUND
801 DEMUN AVENUEST LOUISMO631053199NONECHARITABLESCHOLARSHIP FUND$11,901
IMMANUEL LUTHERAN CHURCH FOUNDATION
605 SOUTH WALNUT STREETSEYMOURIN47274NONECHARITABLETO FURTHER PURPOSE OF EXEMPT ORGANIZATION$19,835
LCMS FOUNDATION
1333 SOUTH KIRKWOOD ROADST LOUISMO631227295NONECHARITABLETO FURTHER PURPOSE OF EXEMPT ORGANIZATION$11,901
LUTHERAN COMMUNITY HOME FOUNDATION
106 W CHURCH AVENUESEYMOURIN47274NONECHARITABLETO FURTHER PURPOSE OF EXEMPT ORGANIZATION$19,835
JACKSON CO SCHNECK MEMORIAL HOSPITAL
411 W TIPTON STSEYMOURIN47274NONEMEDICAL FACILITYTO FURTHER PURPOSE OF EXEMPT ORGANIZATIONTO FURTHER PURPOSE OF EXEMPT ORGANIZATON$15,868
FieldValueIRS element (for citing)
Total Grant Or Contri Pd Dur Yr$79,340TotalGrantOrContriPdDurYrAmt
Total Grant Or Contri Apprv Fut$0TotalGrantOrContriApprvFutAmt

Analysis Income Producing Acty AnalysisIncomeProducingActyGrp

Div And Int From Sec Part VII DivAndIntFromSecPartVIIGrp

FieldValueIRS element (for citing)
Exclusion14ExclusionCd
Exclusion$30,516ExclusionAmt

Other Investment Incm Part VII OtherInvestmentIncmPartVIIGrp

FieldValueIRS element (for citing)
Related Or Exempt Function Incm$385RelatedOrExemptFunctionIncmAmt

Gain Sales Ast Oth Than Invntry GainSalesAstOthThanInvntryGrp

FieldValueIRS element (for citing)
Related Or Exempt Function Incm$49,723RelatedOrExemptFunctionIncmAmt

Subtotals Incm Producing Acty SubtotalsIncmProducingActyGrp

FieldValueIRS element (for citing)
Unrelated Business Taxbl Incm$0UnrelatedBusinessTaxblIncmAmt
Exclusion$30,516ExclusionAmt
Related Or Exempt Function Incm$50,108RelatedOrExemptFunctionIncmAmt
FieldValueIRS element (for citing)
Total Income Producing Acty$80,624TotalIncomeProducingActyAmt

Rln Of Acty To Accom Of Exmpt Prps RlnOfActyToAccomOfExmptPrpsGrp

Rln Of Acty To Accom Of Exmpt Prps RlnOfActyToAccomOfExmptPrpsGrp (2 entries)

Line NumberLineNumberTxtRelationship StatementRelationshipStatementTxt
8EARNINGS FROM INVESTMENTS USED FOR EXEMPT PURPOSES
10EARNINGS FROM INVESTMENTS USED FOR EXEMPT PURPOSES

Trnsfr Trans Rln Nonchrtbl EO TrnsfrTransRlnNonchrtblEOGrp

FieldValueIRS element (for citing)
Trnsfr Of Cash To Nonchrtbl EO0TrnsfrOfCashToNonchrtblEOInd
Trnsfr Other Asset Nonchrtbl EO0TrnsfrOtherAssetNonchrtblEOInd
Sales Or Exchanges Of Assets0SalesOrExchangesOfAssetsInd
Purchase Of Assets Nonchrtbl EO0PurchaseOfAssetsNonchrtblEOInd
Rental Of Facilities Oth Assets0RentalOfFacilitiesOthAssetsInd
Reimbursement Arrangements0ReimbursementArrangementsInd
Loans Or Loan Guarantees0LoansOrLoanGuaranteesInd
Performance Of Services Etc0PerformanceOfServicesEtcInd
Sharing Of Facilities Etc0SharingOfFacilitiesEtcInd
Relationships Nonchrtbl EO0RelationshipsNonchrtblEOInd

Accounting Fees Schedule AccountingFeesSchedule

Accounting Fees Detail AccountingFeesDetail

FieldValueIRS element (for citing)
CategoryACCOUNTING FEESCategoryTxt
Amt$1,438Amt
Net Investment Income$0NetInvestmentIncomeAmt
Disbursements Charitable Prps$1,438DisbursementsCharitablePrpsAmt

Applied To Prior Year Election AppliedToPriorYearElection

FieldValueIRS element (for citing)
ElectionROSE AHLBRAND CHARITABLE TRUST HEREBY ELECTS $19,417 OF 2017'S QUALIFYING DISTRIBUTIONS TO BE APPLIED TO 2016'S UNDISTRIBUTED INCOME UNDER IRC SEC 4942.ElectionDesc

Investments Corp Stock Schedule InvestmentsCorpStockSchedule

Investments Corporate Stock InvestmentsCorporateStockGrp

FieldValueIRS element (for citing)
StockVARIOUS MUTUAL FUNDS - DETAILS MAINTAINEDStockNm
EOY Book Value$1,385,109EOYBookValueAmt
EOYFMV$1,647,521EOYFMVAmt

Other Income Schedule2 OtherIncomeSchedule2

Other Income Detail OtherIncomeDetail (2 entries)

DescDescRevenue And Expenses Per BooksRevenueAndExpensesPerBooksAmtNet Investment IncomeNetInvestmentIncomeAmtAdjusted Net IncomeAdjustedNetIncomeAmt
MISCELLANEOUS INCOME$97$97$97
FEDERAL REFUND$288$288$288

Taxes Schedule TaxesSchedule

Taxes Detail TaxesDetail (2 entries)

CategoryCategoryTxtAmtAmtNet Investment IncomeNetInvestmentIncomeAmtDisbursements Charitable PrpsDisbursementsCharitablePrpsAmt
EXCISE TAX$400$400$0
FOREIGN TAXES$99$99$0