MFA-LITE v1.31 Release
MFA-LITE
v1.31 Release Overview
2 Ways To Download v1.31
1) Download directly from the MFA Excel Add-In
2) Go to My Account -> My Downloads
If you’re not an existing customer, click here to learn more about the MFA product offerings.
Key Enhancements
Enhancement
Description
Image
Return Toggle
Ability to toggle the returns displayed from LP to Project-level returns. This is most helpful when modeling a JV.
Loss to Lease Calculation
Added loss to lease % in the Unit Mix table of the UW_Model tab. This represents the Rent Roll Loss to Lease %.
RUBS Utility Ratio
Added RUBS Utility Ratio calculation into the proforma.
Cost to Close
Added Cost To Close amount in Sources/Uses section.
Cost to Close = Total Equity Required – Operational Reserves – Renovations – Acquisition Fee
Detailed List of Enhancements:
UW_Model tab
• Added ability to toggle the returns displayed from LP to Project-level returns. See cell O2.
• Added loss to lease % in the Unit Mix table (cell L44). This represents the Rent Roll LTL %.
• Added Unlevered IRR (row 166)
• Added RUBS Utility Ratio (row 67)
• Fixed conditional formatting when expense override is used. Previously was greying other income – M64:M65
• Fixed YoY calculation for Operational Expenses (cell M113) and Tax (cell M114) when Expense Override is used (cell L90)
• Added Cost To Close amount in Sources/Uses section (cell S23)
• Adjusted conditional formatting for In-Place DSCR (cell I13) to show when Quik UW is “ON”.
• Fixed T12 Debt calculation (cell J133) so that it matches the fully amortized debt amount of the proforma (no impact to the UW model)