prepare_renovation_program_tool
Estimate unit renovation costs, validate ROI, and produce underwriting-ready renovation program inputs for multifamily deals. Returns deal-ready fields, audit trail, and path-to-pass guidance when ROI falls short.
Instructions
Estimate unit cost, validate ROI, and produce underwriting-ready renovation program input.
Runs the full pipeline: estimate → ROI gate → bridge dict matching the multifamily-underwriting deal schema's renovation_program shape.
Returns a dict with:
renovation_program: ready to splice into the deal JSON
roi_result: full ROI gate result for audit trail
ready_to_underwrite: True if ROI gate passed
If the ROI gate fails, returns the result with ready_to_underwrite=False and the roi_result containing path_to_pass guidance.
Args: unit_sqft: Unit square footage (drives size category) bedrooms: Number of bedrooms bathrooms: Number of bathrooms current_monthly_rent: Current monthly rent target_monthly_rent: Expected post-renovation monthly rent start_month: Renovation start month ("YYYY-MM") monthly_pace: Units renovated per month scope_level: "light" or "standard_value_add" finish_tier: "basic" or "upgraded" year_built: Property year built (triggers risk flags) property_class: "B" or "C" market: "dallas" or "birmingham" unit_id: Optional unit identifier downtime_days: Vacancy days per unit during renovation (default 21) threshold_pct: Minimum ROI percentage (default 15%)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| market | No | ||
| unit_id | No | ||
| bedrooms | Yes | ||
| bathrooms | Yes | ||
| unit_sqft | Yes | ||
| year_built | No | ||
| finish_tier | No | basic | |
| scope_level | No | standard_value_add | |
| start_month | Yes | ||
| monthly_pace | Yes | ||
| downtime_days | No | ||
| threshold_pct | No | ||
| property_class | No | ||
| target_monthly_rent | Yes | ||
| current_monthly_rent | Yes |