RESONANTPROFORMA
v2.305.0.0 · 26-0613
Cedar Grove Apartments·v
SCN
MS auth not configured
InputPulldownDerivedRead-onlyProgrammaticAuto-fillOverriddenTCAC AppDisabledAnswer
Sources − Uses0feasible
Debt Coverage Ratio1.150≥ 1.15
Tiebreaker22.162%rank 6 of 8 · At-Risk
Win Probability0% / 0%vs cutoff (0.6109) / vs simulator
Deferred Developer Fee1.52MMno escape valve
DealDashboardInputsRent RollOperating ExpensesDebt ExecutionNOICosts & BasisTimelineInvestor IRR9% ApplicationPoints SystemTiebreakerCompetition
After-Tax LP IRR10.77%vs target 6.00%
✓ MEETS TARGET · +477 bps
Pre-Tax IRR
7.53%
After-Tax IRR
10.77%
Yield on Contribution
1.75x
Tax Benefit to LP
4,773,230
Residual to Investor
6,807,253
Total Equity
20,645,000
Market Context — CA Credit Pricing Q4 2025 / Q1 2026
This Deal — Fed TC Price
$0.85
This Deal — State TC Price
$0.80
CA 9% CRA Mainstream
$0.84 – $0.90
AHF syndicator survey, Jan 2026
CA 9% Economic (non-CRA)
$0.78 – $0.84
secondary markets w/o CRA bid
Engine Conventions · investor yield assumptions in use
Investor Entity
(default) · Fed 21% · CA 8.84%
Exit Cap Rate
%
(default) · applied to Y16 NOI
LP Share
%
(default) · credits / tax / residual
LP Operating CF Share
%
(default) · CF stays w/ GP pre-DDF
Bonus Depreciation
(default) · tcYear 2026: 20% factor
Basis Allocation
27.5-yr Bldg · 15-yr LI · 5-yr PP
//
Study avg (69/13/18)
Engine defaults:Y1 RampMid-month (IRC § 42(f)(2))·Day CountActual/365Hover any field for details · custom values shown in accent blue
TC Price Sensitivity · after-tax LP IRR at alternate pricing
Credit PriceFed TC EquityPre-Tax IRRAfter-Tax IRRΔ vs TargetMarket Zone
$0.7513,829,0009.99%13.61%+761 bpstertiary / soft LOI
$0.7814,416,0009.08%12.56%+656 bpsCA economic (non-CRA)
$0.8014,808,0008.52%11.91%+591 bpsCA economic (non-CRA)
$0.8415,562,0007.47%10.70%+470 bpsCA CRA mainstream
$0.8816,290,0006.51%9.61%+361 bpsCA CRA mainstream
$0.9217,016,0005.63%8.61%+261 bpstop-of-market CRA
Each row is a full convergence + investor yield re-run at that credit price — the numbers reflect real engine output, not a linear approximation. Δ vs Target measured against the 6.00% after-tax LP IRR threshold.
MACRS Depreciation (15-yr)
YearResidential (27.5-yr)Land Improvements (15-yr)Personal Property (5-yr)Bonus Y1Total Depreciation
1423,116168,925387,370484,2131,463,625
2781,137320,958619,7921,721,888
3781,137288,862371,8751,441,875
4781,137260,145223,1251,264,408
5781,137234,131223,1251,238,393
6781,137210,481111,5631,103,181
7781,137199,332980,469
8781,137199,332980,469
9781,137199,670980,807
10781,137199,332980,469
11781,137199,670980,807
12781,137199,332980,469
13781,137199,670980,807
14781,137199,332980,469
15781,137199,670980,807
Total11,359,0403,278,8431,936,851484,21317,058,947
Minimum Gain (Treas. Reg. 1.704-2)
YearNonrecourse DebtBook Basis (undepreciated)Minimum GainDebt Cover %
111,050,00028,292,98139.1%
211,050,00026,571,09341.6%
311,050,00025,129,21844.0%
411,050,00023,864,81046.3%
511,050,00022,626,41748.8%
611,050,00021,523,23551.3%
711,050,00020,542,76653.8%
811,050,00019,562,29756.5%
911,050,00018,581,48959.5%
1011,050,00017,601,02062.8%
1111,050,00016,620,21266.5%
1211,050,00015,639,74370.7%
1311,050,00014,658,93675.4%
1411,050,00013,678,46680.8%
1511,050,00012,697,65987.0%
Minimum gain = max(0, nonrecourse debt − book basis). When nonrecourse debt exceeds book basis, the excess is allocated to partners whose capital accounts would go negative in liquidation — prevents phantom income for LIHTC LPs.
Investor Cash Flow (15 years)
YearEquity ContributionFederal CreditState CreditOperating CFDepreciationTax BenefitResidual SaleNet CFCumulative
1(20,438,550)1,852,658612,0521,463,625409,534(17,564,307)(17,564,307)
2(206,450)1,852,658612,0521,721,888481,7982,740,057(14,824,249)
31,852,658612,0521,441,875403,4482,868,158(11,956,092)
41,852,658612,0521,264,408353,7912,818,501(9,137,591)
51,852,658612,0521,238,393346,5122,811,222(6,326,369)
61,852,658612,0521,103,181308,6792,773,388(3,552,981)
71,852,658612,052980,469274,3432,739,053(813,929)
81,852,658612,052980,469274,3432,739,0531,925,124
91,852,658612,052980,807274,4382,739,1474,664,271
101,852,658612,052980,469274,3432,739,0537,403,324
11980,807274,438274,4387,677,761
12980,469274,343274,3437,952,104
13980,807274,438274,4388,226,542
14980,469274,343274,3438,500,885
15980,807274,4386,807,2537,081,69115,582,577
Total(20,645,000)18,526,5776,120,51617,058,9474,773,2306,807,25315,582,577
How this is computed
  1. Basis allocation — total basis is split across depreciation classes: 75% residential building (27.5-yr straight line, mid-month convention), 10% land improvements (15-yr MACRS half-year), 15% personal property (5-yr MACRS half-year). Acquisition basis uses the same 75/15/10 split but shifts weight toward 27.5-yr.
  2. MACRS schedule — per-year depreciation by class plus Y1 bonus depreciation on personal property only, phased out per the TCJA schedule (80% 2023, 60% 2024, 40% 2025, 20% 2026, 0% 2027).
  3. Credit stream — federal credits year 1-10 at 99.99% investor share (mid-month convention applies Year 1 reduction with catch-up in Year 11). State credits year 1-4 for CA 4% bond deals, year 1-10 for 9% competitive.
  4. Operating cash flow — 15-year NOI projection minus debt service minus DDS payments (residual receipts soft loans). NOI escalates at rent growth 2.5%/yr minus opex growth 3.5%/yr.
  5. Tax benefit — yearly depreciation × combined federal + state tax rate. For individual LPs: 37% federal + 13.3% CA LTCG, blended through IRC 469 passive loss rules.
  6. Residual — at year 15: sale price = yr 15 NOI / exit cap rate (default 5.5%), minus perm loan balance, minus capital gains tax on the gain over book basis (20% federal LTCG + 13.3% CA).
  7. Minimum gain — tracked each year per Treas. Reg. 1.704-2 to prevent negative capital account triggers. If accumulated depreciation pushes book basis below nonrecourse debt, the excess is allocated to partners under the minimum gain chargeback rules.
  8. IRR — bisection search over the full 15-year cash flow series. Pre-tax IRR excludes the tax benefit line; after-tax IRR includes it. Both use the equity contribution schedule anchored to milestone dates (admission, 100% completion, stabilization, 8609, ODG expiration).
Resonant Proforma v2.305.0.0 · 26-0613 · feasibility + competitiveness, simultaneouslyAuto-saves to localStorage on every change
ƒClick any computed value to see its formula, inputs, and dependents. Toggle ↳ Arrows to overlay precedent/dependent connections.