UPPER ARLINGTON ROTARY CHARITABLE FOUNDATION C/O ANDREW LIVINGSTON

What Upper Arlington Rotary Charitable Foundation C/O Andrew Livingston does

The organization over time

Each line starts at 100 in 2017, so what you read is the shape rather than the size: 150 means half as much again as 2017, 50 means half. The number beside each label in the key is where it ended. The shaded band is where the middle 50% of its peers' revenue would sit, given their growth.

Balance sheet

Total assets and total liabilities at each year end, in dollars. The largest one-year move in total assets was 2020 to 2021, from $263k to $342k (+30%).

How it's funded, over time

Each bar is one year's revenue split into where it came from, and every bar is the same height — these are shares, not amounts, so a year that raised twice as much looks the same size. Hover a bar for the split.

Surplus & reserves

Operating surplus or deficit each year, and months of liquidity in hand. 7 of the last 9 reported years ran a deficit.

Leadership and staff

The officers, directors, trustees and key employees listed on each return. Joined and no longer listed compare each filing with the year before, matching people by surname and first initial; a year after a gap, or a roster under three people, has no comparison.

Who funds it, year by year

2017 → 2023: the base broadened from 2 funders to 3 funders, grant income rose $10k → $14k.

6 of 6 of your funders are donor-advised or pass-through sponsors (tagged DAF) — 100% of grant dollars received. That money is really individual donors directing a sponsor; the institutions to cultivate are the non-DAF funders.

From the IRS filings of UPPER ARLINGTON ROTARY CHARITABLE FOUNDATION C/O ANDREW LIVINGSTON’s funders (the co-funder graph). Association, not causation. Trends are read to FY2023, the last fiscal year that has finished arriving. FY2024–FY2026 are still being filed and are shown unshaded; they do not move any figure on this page.

How concentrated its funding is

UPPER ARLINGTON ROTARY CHARITABLE FOUNDATION C/O ANDREW LIVINGSTON leans on a few funders — its largest provides 77% of grant income and the top three 93%; half comes from just 1 funder.

100% of the income these shares are computed over arrives through pass-through sponsors or from payers whose filings do not say what kind of payment it is. Concentration is still measured over all of it, because the money is real; what it does not support is a claim about how many institutions have chosen to fund UPPER ARLINGTON ROTARY CHARITABLE FOUNDATION C/O ANDREW LIVINGSTON.

Largest funder’s share by year: 2017 79% · 2018 100% · 2019 100% · 2020 55% · 2021 100% · 2022 100% · 2023 57% — diversifying over time.

“Effective funders” = inverse Herfindahl index (1 / Σ shareᵢ²) — the number of equal-sized funders that would give the same concentration. Trends are read to FY2023, the last fiscal year that has finished arriving. FY2024–FY2026 are still being filed and are shown unshaded; they do not move any figure on this page.

Where its funders are

100% of UPPER ARLINGTON ROTARY CHARITABLE FOUNDATION C/O ANDREW LIVINGSTON's grant income arrives through donor-advised or pass-through sponsors, whose addresses record where the money is held rather than where the donor is. Too little is directly attributable to place on a map.

Funder states come from each funder’s own filing. $109k arriving through sponsors registered in 5 states is excluded from the map and the split above: a sponsor holds money on a donor’s behalf, so its registered address would place those dollars somewhere no donor need ever have been. Trends are read to FY2023, the last fiscal year that has finished arriving. FY2024–FY2026 are still being filed and are shown unshaded; they do not move any figure on this page.