3-story wood V-A walkup on Wealthy St corridor: 2,400 sf neighborhood retail (coffee/boutique scale) at grade, tuck-under parking behind (20 spaces), 24 units on floors 2-3. TN-TBA form-based standards; deal is tight on basis given corridor land costs.
Why this scenarioDefault MAX_RETURN scenario using engine-computed numbers for dashboard display.
| Unit Type | Avg SF | Count | Rent (Low / Base / High) | Status | Note |
|---|---|---|---|---|---|
| 1 BR | 680 | 10 | $1600 / / $1900 | Accepted | |
| 2 BR | 920 | 12 | $2000 / / $2350 | Accepted | |
| 3 BR | 1150 | 2 | $2600 / / $2950 | Accepted | |
| Retail | 2400 | — | $24 / / $30 | Overridden | 60LF frontage · visibility 4/5 |
| Line item | Total | % of TDC | |
|---|---|---|---|
| Acquisition | $470,460 | 5.8% | |
▸▾Land acquisition$470,4605.8%Formula lot SF × $/SF heuristic by zoning category Inputs
source: baseline | |||
| Hard Costs (CSI) | $5,851,468 | 71.9% | |
▸▾ 1General Requirements — General Requirements$409,6035.0%Quantity × Rate 25,200 SF_GBA × $16.25 = $409,603 source: baseline | |||
▸▾ 3Concrete — Concrete / Foundations$468,1175.8%Quantity × Rate 25,200 SF_GBA × $18.58 = $468,117 source: baseline | |||
▸▾ 4Masonry — Masonry$234,0592.9%Quantity × Rate 25,200 SF_GBA × $9.29 = $234,059 source: baseline | |||
▸▾ 5Metals — Structural Steel / Framing$526,6326.5%Quantity × Rate 25,200 SF_GBA × $20.90 = $526,632 source: baseline | |||
▸▾ 6Wood, Plastics, and Composites — Rough & Finish Carpentry$468,1175.8%Quantity × Rate 25,200 SF_GBA × $18.58 = $468,117 source: baseline | |||
▸▾ 7Thermal and Moisture Protection — Thermal & Moisture Protection$234,0592.9%Quantity × Rate 25,200 SF_GBA × $9.29 = $234,059 source: baseline | |||
▸▾ 8Openings — Doors, Windows, Storefront$292,5733.6%Quantity × Rate 25,200 SF_GBA × $11.61 = $292,573 source: baseline | |||
▸▾ 9Finishes — Finishes (drywall, flooring, paint)$585,1477.2%Quantity × Rate 25,200 SF_GBA × $23.22 = $585,147 source: baseline | |||
▸▾ 10Specialties — Specialties$117,0291.4%Quantity × Rate 25,200 SF_GBA × $4.64 = $117,029 source: baseline | |||
▸▾ 12Furnishings — Furnishings / Appliances$175,5442.2%Quantity × Rate 25,200 SF_GBA × $6.97 = $175,544 source: baseline | |||
▸▾ 14Conveying Equipment — Elevators / Conveying$175,5442.2%Quantity × Rate 25,200 SF_GBA × $6.97 = $175,544 source: baseline | |||
▸▾ 21Fire Suppression — Fire Suppression$117,0291.4%Quantity × Rate 25,200 SF_GBA × $4.64 = $117,029 source: baseline | |||
▸▾ 22Plumbing — Plumbing$468,1175.8%Quantity × Rate 25,200 SF_GBA × $18.58 = $468,117 source: baseline | |||
▸▾ 23Heating, Ventilating, and Air Conditioning (HVAC) — HVAC$585,1477.2%Quantity × Rate 25,200 SF_GBA × $23.22 = $585,147 source: baseline | |||
▸▾ 26Electrical — Electrical$526,6326.5%Quantity × Rate 25,200 SF_GBA × $20.90 = $526,632 source: baseline | |||
▸▾ 27Communications — Communications / Data$29,2570.4%Quantity × Rate 25,200 SF_GBA × $1.16 = $29,257 source: baseline | |||
▸▾ 28Electronic Safety and Security — Security / Access Control$29,2570.4%Quantity × Rate 25,200 SF_GBA × $1.16 = $29,257 source: baseline | |||
▸▾ 31Earthwork — Earthwork$117,0291.4%Quantity × Rate 25,200 SF_GBA × $4.64 = $117,029 source: baseline | |||
▸▾ 32Exterior Improvements — Exterior Improvements$175,5442.2%Quantity × Rate 25,200 SF_GBA × $6.97 = $175,544 source: baseline | |||
▸▾ 33Utilities — Site Utilities$117,0291.4%Quantity × Rate 25,200 SF_GBA × $4.64 = $117,029 source: baseline | |||
| Soft Costs | $31,364 | 0.4% | |
▸▾Construction-period property taxes$31,3640.4%Formula land value × land millage × construction years Inputs
source: baseline | |||
| Financing | $269,433 | 3.3% | |
▸▾Lender fees / origination$39,4290.5%Formula loan amount × lender fee bps Inputs
source: baseline | |||
▸▾Construction loan interest$230,0042.8%Formula 0.50 (avg outstanding) × loan amount × construction rate × construction years Inputs
source: baseline | |||
| Insurance | $29,257 | 0.4% | |
▸▾Builder's risk insurance$29,2570.4%Formula 0.50% × hard cost Inputs
source: baseline | |||
| Reserves | $237,394 | 2.9% | |
▸▾Operating reserve (6 months OpEx)$118,6971.5%Formula 6 months × monthly stabilized OpEx Inputs
source: baseline | |||
▸▾Lease-up operating reserve$118,6971.5%Formula lease-up months × monthly stabilized OpEx × 50% (avg occupancy shortfall) Inputs
source: baseline | |||
| Marketing + Leasing | $54,800 | 0.7% | |
▸▾Marketing + leasing commissions (initial lease-up)$54,8000.7%Formula 1 month × gross potential rent (one-time) Inputs
source: baseline | |||
| Total Development Cost | $8,132,755 | 100% | |
| Sources | Amount |
|---|---|
| Construction / Permanent Loan (debt) | $3,942,920 |
| Sponsor / LP Equity (equity) | $4,189,835 |
| Total Sources | $8,132,755 |
| Uses | Amount |
|---|---|
| Hard Costs | $5,851,468 |
| Soft Costs | $265,423 |
| Contingency | $351,088 |
| GC Fee | $321,831 |
| Developer Fee | $281,602 |
| Other / Reconciliation | $1,061,344 |
| Total Uses | $8,132,755 |
Holds the concept, rents, hard cost, and debt assumptions constant. Solves for the maximum acquisition cost that still meets the targets you set, accounting for the soft-cost ripple (loan amount, construction interest, reserves all re-resolve as land moves).
x — leave blank to ignore
% — leave blank to ignore
exit at year N
Computed from current scenario inputs by re-running the engine for each cell.
| Cost ↓ / Rent → | -10% | BASE | +10% |
|---|---|---|---|
| +10% | 1.08 | 1.20 | 1.32 |
| BASE | 1.08 | 1.20 | 1.32 |
| -10% | 1.08 | 1.20 | 1.32 |
| Gross Potential Rent | $657,600 |
| Vacancy Loss (5%) | $-32,880 |
| Effective Gross Income | $624,720 |
| Operating Expenses (38% of EGI) | $-237,394 |
| NOI | $387,326 |
| ÷ Exit Cap (6.25%) | $6,197,222 |
| Yr | Phase | Revenue | OpEx | NOI | Debt Service | Cash Flow | Equity Flow |
|---|---|---|---|---|---|---|---|
| 0 | CONSTRUCTION | $0 | $0 | $0 | $0 | $0 | $-2,513,901 |
| 1 | CONSTRUCTION | $0 | $0 | $0 | $0 | $0 | $-1,675,934 |
| 2 | LEASE_UP | $312,360 | $237,394 | $74,966 | $322,772 | $-247,806 | $-247,806 |
| 3 | STABILIZED | $640,338 | $242,141 | $398,197 | $322,772 | $75,425 | $75,425 |
| 4 | STABILIZED | $656,346 | $246,984 | $409,362 | $322,772 | $86,590 | $86,590 |
| 5 | STABILIZED | $672,755 | $251,924 | $420,831 | $322,772 | $98,059 | $98,059 |
| 6 | STABILIZED | $689,574 | $256,962 | $432,612 | $322,772 | $109,840 | $109,840 |
| 7 | STABILIZED | $706,813 | $262,102 | $444,712 | $322,772 | $121,940 | $121,940 |
| 8 | STABILIZED | $724,484 | $267,344 | $457,140 | $322,772 | $134,368 | $134,368 |
| 9 | STABILIZED | $742,596 | $272,691 | $469,905 | $322,772 | $147,133 | $147,133 |
| 10 | STABILIZED | $761,161 | $278,144 | $483,016 | $322,772 | $160,244 | $160,244 |
| 11 | SALE | $780,190 | $283,707 | $496,482 | $322,772 | $173,710 | $4,699,129 |
| Field | Value | Source | Confidence | State | Note |
|---|---|---|---|---|---|
| concept.unitMix | {"mix":[{"count":10,"bedrooms":1},{"count":12,"bedrooms":2},{"count":2,"bedrooms":3}]} | unit-mix-v1 | HIGH | Accepted | Mix accepted as proposed; matches buildable envelope and submarket demand. |
| zoning.envelope.maxFar | 2 | zoning-interpret-v1 | HIGH | Accepted | Base district TN-TBA permits FAR 2. |
| costs.adjustmentPct | 0.03 | cost-adjustment-v1 | MEDIUM | Accepted | Grand Rapids hard-cost premium ~3% above raw industry baseline due to labor tightness. |
| concept.retail.visibilityScore | 4 | concept-v1 | MEDIUM | Accepted | Visibility score (1-5) from frontage length and corridor traffic heuristics. |
| concept.retail.rentBase | 22 | rent-estimate-v1 | MEDIUM | Overridden | Wealthy St corridor asking $26-30, AI is using submarket avg not corridor-specific |
| concept.unitTypes[2].rentBase | 2800 | rent-estimate-v1 | MEDIUM | Accepted | 3BR estimated at $2800/mo per comps within 1mi (CoStar Q1-2026, Rentometer, Zillow); sfAvg 1150sf. |
| concept.unitTypes[1].rentBase | 2175 | rent-estimate-v1 | HIGH | Accepted | 2BR estimated at $2175/mo per comps within 1mi (CoStar Q1-2026, Rentometer, Zillow); sfAvg 920sf. |
| concept.unitTypes[0].rentBase | 1750 | rent-estimate-v1 | HIGH | Accepted | 1BR estimated at $1750/mo per comps within 1mi (CoStar Q1-2026, Rentometer, Zillow); sfAvg 680sf. |
| concept.parkingSpaces | 20 | concept-v1 | HIGH | Accepted | 20 spaces satisfies the TN-TBA ratio of 1/unit (and retail minimums where applicable). |
| concept.totalUnits | 24 | concept-v1 | HIGH | Accepted | AI sized the program at 24 units based on the buildable envelope and TN-TBA form-based standards. |
| Field | Old → New | Note | When |
|---|---|---|---|
| concept.retail.rentBase | 22 → 28 | Wealthy St corridor asking $26-30, AI is using submarket avg not corridor-specific | 4/28/2026 |