Blog · Finance metrics and formulas
Nonprofit financial analysis separates operating performance, donor restrictions and usable liquidity. Work through statement exports, expense trends and an availability schedule with exact spreadsheet formulas.
Nonprofit financial analysis separates three questions: are current activities funded, which resources carry restrictions, and what can meet upcoming payments? Read operating results, donor-restricted activity and available liquidity independently before deciding whether the organization can expand a program or absorb a funding delay.
Bring the statement of activities, statement of financial position, cash flow statement and expense detail for the same fiscal periods. Add the grant and contribution schedule, collection dates, restriction terms and board reserve designations. The controller should resolve missing classifications before anyone builds a dashboard.
Use one organization, one currency and a consistent consolidation boundary. Keep account, month, program, natural expense category and restriction class in the detail. For the underlying report definitions, use nonprofit financial statements; this review concentrates on what those reports mean for funding decisions.
FASB's nonprofit presentation update describes two net asset classes and disclosures about financial assets available for general expenditures within a year. Neither class is itself a bank balance. Buildings, receivables and investments can all affect reported net assets while having very different availability.
Consider an illustrative US youth-services nonprofit. The table covers two complete fiscal years. It has no investment gains, asset-sale gains or other nonoperating items. Amounts are USD, and expenses are positive numbers.
| Statement line | FY2025 (USD) | FY2026 (USD) |
|---|---|---|
| Contributions without donor restrictions | 950,000 | 1,000,000 |
| Program fees | 600,000 | 650,000 |
| Restrictions released for current programs | 450,000 | 550,000 |
| Resources supporting current operations | 2,000,000 | 2,200,000 |
| Program expenses | 1,550,000 | 1,730,000 |
| Management and general expenses | 280,000 | 310,000 |
| Fundraising expenses | 170,000 | 190,000 |
| Total expenses | 2,000,000 | 2,230,000 |
| Operating result under this definition | 0 | -30,000 |
With labels in column A, prior year in B and current year in C, put the first contribution line in row 2. Enter these formulas in C5, C9, C10, C11, C12 and C13, respectively:
=SUM(C2:C4)
=SUM(C6:C8)
=C5-C9
=C10/C5
=C9/B9-1
=C5/B5-1
Format C11:C13 as percentages. The operating margin is -1.4%, expense growth is 11.5%, and operating-resource growth is 10.0%, rounded to one decimal place.
The definition includes releases supporting current operations. Document that choice rather than assuming every organization uses an identical operating subtotal. Broader financial analysis uses the same discipline: establish the measure before comparing periods.
The nonprofit also recognized contributions with donor restrictions of $900,000 in FY2026. The $550,000 release above moves resources between restriction classes; it is not another external contribution.
| FY2026 reconciliation | Calculation | Amount (USD) |
|---|---|---|
| Change without donor restrictions | 2,200,000 - 2,230,000 | -30,000 |
| Change with donor restrictions | 900,000 - 550,000 | 350,000 |
| Total change in net assets | -30,000 + 350,000 | 320,000 |
| External revenue cross-check | 1,000,000 + 650,000 + 900,000 | 2,550,000 |
| External revenue less expenses | 2,550,000 - 2,230,000 | 320,000 |
Both routes reach $320,000. Adding the release to external revenue would count the same support twice. The favorable total therefore does not erase the $30,000 shortfall in the defined operating resources.
For funding concentration, contributions across both restriction classes are $1,900,000, or 74.5% of external revenue: =(1000000+900000)/2550000. That describes dependence on contributed support, not dependence on a single donor. Examine the grant schedule to identify renewal dates and individual funder exposure before drawing that conclusion.
At year-end, the organization has the following financial assets. Restriction deductions below identify distinct amounts within that asset pool; no asset appears in two deductions.
| Availability calculation | Amount (USD) |
|---|---|
| Cash | 600,000 |
| Short-term investments | 250,000 |
| Receivables collectible within one year | 180,000 |
| Total financial assets reviewed | 1,030,000 |
| Less donor-restricted amounts unavailable for general use | 310,000 |
| Less contractually restricted cash | 40,000 |
| Less board-designated reserves under current policy | 180,000 |
| Available for general expenditure within one year | 500,000 |
Place these amounts in B2:B9 in order. Calculate B5 with =SUM(B2:B4) and B9 with =B5-SUM(B6:B8). Tie the starting assets to the statement and each deduction to its supporting schedule.
The IRS Form 990 instructions distinguish donor restrictions from board designations when reporting net assets. Keep that accounting classification separate from management's current spending authorization. A board reserve can remain unavailable under policy without becoming donor restricted.
Annual expenses include $120,000 of depreciation. A simple coverage measure is:
=500000/((2230000-120000)/12)
This gives 2.8 months, rounded to one decimal place. Depreciation is the example's only noncash expense. The calculation uses average monthly expense after removing it and includes collectible receivables, so it is an availability indicator rather than a cash-only runway forecast. A dated receipts-and-payments schedule is still needed to identify a short payroll week. Use nonprofit financial ratios for additional measures and financial ratios for general formula definitions.
The finance director should assign each finding an owner: development for renewal exposure, program leadership for spending commitments and the controller for classification or collection exceptions. Keep the approved operating definition and reserve policy beside the workbook so the next review uses the same basis.
Upload a sample of your own statement and expense exports to Covirage. Covirage maps the columns, its tools compute and check operating movements and availability totals, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See FP&A reporting for the supporting finance workflow.
A surplus measures recognized revenue and expenses, which can include unpaid pledges and noncash items. Some resources also carry donor restrictions. Check collections, payment timing and the availability schedule before treating a surplus as cash available for general spending.
An internal board designation generally sits within net assets without donor restrictions. It can still limit what management may spend under current policy. Show those amounts separately and obtain the required authorization before assuming the designation will be removed.
Compare the same fiscal months or complete fiscal years using consistent accounting and allocation policies. Add budget comparisons and upcoming grant milestones. A seasonal fundraising organization can look weak before its annual campaign even when its full-year funding pattern is unchanged.