Civic Intelligence

Tribute to the Troops

990EZ • Fiscal year 2017 • EIN 20-4803227

Jan 01, 2017 to Dec 31, 2017 • Filed on May 11, 2018

19980 Lakeview AveExcelsior, MN 55014-0326

(612) 991-5928

Siviq Scores

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

Liabilities / Assets

56th percentile

0.00x

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

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

Liabilities / Revenue

56th percentile

0.00x

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

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

Net Margin

1st percentile

-1105%

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

6th percentile

-62%

Faster asset growth than 6% of similar nonprofits.

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

Revenue Growth

3rd percentile

-88%

Faster revenue growth than 3% of similar nonprofits.

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

Assets

Down

$106,857

Down $174,311 (-62%) from 2016

Net Assets

Down

$106,857

Down $174,311 (-62%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue

Down

$15,768

Down $114,490 (-88%) from 2016

Expenses

Up

$190,079

Up $145,906 (+330%) from 2016

Net Income

Down

-$174,311

Down $260,396 (-302%) from 2016

Historical Trend

Balance Sheet Trend

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

$1.0M$500K$0Assets 2010: $147,290Liabilities 2010: $02010Assets 2011: $103,432Liabilities 2011: $02011Assets 2012: $94,271Liabilities 2012: $02012Assets 2013: $123,757Liabilities 2013: $02013Assets 2014: $172,007Liabilities 2014: $02014Assets 2015: $195,083Liabilities 2015: $02015Assets 2016: $281,168Liabilities 2016: $0Net Assets 2016: $281,1682016Assets 2017: $106,857Liabilities 2017: $0Net Assets 2017: $106,8572017Assets 2018: $794,951Liabilities 2018: $0Net Assets 2018: $794,9512018Assets 2019: $846,071Liabilities 2019: $0Net Assets 2019: $846,0712019Assets 2020: $788,437Liabilities 2020: $0Net Assets 2020: $788,4372020Assets 2021: $747,742Liabilities 2021: $0Net Assets 2021: $747,7422021Assets 2022: $751,728Liabilities 2022: $0Net Assets 2022: $751,7282022Assets 2023: $754,359Liabilities 2023: $0Net Assets 2023: $754,3592023Assets 2024: $776,013Liabilities 2024: $0Net Assets 2024: $776,0132024

Highlighted filing

2017

Assets$106,857
Liabilities$0
Net Assets$106,857

Operations Trend

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

$200K$100K$0-$100K-$200KRevenue 2010: $47,890Expenses 2010: $60,275Net Income 2010: -$12,3852010Revenue 2011: $59,002Expenses 2011: $102,860Net Income 2011: -$43,8582011Revenue 2012: $34,162Expenses 2012: $43,323Net Income 2012: -$9,1612012Revenue 2013: $98,895Expenses 2013: $69,409Net Income 2013: $29,4862013Revenue 2014: $118,890Expenses 2014: $70,640Net Income 2014: $48,2502014Revenue 2015: $133,258Expenses 2015: $110,182Net Income 2015: $23,0762015Revenue 2016: $130,258Expenses 2016: $44,173Net Income 2016: $86,0852016Revenue 2017: $15,768Expenses 2017: $190,079Net Income 2017: -$174,3112017Revenue 2018: $138,275Expenses 2018: $152,950Net Income 2018: -$14,6752018Revenue 2019: $132,176Expenses 2019: $81,056Net Income 2019: $51,1202019Revenue 2020: $23,878Expenses 2020: $81,512Net Income 2020: -$57,6342020Revenue 2021: $40,840Expenses 2021: $81,535Net Income 2021: -$40,6952021Revenue 2022: $44,429Expenses 2022: $40,443Net Income 2022: $3,9862022Revenue 2023: $36,585Expenses 2023: $41,253Net Income 2023: -$4,6682023Revenue 2024: $107,065Expenses 2024: $85,411Net Income 2024: $21,6542024

Highlighted filing

2017

Revenue$15,768
Expenses$190,079
Net Income-$174,311
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
May 11, 2018
Return Version
2017v2.2
Gross Receipts
$15,768
Mission and Program Overview

Mission

See mission statement attached

Program Services

DescriptionGrantsExpenses
AMOUNTS PAID TO OR IN SUPPORT OF FAMILIES WHO HAVE LOST A FAMILY MEMBER IN SERVICE TO OUR COUNTRY AND OTHER ORGANIZATIONS IN SUPPORT OF OUR TROOPS$189,000$1,079
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
ROBERT SWANSONChairPT$0--
STEVE PERKINSTreasPT$0--
DIANNA BEARDSLEYSecyPT$0--
Filing and Contact Details

Filer

Filer Name
Tribute to the Troops
EIN
20-4803227
Address
19980 LAKEVIEW AVE, EXCELSIOR, MN 55014-0326

Signing Officer

Name
Robert Swanson
Title
Chair
Phone
6512108354
Signed
2018-05-11
Discuss with paid preparer
Yes

Preparer

Firm
Gerald R Caputa CPA
Address
14735 77TH Place N, Maple Grove, MN 55311
Preparer
Gerald R Caputa
Phone
7634204937
Supplemental Narrative

Additional Explanations

General explanation attachment

ART 1, LINE 10 THERE ARE NO RELATIONSHIPS TO ANY INDIVIDUALS THAT RECEIVED GRANTS. ALL OTHER DISTRIBUTIONS TO ANY INDIVIDUAL WERE LESS THAN $ 5000.00 TOTAL $161000.00 MISSION STATEMENTThe TRIBUTE TO THE TROOPS activities and fund raising is dedicated to those bravesoldiers who made the ultimate sacrifice in service to our country. Our focus is togratefully and graciously demonstrate to loved ones left behind that we, asordinary Americans, will not forget their loss. It is in their memory and honorthat we raise awareness and funds for the benefit and comfort of those whocontinue to serve. Through these efforts we convey our gratefullness andappreciation to all veterans who have served, whether in war, or in peace.

List of grants and similar amounts paid Part I line 10

Activity 529 EDUCATION PLANS Grantee TYLER HILL Street 17966 NIXON COURT NW City, State, Zip Elk River, MN 55330Relationship NO RELATIONSHIP Amount 14,000Activity 529 EDUCATION PLANS Grantee TRISTIAN HILL Street 17966 NIXON COURT NW City, State, Zip Elk River, MN 55330Amount 14,000Relationship ALL AMOUNTS LESS THAN 5000.00 Amount 161,000

Raw XML Appendix156 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 PERKINS
IRS990EZ/BooksInCareOfDetail/PhoneNum06129915928
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt019980 LAKEVIEW AVE
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Excelsior
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MN
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd0553319294
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0281168
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0106857
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt014891
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-174311
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0281168
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0106857
IRS990EZ/GrantsAndSimilarAmountsPaidAmt0189000
IRS990EZ/GrossReceiptsAmt015768
IRS990EZ/GroupExemptionNum05992
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LandAndBuildingsGrp/BOYAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt0877
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0281168
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0106857
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0281168
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0106857
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt05.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt15.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt25.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0ROBERT SWANSON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1STEVE PERKINS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2DIANNA BEARDSLEY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0CHAIR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1TREAS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECY
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt00
IRS990EZ/OtherAssetsTotalDetail/EOYAmt00
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0SEE MISSION STATEMENT ATTACHED
IRS990EZ/PrintingPublicationsPostageAmt01079
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0AMOUNTS PAID TO OR IN SUPPORT OF FAMILIES WHO HAVE LOST A FAMILY MEMBER IN SERVICE TO OUR COUNTRY AND OTHER ORGANIZATIONS IN SUPPORT OF OUR TROOPS
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt0189000
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt01079
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0MN
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0190079
IRS990EZ/TotalProgramServiceExpensesAmt01079
IRS990EZ/TotalRevenueAmt015768
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWWTRIBUTETOTHETROOPS.ORG
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt015768
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt0132288
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt0129491
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt0116190
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt096979
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0490716
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt0537
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt0537
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt09220
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt013474
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt02700
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus4YearsAmt01916
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt027310
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt0537
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt0537
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/InvestmentIncomePYPct00.00000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.99900
IRS990ScheduleA/PublicSupportPY509Pct00.99900
IRS990ScheduleA/PublicSupportTotal509Amt0518026
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt015768
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt0141508
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt0142965
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt0118890
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt098895
IRS990ScheduleA/Total509Grp/TotalAmt0518026
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt015768
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt0141508
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt0143502
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt0118890
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt098895
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0518563
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0ART 1, LINE 10 THERE ARE NO RELATIONSHIPS TO ANY INDIVIDUALS THAT RECEIVED GRANTS. ALL OTHER DISTRIBUTIONS TO ANY INDIVIDUAL WERE LESS THAN $ 5000.00 TOTAL $161000.00 MISSION STATEMENTThe TRIBUTE TO THE TROOPS activities and fund raising is dedicated to those bravesoldiers who made the ultimate sacrifice in service to our country. Our focus is togratefully and graciously demonstrate to loved ones left behind that we, asordinary Americans, will not forget their loss. It is in their memory and honorthat we raise awareness and funds for the benefit and comfort of those whocontinue to serve. Through these efforts we convey our gratefullness andappreciation to all veterans who have served, whether in war, or in peace.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Activity 529 EDUCATION PLANS Grantee TYLER HILL Street 17966 NIXON COURT NW City, State, Zip Elk River, MN 55330Relationship NO RELATIONSHIP Amount 14,000Activity 529 EDUCATION PLANS Grantee TRISTIAN HILL Street 17966 NIXON COURT NW City, State, Zip Elk River, MN 55330Amount 14,000Relationship ALL AMOUNTS LESS THAN 5000.00 Amount 161,000
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0General explanation attachment
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1List of grants and similar amounts paid Part I line 10
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0ROBERT SWANSON
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0CHAIR
ReturnHeader/BusinessOfficerGrp/PhoneNum06512108354
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-05-11
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0TRIBUTE TO THE TROOPS
ReturnHeader/Filer/BusinessNameControlTxt0TRIB
ReturnHeader/Filer/EIN0204803227
ReturnHeader/Filer/USAddress/AddressLine1Txt019980 LAKEVIEW AVE
ReturnHeader/Filer/USAddress/CityNm0EXCELSIOR
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MN
ReturnHeader/Filer/USAddress/ZIPCd0550140326
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId05CCC3B23F300E7C399B482A3CB11F39A2990A37C
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId05CCC3B23F300E7C399B482A3CB11F39A2990A37C
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId04151552018256icedvow
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02018-09-13
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt024.7.255.99
ReturnHeader/FilingSecurityInformation/IPDt02018-09-13
ReturnHeader/FilingSecurityInformation/IPTm011:39:35
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Gerald R Caputa CPA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt014735 77TH Place N
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Maple Grove
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd055311
ReturnHeader/PreparerPersonGrp/PhoneNum07634204937
ReturnHeader/PreparerPersonGrp/PreparationDt02018-08-07
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Gerald R Caputa
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02018-08-07T18:57:02-04:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Facts available. Structured filing facts are available, but richer extracted sections are limited.$7.76$0.00$7.76$1.07$0.85$0.22
2023Detailed filing. Detailed filing data is available for this year.$7.54$0.00$7.54$0.37$0.41$0.05
2022Detailed filing. Detailed filing data is available for this year.$7.52$0.00$7.52$0.44$0.40$0.04
2021Detailed filing. Detailed filing data is available for this year.$7.48$0.00$7.48$0.41$0.82$0.41
2020Detailed filing. Detailed filing data is available for this year.$7.88$0.00$7.88$0.24$0.82$0.58
2019Detailed filing. Detailed filing data is available for this year.$8.46$0.00$8.46$1.32$0.81$0.51
2018Detailed filing. Detailed filing data is available for this year.$7.95$0.00$7.95$1.38$1.53$0.15
2017Detailed filing. Detailed filing data is available for this year.$1.07$0.00$1.07$0.16$1.90$1.74
2016Detailed filing. Detailed filing data is available for this year.$2.81$0.00$2.81$1.30$0.44$0.86
2015Summary only. Only limited summary data is available for this year.$1.95$0.00$1.33$1.10$0.23
2014Summary only. Only limited summary data is available for this year.$1.72$0.00$1.19$0.71$0.48
2013Summary only. Only limited summary data is available for this year.$1.24$0.00$0.99$0.69$0.29
2012Summary only. Only limited summary data is available for this year.$0.94$0.00$0.34$0.43$0.09
2011Summary only. Only limited summary data is available for this year.$1.03$0.00$0.59$1.03$0.44
2010Summary only. Only limited summary data is available for this year.$1.47$0.00$0.48$0.60$0.12