🏢
Load a
Property to Begin Underwriting
Pull any active deal from your PROPERTY DEALFLOW
pipeline — including its Google Drive documents, T12, and rent roll files.
Or continue editing the deal already loaded below.
Purchase Price
$0
— per unit
Cap Rate (T12)
0.00%
Day 1 Proforma
NOI (Underwritten)
$0
Expense ratio: —
Cash-on-Cash Yr1
0.00%
After debt service
IRR (5-Year)
0.00%
Equity multiple: —
DSCR
0.00
LTV: —
Unlevered IRR
0.00%
No-debt IRR
Debt Yield
0.00%
Lender stress test
Yield-on-Cost
0.00%
Stabilized / all-in
Total Return
0.00%
Exit: —
Property Information Deal Setup
📋 More details — map, dates, broker & lender
Deal Tracking
Pricing Matrix Ask · FMV · Offer
$
$
$
%
Per Door
—
vs Ask
—
Our Offer vs Asking Price
| Metric | Asking (OM) | FMV (Cap) | FMV (Cap−CapEx) | Our Offer |
|---|---|---|---|---|
| Total Price | — | — | — | — |
| Cap Rate | — | — | — | — |
| Per Door | — | — | — | — |
| Per Sqft | — | — | — | — |
| GRM | — | — | — | — |
| Whisper Price | — | — of ask | ||
| Last Sale | — | — | ||
Purchase KPIs At Offer Price
| Cap Rate @ Purchase (T12) | — |
| Cap Rate Proforma (Day 1) | — |
| Cap Rate Proforma (Yr 1) | — |
| Gross Rent Multiplier (T12) | — |
| Net Income Multiplier | — |
| Debt Coverage Ratio (DSCR) | — |
| Purchase Cash-on-Cash (Day 1) | — |
| Equity Multiple | — |
| Expense Ratio | — |
| LTV | — |
| Price/Unit | — |
UW Notes Analyst Comments
NOI Bridge Underwritten
Gross Income
$0
−
Expenses
$0
0% ratio
=
NOI
$0
−
Debt Svc
$0
=
Cash Flow
$0
Key ContactsDeal Team
No contacts yet — add broker, lender, seller, attorney…
Documents Due Diligence
Document Checklist
History & Trends rent roll over time
Occupied Units
0
0% occupancy
Vacant Units
0
0% vacancy
Current EGI (Annual)
$0
Avg rent: $0/unit
Market EGI (Annual)
$0
Avg market: $0/unit
Rent Upside (Annual)
$0
0% loss to lease
Avg Rent/Sqft
$0.00
Current in-place
Unit Mix In-Place & Market Rents
| Unit Type | Sqft/Unit | Total Units | Occupied | Vacant | Current Rent | Market Rent | Monthly Income | Upside/Mo | |
|---|---|---|---|---|---|---|---|---|---|
| TOTALS | 0 | 0 | 0 | $0 | $0 | $0 | $0 | ||
Loss To Lease Analysis Upside Rent
| Gross Potential Rent (Market) | $0 |
| Loss to Lease (in-place vs market) | ($0) |
| Below-Market Units | 0 |
| Avg Rent Increase Per Unit | $0 |
| Total Annual Upside | $0 |
| Upside as % of GPR | 0% |
Upgrade Premium Analysis
$
| Monthly Upgrade Income | $0 |
| Annual Upgrade Income | $0 |
Unit Distribution Charts
History & Trends T12 over time
Gross Potential Rent
$0
Annual
Effective Gross Income
$0
$0/mo
Total Expenses
$0
0% of EGI
NOI
$0
0% margin
Exp/Unit/Month
$0
Industry avg ~$350–$600
Avg Income/Unit/Mo
$0
EGI basis
T12 NOI Normalization As-Reported vs Normalized
Brokers and comp tools often underwrite the as-reported T12 — which can include one-time items (tax true-ups, insurance prepayments, non-recurring repairs) that distort NOI. Enter those add-backs to see the normalized NOI and compare apples-to-apples. This is the #1 driver of cap-rate disagreements between tools, and it's why the NOI-basis declaration on the KPI strip is required.
As-Reported NOI
$0
0.00% cap
+
$
tax true-up, prepaids, non-recurring
=
Normalized NOI
$0
0.00% cap
T12 Income Statement Annual
| Income Line Item | T12 Actual | Underwritten | Pro Forma Yr1 |
|---|---|---|---|
| Gross Potential Rent (GPR) |
$
|
$
|
|
| Loss to Lease |
($
|
($
|
|
| Physical Vacancy |
($
|
($
|
|
| Concessions |
($
|
($
|
|
| Bad Debt |
($
|
($
|
|
| RUBS / Utility Reimbursements |
$
|
$
|
|
| Laundry Income |
$
|
$
|
|
| Parking Income |
$
|
$
|
|
| Pet Fees |
$
|
$
|
|
| Storage / Other Income |
$
|
$
|
|
| Effective Gross Income (EGI) | $0 | $0 |
T12 Operating Expenses
Annual
| Expense Line Item | T12 Actual | Underwritten | Pro Forma Yr1 |
|---|---|---|---|
| Property Management (% of EGI) |
%
|
%
|
|
| Property Taxes |
$
|
$
|
|
| Insurance |
$
|
$
|
|
| Repairs & Maintenance |
$
|
$
|
|
| Capital Reserves ($/unit/yr) |
$
|
$
|
|
| Utilities (Water / Trash / Electric) |
$
|
$
|
|
| Payroll / Admin |
$
|
$
|
|
| Landscaping / Pest Control |
$
|
$
|
|
| Marketing / Advertising |
$
|
$
|
|
| Professional Services (Legal/Acctg) |
$
|
$
|
|
| Total Operating Expenses | $0 | $0 | |
| Expense Ratio | 0% | 0% | |
| Net Operating Income (NOI) | $0 | $0 |
T12 vs Underwritten Income Bridge
Expense Breakdown Underwritten
Scenario Comparison Analysis
Live + Pinned
| Scenario | Equity Needed | Down % | Loan Amount | LTV | Rate | Mo. Payment | ADS | DSCR | Max Loan @1.25x | CoC Yr1 | Return Equity |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||||
Loan Amount
$0
0% LTV
Equity Required
$0
0% down
Annual Debt Service
$0
$0/mo
DSCR (Proforma)
0.00
T12 DSCR: — · Min 1.20
Debt Yield
0.00%
NOI / Loan Amount
Loan Terms Primary Debt
$
Synced from Deal Summary
%
%
0 = fully amortizing
Calculated Debt Metrics
| Loan Amount | $0 |
| LTV Ratio | 0% |
| Monthly P&I Payment | $0 |
| Year 1 Annual Debt Service | $0 |
| DSCR (NOI / ADS) | 0.00 |
| Debt Yield (NOI / Loan) | 0% |
| Break-Even Occupancy | 0% |
Returns KPIs 5-Year Hold
| Cash-on-Cash Return (Yr 1) | — |
| Cash-on-Cash Return (Avg) | — |
| Annual Rate of Return | — |
| IRR (5-Year) | — |
| Equity Multiple | — |
| Exit Cap Rate | — |
| Exit Value | — |
| Total Return | — |
Capital Stack Total Investment
$
%
$
Synced from Value Add tab
$
| Purchase Price | $0 |
| Down Payment | $0 |
| Closing Costs | $0 |
| Acquisition Fee | $0 |
| Renovation Budget | $0 |
| Operating Reserves | $0 |
| Total Capital Required | $0 |
| Loan Amount | $0 |
| Total Project Cost | $0 |
| LTC (Loan-to-Cost) | 0% |
Capital Stack Visual Equity vs Debt
Creative Financing All / Some / None
$
See the Portfolios tab for blended metrics across the pool.
Blended Capital Stack
Affordable Housing & Subsidies LIHTC · Section 8 · PILOT
HUD 221(d)(4), 223(f), USDA RD 515, and Agency Small Balance are financing programs — set those in the Loan Type dropdown in Loan Terms above; they get full DSCR/CoC math for free through the primary loan engine.
Unit Renovation Status Forced Appreciation Tracker
Total Units
—
Renovated
Partially Renovated
Unrenovated
—
Renovation Progress
0% complete
Reno $/Unit
—
Total Implemented CapEx
—
Remaining Budget
—
Renovation PhasingYr 1–5 Schedule
| Year | Units to Reno | % of Total | CapEx Spend | Cumul. Units | Cumul. CapEx | Rent Uplift/Mo |
|---|
Unit Type Renovation Breakdown Light VA
| Unit Type | Count to Renovate | Reno Cost / Unit | Subtotal |
|---|---|---|---|
| Studio |
$
|
$0 | |
| 1 Bedroom |
$
|
$0 | |
| 2 Bedroom |
$
|
$0 | |
| 3 Bedroom |
$
|
$0 | |
| Unit Type Total | $0 | ||
| Total Units Planned for Renovation | 0 units | ||
| 💡 These counts auto-fill the "Upgraded Units" field in ROI Analysis and can replace the scope table's unit counts as your primary input. | |||
Light Value Add Budget Cosmetic Upgrades
| Scope Item | Cost/Unit | Units | Total Cost |
|---|---|---|---|
| Interior Paint |
$
|
$0 | |
| Flooring (LVP) |
$
|
$0 | |
| Appliances |
$
|
$0 | |
| Lighting / Fixtures |
$
|
$0 | |
| Cabinet Refresh / Hardware |
$
|
$0 | |
| Countertops |
$
|
$0 | |
| Exterior / Landscaping |
$
|
$0 | |
| Amenity Upgrades (Pool, Gym, etc.) |
$
|
$0 | |
| Total Renovation Budget | $0 | ||
| Cost Per Unit | $0 | ||
ROI Analysis Light VA
$
%
Returns on Renovation
| Total Reno Budget (w/ contingency) | $0 |
| Annual Rent Premium Added | $0 |
| Return on Renovation (ROI) | 0% |
| Payback Period | 0 yrs |
| Value Created (at Exit Cap) | $0 |
| Forced Appreciation / Unit | $0 |
Renovation Phasing % of Units Renovated by Year
| Unit Type | Yr 1 % | Yr 2 % | Yr 3 % | Yr 4 % | Yr 5 % | Total Units Renovated |
|---|---|---|---|---|---|---|
| Studio | % |
% |
% |
% |
% |
0 |
| 1 BR | % |
% |
% |
% |
% |
0 |
| 2 BR | % |
% |
% |
% |
% |
0 |
| 3 BR | % |
% |
% |
% |
% |
0 |
| Grand Total Units Renovated (all types) | 0 units | |||||
Enter % of each unit type's count to be renovated per year. Totals >100% will flag in red.
Unit Type Renovation Breakdown Heavy VA
| Unit Type | Count to Renovate | Reno Cost / Unit | Subtotal |
|---|---|---|---|
| Studio |
$
|
$0 | |
| 1 Bedroom |
$
|
$0 | |
| 2 Bedroom |
$
|
$0 | |
| 3 Bedroom |
$
|
$0 | |
| Unit Type Total | $0 | ||
| Total Units Planned for Renovation | 0 units | ||
Heavy Value Add Budget Full Renovation
| Scope Item | Cost/Unit | Units | Total Cost |
|---|---|---|---|
| Full Kitchen Remodel |
$
|
$0 | |
| Full Bath Remodel |
$
|
$0 | |
| New Flooring (full unit) |
$
|
$0 | |
| HVAC Replacement |
$
|
$0 | |
| Plumbing / Electrical |
$
|
$0 | |
| Windows / Doors |
$
|
$0 | |
| Roofing / Siding / Exterior |
$
|
$0 | |
| Common Areas / Amenities |
$
|
$0 | |
| Site Work / Parking |
$
|
$0 | |
| Total Renovation Budget | $0 | ||
| Cost Per Unit | $0 | ||
ROI Analysis Heavy VA
$
%
Returns on Renovation
| Total Reno (w/ contingency) | $0 |
| Annual Rent Premium Added | $0 |
| Return on Renovation (ROI) | 0% |
| Payback Period | 0 yrs |
| Value Created (at Exit Cap) | $0 |
Renovation Phasing % of Units Renovated by Year
| Unit Type | Yr 1 % | Yr 2 % | Yr 3 % | Yr 4 % | Yr 5 % | Total Units Renovated |
|---|---|---|---|---|---|---|
| Studio | % |
% |
% |
% |
% |
0 |
| 1 BR | % |
% |
% |
% |
% |
0 |
| 2 BR | % |
% |
% |
% |
% |
0 |
| 3 BR | % |
% |
% |
% |
% |
0 |
| Grand Total Units Renovated (all types) | 0 units | |||||
Enter % of each unit type's count to be renovated per year. Totals >100% will flag in red.
Unit Type Renovation Breakdown Distressed
| Unit Type | Count to Renovate | Reno Cost / Unit | Subtotal |
|---|---|---|---|
| Studio |
$
|
$0 | |
| 1 Bedroom |
$
|
$0 | |
| 2 Bedroom |
$
|
$0 | |
| 3 Bedroom |
$
|
$0 | |
| Unit Type Total | $0 | ||
| Total Units Planned for Renovation | 0 units | ||
Distressed Budget Deep Renovation
| Scope Item | Cost/Unit | Units | Total Cost |
|---|---|---|---|
| Structural Repairs |
$
|
$0 | |
| Full Unit Gut Rehab |
$
|
$0 | |
| Roof Replacement |
$
|
$0 | |
| Plumbing / Sewer |
$
|
$0 | |
| Electrical / Panel Upgrades |
$
|
$0 | |
| HVAC (all units) |
$
|
$0 | |
| Environmental / Remediation |
$
|
$0 | |
| Site / Parking / Landscaping |
$
|
$0 | |
| Total Renovation Budget | $0 | ||
| Cost Per Unit | $0 | ||
ROI Analysis Distressed
$
%
Returns on Renovation
| Total Reno (w/ contingency) | $0 |
| Annual Rent Premium Added | $0 |
| Return on Renovation (ROI) | 0% |
| Payback Period | 0 yrs |
| Value Created (at Exit Cap) | $0 |
Renovation Phasing % of Units Renovated by Year
| Unit Type | Yr 1 % | Yr 2 % | Yr 3 % | Yr 4 % | Yr 5 % | Total Units Renovated |
|---|---|---|---|---|---|---|
| Studio | % |
% |
% |
% |
% |
0 |
| 1 BR | % |
% |
% |
% |
% |
0 |
| 2 BR | % |
% |
% |
% |
% |
0 |
| 3 BR | % |
% |
% |
% |
% |
0 |
| Grand Total Units Renovated (all types) | 0 units | |||||
Enter % of each unit type's count to be renovated per year. Totals >100% will flag in red.
Pro Forma Assumptions Growth Rates
%
%
Sunbelt avg 3% rent / Midwest avg 2% · tertiary markets often 1-2%. Tune per deal — the standard 3% default runs hot on stabilized assets and low on heavy value-add.
%
%
%
$
Leave blank to auto-compute from T-12. Enter broker pro forma NOI for value-add deals.
Back-solves implied rent growth from broker Yr-1 & Yr-5 NOI.
$
%
Reno load = $/Unit × Units × %. Overrides the auto-computed Value-Add budget in the pro forma cash flows. Set lower (or $0) on small high-OpEx assets to avoid false negative cash flow.
Exit Analysis Sale Proceeds
| Exit Year NOI | $0 |
| Gross Sale Price | $0 |
| Selling Costs | $0 |
| Net Sale Price | $0 |
| Loan Payoff (at exit) | $0 |
| Net Equity at Exit | $0 |
| Total Cash Distributions | $0 |
| Total Profit | $0 |
5-Year Cash Flow Projection Annual Summary
| Metric | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Gross Potential Rent | |||||
| Vacancy Loss | |||||
| Other Income | |||||
| EGI | |||||
| Operating Expenses | |||||
| NOI | |||||
| Debt Service | |||||
| Cash Flow | |||||
| Cash-on-Cash | |||||
| DSCR | |||||
| NOI Growth % | Base | ||||
| Cap Rate | |||||
| Property Value (at cap) |
Capital-Stack Metrics Unlevered IRR · Debt Yield · YoC
Unlevered IRR
0.00%
Debt Yield · Bridge
0.00%
Debt Yield · Perm
0.00%
Yield-on-Cost
0.00%
Scenario Modeling Edit assumptions per column
| Assumption | Conservative | Base | Aggressive |
|---|---|---|---|
| Rent Growth % | |||
| Exit Cap Rate % | |||
| Vacancy % | |||
| Expense Growth % | |||
| IRR | — | — | — |
| Equity Multiple | — | — | — |
| Avg CoC | — | — | — |
IRR Sensitivity Rent Growth x Exit Cap
| Rent Growth \ Exit Cap | — | — | — | — | — |
|---|---|---|---|---|---|
| 1.0% | — | — | — | — | — |
| 2.0% | — | — | — | — | — |
| 3.0% | — | — | — | — | — |
| 4.0% | — | — | — | — | — |
| 5.0% | — | — | — | — | — |
Cash Flow & Value Chart 5-Year
Price Scenarios negotiation table
to
step
Our Offer Price
$0
vs ask: —
Max Offer (at target cap)
$0
— per unit
Target Cap Rate
0%
Minimum acceptable
Target CoC Yr 1
0%
Minimum acceptable
Max Offer Calculator Work Backwards
%
%
%
x
Maximum Offer Based on Criteria
| NOI (Underwritten) | $0 |
| Max Price @ Target Cap Rate | $0 |
| Max Price @ Target CoC | $0 |
| Recommended Max Offer | $0 |
| Seller Asking Price | $0 |
| Discount to Ask | $0 (0%) |
| Our Offer Price | $0 |
Offer Scenarios Price Sensitivity
| Scenario | Offer Price | Cap Rate | DSCR | CoC Yr1 | IRR |
|---|---|---|---|---|---|
| Full Ask | $0 | 0% | 0.00 | 0% | 0% |
| Our Offer | $0 | 0% | 0.00 | 0% | 0% |
| Max Offer | $0 | 0% | 0.00 | 0% | 0% |
LOI / Offer Summary Key Data Points
| Property Name | — |
| Property Address | — |
| Total Units | — |
| Year Built | — |
| Offer Price | $0 |
| Price Per Unit | $0 |
| Due Diligence Period | |
| Closing Timeline | |
| Earnest Money Deposit | |
| Financing Contingency |
DEAL DECISION Pipeline Status Update
—