Civic Intelligence

Red Wing Public School Parent Advis

EIN 86-1077922 • 501(c)3 • Red Wing, MN

Profile

Enrichment opportunities for rw students

2451 Eagle Ridge DrRed Wing, MN 55066
Siviq Scores

Precomputed percentiles relative to similar nonprofits. These scores are descriptive rather than judgmental.

Liabilities / Assets

59th percentile

0.00x

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

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

Liabilities / Revenue

61st percentile

0.00x

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

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

Net Margin

32nd percentile

-8.6%

Higher net margin than 32% of similar nonprofits.

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

Top Officer Pay

84th percentile

$0

Higher top officer pay than 84% of similar nonprofits.

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

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

Asset Growth

45th percentile

-4.8%

Faster asset growth than 45% of similar nonprofits.

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

Revenue Growth

88th percentile

67%

Faster revenue growth than 88% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets59th percentile

Assets

Down

$82,383

Down $4,181 (-4.8%) from 2015

Liabilities

Flat

$0

Flat from 2015

Net Assets

Down

$82,383

Down $4,181 (-4.8%) from 2015

Operations
Liabilities / Revenue61st percentileNet Margin32nd percentile

Revenue

Up

$48,524

Up $19,469 (+67%) from 2015

Expenses

Up

$52,705

Up $23,683 (+82%) from 2015

Net Income

Down

-$4,181

Down $4,214 (-12770%) from 2015

Trend Graphs

Balance Sheet Trend

Asset Growth45th percentile

Grouped bars show assets, liabilities, and net assets across loaded filings.

$100K$50K$0Assets 2012: $80,521Liabilities 2012: $0Net Assets 2012: $80,5212012Assets 2013: $95,613Liabilities 2013: $0Net Assets 2013: $95,6132013Assets 2014: $86,531Liabilities 2014: $0Net Assets 2014: $86,5312014Assets 2015: $86,564Liabilities 2015: $0Net Assets 2015: $86,5642015Assets 2016: $82,383Liabilities 2016: $0Net Assets 2016: $82,3832016

Highlighted filing

2016

Assets$82,383
Liabilities$0
Net Assets$82,383
Open 2016 Filing

Operations Trend

Revenue Growth88th percentile

Revenue, expenses, and net income by year, with the latest filing highlighted.

$60K$40K$20K$0-$20KRevenue 2012: $41,125Expenses 2012: $19,355Net Income 2012: $21,7702012Revenue 2013: $37,812Expenses 2013: $22,720Net Income 2013: $15,0922013Revenue 2014: $32,741Expenses 2014: $41,823Net Income 2014: -$9,0822014Revenue 2015: $29,055Expenses 2015: $29,022Net Income 2015: $332015Revenue 2016: $48,524Expenses 2016: $52,705Net Income 2016: -$4,1812016

Highlighted filing

2016

Revenue$48,524
Expenses$52,705
Net Income-$4,181
Open 2016 Filing

Filings

Most recent year

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

Open filing
Assets
$82,383
Liabilities
$0
Net assets
$82,383
Revenue
$48,524
Expenses
$52,705
Net income
-$4,181
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2016Detailed filing. Detailed filing data is available for this year.$82.4$0.00$82.4$48.5$52.7$4.18
2015Detailed filing. Detailed filing data is available for this year.$86.6$0.00$86.6$29.1$29.0$0.03
2014Detailed filing. Detailed filing data is available for this year.$86.5$0.00$86.5$32.7$41.8$9.08
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$95.6$0.00$95.6$37.8$22.7$15.1
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$80.5$0.00$80.5$41.1$19.4$21.8
Latest Filing Detail
Jump To
Filing Snapshot
Filing Period
Jul 1, 2015 to Jun 30, 2016
Signed
Nov 10, 2016
Return Version
2015v2.1
Gross Receipts
$86,334
Mission and Program Overview

Mission

Enrichment opportunities for rw students

Program Services

DescriptionGrantsExpenses
PROVIDING ENRICHMENT OPPORTUNITIES THROUGH FIELD TRIPS AND COOPERATIVE EFFORTS WITH THE SCIENCE MUSEUM EAGLE BLUFF QUARRY HILL THE YMCA AND OTHER SIMILAR ORGANIZATIONS-$24,832
ENHANCING STUDENTS LEARNING ENVIRONMENT AS WELL AS FULFILLING BASIC CLASSROOM NEEDS OF ALL STUDENTS IN THE RED WING PUBLIC SCHOOLS APPROX 3200 STUDENTS BENEFITED FROM THE PROGRA-$6,757
AUTHOR VISITS GIVE STUDENTS THE OPPORTUNITY TO MEET AUTHORS AND PROMOTE THE IMPORTANCE OF LITERACY-$2,050
Compensation and Service Providers
Top Officer Pay84th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
RACHEL MARSHALLTreasurer-$0--
MARTHA HARRISPresident-$0--
CHRIS MARSHALLVice President-$0--
LAURA SCHMIDTSecretary-$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Club Choice$42,947$42,947$26,606$16,341
Book Fair$11,785$11,785$11,204$581
Total Events$54,732$54,732$37,810$16,922
Filing and Contact Details

Filer

Filer Name
Red Wing Public School Parent Advis
EIN
86-1077922
Address
2451 EAGLE RIDGE DR, Red Wing, MN 55066

Signing Officer

Name
Rachel Marshall
Title
Treasurer
Phone
6513011344
Signed
2016-11-10
Discuss with paid preparer
Yes

Preparer

Firm
Liberty Tax Service
Address
3107 SOUTH SERVICE DR, Red Wing, MN 55066
Preparer
Nikki Shelstad
Phone
6513887197
Supplemental Narrative

Additional Explanations

Description of other expenses Part I line 16

“Description AmountAUTHOR VISIT 2,050TEACHER APPRECIATION 1,120PLAYGROUND AND CLASSROOM EQUIPMENT 2,078BANK CHARGES 381FIELD TRIPS 24,832BOOKS 3,349YEARBOOKS 5,364GRADUATION PARTY 11,492STUDENT PRIZES AND AWARDS 1,330MN ANNUAL REGISTRATION FEE 25”

Raw XML Appendix164 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/PersonNm0RACHEL MARSHALL
IRS990EZ/BooksInCareOfDetail/PhoneNum06513882280
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt02451 EAGLE RIDGE DR
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Red Wing
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MN
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd055066
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt086564
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt082383
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt021313
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-4181
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0295
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt086564
IRS990EZ/Form990TotalAssetsGrp/EOYAmt082383
IRS990EZ/FundraisingGrossIncomeAmt054732
IRS990EZ/GrossReceiptsAmt086334
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LandAndBuildingsGrp/BOYAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt086564
IRS990EZ/NetAssetsOrFundBalancesEOYAmt082383
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt086564
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt082383
IRS990EZ/OccupancyRentUtltsAndMaintAmt061
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.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/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0RACHEL MARSHALL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1MARTHA HARRIS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2CHRIS MARSHALL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3LAURA SCHMIDT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2VICE PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3SECRETARY
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt00
IRS990EZ/OtherAssetsTotalDetail/EOYAmt00
IRS990EZ/OtherExpensesTotalAmt052021
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0ENRICHMENT OPPORTUNITIES FOR RW STUDENTS
IRS990EZ/PrintingPublicationsPostageAmt0328
IRS990EZ/ProgramServiceRevenueAmt010289
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0PROVIDING ENRICHMENT OPPORTUNITIES THROUGH FIELD TRIPS AND COOPERATIVE EFFORTS WITH THE SCIENCE MUSEUM EAGLE BLUFF QUARRY HILL THE YMCA AND OTHER SIMILAR ORGANIZATIONS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1ENHANCING STUDENTS LEARNING ENVIRONMENT AS WELL AS FULFILLING BASIC CLASSROOM NEEDS OF ALL STUDENTS IN THE RED WING PUBLIC SCHOOLS APPROX 3200 STUDENTS BENEFITED FROM THE PROGRA
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt2AUTHOR VISITS GIVE STUDENTS THE OPPORTUNITY TO MEET AUTHORS AND PROMOTE THE IMPORTANCE OF LITERACY
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt024832
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt16757
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt22050
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt037810
IRS990EZ/SpecialEventsNetIncomeLossAmt016922
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0MN
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt052705
IRS990EZ/TotalProgramServiceExpensesAmt033639
IRS990EZ/TotalRevenueAmt048524
IRS990EZ/TransactionWithControlEntInd0false
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt021313
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt012950
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt015569
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt015827
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt012795
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt078454
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt065021
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt054225
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt048556
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt057877
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus4YearsAmt028933
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt0254612
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/InvestmentIncomePYPct00.00000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct01.00000
IRS990ScheduleA/PublicSupportPY509Pct01.00000
IRS990ScheduleA/PublicSupportTotal509Amt0333066
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt086334
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt067175
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt064125
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt073704
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt041728
IRS990ScheduleA/Total509Grp/TotalAmt0333066
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt086334
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt067175
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt064125
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt073704
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt041728
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0333066
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt037810
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0CLUB CHOICE
IRS990ScheduleG/FundraisingEventInformationGrp/Event2Nm0BOOK FAIR
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt042947
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent2Amt011785
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt054732
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt042947
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent2Amt011785
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt054732
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt016922
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt037810
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt026606
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent2Amt011204
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Description AmountAUTHOR VISIT 2,050TEACHER APPRECIATION 1,120PLAYGROUND AND CLASSROOM EQUIPMENT 2,078BANK CHARGES 381FIELD TRIPS 24,832BOOKS 3,349YEARBOOKS 5,364GRADUATION PARTY 11,492STUDENT PRIZES AND AWARDS 1,330MN ANNUAL REGISTRATION FEE 25
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Description of other expenses Part I line 16
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0RACHEL MARSHALL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum06513011344
ReturnHeader/BusinessOfficerGrp/SignatureDt02016-11-10
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0RED WING PUBLIC SCHOOL PARENT ADVIS
ReturnHeader/Filer/BusinessNameControlTxt0REDW
ReturnHeader/Filer/EIN0861077922
ReturnHeader/Filer/USAddress/AddressLine1Txt02451 EAGLE RIDGE DR
ReturnHeader/Filer/USAddress/CityNm0Red Wing
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MN
ReturnHeader/Filer/USAddress/ZIPCd055066
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0020662441
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0LIBERTY TAX SERVICE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt03107 SOUTH SERVICE DR
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Red Wing
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd055066
ReturnHeader/PreparerPersonGrp/PhoneNum06513887197
ReturnHeader/PreparerPersonGrp/PreparationDt02016-11-10
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0NIKKI SHELSTAD
ReturnHeader/ReturnTs02016-11-10T14:53:33-06:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02015-07-01
ReturnHeader/TaxPeriodEndDt02016-06-30
ReturnHeader/TaxYr02015

Document Assets

No mirrored PDF or thumbnail assets are attached yet.