Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Excel-workbook---the-Atlas-Network

VIEWS: 8 PAGES: 11

Excel-workbook---the-Atlas-Network

More Info
									Public Support Percentage Calculation Model
Introduction Organizations in the U.S. that are registered as tax-exempt charities -- such as under Section 501(c)(3) -- must show that they are broadly supported by the public (i.e., not reliant on a few major donors or investment income). Because these rules are rather cumbersome to use for planning purposes, we have developed this spreadsheet to help institutes work through the ramifications of different funding scenarios. Important Disclaimer! Please understand that this workbook has been developed for informational and educational use only. Atlas Economic Research Foundation does not assume responsibility for the accuracy of results calculated or forecast using this model, and we recommend consulting a lawyer or tax specialist to address the particular circumstances of your institute.

Also note that there are special siuations not contemplated in this workbook. For example, some "one-time" gifts may be omitted from your public support calculations. Contributions from other public (non-private) charities count as public support in their entirety. Gifts that are pledges in one year, but paid out over several also require special treatment. Further, some organizations that fail the public support test are able to appeal and demonstrate their compliance with the rules regarding 501(c)(3) organizations. Again, please discuss these matters with an attorney or other quailfied advisor. This workbook simply is meant to help organizations identify how different funding scenarios will affect their Public Support Percentage (PS%) calculations. The basic idea is the IRS differentiates between modest contributions from unrelated supporters (e.g., "public support") and large contributions or investment income (i.e., "unqualified support"). The first "X" number of dollars that you receive from any donor is considered public support. Above the "X" threshold, funds from a large supporter are registered as "non-qualified" amounts, which count against your organization's PS%. If your PS% drops below 33.3%, your organization would fail the test for retaining tax-exempt status. What makes this difficult is the fact that "X" is a moving target, based upon the preceding four years of activity. Using this Spreadsheet This workbook consists of four sheets (excluding this one), which will help you calculate your Public Support Percentage. Throughout the workbook, cells that require you to enter information have text in the color RED. Cells that contain formulas, which should not be altered, have numbers in the color BLUE. Other text is in BLACK. Year-by-Year Data: Identify which years you are concerned with. (This sets up the columns appropriately. If you change this number, you will need to re-enter data for the individual columns.) Then enter in summary financial data direct from your IRS Form 990 for past years, and enter your best predictions for these numbers on your future Form 990s. Also enter historical donation numbers for large donors (replacing "Big Donor #1" with the appropriate name, etc.), and your predictions for coming years. To play it safe, it is best to input realistic-to-aggressive estimates of amounts that you will receive from major donors, investment income and through selling products or services. Then be somewhat conservative in your estimate of overall contributions. Calculations: Turning to the next page, you can see the public support percentage calculated for the years for which there was information (inputed into the Year-by-Year Data page) for the preceding four-year period. the four-year totals that will used in the calculation for the given tax year. Lower on the page, you can see how the calculation was made (based upon how much of each major donor's support is to be classified as non-qualified).

First Step Enter the first year for which you want to input financial information: Required Information Overall Financial Information Contributions Received Membership Fees Registration Fees Interest income Total Total less registration fees Major Donor Lists Big Donor #1 Big Donor #2 Big Donor #3 Big Donor #4 Big Donor #5 Big Donor #6 Big Donor #7 Big Donor #8 Big Donor #9 Big Donor #10 Big Donor #11 Big Donor #12 Big Donor #13 Big Donor #14 Big Donor #15 Big Donor Total Instructions 1995 1996

1995 1997 1998

-

-

-

-

-

-

-

-

Input all relevant historical data on this page in cells that have red font. For future years, use different estimates to do a se Create more lines for your major donors if necessary. But be very careful!! You must also add additional donor lines for "

Calendar Year Info

1994 Actual 1,982,639 -

1995 Actual 1,783,529 -

1996 Actual 2,484,847 -

1997 Actual 1,170,306 -

Contributions Received Membership Fees

Registration Fees Interest income Total Total less registration fees

14,662 81,418 2,078,719 2,064,057

4,989 90,095 1,878,613 1,873,624

7,348 94,018 2,586,213 2,578,865

6,929 82,334 1,259,569 1,252,640

Totals four years) Contributions Received Membership Fees Registration Fees Interest income

(preceding 1998 (94- 1999 (95- 2000 (96- 2001 (9797) 98) 99) 00) 7,421,321 33,928 347,865 7,803,114 7,769,186 155,384 #REF! 347,865 #REF! #REF! #REF! 7,043,811 46,870 329,856 7,420,537 7,373,667 147,473 #REF! 329,856 #REF! #REF! #REF! 7,315,052 54,631 299,720 7,669,403 7,614,772 152,295 #REF! 299,720 #REF! #REF! #REF! 8,525,131 74,887 269,111 8,869,129 8,794,242 175,885 #REF! 269,111 #REF! #REF! #REF!

Total Total less registration fees (TLRF) 2% of TLRF (Threshold Amount) Amount of non-qualified donations Non-qualified interest income Total Non-Qualified Amount Public Support Amount Public Support Percentage

1999

2000

2001

2002

2003

2004

-

-

-

-

-

-

-

-

-

-

-

-

ears, use different estimates to do a sensitivity analysis of likely results in regard to your public support test. st also add additional donor lines for "Calculations" worksheet and verify each cell in that row pulling information from appropriate cells.

1998 Actual 1,605,129 -

1999 Actual 2,054,770 -

2000 Estimated 3,694,926 -

2001 Estimated 2,800,000 -

2002 Estimated 2,800,000 -

2003 Estimated 2,800,000 -

27,604 63,409 1,696,142 1,668,538

12,750 59,959 2,127,479 2,114,729

27,604 63,409 3,785,939 3,758,335

27,604 63,409 2,891,013 2,863,409

27,604 63,409 2,891,013 2,863,409

27,604 63,409 2,891,013 2,863,409

2002 (98-01) 10,154,825 95,562 250,186 10,500,573 10,405,011 208,100 #REF! 250,186 #REF! #REF! #REF!

2003 (99-02) 11,349,696 95,562 250,186 11,695,444 11,599,882 231,998 #REF! 250,186 #REF! #REF! #REF!

2004 (00-03) 12,094,926 110,416 253,636 12,458,978 12,348,562 246,971 #REF! 253,636 #REF! #REF! #REF!

2005 04)

(01- 2006 05)

(02-

2007 (03-06) 11,200,000 110,416 253,636 11,564,052 11,453,636 229,073 #REF! 253,636 #REF! #REF! #REF!

11,200,000 110,416 253,636 11,564,052 11,453,636 229,073 #REF! 253,636 #REF! #REF! #REF!

11,200,000 110,416 253,636 11,564,052 11,453,636 229,073 #REF! 253,636 #REF! #REF! #REF!

nformation from appropriate cells.

2004 Estimated 2,800,000 -

27,604 63,409 2,891,013 2,863,409

2008 (04-07) 11,200,000 110,416 253,636 11,564,052 11,453,636 229,073 #REF! 253,636 #REF! #REF! #REF!

Required Information Four Year Term First year included Last year included

1995

1996

1997

1998

1991 1994

1992 1995

1993 1996

1994 1997

Overall Financial Information Contributions Received Membership Fees Registration Fees Interest income Total Total less registration fees 2% of TLRF (Threshold Amount) Amount of non-qualified donations Non-qualified interest income Total Non Qualified Amount Total Qualified Amount Public Support Percentage (PS%) Is PS% above 33.0% Major Donor Lists Big Donor #1 Big Donor #2 Big Donor #3 Big Donor #4 Big Donor #5 Big Donor #6 Big Donor #7 Big Donor #8 Big Donor #9 Big Donor #10 Big Donor #11 Big Donor #12 Big Donor #13 Big Donor #14 Big Donor #15 Amounts in Excess of Threshold Amount Big Donor #1 Big Donor #2 Big Donor #3 Big Donor #4 Big Donor #5 Big Donor #6 Big Donor #7

N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A

N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A

N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A

N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A

N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A

N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A

N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A

N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A

N/A N/A N/A N/A N/A N/A N/A

N/A N/A N/A N/A N/A N/A N/A

N/A N/A N/A N/A N/A N/A N/A

N/A N/A N/A N/A N/A N/A N/A

Big Donor #8 Big Donor #9 Big Donor #10 Big Donor #11 Big Donor #12 Big Donor #13 Big Donor #14 Big Donor #15 Total

N/A N/A N/A N/A N/A N/A N/A N/A N/A

N/A N/A N/A N/A N/A N/A N/A N/A N/A

N/A N/A N/A N/A N/A N/A N/A N/A N/A

N/A N/A N/A N/A N/A N/A N/A N/A N/A

1999

2000

2001

2002

2003

2004

1995 1998

1996 1999

1997 2000

1998 2001

1999 2002

2000 2003

#DIV/0! #DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-


								
To top