Financial State of the Club Used the CPI to eliminate inflation (all - - PDF document

Financial State of the Club

Larry Robinson October 30, 2019

Introduction

• Appreciate awesome help in collecting data

– Jay O’Leary – Joanne Lamoureux

• Pretty graphs
• Truthiness: Some handwaving to clarify insights
• Used the CPI to eliminate inflation (all in 2019 $)
• Going back 10 years (or less)
• Economist‐speak: “Descriptive, not normative.”
• Not a forensic accountant nor a strategic planner.

Data Visualization

Outline

• Club demographics
• Timeline of “asks”

– Overall income vs. expenses

• Charities supported

– And other expenses

• Fundraisers

– And other income

• Not today: Community Foundation, Charitable

Trust.

Club size

• Fairly stable (≈ 176) since 2012

2012 2013 2014 2015 2016 2017 2018 2019 165 170 175 180 185

Meeting Attendance (actual)

15% 20% 25% 30% 35% 40% 45% 50% 7/2014 7/2015 7/2016 7/2017 7/2018 7/2019 ↓ 3.1%

33.9%

Gender Composition

0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% 2012 2013 2014 2015 2016 2017 2018 2019

Years in Rotary

0% 20% 40% 60% 80% 100% 2012 2013 2014 2015 2016 2017 2018 2019 < 1 1 ‐ 5 5 ‐ 10 10 ‐ 20 > 20

Years in Rotary (as of 2019)

5 10 15 20 25 30 < 1 1 ‐ 5 5 ‐ 10 10 ‐ 20 > 20

Age (as of 2019)

0% 5% 10% 15% 20% 25% 30% 20's 30's 40's 50's 60's 70's +

Calendar of “Asks”

July Dues $150 Rotary Harvest Road Rally Oct LAFF $48 Pancake Day $45 Pancake Day Foundation Share the Warmth Jan Dues $150 Bell Ringing Dozen Dinner Draw $50 April Linen Closet Highway Cleanup July Fireworks

Overall Income vs. Expenses

(20,000) 20,000 40,000 60,000 80,000

09‐10 10‐11 11‐12 12‐13 13‐14 14‐15 15‐16 16‐17 17‐18 18‐19

Major Supported Charities

5,000 10,000 15,000 20,000 25,000 30,000 35,000

09‐10 10‐11 11‐12 12‐13 13‐14 14‐15 15‐16 16‐17 17‐18 18‐19

RYLA Youth Soccer Vocational Exchange Students Local Service Projects Community Grants International Projects Books for the World

Other Outflows

5,000 10,000 15,000 20,000 25,000

09‐10 10‐11 11‐12 12‐13 13‐14 14‐15 15‐16 16‐17 17‐18 18‐19

Administration Membership Public image Club service Rotary foundation

(10,000) 10,000 20,000 30,000 40,000

09‐10 10‐11 11‐12 12‐13 13‐14 14‐15 15‐16 16‐17 17‐18 18‐19 19‐20

Fireworks Meetings Pancake Day Little Apple Road Rally Dozen Dinner Draw

Ongoing Fundraisers

(Omits Rose Sale, Wizarding Weekend)

Pancake Day

(6,000) (3,000) 3,000 6,000 9,000 12,000 15,000 18,000

09‐10 10‐11 11‐12 12‐13 13‐14 14‐15 15‐16 16‐17 17‐18 18‐19

(6,000) (3,000) 3,000 6,000 9,000 12,000 15,000 18,000

09‐10 10‐11 11‐12 12‐13 13‐14 14‐15 15‐16 16‐17 17‐18 18‐19

Little Apple Fall Follies

( 6,000) ( 3,000) 3,000 6,000 9,000 12,000 15,000 18,000

09‐10 10‐11 11‐12 12‐13 13‐14 14‐15 15‐16 16‐17 17‐18 18‐19 19‐20

Road Rally

( 6,000) ( 3,000) 3,000 6,000 9,000 12,000 15,000 18,000

09‐10 10‐11 11‐12 12‐13 13‐14 14‐15 15‐16 16‐17 17‐18 18‐19 19‐20

Fireworks

Dozen Dinner Draw

( 6,000) ( 3,000) 3,000 6,000 9,000 12,000 15,000 18,000

09‐10 10‐11 11‐12 12‐13 13‐14 14‐15 15‐16 16‐17 17‐18 18‐19

( 6,000) ( 3,000) 3,000 6,000 9,000 12,000 15,000 18,000

09‐10 10‐11 11‐12 12‐13 13‐14 14‐15 15‐16 16‐17 17‐18 18‐19

Meetings

Kettle, Happy Dollars, Raffle, etc.

Other Inflows

10,000 20,000 30,000 40,000

09‐10 10‐11 11‐12 12‐13 13‐14 14‐15 15‐16 16‐17 17‐18 18‐19 Club dues (net of RI and District) Meeting overhead Other

Summary

• Overview of our recent history.
• Leave to the entire club, and to President

Frank, to figure out the implications for the future.