Civic Intelligence

Rotary Club of Coral Gables Inc

990EZ • Fiscal year 2018 • EIN 59-6152307

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

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

(305) 441-8063

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.

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

Liabilities / Revenue

91st percentile

0.60x

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

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

Net Margin

70th percentile

13%

Higher net margin than 70% of similar nonprofits.

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

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.

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

Asset Growth

75th percentile

15%

Faster asset growth than 75% of similar nonprofits.

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

Revenue Growth

13th percentile

-31%

Faster revenue growth than 13% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets89th percentile

Assets

Up

$128,062

Up $16,595 (+15%) from 2017

Net Assets

Up

$77,420

Up $10,957 (+16%) from 2017

Liabilities

Up

$50,642

Up $5,638 (+13%) from 2017

Revenue And Expenses
Liabilities / Revenue91st percentileNet Margin70th percentile

Revenue

Down

$84,359

Down $37,830 (-31%) from 2017

Expenses

Down

$73,402

Down $47,505 (-39%) from 2017

Net Income

Up

$10,957

Up $9,675 (+755%) from 2017

Historical Trend

Balance Sheet Trend

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

2018

Assets$128,062
Liabilities$50,642
Net Assets$77,420
Open 2018 Filing

Operations Trend

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

2018

Revenue$84,359
Expenses$73,402
Net Income$10,957
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2017 to Jun 30, 2018
Signed
May 1, 2019
Return Version
2017v2.3
Gross Receipts
$84,359
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-$73,402
Compensation and Service Providers
Top Officer Pay86th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
SUSAN FORNARISPresidentPT$0--
JAMES N SKINNERPresident El-$0--
JOHN PORROPast Preside-$0--
SALLY BAUMGARTNERSecretaryPT$0--
GLORIA ANN BURNSPublic Relat-$0--
WILLIAM F QUESENBERRY IIITreasurerPT$0--
NICOLAS ETEROVICDirector-$0--
KELLY GARCESDirector-$0--
HATSUNARO KIYANITZADirector-$0--
TERRY C LONGDirector-$0--
MIQUEL SALOMDirector-$0--
YOLANDA VIRGINIA WOODBRIDGEDirector-$0--
Filing and Contact Details

Filer

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

Signing Officer

Name
William F Quesenberry Iii
Title
Treasurer
Phone
3054418063
Signed
2019-05-01
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 57,836 rotary dues 9,820 community service 1,863 miscellaneous 34 admin expenses 3,849 total 73,402”

Form 990-ez, Part II, Line 24

“Pre-paid expenses 0 480 total 0 480”

Form 990-ez, Part II, Line 26

“Accounts payable and accrued expenses 0 334 deferred revenue 45,004 50,308”

Form 990-ez, Part III

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

Raw XML Appendix148 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/PersonNm0WILLIAM F QUESENBERRY III
IRS990EZ/BooksInCareOfDetail/PhoneNum03054418063
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 14-1446
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0CORAL GABLES
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0FL
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd033114
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0111467
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0127582
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt0107
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt010957
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0111467
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0128062
IRS990EZ/GrossReceiptsAmt084359
IRS990EZ/GroupExemptionNum00573
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0273
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt083299
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt066463
IRS990EZ/NetAssetsOrFundBalancesEOYAmt077420
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt066463
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt077420
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt020.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2000.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt35.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt4000.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/PersonNm0SUSAN FORNARIS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1JAMES N SKINNER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2JOHN PORRO
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3SALLY BAUMGARTNER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4GLORIA ANN BURNS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5WILLIAM F QUESENBERRY III
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6NICOLAS ETEROVIC
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm7KELLY GARCES
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm8HATSUNARO KIYANITZA
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm9TERRY C LONG
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm10MIQUEL SALOM
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm11YOLANDA VIRGINIA WOODBRIDGE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1PRESIDENT EL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2PAST PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4PUBLIC RELAT
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/EOYAmt0480
IRS990EZ/OtherExpensesTotalAmt073402
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0FORM 990-EZ, PART III, PRIMARY EXEMPT PURPOSE - TO PROMOTE BUSINESS AND PROVIDE COMMUNITY SERVICES.
IRS990EZ/ProgramServiceRevenueAmt0680
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0MEMBERSHIP MEETINGS TO PROMOTE BUSINESS AND COMMUNITY SERVICES, DISTRICT AND INTERNATIONAL CONFERENCES
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt073402
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SpecialConditionDesc0EXTENSION GRANTED TO 51519
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt045004
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt050642
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt073402
IRS990EZ/TotalProgramServiceExpensesAmt073402
IRS990EZ/TotalRevenueAmt084359
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.CORALGABLESROTARY.ORG
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES ROTARY MEETINGS & EVENTS 57,836 ROTARY DUES 9,820 COMMUNITY SERVICE 1,863 MISCELLANEOUS 34 ADMIN EXPENSES 3,849 TOTAL 73,402
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1PRE-PAID EXPENSES 0 480 TOTAL 0 480
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2ACCOUNTS PAYABLE AND ACCRUED EXPENSES 0 334 DEFERRED REVENUE 45,004 50,308
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/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0WILLIAM F QUESENBERRY III
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum03054418063
ReturnHeader/BusinessOfficerGrp/SignatureDt02019-05-01
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0ROTARY CLUB OF CORAL GABLES INC
ReturnHeader/Filer/BusinessNameControlTxt0ROTA
ReturnHeader/Filer/EIN0596152307
ReturnHeader/Filer/PhoneNum03054418063
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/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt096.92.23.121
ReturnHeader/FilingSecurityInformation/IPDt02019-05-09
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm013:19:03
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/PreparationDt02019-05-09
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0WILLIAM H FORSHEE
ReturnHeader/ReturnTs02019-05-09T13:19:03-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-07-01
ReturnHeader/TaxPeriodEndDt02018-06-30
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
$128,062
Liabilities
$50,642
Net assets
$77,420
Revenue
$84,359
Expenses
$73,402
Net income
$10,957
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
2018Detailed filing. Detailed filing data is available for this year.$1.28$0.51$0.77$0.84$0.73$0.11
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$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