Tax Basis Engine

Initial Investment (2014)
$6.80M
22.0% partnership stake · 12-yr horizon
Current Outside Basis
$5.12M
▼ $1.68M consumed since inception
Cumulative Credits Claimed
$7.71M
12 years · $642K avg/year
Projected Exit Year
2031
Outside-Basis Roll-Forward · 2014 → 2031 (Projected)
2014 2018 2022 2025 2028 2031 $7M $5M $3M $1M
Historical (auto-calculated)
Projected (basis exhaustion)
Today
Tax Basis Agent · Calculation Trace
Verified
Step 1 · Initial contribution
Opening basis = $6,800,000
2014 cash investment, recorded against Citizens Community Capital, Inc.
Step 2 · Allocated losses
Cumulative losses through 2025: ($1,924,612)
12 years of ordinary & rental losses · agent re-keyed each year from K-1 history
Step 3 · Distributions
Cumulative distributions: ($142,000)
Cash distributed in 2019 ($82K) and 2022 ($60K)
Step 4 · 743(b) adjustment
Step-up basis: +$381,840
Investors Bank acquisition triggered partnership-level basis election
Step 5 · Final outside basis
Closing basis = $5,115,228
Reconciles to AMP report column 14 with zero variance
⚡ Auditable trace
Every line of this calculation is traceable back to the source K-1 PDF page & field. Click any step to see the underlying citation.
Year-by-Year Ledger
Year Loss Distrib. Adj. Basis EOY
2014($120K)$6.68M
2015($138K)$6.54M
2016($156K)$6.39M
2017($172K)$6.21M
2018($164K)$6.05M
2019($178K)($82K)$5.79M
2020($188K)$5.60M
2021($172K)$5.43M
2022($168K)($60K)$5.20M
2023($170K)$5.03M
2024($148K)$4.88M
2025($150K)+$382K$5.12M
Early-Exit Scenario Modeler
Strategic Insights Agent
Hold to Maturity
2031
Exit at 15-yr compliance end
Remaining credits$3.85M
Recapture riskNone
NPV @ 8%$2.88M
Recommended
Strategic Exit
2028
Sell to secondary at 92% NAV
Capital release$4.71M
Recapture riskLow (3.2%)
NPV @ 8%$3.42M
Aggressive Exit
2026
Exit Q4 · 80% NAV
Capital release$4.10M
Recapture riskHigh (18.4%)
NPV @ 8%$2.35M