Investment Assets (Average Monthly FMV)
Average of monthly FMV per IRS Form 990-PF Part X.
Distributions and Income
Grants, program-related investments, set-asides.
Qualifying admin costs (not investment mgmt).
For excise tax calculation (IRC 4940).
Excess from prior years (up to 5-year carryforward).
Your Results
Enter foundation assets and distributions to calculate payout compliance.
Embed This Calculator on Your Website
Add this free calculator to your blog, website, or CMS with a simple copy-paste embed code.
Introduction
The IRS assessed $28.3 million in excise taxes on private foundations in 2022 for failure to meet minimum distribution requirements, according to IRS Statistics of Income data. The math behind the 5% mandatory payout rule sounds straightforward: distribute 5% of your investment assets annually. In practice, private foundation CFOs and trustees routinely miscalculate the distributable amount because they use year-end fair market values instead of monthly averages, miscategorize investment management fees as qualifying distributions, or forget that the 5% requirement is calculated on net investment assets after subtracting acquisition indebtedness. A foundation holding $12 million in assets at year-end but $9 million at mid-year has a very different average FMV than the year-end number suggests, and the IRS requires the average of all 12 monthly values, not a single snapshot. The IRS Private Foundation Annual Report (Form 990-PF) is an annual compliance certification, and the 30% initial excise tax on undistributed income is not a small penalty.
What This Calculator Does
This foundation payout rate calculator determines whether a private foundation meets the IRC 4942 mandatory 5% annual distribution requirement. You enter the average monthly fair market value of investment assets, cash and cash equivalents, liabilities, qualifying distributions (grants and program-related investments), and reasonable administrative expenses. The calculator computes net investment assets, the minimum required distribution, actual payout rate, excess or shortfall, and the 1.39% flat excise tax on net investment income under IRC 4940.
The Formula
Net investment assets are the average of monthly fair market values throughout the tax year, not a single year-end figure. This average includes investment securities at FMV, real estate held for investment, cash and cash equivalents, and other investment assets. Acquisition indebtedness (debt used to finance investment assets) is subtracted. The 5% minimum distribution is applied to the net figure. Qualifying distributions include grants to 501(c)(3) public charities, program-related investments (PRIs), IRS-approved set-asides, amounts paid for charitable-use assets, and reasonable administrative expenses directly related to exempt activities. Investment management fees do not qualify. The excise tax on net investment income is a flat 1.39% rate under IRC 4940, applied to interest, dividends, rents, royalties, and net capital gains.
Step-by-Step Example
Calculate average monthly fair market value
Record investment asset FMV at the first day of each month: Jan $9.8M, Feb $10.1M, Mar $10.4M, Apr $10.2M, May $9.9M, Jun $10.3M, Jul $10.8M, Aug $11.2M, Sep $10.9M, Oct $11.4M, Nov $11.7M, Dec $12.0M. Average: sum of 12 monthly values / 12 = $10.725M. This is very different from year-end FMV of $12.0M.
Calculate net investment assets and minimum distribution
Add cash held for investment (not operating accounts): $650,000 average. Subtract acquisition indebtedness: $0 (no investment debt). Net investment assets: $10,725,000 + $650,000 = $11,375,000. Minimum required distribution (5%): $568,750.
Tally qualifying distributions
Qualifying grants made to public charities: $525,000. Program-related investments: $0. Reasonable charitable administrative expenses (program staff, grantmaking costs, NOT investment management fees): $68,000. Total qualifying distributions: $593,000.
Check compliance and calculate excise tax
Minimum required: $568,750. Actual qualifying distributions: $593,000. Excess: $24,250 (can be carried forward up to 5 years to reduce future minimums). Actual payout rate: $593,000 / $11,375,000 = 5.21%. Net investment income: $440,000. Excise tax at 1.39%: $6,116. Compliance confirmed; tax obligation calculated.
Real-World Use Cases
Year-End Payout Compliance Check
A foundation's investment committee meets in October to review the year-to-date qualifying distributions. Grants made year-to-date: $410,000. Estimated qualifying administrative expenses through December: $58,000. Total projected qualifying: $468,000. Minimum required: $568,750. Shortfall: $100,750. The committee has 10 weeks to authorize and distribute an additional $100,750 in grants to avoid the 30% excise tax on undistributed income. The calculation triggers immediate grant-making action.
Investment Committee Asset Allocation Decision
A foundation is considering shifting 15% of its portfolio from fixed income ($1.8M) into a real estate investment trust (REIT) with higher expected returns but greater volatility. The payout calculator models how a 20% decline in REIT value during a market downturn would affect the average monthly FMV calculation and the minimum distribution for the following year. The analysis shows that the shift would increase the minimum payout by $9,000/year but could reduce it by $18,000 in a severe downturn, informing the risk-adjusted portfolio decision.
Multi-Year Distribution Planning with Carryforward
A foundation made distributions of $720,000 in 2025 against a $575,000 minimum, creating a $145,000 carryforward. In 2026, the minimum is $590,000. The available carryforward reduces the current-year distribution requirement to $590,000 - $145,000 = $445,000 for compliance purposes. Understanding the carryforward allows the foundation to smooth grant-making across years without creating unnecessary distribution pressure in years with lower investment income.
Comparison
| Distribution Type | Qualifies for 5% Payout? | Notes |
|---|---|---|
| Grants to public charities (501(c)(3)) | Yes | Must be to organizations not controlled by disqualified persons |
| Program-related investments (PRIs) | Yes | Low-interest loans, equity investments in mission-related activities |
| IRS-approved set-asides | Yes | Requires IRS approval for specific future project uses |
| Reasonable charitable admin expenses | Yes | Program staff, grantmaking costs, not investment management |
| Investment management fees | No | Not a qualifying distribution; deducted from investment income |
| Grants to disqualified persons | No | Creates self-dealing; additional excise taxes apply |
| Operating expenses (non-charitable) | No | General overhead not directly related to exempt activities |
Common Mistakes to Avoid
Using year-end FMV instead of the required average of monthly FMVs. A foundation whose portfolio grew from $8M to $12M during the year has an average FMV of approximately $10M, resulting in a $500,000 minimum distribution rather than $600,000 based on year-end value. Using year-end value overstates the minimum requirement; using it to plan distributions understates it in growing portfolios.
Including investment management fees as qualifying distributions. Fees paid to investment advisors, portfolio managers, custodians, and financial planners are not qualifying distributions. Only expenses directly related to the foundation's charitable activities count. Incorrectly claiming investment management fees as qualifying distributions is a common Form 990-PF error that creates deficiency notices.
Forgetting the 5-year carryforward for excess distributions. Distributions above the 5% minimum can be carried forward for up to 5 years and applied against future minimums. Foundations that make large distributions in one year and small distributions the next often have carryforward credits they are not using, creating unnecessary distribution pressure.
Confusing the 5% payout test with the 1.39% excise tax. These are two separate obligations. The 5% payout test requires minimum distributions to avoid the 30% undistribution excise tax. The 1.39% excise tax applies separately to the foundation's net investment income regardless of how much was distributed. Both must be calculated independently.
Not tracking the foundation's basis in the 5% assets. The minimum distribution is calculated on asset FMV, not cost basis. As portfolio values change monthly, the average FMV changes. Foundations that do not maintain accurate monthly FMV records throughout the year must reconstruct them from account statements at year-end, which is error-prone.
Frequently Asked Questions
Accuracy and Disclaimer
This calculator provides private foundation payout compliance estimates based on 2026 IRC 4940 and 4942 rules. Foundation excise tax and distribution requirements are complex areas of tax law. The calculations depend on accurate monthly FMV records, proper classification of qualifying distributions, and correct identification of net investment income. This tool is for planning purposes only and does not constitute tax or legal advice. Consult with a tax attorney or CPA experienced in private foundation compliance for Form 990-PF preparation and IRS guidance on your specific distribution calculations.
Conclusion
Foundation payout compliance is a year-round planning exercise, not a December calculation. Foundations that monitor their distribution status quarterly have time to authorize additional grants before year-end if they are tracking below the 5% minimum. Once your payout requirements are confirmed, use the Grant Budget Calculator to ensure that grants being made to grantee organizations include the full allowable indirect cost recovery, maximizing the impact of each qualifying distribution. For foundations building a multi-year giving strategy, excess distributions can be carried forward for up to 5 years and applied against future minimum requirements.
Related Non-Profit & Grants Calculators
Grant Budget Calculator
Allocate direct and indirect costs for federal and foundation grant proposals using 2026 OMB Uniform Guidance rates including the 10% de minimis and negotiated indirect cost rates (NICRA).
Use CalculatorNon-Profit & GrantsProgram Cost Per Beneficiary Calculator
Calculate the cost per person served, cost per outcome achieved, and program efficiency ratio to measure impact per dollar spent across non-profit programs and social services.
Use CalculatorNon-Profit & GrantsDonation ROI Calculator
Calculate cost per dollar raised, fundraising ROI, and net revenue from campaigns using 2026 M+R Benchmarks where the average non-profit cost per dollar raised is $0.20 to $0.35.
Use CalculatorNon-Profit & GrantsVolunteer Hour Value Calculator
Calculate the economic value of volunteer contributions using the 2026 Independent Sector national rate of $36.15 per hour with state-level adjustments and specialized skill premiums.
Use CalculatorNon-Profit & GrantsRestricted vs. Unrestricted Fund Allocation Tracker
Track fund balances by ASC 958 restriction class (without donor restrictions, with time/purpose restrictions, and permanently restricted endowment) with spending compliance checks and liquidity analysis.
Use CalculatorNon-Profit & GrantsGrant Application ROI Calculator
Calculate staff time cost to write a grant versus award amount and win probability to determine expected value, break-even probability, and cost per dollar raised for grant pursuit decisions.
Use CalculatorYou May Also Find Useful
Tax Calculator
Estimate your 2026 federal income tax based on filing status, gross income, deductions, and current tax brackets. See your marginal and effective tax rates instantly.
Use CalculatorFinance & AccountingSalary to Hourly Calculator
Convert your annual salary to an hourly wage instantly. Adjust for hours per week, weeks per year, and overtime to find your true hourly rate.
Use CalculatorFinance & AccountingCommission Calculator
Determine sales commissions based on revenue, rate tiers, and bonus structures.
Use Calculator