Free tool

The 5% payout, computed properly

The minimum-distribution math has more moving parts than 5% × assets: monthly averaging, the cash exclusion, the excise-tax offset, five-year carryforwards applied oldest-first, and proration for a first short year. This worksheet runs the real pipeline from the Form 990-PF instructions — and cites every line, so your CPA can check it.

Fiscal year

First day of tax year

Formed mid-year? Use the formation date — the 5% prorates.

Last day of tax year

Investment assets (not used for charity)

Enter month-by-month values (more precise)

Avg. securities

Average monthly market value

Avg. cash

Other assets

Real estate, partnerships, etc.

Acquisition indebtedness

Debt used to acquire those assets — usually $0

Cash exclusion override

Only if you claim more than the standard 1.5%

This year’s activity

Estimated net investment income

Interest, dividends, net gains — an estimate is fine

Qualifying distributions so far

Grants paid + direct charitable expenses this year

Undistributed income from last year

Last year's requirement still unpaid — usually $0

Excess distribution carryforwards

Years you gave more than required (last five years). Oldest is applied first; unused amounts expire after five years.

Enter your foundation’s numbers and the worksheet renders here — every line cited to the Form 990-PF instructions.