Civic Intelligence

Rotary Club of Coral Gables Inc

990EZ • Fiscal year 2017 • EIN 59-6152307

Jul 01, 2016 to Jun 30, 2017 • Filed on May 03, 2018

Organization ProfileWWW.CORALGABLESROTARY.ORG
PO Box 14-1446Coral Gables, FL 33114

(305) 441-0123

Siviq Scores

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

Liabilities / Assets

89th percentile

0.40x

Higher debt load relative to assets than 89% of similar nonprofits.

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

Liabilities / Revenue

88th percentile

0.37x

Higher debt load relative to revenue than 88% of similar nonprofits.

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

Net Margin

45th percentile

1.0%

Higher net margin than 45% of similar nonprofits.

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

Top Officer Pay

86th percentile

$0

Higher top officer pay than 86% of similar nonprofits.

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

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

Asset Growth

25th percentile

-9.9%

Faster asset growth than 25% of similar nonprofits.

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

Revenue Growth

44th percentile

-2.6%

Faster revenue growth than 44% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets89th percentile

Assets

Down

$111,467

Down $12,263 (-9.9%) from 2016

Net Assets

Up

$66,463

Up $1,282 (+2.0%) from 2016

Liabilities

Down

$45,004

Down $13,545 (-23%) from 2016

Revenue And Expenses
Liabilities / Revenue88th percentileNet Margin45th percentile

Revenue

Down

$122,189

Down $3,211 (-2.6%) from 2016

Expenses

Down

$120,907

Down $15,188 (-11%) from 2016

Net Income

Up

$1,282

Up $11,977 (+112%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth25th percentile

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

$200K$150K$100K$50K$0Assets 2012: $176,505Liabilities 2012: $84,431Net Assets 2012: $92,0742012Assets 2013: $168,451Liabilities 2013: $74,137Net Assets 2013: $94,3142013Assets 2015: $126,240Liabilities 2015: $50,364Net Assets 2015: $75,8762015Assets 2016: $123,730Liabilities 2016: $58,549Net Assets 2016: $65,1812016Assets 2017: $111,467Liabilities 2017: $45,004Net Assets 2017: $66,4632017Assets 2018: $128,062Liabilities 2018: $50,642Net Assets 2018: $77,4202018Assets 2019: $112,049Liabilities 2019: $36,351Net Assets 2019: $75,6982019Assets 2020: $97,204Liabilities 2020: $20,839Net Assets 2020: $76,3652020Assets 2021: $112,852Liabilities 2021: $30,647Net Assets 2021: $82,2052021Assets 2022: $82,971Liabilities 2022: $21,973Net Assets 2022: $60,9982022Assets 2023: $76,766Liabilities 2023: $8,442Net Assets 2023: $68,3242023Assets 2025: $63,914Liabilities 2025: $30,753Net Assets 2025: $33,1612025

Highlighted filing

2017

Assets$111,467
Liabilities$45,004
Net Assets$66,463
Open 2017 Filing

Operations Trend

Revenue Growth44th percentile

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

$200K$150K$100K$50K$0-$50KRevenue 2012: $138,412Expenses 2012: $136,444Net Income 2012: $1,9682012Revenue 2013: $148,108Expenses 2013: $145,868Net Income 2013: $2,2402013Revenue 2015: $134,130Expenses 2015: $154,575Net Income 2015: -$20,4452015Revenue 2016: $125,400Expenses 2016: $136,095Net Income 2016: -$10,6952016Revenue 2017: $122,189Expenses 2017: $120,907Net Income 2017: $1,2822017Revenue 2018: $84,359Expenses 2018: $73,402Net Income 2018: $10,9572018Revenue 2019: $88,214Expenses 2019: $89,936Net Income 2019: -$1,7222019Revenue 2020: $60,052Expenses 2020: $59,385Net Income 2020: $6672020Revenue 2021: $37,879Expenses 2021: $32,039Net Income 2021: $5,8402021Revenue 2022: $40,722Expenses 2022: $61,929Net Income 2022: -$21,2072022Revenue 2023: $85,144Expenses 2023: $77,744Net Income 2023: $7,4002023Revenue 2025: $60,812Expenses 2025: $70,014Net Income 2025: -$9,2022025

Highlighted filing

2017

Revenue$122,189
Expenses$120,907
Net Income$1,282
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2016 to Jun 30, 2017
Signed
May 3, 2018
Return Version
2016v3.1
Gross Receipts
$122,189
Mission and Program Overview

Mission

Form 990-ez, part iii, primary exempt purpose - to promote business and provide community services.

Program Services

DescriptionGrantsExpenses
MEMBERSHIP MEETINGS TO PROMOTE BUSINESS AND COMMUNITY SERVICES, DISTRICT AND INTERNATIONAL CONFERENCES-$120,907
Compensation and Service Providers
Top Officer Pay86th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
JOHN PORROPresidentPT$0--
SUSAN FORNARISPresident El-$0--
STEVEN SPANNPast Preside-$0--
SALLY BAUMGARTNERVice PresidePT$0--
BILL MARTINEZSecretaryPT$0--
DEBBIE SWAINTreasurerPT$0--
CAROL ALEXANDERDirector-$0--
PHIL BOSWELLDirector-$0--
GEORGE REEVESDirector-$0--
YOLI WOODBRIDGEDirector-$0--
REBECCA KIBBEDirector-$0--
DAVID MITCHELLDirector-$0--
Filing and Contact Details

Filer

Filer Name
Rotary Club of Coral Gables Inc
EIN
59-6152307
Phone
3054410123
Address
PO BOX 14-1446, CORAL GABLES, FL 33114

Signing Officer

Name
Debbie Swain
Title
Treasurer
Phone
3054418063
Signed
2018-05-03
Discuss with paid preparer
Yes

Preparer

Firm
Forshee & Lockwood Pa
Address
2600 SOUTH DOUGLAS ROAD STE 406, CORAL GABLES, FL 33134-6134
Preparer
William H Forshee
Phone
3054470777
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

“Expenses rotary meetings & events 68,786 rotary dues 13,973 community service 4,537 miscellaneous 2,014 admin expenses 3,524 total 92,834”

Form 990-ez, Part II, Line 24

“Due from rotary foundation 7,456 0 total 7,456 0”

Form 990-ez, Part II, Line 26

“Deferred revenue 58,549 45,004”

Form 990-ez, Part III

“Form 990-ez, part iii, primary exempt purpose - to promote business and provide community services.”

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/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/PersonNm0DEBBIE SWAIN
IRS990EZ/BooksInCareOfDetail/PhoneNum03054410123
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 14-1446
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0CORAL GABLES
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0FL
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd033114
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0116274
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0111467
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt0102
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt01282
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt028073
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0123730
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0111467
IRS990EZ/GrossReceiptsAmt0122189
IRS990EZ/GroupExemptionNum00573
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt092
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt0120091
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt065181
IRS990EZ/NetAssetsOrFundBalancesEOYAmt066463
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt065181
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt066463
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt020.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt35.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt45.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt510.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt6000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt7000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt8000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt9000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt10000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt11000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt70
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt80
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt90
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt100
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt110
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0JOHN PORRO
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1SUSAN FORNARIS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2STEVEN SPANN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3SALLY BAUMGARTNER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4BILL MARTINEZ
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5DEBBIE SWAIN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6CAROL ALEXANDER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm7PHIL BOSWELL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm8GEORGE REEVES
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm9YOLI WOODBRIDGE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm10REBECCA KIBBE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm11DAVID MITCHELL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1PRESIDENT EL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2PAST PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3VICE PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt7DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt8DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt9DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt10DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt11DIRECTOR
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt07456
IRS990EZ/OtherExpensesTotalAmt092834
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0FORM 990-EZ, PART III, PRIMARY EXEMPT PURPOSE - TO PROMOTE BUSINESS AND PROVIDE COMMUNITY SERVICES.
IRS990EZ/ProgramServiceRevenueAmt01904
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0MEMBERSHIP MEETINGS TO PROMOTE BUSINESS AND COMMUNITY SERVICES, DISTRICT AND INTERNATIONAL CONFERENCES
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt0120907
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SpecialConditionDesc0EXTENSION GRANTED TO 51518
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt058549
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt045004
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0120907
IRS990EZ/TotalProgramServiceExpensesAmt0120907
IRS990EZ/TotalRevenueAmt0122189
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.CORALGABLESROTARY.ORG
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES ROTARY MEETINGS & EVENTS 68,786 ROTARY DUES 13,973 COMMUNITY SERVICE 4,537 MISCELLANEOUS 2,014 ADMIN EXPENSES 3,524 TOTAL 92,834
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1DUE FROM ROTARY FOUNDATION 7,456 0 TOTAL 7,456 0
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2DEFERRED REVENUE 58,549 45,004
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3FORM 990-EZ, PART III, PRIMARY EXEMPT PURPOSE - TO PROMOTE BUSINESS AND PROVIDE COMMUNITY SERVICES.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART II, LINE 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART II, LINE 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART III
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0DEBBIE SWAIN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum03054418063
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-05-03
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0ROTARY CLUB OF CORAL GABLES INC
ReturnHeader/Filer/BusinessNameControlTxt0ROTA
ReturnHeader/Filer/EIN0596152307
ReturnHeader/Filer/PhoneNum03054410123
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 14-1446
ReturnHeader/Filer/USAddress/CityNm0CORAL GABLES
ReturnHeader/Filer/USAddress/StateAbbreviationCd0FL
ReturnHeader/Filer/USAddress/ZIPCd033114
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId03C7B68B3EF2F083E7E0E12A769FB4358154195C6
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId03C7B68B3EF2F083E7E0E12A769FB4358154195C6
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0650282278
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0FORSHEE & LOCKWOOD PA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02600 SOUTH DOUGLAS ROAD STE 406
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0CORAL GABLES
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0FL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0331346134
ReturnHeader/PreparerPersonGrp/PhoneNum03054470777
ReturnHeader/PreparerPersonGrp/PreparationDt02018-05-07
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0WILLIAM H FORSHEE
ReturnHeader/ReturnTs02018-05-07T15:57:46-04:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02016-07-01
ReturnHeader/TaxPeriodEndDt02017-06-30
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
$111,467
Liabilities
$45,004
Net assets
$66,463
Revenue
$122,189
Expenses
$120,907
Net income
$1,282
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.$0.64$0.31$0.33$0.61$0.70$0.09
2023Detailed filing. Detailed filing data is available for this year.$0.77$0.08$0.68$0.85$0.78$0.07
2022Detailed filing. Detailed filing data is available for this year.$0.83$0.22$0.61$0.41$0.62$0.21
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.13$0.31$0.82$0.38$0.32$0.06
2020Detailed filing. Detailed filing data is available for this year.$0.97$0.21$0.76$0.60$0.59$0.01
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.12$0.36$0.76$0.88$0.90$0.02
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.28$0.51$0.77$0.84$0.73$0.11
2017Detailed filing. Detailed filing data is available for this year.$1.11$0.45$0.66$1.22$1.21$0.01
2016Detailed filing. Detailed filing data is available for this year.$1.24$0.59$0.65$1.25$1.36$0.11
2015Detailed filing. Detailed filing data is available for this year.$1.26$0.50$0.76$1.34$1.55$0.20
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.68$0.74$0.94$1.48$1.46$0.02
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.77$0.84$0.92$1.38$1.36$0.02