20-Year Office-to-Residential Tax Abatement, Inclusionary Zoning & Conversion Feasibility — Calculator, Excel Workpaper & API (BI-45)
Evaluates DMPED Housing in Downtown (HID) 20-Year Real Property Tax Abatement Schedule; 11-C DCMR Ch. 10 Inclusionary Zoning (IZ) 60%/80% MFI Rent Restriction; Stabilized Yield-on-Cost vs. Exit Cap Spread Underwriting Rule; Fannie Mae / Freddie Mac Permanent Takeout LTC & DSCR Loan Sizing. Submit: Rsf Conv, Total Units, Iz Share, Rent Mkt Monthly. Excel Tabs: Summary Budget Bridge, DMPED 20Yr HID Abatement, IZ 60 80 MFI Rent Matrix, Conversion Hard Soft Cost. Calibrated across all 57 US States, Washington, D.C., US Territories, and Federal IRC § 11 baselines in sub-millisecond deterministic Python & NumPy CPU execution.
Official Statutory & Regulatory Workpaper Title: 20-Year Adaptive-Reuse Property Tax Abatement, 60%/80% MFI Affordable Rent Cap & Agency Takeout Schedule
Official Agency Form / Workpaper Standard: 20-Year Adaptive-Reuse Tax-Abatement & Inclusionary Zoning Rent Schedule
Governing Accounting, Tax & Statutory Authorities: D.C. Official Code § 47-860.01 et seq. (Housing in Downtown 20-Year Tax Abatement); 10-B DCMR Chapter 62 (DMPED HID Rules); 11-C DCMR Chapter 10 (Inclusionary Zoning)
Common Practitioner & Search Aliases: Office to Multifamily Conversion Calculator, 20-Year Property Tax Abatement NPV, Inclusionary Zoning AMI/MFI Rent Cap, Adaptive Reuse Yield on Cost, Fannie Freddie Takeout Permanent Loan Sizing
Interactive 20-Year Office-to-Residential Tax Abatement, Inclusionary Zoning & Conversion Feasibility Calculator (BI-45)
Enter your trial-balance, schedule, or contract numbers below to verify headline statutory outputs in real time across 57 US jurisdictions (zero data stored).
Optional: Paste Advanced Custom Schedule / Array Overrides (JSON)
Computed Headline Statutory & Financial KPIs
Download 5-Tab Formula-Linked Excel Workpaper (.xlsx) — $19.00
Includes 5 formatted CPA/analyst tabs compiled from your exact inputs: 01_Executive_Summary, 02_Statutory_Rules (4 rules), 03_Workpaper_Schedule (5 rows + =SUM/=AVERAGE formulas), 04_Scenario_Sensitivity (=C-B variance formulas), and 05_Compliance_Audit_Flags (3 threshold gates).
1. Deterministic Statutory & Regulatory Laws Executed
Unlike prompt-only LLM skills that approximate multi-period schedules in token space, BI-45 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) DMPED Housing in Downtown (HID) 20-Year Real Property Tax Abatement Schedule [D.C. Official Code Sec. 47-860.02 & 10-B DCMR Ch. 62]
- (2) 11-C DCMR Ch. 10 Inclusionary Zoning (IZ) 60%/80% MFI Rent Restriction [D.C. Official Code Sec. 47-860.02(a)(2) & 11-C DCMR Ch. 10]
- (3) Stabilized Yield-on-Cost vs. Exit Cap Spread Underwriting Rule [CREFC / HUD Multifamily Adaptive-Reuse Yield-on-Cost Standard]
- (4) Fannie Mae / Freddie Mac Permanent Takeout LTC & DSCR Loan Sizing [Fannie Mae Multifamily Selling & Servicing Guide Part III (DSCR >= 1.25x)]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | As-Is Commercial Office Rent Roll, Remaining Lease Expirations, OTR Tax Bills & Acquisition Basis | Structured JSON object/array or CSV text |
FILE-2 | Architect Concept Stacking Plan (Gross vs. Net Rentable Residential SqFt & Unit Mix) & GMP Estimate | Structured JSON object/array or CSV text |
FILE-3 | Downtown D.C. Multifamily Submarket Rent Comps & Proposed 60%/80% MFI Affordable Unit Allocation | Structured JSON object/array or CSV text |
FILE-4 | Proposed Construction Debt Term Sheets, C-PACE Quotes & Sponsor Equity Waterfall Terms | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | 01 Summary Budget Bridge |
| Schedule 2 | 02 DMPED 20Yr HID Abatement |
| Schedule 3 | 03 IZ 60 80 MFI Rent Matrix |
| Schedule 4 | 04 Conversion HardSoft Cost |
| Schedule 5 | 05 YieldOnCost ExitCap Grid |
| Schedule 6 | 06 Const to Perm Debt Stack |
3. Quick Integration — REST API (cURL) & AI Agent MCP
A. Direct HTTP / REST API Call
curl -X POST "https://quantledger-73-engine-financial-and-statutory-api.p.rapidapi.com/v1/suites/BI-45/compute" \
-H "Content-Type: application/json" \
-H "X-RapidAPI-Key: YOUR_RAPIDAPI_KEY" \
-H "X-RapidAPI-Host: quantledger-73-engine-financial-and-statutory-api.p.rapidapi.com" \
-d '{
"jurisdiction": "NY",
"naics_or_sic": "541211",
"structured_inputs": {}
}'
B. Model Context Protocol (MCP) Tool Call
// Tool call inside Claude Desktop, Cursor, VS Code Copilot, LangGraph, or CrewAI:
execute_institutional_math_engine({
"engine_code": "BI-45",
"jurisdiction": "DE",
"naics_or_sic": "541211",
"structured_inputs": {}
})