I will create value add model for multifamily with retail shops

Need a model that handles both sides of your deal? I build Excel acquisition models for mixed-use properties combining multifamily units with ground-floor/attached retail where each component follows its own real-world logic, not one blended assumption.

Residential side: Unit-by-unit rent roll by floor plan/unit type, market vs. in-place rent, renewal vs. turnover assumptions, physical/economic vacancy, loss-to-lease, concessions, and unit turn costs, unit wise renovation.

Retail: True rollover-based leasing renewal probability, downtime, releasing costs, plus flexible recovery structures (Net, Base Year, or Gross), tenant-by-tenant.

• T-12 actuals anchoring every projection
• IRR, cash-on-cash & yield on cost levered/unlevered, full waterfall
• Real debt scenarios senior loans, refis, extensions, loan fees, SOFR+spread or fixed
• Combined property cash flow with both income streams tracked separately, then rolled up
• Built for PE firms, developers/owners, and brokers underwriting mixed-income assets.
• Waterfall

Every model is fully customized to your unit mix, retail tenancy, and reporting needs.