Civic Intelligence

Tan Foundation Inc

990EZ • Fiscal year 2018 • EIN 20-5261764

Apr 01, 2017 to Mar 31, 2018 • Filed on Aug 26, 2018

Organization ProfileN/A
5180 Old Post RoadYuma, CO 80759

(970) 231-6160

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 2018

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2018

Net Margin

1st percentile

-2817%

Higher net margin than 1% 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

41st percentile

-2.1%

Faster asset growth than 41% of similar nonprofits.

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

Revenue Growth

80th percentile

33%

Faster revenue growth than 80% of similar nonprofits.

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

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Down

$30,958

Down $676 (-2.1%) from 2017

Net Assets

Down

$30,958

Down $676 (-2.1%) from 2017

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin1st percentile

Revenue

Up

$24

Up $6 (+33%) from 2017

Expenses

Down

$700

Down $7,500 (-91%) from 2017

Net Income

Up

-$676

Up $7,506 (+92%) from 2017

Historical Trend

Balance Sheet Trend

Asset Growth41st 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

2018

Assets$30,958
Liabilities-
Net Assets$30,958
Open 2018 Filing

Operations Trend

Revenue Growth80th 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

2018

Revenue$24
Expenses$700
Net Income-$676
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Apr 1, 2017 to Mar 31, 2018
Signed
Aug 26, 2018
Return Version
2017v2.3
Gross Receipts
$24
Mission and Program Overview

Mission

To support local youth education and athletics

Program Services

DescriptionGrantsExpenses
PROVIDE FINANCIAL ASSISTANCE TO SCHOOL AND COMMUNITY SPORTS PROGRAMS FOR THE BENEFIT OF LOCAL YOUTH.$300$700
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

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

Filer

Filer Name
Tan Foundation Inc
EIN
20-5261764
Phone
9702316160
Address
5180 OLD POST ROAD, YUMA, CO 80759

Signing Officer

Name
Steve Coughlin
Title
President
Phone
9702316160
Signed
2018-08-26
Discuss with paid preparer
Yes

Preparer

Firm
Bohall Neubauer & Co
Address
206 MAIN ST, WRAY, CO 80758-0314
Preparer
Daniel Prentice CPA
Phone
9703325091
Raw XML Appendix141 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/AddressChangeInd0X
IRS990EZ/BooksInCareOfDetail/PersonNm0STEVE COUGHLIN
IRS990EZ/BooksInCareOfDetail/PhoneNum09702316160
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt05180 OLD POST ROAD
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0YUMA
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0CO
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd080759
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt031634
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt030958
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-676
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0400
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt031634
IRS990EZ/Form990TotalAssetsGrp/EOYAmt030958
IRS990EZ/GrantsAndSimilarAmountsPaidAmt0300
IRS990EZ/GrossReceiptsAmt024
IRS990EZ/InvestmentIncomeAmt024
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt031634
IRS990EZ/NetAssetsOrFundBalancesEOYAmt030958
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt031634
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt030958
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt32.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0ROBERT HARDING
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1LYLE SMITH
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2RICK WHITEHEAD
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3STEVE COUGHLIN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1VICE PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3PRESIDENT
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO SUPPORT LOCAL YOUTH EDUCATION AND ATHLETICS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0PROVIDE FINANCIAL ASSISTANCE TO SCHOOL AND COMMUNITY SPORTS PROGRAMS FOR THE BENEFIT OF LOCAL YOUTH.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt0300
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt0700
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0CO
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0700
IRS990EZ/TotalProgramServiceExpensesAmt0700
IRS990EZ/TotalRevenueAmt024
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt012500
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt010000
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt022500
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt024
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt018
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt017
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt019
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt019
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt097
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt024
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt024
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt024
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt018
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt017
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt019
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt019
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt097
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/InvestmentIncomePYPct00.00000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.99570
IRS990ScheduleA/PublicSupportPY509Pct00.99770
IRS990ScheduleA/PublicSupportTotal509Amt022524
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt024
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt012500
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt010000
IRS990ScheduleA/Total509Grp/TotalAmt022524
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt048
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt018
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt012517
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt019
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt010019
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt022621
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0STEVE COUGHLIN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum09702316160
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-08-26
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0TAN FOUNDATION INC
ReturnHeader/Filer/BusinessNameControlTxt0TANF
ReturnHeader/Filer/EIN0205261764
ReturnHeader/Filer/PhoneNum09702316160
ReturnHeader/Filer/USAddress/AddressLine1Txt05180 OLD POST ROAD
ReturnHeader/Filer/USAddress/CityNm0YUMA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0CO
ReturnHeader/Filer/USAddress/ZIPCd080759
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0AE010EB1814B52B571107CFF278CB28C4B102315
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0DF3B33C1091E24A75AC7625B6BB98AD2B53AD600
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt064.37.18.247
ReturnHeader/FilingSecurityInformation/IPDt02018-09-04
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm011:59:22
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0454035568
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0BOHALL NEUBAUER & CO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0206 MAIN ST
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0WRAY
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0CO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0807580314
ReturnHeader/PreparerPersonGrp/PhoneNum09703325091
ReturnHeader/PreparerPersonGrp/PreparationDt02018-09-04
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0DANIEL PRENTICE CPA
ReturnHeader/ReturnTs02018-09-04T10:59:22-06:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-04-01
ReturnHeader/TaxPeriodEndDt02018-03-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$30,958
Liabilities
-
Net assets
$30,958
Revenue
$24
Expenses
$700
Net income
-$676
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