Civic Intelligence

Somerset Scholarship Fund

990EZ • Fiscal year 2013 • EIN 45-4617048

Jan 01, 2013 to Dec 31, 2013 • Filed on Apr 24, 2014

Organization ProfileN/A
1416 Dodd Road55118

(612) 457-1416

Siviq Scores

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

Liabilities / Assets

55th percentile

0.00x

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

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

Liabilities / Revenue

56th percentile

0.00x

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

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

Net Margin

63rd percentile

9.1%

Higher net margin than 63% of similar nonprofits.

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

Top Officer Pay

73rd percentile

$0

Higher top officer pay than 73% of similar nonprofits.

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

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

Asset Growth

57th percentile

5.7%

Faster asset growth than 57% of similar nonprofits.

2013 filings • 501(c)3 • <$500k nonprofits • Annualized from 2012 to 2013

Revenue Growth

6th percentile

-60%

Faster revenue growth than 6% of similar nonprofits.

2013 filings • 501(c)3 • <$500k nonprofits • Annualized from 2012 to 2013

Balance Sheet
Liabilities / Assets55th percentile

Assets

Up

$62,092

Up $3,343 (+5.7%) from 2012

Net Assets

Up

$62,092

Up $3,343 (+5.7%) from 2012

Liabilities

Flat

$0

Flat from 2012

Revenue And Expenses
Liabilities / Revenue56th percentileNet Margin63rd percentile

Revenue

Down

$36,816

Down $56,278 (-60%) from 2012

Expenses

Down

$33,473

Down $872 (-2.5%) from 2012

Net Income

Down

$3,343

Down $55,406 (-94%) from 2012

Historical Trend

Balance Sheet Trend

Asset Growth57th percentile

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

$200K$150K$100K$50K$0Assets 2011: $1Liabilities 2011: $02011Assets 2012: $58,749Liabilities 2012: $0Net Assets 2012: $58,7492012Assets 2013: $62,092Liabilities 2013: $0Net Assets 2013: $62,0922013Assets 2014: $73,118Liabilities 2014: $0Net Assets 2014: $73,1182014Assets 2015: $70,738Liabilities 2015: $0Net Assets 2015: $70,7382015Assets 2016: $87,131Liabilities 2016: $0Net Assets 2016: $87,1312016Assets 2017: $61,121Liabilities 2017: $0Net Assets 2017: $61,1212017Assets 2018: $71,349Liabilities 2018: $0Net Assets 2018: $71,3492018Assets 2019: $80,332Liabilities 2019: $0Net Assets 2019: $80,3322019Assets 2020: $94,918Liabilities 2020: $0Net Assets 2020: $94,9182020Assets 2021: $123,672Liabilities 2021: $0Net Assets 2021: $123,6722021Assets 2022: $147,678Liabilities 2022: $0Net Assets 2022: $147,6782022Assets 2023: $153,201Liabilities 2023: $02023Assets 2025: $59,394Liabilities 2025: $0Net Assets 2025: $59,3942025

Highlighted filing

2013

Assets$62,092
Liabilities$0
Net Assets$62,092
Open 2013 Filing

Operations Trend

Revenue Growth6th percentile

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

$150K$100K$50K$0-$50KRevenue 2011: $0Expenses 2011: $0Net Income 2011: $02011Revenue 2012: $93,094Expenses 2012: $34,345Net Income 2012: $58,7492012Revenue 2013: $36,816Expenses 2013: $33,473Net Income 2013: $3,3432013Revenue 2014: $53,734Expenses 2014: $42,708Net Income 2014: $11,0262014Revenue 2015: $53,909Expenses 2015: $56,289Net Income 2015: -$2,3802015Revenue 2016: $79,103Expenses 2016: $62,710Net Income 2016: $16,3932016Revenue 2017: $48,482Expenses 2017: $74,492Net Income 2017: -$26,0102017Revenue 2018: $81,099Expenses 2018: $70,871Net Income 2018: $10,2282018Revenue 2019: $103,295Expenses 2019: $94,312Net Income 2019: $8,9832019Revenue 2020: $98,177Expenses 2020: $83,591Net Income 2020: $14,5862020Revenue 2021: $120,322Expenses 2021: $91,568Net Income 2021: $28,7542021Revenue 2022: $97,438Expenses 2022: $73,432Net Income 2022: $24,0062022Revenue 2023: $97,041Expenses 2023: $91,518Net Income 2023: $5,5232023Revenue 2025: $96,813Expenses 2025: $137,893Net Income 2025: -$41,0802025

Highlighted filing

2013

Revenue$36,816
Expenses$33,473
Net Income$3,343
Open 2013 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2013 to Dec 31, 2013
Signed
Apr 24, 2014
Return Version
2013v3.0
Gross Receipts
$36,816
Mission and Program Overview

Mission

Somerset scholarship fund is organized and operated to raise funds from members of somerset country club that are used to provide scholarships to employees or decendants of such employees, of somerset country club, which is a 503(c)(7) organization. Members of somerset country club, the club manager, the board of directors, officers, and committee members are not eligible to be scholarship receipients.

Program Services

DescriptionGrantsExpenses
TO PROVIDE FUNDS TO FINANCE OR AID IN FINANCING , THE POST-SECONDARY UNDERGRADUATE EDUCATION OF ONE OR MORE QUALIFIED APPLICANTS AT ANY ACCREDITED TWO YEAR OR FOUR YEAR COLLEGE, UNIVERSITY OR VOCATIONAL/TECHNICAL SCHOOL.$31,000$33,473
Compensation and Service Providers
Top Officer Pay73rd percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
BERT J MCKASYPresident-$0--
JOYCE GRANNISSecretary-$0--
JAMES P WICKERTreasurer-$0--
JAKE CRANDALLDirector-$0--
ANNE M FIELDDirector-$0--
Filing and Contact Details

Filer

EIN
45-4617048
Phone
6124571416

Signing Officer

Name
Bert Mckasy
Title
President
Phone
6124571416
Signed
2014-04-24
Discuss with paid preparer
Yes

Preparer

Preparer
Daniel J Flicek
Phone
6512276695
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 4 - Other Investment Income

“Description: interest income. Amount: 76.”

Form 990-ez, Part I, Line 16 - Other Expenses

“Description: bank charges. Amount: 85. Description: insurance. Amount: 1,000. Description: office supplies. Amount: 425. Total to form 990-ez, line 16: 1,510.”

Raw XML Appendix144 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/ActivitiesNotPreviouslyRptInd00
IRS990EZ/BooksInCareOfDetail/PersonNm0TIM KUMEROW
IRS990EZ/BooksInCareOfDetail/PhoneNum06514571416
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine101416 DODD ROAD
IRS990EZ/BooksInCareOfDetail/USAddress/City0MENDOTA HEIGHTS
IRS990EZ/BooksInCareOfDetail/USAddress/State0MN
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCode055118
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt058749
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt062092
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd00
IRS990EZ/ContributionsGiftsGrantsEtcAmt036740
IRS990EZ/DirectIndirectPltclExpendAmt00
IRS990EZ/DonorAdvisedFndsInd00
IRS990EZ/EngagedInExcessBenefitTransInd00
IRS990EZ/ExcessOrDeficitForYearAmt03343
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0863
IRS990EZ/FiledScheduleAInd01
IRS990EZ/ForeignFinancialAccountInd00
IRS990EZ/ForeignOfficeInd00
IRS990EZ/Form990TotalAssetsGrp/BOYAmt058749
IRS990EZ/Form990TotalAssetsGrp/EOYAmt062092
IRS990EZ/GrantsAndSimilarAmountsPaidAmt031000
IRS990EZ/GrossReceiptsAmt036816
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InfoInScheduleOPartVInd0X
IRS990EZ/InvestmentIncomeAmt076
IRS990EZ/LobbyingActivitiesInd00
IRS990EZ/MadeLoansToFromOfficersInd00
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt058749
IRS990EZ/NetAssetsOrFundBalancesEOYAmt062092
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt058749
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt062092
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt02.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt12.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt31.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt41.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0BERT J MCKASY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1JOYCE GRANNIS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2JAMES P WICKER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3JAKE CRANDALL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4ANNE M FIELD
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4DIRECTOR
IRS990EZ/OperateHospitalInd00
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd00
IRS990EZ/OrganizationHadUBIInd00
IRS990EZ/OtherChangesInNetAssetsAmt00
IRS990EZ/OtherExpensesTotalAmt01510
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd00
IRS990EZ/PrimaryExemptPurposeTxt0SOMERSET SCHOLARSHIP FUND IS ORGANIZED AND OPERATED TO RAISE FUNDS FROM MEMBERS OF SOMERSET COUNTRY CLUB THAT ARE USED TO PROVIDE SCHOLARSHIPS TO EMPLOYEES OR DECENDANTS OF SUCH EMPLOYEES, OF SOMERSET COUNTRY CLUB, WHICH IS A 503(C)(7) ORGANIZATION. MEMBERS OF SOMERSET COUNTRY CLUB, THE CLUB MANAGER, THE BOARD OF DIRECTORS, OFFICERS, AND COMMITTEE MEMBERS ARE NOT ELIGIBLE TO BE SCHOLARSHIP RECEIPIENTS.
IRS990EZ/PrintingPublicationsPostageAmt0100
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0TO PROVIDE FUNDS TO FINANCE OR AID IN FINANCING , THE POST-SECONDARY UNDERGRADUATE EDUCATION OF ONE OR MORE QUALIFIED APPLICANTS AT ANY ACCREDITED TWO YEAR OR FOUR YEAR COLLEGE, UNIVERSITY OR VOCATIONAL/TECHNICAL SCHOOL.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt031000
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt033473
IRS990EZ/ProhibitedTaxShelterTransInd00
IRS990EZ/RelatedOrganizationCtrlEntInd00
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd00
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0MN
IRS990EZ/SubjectToProxyTaxInd00
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd00
IRS990EZ/TaxImposedOnOrganizationMgrAmt00
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TaxReimbursedByOrganizationAmt00
IRS990EZ/TotalExpensesAmt033473
IRS990EZ/TotalProgramServiceExpensesAmt033473
IRS990EZ/TotalRevenueAmt036816
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd00
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/First5Years170Ind0X
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt036740
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt093094
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt0129834
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearAmt076
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus1YearAmt046
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt0122
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportTotal170Amt0129834
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt036740
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt093094
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt0129834
IRS990ScheduleA/TotalSupportAmt0129956
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0DESCRIPTION: INTEREST INCOME. AMOUNT: 76.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1DESCRIPTION: BANK CHARGES. AMOUNT: 85. DESCRIPTION: INSURANCE. AMOUNT: 1,000. DESCRIPTION: OFFICE SUPPLIES. AMOUNT: 425. TOTAL TO FORM 990-EZ, LINE 16: 1,510.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 4 - OTHER INVESTMENT INCOME
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 16 - OTHER EXPENSES
TransferPrsnlBnftContractsDecl/DeclarationDesc0THE ORGANIZATION DID NOT, DURING THE YEAR, RECEIVE ANY FUNDS, DIRECTLY,OR INDIRECTLY, TO PAY PREMIUMS ON A PERSONAL BENEFIT CONTRACT.THE ORGANIZATION, DID NOT, DURING THE YEAR, PAY ANY PREMIUMS, DIRECTLY,OR INDIRECTLY, ON A PERSONAL BENEFIT CONTRACT.
ReturnHeader/BuildTS02015-11-30 17:44:51Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0BERT MCKASY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum06124571416
ReturnHeader/BusinessOfficerGrp/SignatureDt02014-04-24
ReturnHeader/Filer/BusinessName/BusinessNameLine10SOMERSET SCHOLARSHIP FUND
ReturnHeader/Filer/BusinessNameControlTxt0SOME
ReturnHeader/Filer/EIN0454617048
ReturnHeader/Filer/PhoneNum06124571416
ReturnHeader/Filer/USAddress/AddressLine101416 DODD ROAD
ReturnHeader/Filer/USAddress/City0MENDOTA HEIGHTS
ReturnHeader/Filer/USAddress/State0MN
ReturnHeader/Filer/USAddress/ZIPCode055118
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0411647057
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine10MAHONEYULBRICHCHRISTIANSEN & RUSS PA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1030 EAST PLATO BOULEVARD
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/City0SAINT PAUL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/State0MN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCode0551071809
ReturnHeader/PreparerPersonGrp/PhoneNum06512276695
ReturnHeader/PreparerPersonGrp/PreparationDt02014-04-24
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0DANIEL J FLICEK
ReturnHeader/ReturnTs02014-05-06T13:50:07-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02013-01-01
ReturnHeader/TaxPeriodEndDt02013-12-31
ReturnHeader/TaxYr02013

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$62,092
Liabilities
$0
Net assets
$62,092
Revenue
$36,816
Expenses
$33,473
Net income
$3,343
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.$0.59$0.00$0.59$0.97$1.38$0.41
2023Summary only. Only limited summary data is available for this year.$1.53$0.00$0.97$0.92$0.06
2022Detailed filing. Detailed filing data is available for this year.$1.48$0.00$1.48$0.97$0.73$0.24
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.24$0.00$1.24$1.20$0.92$0.29
2020Detailed filing. Detailed filing data is available for this year.$0.95$0.00$0.95$0.98$0.84$0.15
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.80$0.00$0.80$1.03$0.94$0.09
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.71$0.00$0.71$0.81$0.71$0.10
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.61$0.00$0.61$0.48$0.74$0.26
2016Detailed filing. Detailed filing data is available for this year.$0.87$0.00$0.87$0.79$0.63$0.16
2015XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.71$0.00$0.71$0.54$0.56$0.02
2014Detailed filing. Detailed filing data is available for this year.$0.73$0.00$0.73$0.54$0.43$0.11
2013Detailed filing. Detailed filing data is available for this year.$0.62$0.00$0.62$0.37$0.33$0.03
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.59$0.00$0.59$0.93$0.34$0.59
2011Summary only. Only limited summary data is available for this year.$0.00$0.00$0.00$0.00$0.00