Variable pages · IRS 990 Master Concordance

SN_01_LTD_ASSET_DIST_FMV

Fair market value of asset(s) distributed or amount of transaction expenses

Description
Fair market value of asset(s) distributed or amount of transactional expenses
Table
SN-P01-T01-LIQUIDATION-TERMINATION-DISSOLUTION (many)
Part
Part I - Liquidation, Termination, or Dissolution
Location
SCHED-N-PART-01-LINE-01-COL-C
Type
numeric
Scope
PZ – 990 and 990-EZ
Database
F990
Forms
SZ
2 / 4
xpaths observed / mapped
33k
filings with a value
2009–2024
tax years observed
0 + 2 reviewed
open flags

Checks

Value checks

ResultValue checkDetail
✓ passValues parse as numbers100.0% of values are numeric
✓ passNo sudden change in the median between adjacent yearslargest change 1.5x (IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/FairMarketValueOfAssetAmt, 990, TY2022)
✓ passPooled xpaths are on the same scale (same return type)largest ratio of medians between xpaths: 1.6x
ⓘ infoSign convention2.8% of values are negative (fine for net amounts)

Flags

FlagSeverityXpathDetailReview
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/FairMarketValueOfAssetAmtmany-to-one table, but 68% of values sit in no repeating element✓ accepted
noteGenuine repeating group: the group element is the repeat_root in filings with 2+ rows and '' in single-row filings, so the high unrepeated share just means most filers report one row. Evidence: repeats in 32.1% of 29,912 filings, max 181/filing, TY2013-2024; repeat_root: ''=68% ; IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail=32%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleN/LiquidationTable/LiquidationDetail/FMVOfAssetmany-to-one table, but 63% of values sit in no repeating element✓ accepted
noteGenuine repeating group: the group element is the repeat_root in filings with 2+ rows and '' in single-row filings, so the high unrepeated share just means most filers report one row. Evidence: repeats in 36.6% of 3,007 filings, max 58/filing, TY2009-2012; repeat_root: ''=63% ; IRS990ScheduleN/LiquidationTable/LiquidationDetail=37%.

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1IRS990ScheduleN/LiquidationTable/LiquidationDetail/FMVOfAssetSZ2009–20123,0070.433%36.6%
x2IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/FairMarketValueOfAssetAmtSZ2013–202429,9120.635%32.1%
x3IRS990ScheduleN/Form990ScheduleNPartI/LiquidationTable/FMVOfAssetSZnot observed0
x4IRS990ScheduleN/LiquidationTable/FMVOfAssetSZnot observed0

% filers: percent of in-scope filers whose return has the xpath, in its latest year. Repeats in: share of filings where the element occurs more than once.

Coverage by tax year

Filings’09’10’11’12’13’14’15’16’17’18’19’20’21’22’23’24
x11657019561.2k
x21.4k1.6k1.9k2.1k2.2k2.5k2.5k2.9k3.1k3.4k3.4k2.9k
Fill rate: % of all filings of the return type (largest xpath)
990<1<1<1<1<1<1<1<1<1<1<11<1<1<11
990-EZ1<1<11111111111111

Filings with a value, by xpath (rows, numbered as in the xpath table) and tax year. A change of row from one year to the next is usually the IRS renaming the element (most were renamed in 2013). Hover a cell for the exact count.

Values

ReturnFilings% numeric% zero% negativeP25MedianP75P99
99016,799100.0%3.1%3.5%5,67950,891457,81838,725,925
990-EZ16,120100.0%5.1%1.9%1,0005,00025,9261,222,534

Percentiles are the median over tax years of each year's percentile.

Example filings

Tax yearReturnXpathOrganizationValue
2024990EZx2Pacific Shores Property Owners Assocn10000XML
2012990x1BLACKSTONE INDUSTRIES EMPLOYEE BENEFIT …0XML