-
Tools to determine the financial health of a nonprofit:
- LOOKING CLOSER: Review and consider which method or combination of methods would work best for the needs of your organization:
-
Use the auditor's report
-
An auditor's report is a written opinion of an auditor regarding whether an entity's financial statements are fairly presented and in accordance with GAAP. The report is written in a standard GAAS (Generally Accepted Auditing Standards) format. A negative report is a qualified report/statement
-
What do you want to avoid a qualified auditor's report/statement?
- Hire an outside consultant that handles compilations (level C assurance) and/or reviews (level B assurance), await the auditor's report (level A assurance)
-
Use horizontal analysis
-
Use vertical analysis
-
Use expense proportion analysis
-
Analyze the portion between program expenses and management expenses
- TIP: Add fundraising expenses as a line item within management and administration
-
TIP: Use these ratios
- TIP: Use these ratios
- Total program expenses
- divided into
- Total expenses
- TIP: Use these ratios
- Total fundraising expenses
- divided into
- Total expenses
- TIP: Use these ratios
- Total management and administration expenses
- divided into
- Total expenses
- TIP: Use benchmarks as indicators
-
TIP: Use consistent bookkeeping to obtain reliable ratios
- Use consistent classification for every expense
-
Real world examples:
- You will notice that in 1985 the mean standard was about 20% of all costs allocated to overhead. By the year 2005, the standard moved to less than 10% of all costs allocated to overhead. A significant change.
-
Use fundraising effectiveness ratio
-
TIP: Classify fundraising activities by type (e.g. classify transactions by contributions and fundraising and the method which each was incurred/earned).
-
TIP: Use this method only after careful consideration of the cost and effort needed to use it effectively.
-
Use revenue concentration analysis
- TIP: Diversify contribution/fund sources
- TIP: Broaden the large donor base
-
Use traffic light revenue analysis
-
TIP: Allocate revenues among colors indicated 'green' as the most reliable fund/contribution source and subsequentially 'yellow', and 'red' as the least reliable fund sources
- Allocate more resources to the programs that have more 'green' reliable fund/contribution sources
-
Use traditional ratio analysis
-
Liquity ratios
-
Current ratio
- Current assets
- divided into
- Current liabilities
- Advantage: This ratio is preferred by the public. The ideal ratio is a 2 to 1 ratio or higher.
- An example: A nonprofit may have a ratio that increase from 2:1 to 1:1. This could indicate that the nonprofit is experiencing increasing cash shortfalls that prevents it from keeping up with AP
-
Quick ratio
- Cash
- plus
- Marketable securities
- plus
- Accounts and pledges receivables
- all above divided into
- Current liabilities
- Advantage: This ratio matches only assets that can be quickly liquidated against current liabilities
- TIP: Remove aged receivables over e.g. 90 days that may not be collectible
-
Cash flow ratios
-
Days Sales in Accounts Receivable
- AR
- divided into
- Annual revenue
- multiplied by
- 365 days
- Advantage: General measurement of ability of organization to collect from payment offered on terms. Measurements of 25% more than standard could indicate potential cash flow problems
- TIP: If this method is used, consider performing a month to month analysis and notice any trends (seasonality, etc)
-
Days Sales in Inventory (DSI)
- Average inventory
- divided into
- COGS
- multiplied by
- 365 days
- Advantage: General measurement of ability to convert inventory sales. A small number could indicate efficiency in selling inventory to meet cash flow needs
- TIP: If this method is used, consider that figures may be misleading because of 1/ selling off inventory at a discount, 2/ Chaning valuation methods, 3/ Miscalculations, or 4/ switching operation style (e.g. from distribution to manuf.)
-
Days Payables Outstanding
- Calculate turnover ratio
- Ending AP
- minus
- Beginning AP
- divided into
- 2
- multiple by
- 365 days
- Advantage: Measures the number of days it takes a nonprofit to turnover its AP. A small number could indicate proper management of cash flow levels of meet AP requirements
-
Use free cash flow analysis
-
Calculate operating cash flow
- Net income
- plus
- Depreciation
- plus
- Amortization
- plus or minus
- Change in working capital
- minus
- Capital expenditures
-
Advantages: Measures net change in cash generated by operation minus cash outlays for working capital and capital expenditure needs during a reporting period. Having free cash flow of substantial amounts could indicate a healthy financial condition.
- TIP: When using this method, consider expections to report period that reflect free cash flow. Some potentials of this result may be: selling off major assets, capital expenditure reductions, payment delays, accelerated AR due to discounts offered, staff reductions, or holding periodic pay increases