MFA ADVANCED
Built for Advanced Multifamily Underwriting in Excel
MFA-ADVANCED includes a complete set of tools designed to support accurate, efficient, and repeatable underwriting for real multifamily investment decisions.
One Advanced Underwriting Engine
Every MFA-ADVANCED model is powered by a single underwriting engine that connects assumptions, calculations, and outputs across the entire deal. This unified structure ensures consistency, accuracy, and clarity from initial screening through final investment decisions.
Complete Transparency, Consistent Methodology
MFA-ADVANCED is built with full formula visibility and a consistent modeling structure so assumptions, calculations, and outputs remain easy to understand and verify. This approach allows users to apply the same underwriting standards across every deal.
Transparent Formula Structure: All calculations are fully visible and traceable, allowing users to review and validate every assumption and output.
Assumption-Driven Modeling: Key assumptions are clearly organized so changes flow consistently through the entire model.
Repeatable Underwriting Framework: Each deal follows the same structured methodology, improving consistency across analyses.
Capital Stack & Partnership Structuring
Model the full capital stack and partnership economics with precision. MFA-ADVANCED supports complex equity structures, waterfall calculations, and return analysis that meet institutional standards for transparency and rigor.
Advanced Capital Stack Modeling: Structure multiple layers of debt and equity including senior debt, loan assumptions, mezzanine, preferred equity, and common equity with detailed capitalization tracking
GP / LP Waterfall Modeling: Calculate sophisticated waterfall structures with preferred returns, catch-up provisions, and multiple promote tiers to ensure proper alignment with investor expectations
Partnership Return Analysis: Track cash-on-cash returns, IRR, ARR, and equity multiples by partner class across the entire investment lifecycle
Investor-Grade Outputs: Generate clear summaries that communicate deal economics to limited partners, lenders, and investment committees with precision
Capital Stack & Partnership Structuring
Model complex capital structures with institutional-level precision. MFA-ADVANCED supports layered equity, preferred returns, promote structures, and partnership economics commonly used in professional multifamily investing.
Advanced Capital Stack Modeling
Model multiple layers of debt and equity, preferred returns, and supplemental capital sources with clarity and precision.
GP / LP Waterfall Modeling
Build customizable investor waterfalls with multiple hurdles, promote tiers, and flexible distribution structures for general and limited partners.
Partnership Return Analysis
Evaluate returns for all partners, including IRR, equity multiples, and timing of cash distributions across the hold period.
Investor-Grade Outputs
Generate clean, structured summaries of partnership economics designed for investor review and decision-making.
Advanced Underwriting Aids
Optional Built-in underwriting tools reduce manual work while maintaining analytical depth and consistency across deals.
Rent Roll Analyzer
Review unit-level rents, expirations, and turnover directly within the underwriting workflow.
Rent Comparable Analysis
Review comparable market rents to support realistic rent growth assumptions and validate underwriting projections.
Expense Database
Store and reuse historical expense data to speed up underwriting and improve consistency.
Other Income & Miscellaneous Modeling
Account for ancillary income streams and miscellaneous revenue items that impact overall deal performance.
Detailed Renovation Modeling
Build comprehensive renovation budgets by unit type with line-item scope detail. Track quantities, per-unit costs, and total capital requirements to defend value-add assumptions with granular precision.
Property Tax & Closing Cost Modeling
Estimate property taxes, reassessments, and acquisition-related closing costs with dedicated worksheets.
Risk Visibility & Decision Control
Evaluate how changes in assumptions impact performance before committing capital.
Sensitivity Testing
Test key variables such as exit cap rates, rent growth, expenses, and leverage to understand downside and upside risk.
Deal Review Checklist
Structure meaningful deal conversations with a comprehensive review framework. Capture key inputs, opportunities, risks, and decisions in one centralized worksheet so nothing is missed during deal screening and team discussions
Outputs Built For Real Capital Decisions
All outputs in MFA-ADVANCED are designed for real-world use in investor discussions, internal reviews, and partnership evaluations.
Investor-Ready Outputs
Clear summaries of cash flow, returns, and performance metrics designed to support informed capital decisions.
Exit & Valuation Analysis
Analyze exit pricing, valuation assumptions, and timing to understand outcomes across different different scenarios.
Automation Without Black Boxes
MFA-ADVANCED automates repetitive tasks and structures workflows for efficiency—without sacrificing transparency. Every calculation remains visible so you can review, verify, and trust the numbers behind every output.
Speed Without Sacrificing Trust
Built-in automation is used to streamline data entry, calculation updates, and output generation while maintaining complete visibility into assumptions and formulas. This allows investors to move faster without relying on hidden logic or opaque systems.
Structured workflows that save time
No hidden calculations or black-box logic
Full auditability retained throughout
Clear visibility into all assumptions
Full Multifamily Underwriting Model
End-to-end underwriting from acquisition through exit, including income, expenses, financing, renovations, and returns. Designed to handle real assumptions without simplified placeholders.
Pro Forma Modeling
Model stabilized and transitional operations with full control over rent growth, expense growth, vacancy, concessions, and other operating assumptions.
Exit & Valuation Analysis
Analyze exit pricing, cap rates, sales costs, and timing to understand downside and upside scenarios across holding periods.
Advanced Capital Stack Modeling
Support for complex deal structures including multiple debt layers, supplemental loans, preferred equity, and varied capital sources.
Partnership Return Analysis
Clear modeling of Cash-on-Cash, IRR, equity multiple, and distribution timing for both LPs and GPs.
GP / LP Waterfall Modeling
Fully customizable investor waterfalls with preferred returns, multiple hurdles, promotes, and flexible distribution splits.
Sensitivity Testing
Test key assumptions such as exit cap rates, rent growth, expenses, and leverage to understand risk and return trade-offs.
Scenario Comparison
Compare multiple underwriting scenarios side by side to evaluate different business plans or market outcomes.
Rent Roll Analyzer
Analyze unit mix, rents, expirations, turnover, and trends directly from structured rent roll data.
Rent Roll Formatter
Clean and standardize Excel rent rolls before importing into MFA-ADVANCED to reduce manual cleanup and errors.
Expense Database
Store and reuse historical T12 expense data to improve consistency and speed when underwriting new deals.
Market Analysis Tool
Review supporting market data and trends to validate underwriting assumptions and contextualize projections.
Property Tax & Closing Cost Modeling
Dedicated worksheets to model property taxes, reassessments, and acquisition/exit costs accurately.
Renovation & Value-Add Planning
Plan renovation scope, timing, costs, and rent impacts within the underwriting model.
Built-In Automations
Purpose-built automations reduce repetitive manual tasks while keeping calculations transparent and controllable.
Quick Underwriting Workflow
Evaluate deals quickly with structured inputs that still produce full underwriting outputs.
Excel-Native Design
Built entirely in Excel for flexibility, transparency, and compatibility with existing workflows.
Investor-Ready Outputs
Clean summaries and outputs suitable for internal review, investor discussions, and lender conversations.
Underwriting Checklist
Structured checklist to ensure key assumptions and review steps are not overlooked.
