Civic Intelligence

Aguilar Ross Foundation Ltd.

990PF • Fiscal year 2018 • EIN 39-1914688

Jul 01, 2017 to Jun 30, 2018 • Filed on Aug 31, 2018

5381 South 48th StreetGreenfield, WI 53220

(262) 574-5496

Siviq Scores

Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.

Liabilities / Assets

57th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2018 filings • 501(c)3 • <$500k nonprofits • Source year 2018

Liabilities / Revenue

56th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2018 filings • 501(c)3 • <$500k nonprofits • Source year 2018

Net Margin

66th percentile

12%

Higher net margin than 66% of similar nonprofits.

2018 filings • 501(c)3 • <$500k nonprofits • Source year 2018

Top Officer Pay

76th percentile

$0

Higher top officer pay than 76% of similar nonprofits.

Top officer pay equals 0.0% of source-year revenue.

2018 filings • 501(c)3 • <$500k nonprofits • Source year 2018

Asset Growth

55th percentile

4.0%

Faster asset growth than 55% of similar nonprofits.

2018 filings • 501(c)3 • <$500k nonprofits • Annualized from 2016 to 2018

Revenue Growth

Score unavailable

No value available

A valid growth rate could not be computed from the available filing history.

Annualized from 2016 to 2018

Assets

Up

$307,757

Up $23,476 (+8.3%) from 2016

Net Assets

$307,757

No earlier filing loaded for comparison.

Liabilities

Flat

$0

Flat from 2016

Revenue

Up

$47,509

Up $82,165 (+237%) from 2016

Expenses

Up

$41,894

Up $9,284 (+28%) from 2016

Net Income

Up

$5,615

Up $72,881 (+108%) from 2016

Historical Trend

Balance Sheet Trend

The highlighted filing sits inside the broader history for assets, liabilities, and net assets.

$600K$400K$200K$0Assets 2011: $252,023Liabilities 2011: $0Net Assets 2011: $252,0232011Assets 2012: $263,159Liabilities 2012: $0Net Assets 2012: $263,1592012Assets 2013: $268,065Liabilities 2013: $02013Assets 2014: $338,144Liabilities 2014: $02014Assets 2015: $351,547Liabilities 2015: $02015Assets 2016: $284,281Liabilities 2016: $02016Assets 2018: $307,757Liabilities 2018: $0Net Assets 2018: $307,7572018Assets 2020: $326,405Liabilities 2020: $0Net Assets 2020: $326,4052020Assets 2021: $364,580Liabilities 2021: $0Net Assets 2021: $364,5802021Assets 2022: $408,400Liabilities 2022: $0Net Assets 2022: $408,4002022Assets 2023: $433,739Liabilities 2023: $0Net Assets 2023: $433,7392023Assets 2024: $462,441Liabilities 2024: $0Net Assets 2024: $462,4412024Assets 2025: $479,145Liabilities 2025: $0Net Assets 2025: $479,1452025

Highlighted filing

2018

Assets$307,757
Liabilities$0
Net Assets$307,757

Operations Trend

Revenue, expenses, and net income across loaded years, with this filing highlighted.

$150K$100K$50K$0-$50K-$100KExpenses 2011: $31,4122011Expenses 2012: $36,6602012Revenue 2013: $53,451Expenses 2013: $48,545Net Income 2013: $4,9062013Revenue 2014: $117,449Expenses 2014: $47,370Net Income 2014: $70,0792014Revenue 2015: $58,751Expenses 2015: $45,348Net Income 2015: $13,4032015Revenue 2016: -$34,656Expenses 2016: $32,610Net Income 2016: -$67,2662016Revenue 2018: $47,509Expenses 2018: $41,894Net Income 2018: $5,6152018Revenue 2020: $22,501Expenses 2020: $42,692Net Income 2020: -$20,1912020Revenue 2021: $71,367Expenses 2021: $33,191Net Income 2021: $38,1762021Revenue 2022: $79,396Expenses 2022: $35,576Net Income 2022: $43,8202022Revenue 2023: $74,299Expenses 2023: $48,960Net Income 2023: $25,3392023Revenue 2024: $75,017Expenses 2024: $46,315Net Income 2024: $28,7022024Revenue 2025: $95,968Expenses 2025: $79,264Net Income 2025: $16,7042025

Highlighted filing

2018

Revenue$47,509
Expenses$41,894
Net Income$5,615
Jump To
Filing Snapshot
Filing Period
Jul 1, 2017 to Jun 30, 2018
Signed
Aug 31, 2018
Return Version
2017v2.2
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
FRANCISCO AGUILARPressec-$0--
ELIZABETH ROSSVP Treasurer-$0--
MARK SHILLERAsst Sec-$0--
JOHN EGANDirector-$0--
FRANCISCO AGUILAR JrDirector-$0--
MAI PHODirector-$0--
Filing and Contact Details

Filer

Filer Name
Aguilar Ross Foundation
EIN
39-1914688
Address
5381 SOUTH 48TH STREET, GREENFIELD, WI 53220

Signing Officer

Name
Francisco Aguilar
Title
Officer
Phone
4142320375
Signed
2018-08-31
Discuss with paid preparer
Yes

Preparer

Firm
Paul J Schilling CPA SC
Address
1744 Blackhawk Trail, Waukesha, WI 53186
Preparer
Paul J Schilling CPA
Phone
2625745496
Raw XML Appendix348 raw XML fields

This appendix keeps the raw XML leaves available for debugging and edge-case review. The human report above is the primary experience.

Path#Value
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt0292374
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt0366580
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0Marketable Securities
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt08063
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt010785
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt018848
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt018848
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt010784
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt033500
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt033500
IRS990PF/AnalysisOfRevenueAndExpenses/ContriRcvdRevAndExpnssAmt028662
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt08063
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt08063
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt05615
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt0268942
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt010784
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt012183
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncmAmt06664
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt08201
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0193
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt033500
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt06664
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt041894
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt018847
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt047509
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt06664
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt08394
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02018-06-30
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt12017-06-30
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt0137130
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt1121028
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0-1894
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt112678
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0-1894
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt112678
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt0135236
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt1133706
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd1P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0See Attached Schedule
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1See Attached Schedule
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02018-06-30
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12018-06-30
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt010784
IRS990PF/CapGainsLossTxInvstIncmDetail/NetShortTermCapitalGainLossAmt0-1894
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt05615
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0307757
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0302142
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0307757
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt018353
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt018353
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt018353
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt018597
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0244
IRS990PF/DistributableAmountGrp/TotalTaxAmt0244
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0244
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0244
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0244
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt0244
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/FMVAssetsEOYAmt0381963
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt011793
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt015383
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt015383
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0290349
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0292374
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0366580
IRS990PF/Form990PFBalanceSheetsGrp/OrganizationFollowsSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0302142
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0307757
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0381963
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0302142
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0307757
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0302142
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0307757
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedBOYAmt0302142
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedEOYAmt0307757
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0377603
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt013676
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0363927
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt05664
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt018597
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0371939
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0377603
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt10.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt20.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt30.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt40.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt50.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt30
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt40
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt50
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt30
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt40
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt50
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt30
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt40
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt50
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0FRANCISCO AGUILAR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1ELIZABETH ROSS
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm2MARK SHILLER
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm3JOHN EGAN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm4FRANCISCO AGUILAR Jr
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm5MAI PHO
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0PRESSEC
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1VP TREASURER
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt2ASST SEC
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt3DIRECTOR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt4DIRECTOR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt5DIRECTOR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt05381 S 48TH ST
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt15381 S 48TH ST
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt2111 EAST KILBOURN AVENUE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt31924 N 71ST STREET
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt4227 South Monroe Street
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt5227 South Monroe Street
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0Greenfield
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1Milwaukee
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm2Milwaukee
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm3Milwaukee
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm4Hinsdale
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm5Hinsdale
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0WI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1WI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd2WI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd3WI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd4IL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd5IL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd053220
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd153220
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd253202
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd353213
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd460521
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd560521
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt037324
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt037446
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt029700
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt026000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt036000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt040000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt040000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.100349
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.092336
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.088484
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.097621
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.105363
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.117939
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0122
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0371939
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0321653
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0293838
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0368773
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0379640
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0339157
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt033500
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.501743
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt033500
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt033500
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt033500
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistrIncmSect4942a2NotAppInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0true
IRS990PF/StatementsRegardingActyGrp/IndividualWithBooksNm0FRANCISCO AGUILAR
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt05381 S 48TH ST
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0Greenfield
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0WI
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd053220
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0true
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0WI
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PhoneNum04144210374
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/SummaryOfDirectChrtblActyGrp/Description1Txt0NA
IRS990PF/SummaryOfDirectChrtblActyGrp/Expenses1Amt00
IRS990PF/SumOfProgramRelatedInvstGrp/Description1Txt0None
IRS990PF/SumOfProgramRelatedInvstGrp/Expenses1Amt00
IRS990PF/SupplementaryInformationGrp/ContributingManagerNm0Francisco G Aguilar
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt033500
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0Support of the San Luis Medical Clinic in Mexico
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/AddressLine1Txt0Vallejo 640
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/CityNm0San Luis
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/CountryCd0MX
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/ProvinceOrStateNm0San Luis
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm0San Luis Medical Clinic
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0None
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/ShareholderManagerNm0None
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt033500
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd0false
IRS990PF/UndistributedIncomeGrp/AppliedToCurrentYearAmt018353
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt018353
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt013807
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt011396
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt017778
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr4Amt021832
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr5Amt023210
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt023210
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt079960
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt015147
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt013807
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt011396
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt017778
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt021832
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt033500
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt015147
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt0103170
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt088023
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990ScheduleB/ContributorInformationGrp/ContributorNum01
IRS990ScheduleB/ContributorInformationGrp/ContributorPersonNm0FRANCISCO G AGUILAR
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine1Txt05381 SOUTH 48TH STREET
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/CityNm0GREENFIELD
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/StateAbbreviationCd0WI
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCd053220
IRS990ScheduleB/ContributorInformationGrp/NoncashContributionInd0X
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt028662
IRS990ScheduleB/GeneralRuleInd0X
IRS990ScheduleB/NonCashPropertyContributionGrp/ContributorNum01
IRS990ScheduleB/NonCashPropertyContributionGrp/FairMarketValueAmt028662
IRS990ScheduleB/NonCashPropertyContributionGrp/NoncashPropertyDesc0363 Shares Walgreen Boots Alliance
IRS990ScheduleB/NonCashPropertyContributionGrp/ReceivedDt02017-09-26
IRS990ScheduleB/Organization501c3ExemptPFInd0X
OtherExpensesSchedule/OtherExpensesScheduleGrp/AdjustedNetIncomeAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/AdjustedNetIncomeAmt10
OtherExpensesSchedule/OtherExpensesScheduleGrp/AdjustedNetIncomeAmt20
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0Investment Fees
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc1Accounting Fees
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc2Bank Service Charges
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt10
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt20
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt06664
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt10
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt20
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt06664
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt11150
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt2387
SubstantialContributorsSch/SubstantialContributorDetail/PersonNm0Francisco G Aguilar
SubstantialContributorsSch/SubstantialContributorDetail/USAddress/AddressLine1Txt05381 South 48th Street
SubstantialContributorsSch/SubstantialContributorDetail/USAddress/CityNm0Milwaukee
SubstantialContributorsSch/SubstantialContributorDetail/USAddress/StateAbbreviationCd0WI
SubstantialContributorsSch/SubstantialContributorDetail/USAddress/ZIPCd053220
TaxesSchedule/TaxesDetail/AdjustedNetIncomeAmt00
TaxesSchedule/TaxesDetail/Amt0193
TaxesSchedule/TaxesDetail/CategoryTxt0Federal Income Tax
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0Francisco Aguilar
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0OFFICER
ReturnHeader/BusinessOfficerGrp/PhoneNum04142320375
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-08-31
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0AGUILAR ROSS FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0AGUI
ReturnHeader/Filer/EIN0391914688
ReturnHeader/Filer/USAddress/AddressLine1Txt05381 SOUTH 48TH STREET
ReturnHeader/Filer/USAddress/CityNm0GREENFIELD
ReturnHeader/Filer/USAddress/StateAbbreviationCd0WI
ReturnHeader/Filer/USAddress/ZIPCd053220
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0BEAF02BE3C6BA0234A8C6D599592CA03EBE33C43
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0BEAF02BE3C6BA0234A8C6D599592CA03EBE33C43
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId039110420182472kweskf
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02018-09-04
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0107.136.144.180
ReturnHeader/FilingSecurityInformation/IPDt02018-09-04
ReturnHeader/FilingSecurityInformation/IPTm010:27:36
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0264013461
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Paul J Schilling CPA SC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01744 Blackhawk Trail
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Waukesha
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0WI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd053186
ReturnHeader/PreparerPersonGrp/PhoneNum02625745496
ReturnHeader/PreparerPersonGrp/PreparationDt02018-09-04
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Paul J Schilling CPA
ReturnHeader/ReturnTs02018-09-04T10:25:47-04:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02017-07-01
ReturnHeader/TaxPeriodEndDt02018-06-30
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.$4.79$0.00$4.79$0.96$0.79$0.17
2024XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.62$0.00$4.62$0.75$0.46$0.29
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.34$0.00$4.34$0.74$0.49$0.25
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.08$0.00$4.08$0.79$0.36$0.44
2021Detailed filing. Detailed filing data is available for this year.$3.65$0.00$3.65$0.71$0.33$0.38
2020Detailed filing. Detailed filing data is available for this year.$3.26$0.00$3.26$0.23$0.43$0.20
2018Detailed filing. Detailed filing data is available for this year.$3.08$0.00$3.08$0.48$0.42$0.06
2016Summary only. Only limited summary data is available for this year.$2.84$0.00$0.35$0.33$0.67
2015Summary only. Only limited summary data is available for this year.$3.52$0.00$0.59$0.45$0.13
2014Summary only. Only limited summary data is available for this year.$3.38$0.00$1.17$0.47$0.70
2013Summary only. Only limited summary data is available for this year.$2.68$0.00$0.53$0.49$0.05
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$2.63$0.00$2.63$0.37
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$2.52$0.00$2.52$0.31