Docstoc

990 Decoder - Nonprofits Assistance Fund.xls

Document Sample
990 Decoder - Nonprofits Assistance Fund.xls Powered By Docstoc
					                             Financial Management Resource



OVERVIEW OF THIS NONPROFIT MANAGEMENT RESOURCE
The worksheet was developed using information from 3 pages from the
new IRS 990 filing to generate a year end Balance Sheet, Income Statement
and a ratio analysis tool. The new 990 went into effect in 2008 for most nonprofits.
This worksheet translates the financial data from the 990 into easy to use financial
report formats and several useful ratios that can be useful as one part of a review
or analysis of a nonprofit. The IRS 990 provides many types of information
about a nonprofit, including program accomplishments, governance, and management.

GUIDE TO USING THIS 990 TO FINANCIALS STATEMENTS WORKSHEET
Yellow tabs require data entry. Enter information in yellow highlighted cells.
Green tabs use the data to create the reports for your use.
Formulas and links are protected cells.

Balance Sheet Data Input (yellow tab)
This worksheet mirrors page 11 of your 990. At the top of the sheet in the
yellow highlighted cells input name of the organization and date. Then transcribe
numbers from the 990 to the corresponding cell on the worksheet. You cannot
enter numbers in the shaded cells. The cells with red borders are equations and
entry of numbers is not allowed.

Income Date Input (yellow tab)
This worksheet mirrors page 9 of your 990. Transcribe numbers from the 990
to this worksheet. The cells with red borders are equations and
entry of numbers is not allowed. You cannot enter numbers in the shaded cells.

Expenses Data Input (yellow tab)
This worksheet mirrors page 10 of your 990. Transcribe numbers from the 990
to this worksheet. The cells with red borders are equations and
entry of numbers is not allowed. You cannot enter numbers in the shaded cells.

Balance Sheet & Income Statements (green tabs)
These tabs should be fully completed from the data input tabs. Column F
gives the source reference to the 900 and these columns can be hidden, but not
deleted. User is able to reformat these sheets, but entry is protected.

Ratios (green tab)
User will need to enter information on Line 28 (highlighted in yellow) to get the
Reliance on Income Ratio. All other numbers are linked data input tabs.
User is able to reformat this tab




   Resource created by Nonprofits Assistance Fund www.nonprofitsassistancefund.org 2010
Form 990                            ENTER COMPANY NAME                                                         Date ENTER DATE                          Page 11
Part X                              Balance Sheet
                                                                                                                              (A)                   (B)
                                                                                                                       Beginning of year         End of year
                                1   Cash - non interest bearing                                                                      -     1               -
                                2   Savings and temporary cash investments                                                           -     2               -
                                3   Pledges and grents receivable, net                                                               -     3               -
                                4   Accounts receivable, net                                                                         -     4               -
                                    Receivables from current and former officers, director, trustees, key employees,
                                5   or other related parties                                                                         -     5               -
                                    Receivables from other disqualified person (as defined under section 4958(f)(1))
                                6   and persons described in section 4958(c)(3)B                                                     -     6               -
                                7   Notes and loans receivable, net                                                                  -     7               -
                 Assets




                                8   Inventories for sale or use                                                                      -     8               -
                                9   Prepaid expenses and deferred charges                                                            -     9               -
                               10a Land, buildings, and equipment: cost basis                10a                -
                               10b Less: accumulated depreciation                            10b                -                    -     10c             -
                               11   Investments - publicly traded securities                                                               11              -
                               12   Investments - other securities                                                                         12              -
                               13   Investments - program related                                                                          13              -
                               14   Intangible assets                                                                                      14              -
                               15   Other assets                                                                                     -     15              -
                               16   Total assets                                                                                     -     16              -
                               17   Accout payable and accrued expenses                                                              -     17              -
                               18   Grants payable                                                                                   -     18              -
                               19   Deferred revenue                                                                                 -     19              -
                               20   Tax-exempt bond liabilities                                                                      -     20              -
 Liabilities




                               21   Escrow account liability                                                                         -     21              -
                                    Payables to current and former officers, director, trustees, highest compensated
                               22   employees, and disqualified persons                                                              -     22              -
                               23   Secured mortgages and notes payable to unrelated third parties                                   -     23              -
                               24   Unsecured notes and loans payable                                                                -     24              -
                               25   Other liabilities                                                                                -     25              -
                               26   Total liabilities                                                                                -     26              -
                                    Organizations that follow SFAS 117, check here ___ and complete lines 27
                                    through 29. and line 33 and 34
                                                                                                                                     -                     -
 Net assets or Fund Balances




                               27   Unrestricted net assets                                                                                27
                               28   Temporary restricted net assets                                                                  -     28              -
                               29   Permanently restricted net assets                                                                -     29              -
                                    Organizations that do not follow SFAS 117, check here ___ and complete
                                    lines 30 through 34.
                               30   Capital staock or trust principal, or current funds                                              -     30              -
                               31   Paid-in capital surplus, or land, building, or equipment fund                                    -     31              -
                               32   Retained earnings, endowment, accumulated income, or other funds                                 -     32              -
                               33   Total net assets or fund balances                                                                -     33              -
                               34   Total liabilites and net assets/fund balances                                                    -     34              -




                                        Resource created by Nonprofits Assistance Fund www.nonprofitsassistancefund.org 2010
Form 990                                     ENTER COMPANY NAME                                                               Date         ENTER DATE                                        Page 9
Part VIII                                    Statement of Revenue
                                                                                                                                 (A)               (B)               (C )              (D)
                                                                                                                           Total revenue   Related or exempt
                                                                                                                                            function revenue       Unrelated         Revenue
                                                                                                                                                               business revenue excluded from tax
                                    1 a Federal campaigns                                           1a             -
 Contributions, gifts, grants and




                                         b Membership dues                                          1b             -
     other similar amount




                                         c Fundraising events                                       1c             -
                                         d Related organizations                                    1d             -
                                         e Government grants (contributions)                        1e             -
                                             Other contributions, gifts, grants, and similar
                                         f   amounts not included above                             1f             -
                                         g Noncash contributions included in lines 1a-1f $                         -
                                         h Total                                                                                     -
                                                                                                         Business Code
          Program Service Revenue




                                    2 a       --                                                                                     -                 -                    -                 -
                                         b    --                                                                                     -                 -                    -                 -
                                         c    --                                                                                     -                 -                    -                 -
                                         d    --                                                                                     -                 -                    -                 -
                                         e    --                                                                                     -                 -                    -                 -
                                         f   All other program revenue                                                               -                 -                    -                 -
                                         g Total                                                                                     -
                                    3      Investment income (including dividends, interest, and other similar
                                           amounts)                                                                                  -                 -                    -                 -
                                    4        Income from investment of tax-exempt bond proceeds                                      -                 -                    -                 -
                                    5        Royalties                                                                               -                 -                    -                 -
                                                                                       (i) Real           (ii) Personal
                                    6 a Gross rents                                                                -
                                         b Less: rental expenses                                                   -
                                         c Rental income(loss)                               -                     -
                                         d Net rental income                                                                         -                 -                    -                 -
                                    7 a Gross amount from sales of                 (i) Securities           (ii) Other
                                             assets other than inventory                     -                     -
                                         b Less: cost or other basis
          Other Revenue




                                             and sales expense                               -                     -
                                         c Gain or (loss)                                    -                     -
                                      d Net gain or (loss)                                                                           -                 -                    -                 -
                                    8 a Gross income from fundraising events (not
                                        including $____________ of contributions
                                        reported on line 1c). See Part IV, line 18                  a                  -
                                         b Less: direct expenses                                    b              -
                                      c Net income or (loss) from fundraising events                                                 -                 -                    -                 -
                                    9 a Gross income from gaming activities. See part
                                        IV, line 19                                                 a              -
                                         b Less; direct expenses                                    b              -
                                       c Net gain or (loss) from gaming activities                                                   -                 -                    -                 -
                                    10 a Gross sale of inventory, less returns and
                                         allowances                                                 a              -
                                         b Less; cost of goods sold                                 b              -
                                         c Net income or (loss) from sales of inventory                                              -                 -                    -                 -
                                                           Micellaneous Revenue                          Business Code
                                    11 a                                                                     -               -            -                                                   -
                                         b                                                                   -               -            -                                                   -
                                         c                                                                   -               -            -                                                   -
                                         d   All other revenue                                               -               -            -                                                   -
                                         e   Total                                                           -               -            -                                                   -
                                    12       Total Revenue                                                   -               -            -
                                                       Resource created by Nonprofits Assistance Fund www.nonprofitsassistancefund.org 2010                                                   -
Form 990ENTER COMPANY NAME                                                                Date                     ENTER DATE                        Page 10
Part IX Statement of Functional Expenses
                                             Section 501(c)(3) and 501(c)(4) organizations must complete all columns.
                           All other organizations must complete column (A) but are not required to complete columns (B), (C), and (D)
                                                                             (A)                   (B)                    (C )                    (D)
Do not include amounts reported on lines 6b,7b,8b, and                 Total Expenses       Program Services        Management and       Fundraising expenses
                                                                                                expenses            general expenses
10b of part VIII
1        Grants and other assistance to goverments and
         organizations in the U.S.                                                    -                    -
2
         Grants and other assistance to individuals in the U.S.
                                                                                      -                    -
3        Grants and other assistance to governments,
         organizations, and indiviuals outside the U.S.                               -                    -
4        Benefits to or for members                                                   -                    -
5        Compensation of current officers, directors, trusttes, and
         key employees                                                                -                    -                      -                     -
6        Compensation not included above, to disqualified
         persons (as defined under section 4958(f)(1) and
         persons described in section 4958(c)(3)(b)                                   -                        -                  -                     -
7        Other salaries and wages                                                     -                    -                      -                     -
8        Pension plan contributions (includes section 401(k) and
         section 403(b) employer contribution                                         -                    -                      -                     -
9        Other employee benefits                                                      -                    -                      -                     -
10       Payroll taxes                                                                -                    -                      -                     -
11       Fees for services (non-employees)
    a    Management                                                                   -                    -                      -                     -
    b    Legal                                                                        -                    -                      -                     -
    c    Accounting                                                                   -                    -                      -                     -
    d    Lobbying                                                                     -                    -                      -                     -
    e    Professional fundraising services                                            -                                                                 -
     f   Investment management fees                                                   -                    -                      -                     -
    g    Other                                                                        -                    -                      -                     -
12       Advertising and promotion                                                    -                    -                      -                     -
13       Office expense                                                               -                    -                      -                     -
14       Information technology                                                       -                    -                      -                     -
15       Royalties                                                                    -                    -                      -                     -
16       Occupancy                                                                    -                    -                      -                     -
17       Travel                                                                       -                    -                      -                     -
18       Payment of travel or entertainment expenses for any
         federal, state, or local public officials                                    -                    -                      -                     -
19       Conferences, conventions, or meetings                                        -                    -                      -                     -
20       Interest                                                                     -                    -                      -                     -
21       Payments to affiliates                                                       -                    -                      -                     -
22       Depreciation, depletion, and amortization                                    -                    -                      -                     -
23       Insurance                                                                    -                    -                      -                     -
24       Other expenses                                                               -
    a                                                                                 -                    -                      -                     -
    b                                                                                 -                    -                      -                     -
    c                                                                                 -                    -                      -                     -
    d                                                                                 -                    -                      -                     -
    e                                                                                 -                    -                      -                     -
     f   All other expenses ___________________                                       -                    -
25       Total functional expenses                                                    -                    -                      -                     -
26
         Joint Costs. Check here ______ if following SOP 98-2.
         Complete this line only if the organization reported in
         column (B) joint costs from a combined educational
         campaign and fundraising solicitation
                                                                                      -                    -                      -                     -
                            Resource created by Nonprofits Assistance Fund www.nonprofitsassistancefund.org 2010
              ENTER COMPANY NAME
    Balance Sheet (Statement of Financial Position)
                  ENTER DATE

Assets                                                Data source from Part X
Cash & Short-term Investments         $               1+2
Grants & Pledges Receivable                           3
Accounts Receivable                                   4+5+6
Notes Receivable                                      7
Inventories                                           8
Prepaid expenses                                      9
Land, buildings & equip (net)                         10c
Investments                                           11+12+13
Other assets                                          14+15



Total Assets                          $


Liabilities and Net Assets
Accounts Payable & Accrued Expenses   $               17+21+22
Grants Payable                                        18
Deferred Revenue                                      19
Loans and Mortgages Payable                           20+23+24
Other Liabilities                                     25
Total Liabilities

Unrestricted Net Assets                               27
Temporarily Restricted Net Assets                     28
Permanently Restricted Net Assets                     29
Total Net Assets

Total Liabilities & Net Assets        $
Data source from Part X
         ENTER COMPANY NAME
 Income Statement (Statement of Activities)
              ENTER DATE

INCOME                                                             Data source from Part VIII
Support
Federated campaigns                     $                          1a
Membership dues                                                    1b
Fundraising events (net)                                           1c + 8c
Related Organization                                               1d
Government grants                                                  1e
Grants and contributions                                           1f - 1g
In-kind contributions                                              1h
Total Support                           $

Revenue
 --                                     $                          2a
 --                                                                2b
 --                                                                2c
 --                                                                2d
 --                                                                2e
Other program service revenue                                      2f
Investment income                                                  3+4
Net rental income                                                  6d
Net income from sale of assets                                     7d
Net income from gaming activities                                  9c
Net income from sales of inventory                                 10c
All other income                                                   5+ 11a + 11b+ 11c+ 11d
Total Revenue                           $
Total Support & Revenues                $

EXPENSE                                                            Data source from Part IX
Salaries & Wages                        $                          5+6+7
Employee benefits & taxes                                          8 + 9 + 10
Contract & Professional Fees                                       11a+11b+11c+11d+11e+11f+11g
Grants paid                                                        1+2+3+4
Payments to affiliates                                             21
Operating expenses                                                 12+13+14+15+16+17+18+19+23
Other expenses                                                     24a+24b+24c+24e+24f
Interest expense                                                   20
Depreciation & amortization                                        22
Total Expenses                          $
                                                                   Data source from Part X - balance
Change in Unrestricted Net Assets                                  Line 27(B) - 27(A)
Change in Temp Restricted Net Assets                               Line 28(B) - 28(A)
Change in Perm Restricted Net Assets                               Line 29(B) - 29(A)
Total Change in Net Assets              $



Resource created by Nonprofits Assistance Fund www.nonprofitsassistancefund.org 2010
Resource created by Nonprofits Assistance Fund www.nonprofitsassistancefund.org 2010
ta source from Part VIII




11a + 11b+ 11c+ 11d




ta source from Part IX


a+11b+11c+11d+11e+11f+11g


+13+14+15+16+17+18+19+23
a+24b+24c+24e+24f



ta source from Part X - balance sheet




                           Resource created by Nonprofits Assistance Fund www.nonprofitsassistancefund.org 2010
                                               ENTER COMPANY NAME
                                                      Ratios
                                                   ENTER DATE

    Ratio analysis is a tool to be used to deepen understanding and interpretation of financial information. While there are
    dozens of ratios that can be calculated, most nonprofits can use a handful of them to learn more about their financial
    condition. The ratios included here can be calculated using data from the IRS 990 as a way to summarize some key
    financial indicators.

    To be valuable, ratios must be: viewed both at a single point in time and as a trend over time; used in comparison to
    benchmarks or goals; and interpreted in the context of both internal and external factors. No one ratio can provide a
    complete answer to questions about financial health, viability, or efficiency.


1   Months Cash on Hand
      Total Expenses                                         -                             Having adequate cash to pay regular expenses
       Minus Depreciation                                    -                               and obligations is an indicator of financial
      Equals cash expenses                                   -                            stability. Data from the 990 about cash & short-
                                                                                         term investments is used to calculate the formual
      Expenses divided by 12 months                          -
                                                                                         for how many MONTHS of expenses can be paid .
      Cash and Short Term Investments                            0                        A common benchmark is 3 months of cash.with
      Months Cash on Hand                          #DIV/0!            Months of expenses                     cash on hand.


2   Unrestricted Net Assets Ratio
       Unrestricted Net Assets                                   0
       Total expenses                                             0                      Unrestricted Net Assets accumulated over time is
                                                                                            a measure of the full "cushion" held by the
       Total Exp. Divided by 12 months                       -
                                                                                           nonprofit in all asset types, not only cash. The
       Unrestricted Net Assets Ratio               #DIV/0!            Months of expenses     formual calculates how many MONTHS of
                                                                                         expenses are available in Unrestricted Net Assets.
3   Reliance on Income Ratio
                                                                       MANUAL ENTRY
                                                                                               Manually enter the type and amount of the
        Total income                                         -
                                                                                              nonprofit's largest type of income. This activity
        Reliance on Income Ratio                   #DIV/0!              of total income        must have systems and staffing to maintain.
                                                                                                    There is no standard benchmark.
4   Personnel Expenses Ratio
       Total Salary & Wages                                      0
       Employee Benfits & Taxes                                  0                           The majority of nonprofits deliver services in the
                                                                                             community through people. Personnel expenses
       Total Personnel Expense                                   0
                                                                                             are usually the largest portion of the budget. This
       Total Expenses                                            0                            formula is a useful view of the expense profile,
       Personnel Expense Ratio                     #DIV/0!             of total expenses                especially from year to year.


5   Functional Expense Percentage                                         Percentage
       Program Expenses                                          0         #DIV/0!              An indicator of the distribution of expenses.
       Management and General Expenses                       -             #DIV/0!           Common benchmarks expect 65-70% of expenses
                                                                                              to be for programs. Management & fundraising
       Fundraising Expenses                                  -             #DIV/0!
                                                                                              expenses are defined in 990 instructions. These
       Total Expenses                                        -             #DIV/0!             activities require adequate budgets in order to
                                                                                                          maintain a strong nonprofit.
6   Fundraising Efficiency
       Total Contributions, Gifts, Grants               -
                                                                                           An indicator of how much contributed income is
       Fundraising Expenses                             -
                                                                                             raised for each dollar spent on fundraising.
       Contributions Raised per Fundraising Exp.#DIV/0!               per $ of fundraising Comparisons are most useful internally or to very
                                                                                                         similar organizations.


               Resource created by Nonprofits Assistance Fund www.nonprofitsassistancefund.org 2010

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:8/9/2012
language:
pages:10
zhaonedx zhaonedx http://
About