Public Support Test Calculator

Measure public support across five years with capped donors. Include exclusions, grants, and gross receipts. See threshold status before preparing nonprofit filing reports today.

Enter Public Support Data

Year 1

Year 2

Year 3

Year 4

Year 5

Formula Used

Total Support = Public Gifts + Government Grants + Public Charity Grants + Program Service Revenue + Investment Income + Disqualified Person Support - Unusual Grants Excluded.

Adjusted Public Support = Public Gifts + Government Grants + Public Charity Grants + Program Service Revenue - Excess Over 2 Percent Cap - Unusual Grants Excluded.

Public Support Percentage = Adjusted Public Support ÷ Total Support × 100.

The calculator compares the percentage with the selected safe threshold and facts range threshold.

How to Use This Calculator

  1. Enter support data for each year in the five year test window.
  2. Add broad public gifts, government grants, public charity grants, and service revenue.
  3. Enter investment income and disqualified person support for total support.
  4. Enter unusual grants excluded from the test.
  5. Enter the large donor amount that exceeds the selected 2 percent cap review.
  6. Adjust thresholds and decimal places when needed.
  7. Press the calculate button to show the result above the form.
  8. Use the CSV or PDF buttons to save the calculation summary.

Example Data Table

Year Public Gifts Government Grants Public Charity Grants Program Revenue Investment Income Exclusions Excess Cap
2021 85000 25000 18000 12000 4000 0 3000
2022 91000 27000 16000 14000 4600 0 2500
2023 98000 29000 19000 15000 5200 10000 4000

Public Support Test Overview

A public support test reviews how widely an organization is funded. It is often used by charities that must show broad community backing. The calculator turns support records into a percentage. It also highlights concentration risk. The result helps teams prepare cleaner internal schedules.

Why the Percentage Matters

The main question is simple. How much support came from the public base? A higher percentage suggests wider support. A lower percentage may show reliance on a few sources. Many reviews compare the result with a one third safe level. Some cases also consider a ten percent facts and circumstances range.

What Counts as Support

Support can include public donations, grants, and service revenue. It can also include investment income or other receipts in total support. Some amounts may be excluded. Unusual grants may be removed from both sides. Excess large donor support may be removed from the numerator. Disqualified person support is usually tracked separately.

Using Five Year Data

The test often uses several years. This page accepts five yearly columns. That view reduces noise from one strong campaign. It also reveals trends. A charity can see whether broad support is improving, flat, or falling. The yearly table makes review easier for staff and advisers.

Reading the Result

The calculator reports total support, adjusted public support, and the support percentage. It then compares that percentage with chosen thresholds. A pass message does not replace professional advice. It does give a fast planning signal. It also helps identify missing records before formal reporting begins.

Better Record Keeping

Keep donor summaries, grant letters, program revenue notes, and exclusion details together. Label unusual grants clearly. Separate disqualified person support from broad public donations. Review the 2 percent cap before final entry. Good source labels make the percentage more reliable. Export the CSV or PDF for review meetings. Save each version with the filing year.

Planning Notes

Use the result before budgets are approved. A low percentage may support a broader outreach plan. It may also show a need for better small donor records. Do not mix pledged amounts with received support. Enter only the period being tested. Recheck formulas when amended returns change prior year numbers. Store dated exports securely.

FAQs

What is a public support test?

It is a percentage test that reviews whether support comes from a broad public base. It helps identify funding concentration and support diversity.

What is adjusted public support?

Adjusted public support is the numerator after subtracting excluded unusual grants and large donor excess amounts from public support sources.

Why are unusual grants excluded?

Unusual grants may be removed when they distort normal support patterns. The calculator subtracts them from both total support and public support.

What does the 2 percent cap mean?

It represents support from large donors that may be excluded from the numerator. Enter only the excess amount, not the full donor gift.

Can I change the thresholds?

Yes. The safe threshold and facts range threshold are editable. This helps you test different review assumptions or internal policies.

Does this replace professional review?

No. This tool gives a planning estimate. Formal filings should be reviewed with qualified tax, accounting, or legal guidance.

Why use five years?

A five year view smooths unusual spikes. It also shows whether support is becoming broader or more concentrated over time.

What exports are available?

You can download a CSV summary for spreadsheets. You can also download a PDF summary for records, meetings, and review files.

Related Calculators

Paver Sand Bedding Calculator (depth-based)Paver Edge Restraint Length & Cost CalculatorPaver Sealer Quantity & Cost CalculatorExcavation Hauling Loads Calculator (truck loads)Soil Disposal Fee CalculatorSite Leveling Cost CalculatorCompaction Passes Time & Cost CalculatorPlate Compactor Rental Cost CalculatorGravel Volume Calculator (yards/tons)Gravel Weight Calculator (by material type)

Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.