Civic Intelligence

Tan Foundation Inc

990EZ • Fiscal year 2017 • EIN 20-5261764

Apr 01, 2016 to Mar 31, 2017 • Filed on Jul 21, 2017

Organization ProfileN/A
412 South GumYuma, CO 80759

(970) 848-5447

Siviq Scores

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

Liabilities / Assets

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on this filing.

Source year 2017

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2017

Net Margin

1st percentile

-45456%

Higher net margin than 1% of similar nonprofits.

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

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.

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

Asset Growth

20th percentile

-21%

Faster asset growth than 20% of similar nonprofits.

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

Revenue Growth

1st percentile

-100%

Faster revenue growth than 1% of similar nonprofits.

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

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Down

$31,634

Down $8,182 (-21%) from 2016

Net Assets

Down

$31,634

Down $8,182 (-21%) from 2016

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin1st percentile

Revenue

Down

$18

Down $12,499 (-100%) from 2016

Expenses

Down

$8,200

Down $1,438 (-15%) from 2016

Net Income

Down

-$8,182

Down $11,061 (-384%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth20th percentile

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

$60K$40K$20K$0Assets 2011: $48,013Net Assets 2011: $48,0132011Assets 2012: $47,903Net Assets 2012: $47,9032012Assets 2013: $44,983Liabilities 2013: $02013Assets 2014: $49,802Net Assets 2014: $49,8022014Assets 2015: $36,937Net Assets 2015: $36,9372015Assets 2016: $39,816Net Assets 2016: $39,8162016Assets 2017: $31,634Net Assets 2017: $31,6342017Assets 2018: $30,958Net Assets 2018: $30,9582018Assets 2019: $22,322Net Assets 2019: $22,3222019

Highlighted filing

2017

Assets$31,634
Liabilities-
Net Assets$31,634
Open 2017 Filing

Operations Trend

Revenue Growth1st percentile

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

$30K$20K$10K$0-$10K-$20KRevenue 2011: $24,237Expenses 2011: $23,952Net Income 2011: $2852011Revenue 2012: $23,442Expenses 2012: $23,552Net Income 2012: -$1102012Revenue 2013: $12,138Expenses 2013: $15,058Net Income 2013: -$2,9202013Revenue 2014: $10,019Expenses 2014: $5,200Net Income 2014: $4,8192014Revenue 2015: $19Expenses 2015: $12,884Net Income 2015: -$12,8652015Revenue 2016: $12,517Expenses 2016: $9,638Net Income 2016: $2,8792016Revenue 2017: $18Expenses 2017: $8,200Net Income 2017: -$8,1822017Revenue 2018: $24Expenses 2018: $700Net Income 2018: -$6762018Revenue 2019: $5,081Expenses 2019: $13,716Net Income 2019: -$8,6352019

Highlighted filing

2017

Revenue$18
Expenses$8,200
Net Income-$8,182
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Apr 1, 2016 to Mar 31, 2017
Signed
Jul 21, 2017
Return Version
2016v3.0
Gross Receipts
$18
Mission and Program Overview

Mission

To support local youth education and athletics

To support youth education and athletics

Program Services

DescriptionGrantsExpenses
PROVIDED FINANCIAL ASSISTANCE TO SCHOOL AND COMMUNITY SPORTS PROGRAMS FOR THE BENEFIT OF LOCAL YOUTH.$4,550$4,550
PROVIDED COLLEGE SCHOLARSHIPS TO YUMA HIGH SCHOOL GRADUATES DURING THE CURRENT TAX YEAR.$3,000$3,000
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
STEVE COUGHLINPresident-$0--
RICK WHITEHEADSecretary-$0--
LYLE SMITHVice President-$0--
ROB HARDINGTreasurer-$0--
Filing and Contact Details

Filer

Filer Name
Tan Foundation Inc
EIN
20-5261764
Phone
9708485447
Address
412 SOUTH GUM, YUMA, CO 80759

Signing Officer

Name
Steve Coughlin
Title
President
Phone
9708485447
Signed
2017-07-21
Discuss with paid preparer
Yes

Preparer

Firm
Bohall Neubauer & Co
Address
PO Box 314, Wray, CO 80758
Preparer
Daniel Prentice CPA
Phone
9703325091
Supplemental Narrative

Additional Explanations

Form 990EZ, Part I, Line 10

“College scholarships; education; 2 college students: from local community, yuma, co, 80759; none, 30”

Form 990EZ, Part I, Line 10

“Community sport; community; school and community: sports teams, yuma, co, 80759; none, 4550.”

Raw XML Appendix153 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
IRS990EZ/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/PersonNm0STEVE COUGHLIN
IRS990EZ/BooksInCareOfDetail/PhoneNum09708485447
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0412 SOUTH GUM
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0YUMA
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0CO
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd080759
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt039816
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt031634
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt00
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-8182
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0650
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt039816
IRS990EZ/Form990TotalAssetsGrp/EOYAmt031634
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GainOrLossFromSaleOfAssetsAmt00
IRS990EZ/GamingGrossIncomeAmt00
IRS990EZ/GrantsAndSimilarAmountsPaidAmt07550
IRS990EZ/GrossProfitLossSlsOfInvntryAmt00
IRS990EZ/GrossReceiptsAmt018
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt018
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt00
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt039816
IRS990EZ/NetAssetsOrFundBalancesEOYAmt031634
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt039816
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt031634
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt02.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt31.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0STEVE COUGHLIN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1RICK WHITEHEAD
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2LYLE SMITH
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3ROB HARDING
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2VICE PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3TREASURER
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO SUPPORT YOUTH EDUCATION AND ATHLETICS
IRS990EZ/ProgramServiceRevenueAmt00
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0PROVIDED COLLEGE SCHOLARSHIPS TO YUMA HIGH SCHOOL GRADUATES DURING THE CURRENT TAX YEAR.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1PROVIDED FINANCIAL ASSISTANCE TO SCHOOL AND COMMUNITY SPORTS PROGRAMS FOR THE BENEFIT OF LOCAL YOUTH.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt03000
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt14550
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt03000
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt14550
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/SpecialEventsNetIncomeLossAmt00
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt08200
IRS990EZ/TotalProgramServiceExpensesAmt07550
IRS990EZ/TotalRevenueAmt018
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt012500
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt010000
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt012104
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt034604
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt00
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt018
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt017
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt019
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt019
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt034
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt0107
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt018
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt017
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt019
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt019
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt034
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt0107
IRS990ScheduleA/InvestmentIncomeCYPct00.00310
IRS990ScheduleA/InvestmentIncomePYPct00.00230
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00
IRS990ScheduleA/PublicSupportCY509Pct00.99690
IRS990ScheduleA/PublicSupportPY509Pct00.99770
IRS990ScheduleA/PublicSupportTotal170Amt00
IRS990ScheduleA/PublicSupportTotal509Amt034604
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt012500
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt010000
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt012104
IRS990ScheduleA/Total509Grp/TotalAmt034604
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt034711
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0COLLEGE SCHOLARSHIPS; EDUCATION; 2 COLLEGE STUDENTS: FROM LOCAL COMMUNITY, YUMA, CO, 80759; NONE, 30
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1COMMUNITY SPORT; COMMUNITY; SCHOOL AND COMMUNITY: SPORTS TEAMS, YUMA, CO, 80759; NONE, 4550.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Form 990EZ, Part I, Line 10
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Form 990EZ, Part I, Line 10
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0STEVE COUGHLIN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum09708485447
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-07-21
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0TAN FOUNDATION INC
ReturnHeader/Filer/BusinessNameControlTxt0TANF
ReturnHeader/Filer/EIN0205261764
ReturnHeader/Filer/PhoneNum09708485447
ReturnHeader/Filer/USAddress/AddressLine1Txt0412 SOUTH GUM
ReturnHeader/Filer/USAddress/CityNm0YUMA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0CO
ReturnHeader/Filer/USAddress/ZIPCd080759
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0AE010EB1814B52B571107CFF278CB28C4B102315
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId010A7952E695E3543AB81882CD9F542501A93FB48
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt067.214.192.241
ReturnHeader/FilingSecurityInformation/IPDt02017-08-07
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0PD
ReturnHeader/FilingSecurityInformation/IPTm010:57:36
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Bohall Neubauer & Co
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0PO Box 314
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Wray
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0CO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd080758
ReturnHeader/PreparerPersonGrp/PhoneNum09703325091
ReturnHeader/PreparerPersonGrp/PreparationDt02017-08-07
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0DANIEL PRENTICE CPA
ReturnHeader/ReturnTs02017-08-07T10:57:49-07:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02016-04-01
ReturnHeader/TaxPeriodEndDt02017-03-31
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2017 • Form 990EZDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$31,634
Liabilities
-
Net assets
$31,634
Revenue
$18
Expenses
$8,200
Net income
-$8,182
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2019Detailed filing. Detailed filing data is available for this year.$22.3$22.3$5.08$13.7$8.64
2018Detailed filing. Detailed filing data is available for this year.$31.0$31.0$0.02$0.70$0.68
2017Detailed filing. Detailed filing data is available for this year.$31.6$31.6$0.02$8.20$8.18
2016Detailed filing. Detailed filing data is available for this year.$39.8$39.8$12.5$9.64$2.88
2015Detailed filing. Detailed filing data is available for this year.$36.9$36.9$0.02$12.9$12.9
2014Detailed filing. Detailed filing data is available for this year.$49.8$49.8$10.0$5.20$4.82
2013Summary only. Only limited summary data is available for this year.$45.0$0.00$12.1$15.1$2.92
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$47.9$47.9$23.4$23.6$0.11
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$48.0$48.0$24.2$24.0$0.29