BETAEstimates only · Verify all outputs independently before submitting offers, financing requests, or investor commitments · Cornerstone UW App is in active validation against back-tested deals
New Deal Underwriting Analyzer
Light Value Add Light Value Add
?
Guest

✅ Deal Tasks

Deal: No deal loaded

🎓 UW Guide

Loading…

⚡ Quick Look

Back-of-napkin snapshot
Loading…

🔗 Load Property from Pipeline

📁 Property Documents

🗂 Open Property Folder in Google Drive →
🔗 Connect your PROPERTY DEALFLOW sheet by setting UW_API_URL in the script.
Deploy UWApi.gs as a web app from your sheet, then paste the /exec URL at the top of the <script> section below.
🏢
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 uniti
Cap Rate (T12)i
0.00%
Day 1 Proforma
NOI (Underwritten)i
$0
Expense ratio: —
Cash-on-Cash Yr1i
0.00%
After debt service
IRR (5-Year)i
0.00%
Equity multiple: —
DSCRi
0.00
LTV: —
Unlevered IRRi
0.00%
No-debt IRR
Debt Yield
0.00%
Lender stress test
Yield-on-Costi
0.00%
Stabilized / all-in
Property Information Deal Setup
Pricing Matrix Ask vs Underwritten
$
$
Metric Asking Price Our Offer Variance
Price Per Unit
Price Per Sqfti
Cap Rate (T12)i
GRMi
Whisper Price — of ask
Last Sale Price
UW Notes Analyst Comments
Purchase KPIs At Offer Price
Cap Rate @ Purchase (T12)i
Cap Rate Proforma (Day 1)i
Cap Rate Proforma (Yr 1)i
Gross Rent Multiplier (T12)i
Net Income Multiplieri
Debt Coverage Ratio (DSCR)i
Purchase Cash-on-Cash (Day 1)i
Returns KPIs 5-Year Hold
Cash-on-Cash Return (Yr 1)i
Cash-on-Cash Return (Avg)i
Annual Rate of Returni
IRR (5-Year)i
Equity Multiple
Exit Cap Ratei
Exit Valuei
Total Returni
NOI Bridge Underwritten
Gross Income
$0
Expenses
$0
0% ratio
=
NOI
$0
Debt Svc
$0
=
Cash Flow
$0
Occupied Unitsi
0
0% occupancy
Vacant Unitsi
0
0% vacancy
Current EGI (Annual)i
$0
Avg rent: $0/unit
Market EGI (Annual)i
$0
Avg market: $0/unit
Rent Upside (Annual)i
$0
0% loss to lease
Avg Rent/Sqfti
$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)i $0
Loss to Lease (in-place vs market)i ($0)
Below-Market Unitsi 0
Avg Rent Increase Per Uniti $0
Total Annual Upsidei $0
Upside as % of GPRi 0%
$
Monthly Upgrade Income $0
Annual Upgrade Income $0
Unit Distribution Charts

Gross Potential Renti
$0
Annual
Effective Gross Incomei
$0
$0/mo
Total Expensesi
$0
0% of EGI
NOIi
$0
0% margin
Exp/Unit/Monthi
$0
Industry avg ~$350–$600
T12 NOI Normalization As-Reported vs Normalized

Brokers and comp tools (e.g. Multydeals) 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.

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
Gross Potential Rent (GPR)i
$
$
Loss to Leasei
($
($
Economic Vacancy / Credit Lossi
($
($
Bad Debt / Concessions
($
($
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
Property Management (% of EGI)
%
%
Property Taxes
$
$
Insurance
$
$
Repairs & Maintenance
$
$
Capital Reserves ($/unit/yr)i
$
$
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
Loan Amounti
$0
0% LTV
Equity Requiredi
$0
0% down
Annual Debt Servicei
$0
$0/mo
DSCR (Proforma)i
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
Loan Amount $0
LTV Ratioi 0%
Monthly P&I Paymenti $0
Year 1 Annual Debt Servicei $0
DSCR (NOI / ADS)i 0.00
Debt Yield (NOI / Loan)i 0%
Break-Even Occupancyi 0%
Capital Stack Total Investment
$
%
$
Synced from Value Add tab
$
Purchase Price $0
Down Paymenti $0
Closing Costsi $0
Acquisition Feei $0
Renovation Budgeti $0
Operating Reservesi $0
Total Capital Requiredi $0
Loan Amount $0
Total Project Cost $0
LTC (Loan-to-Cost)i 0%
Capital Stack Visual Equity vs Debt
ℹ️
Value Add budget flows into the Financing tab (Total Capital) and affects Pro Forma projections. Select your deal type below to see the appropriate renovation scope template.
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
$
%
Total Reno Budget (w/ contingency)i $0
Annual Rent Premium Added $0
Return on Renovation (ROI) 0%
Payback Periodi 0 yrs
Value Created (at Exit Cap) $0
Forced Appreciation / Uniti $0
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
$
%
Total Reno (w/ contingency) $0
Annual Rent Premium Added $0
Return on Renovation (ROI) 0%
Payback Periodi 0 yrs
Value Created (at Exit Cap) $0
⚠️
Distressed / deep value properties require extensive due diligence. Budget generously for structural, mechanical, and deferred maintenance items. Contingency should be 20–25%.
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
$
%
Total Reno (w/ contingency) $0
Annual Rent Premium Added $0
Return on Renovation (ROI) 0%
Payback Periodi 0 yrs
Value Created (at Exit Cap) $0
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 NOIi $0
Gross Sale Pricei $0
Selling Costsi $0
Net Sale Pricei $0
Loan Payoff (at exit)i $0
Net Equity at Exiti $0
Total Cash Distributionsi $0
Total Profiti $0
5-Year Cash Flow Projection Annual Summary
Metric Year 1 Year 2 Year 3 Year 4 Year 5
Gross Potential Renti
Vacancy Lossi
Other Income
EGI
Operating Expensesi
NOI
Debt Servicei
Cash Flow
Cash-on-Cash
Cap Ratei
Property Value (at cap)i
Capital-Stack Metrics Unlevered IRR · Debt Yield · YoC
Unlevered IRRi
0.00%
Debt Yield · Bridgei
0.00%
Debt Yield · Permi
0.00%
Yield-on-Costi
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 iRent Growth x Exit Cap
Rent Growth \ Exit Cap
1.0%
2.0%
3.0%
4.0%
5.0%
Cash Flow & Value Chart 5-Year
Our Offer Price
$0
vs ask: —
Max Offer (at target cap)i
$0
— per unit
Target Cap Ratei
0%
Minimum acceptable
Target CoC Yr 1i
0%
Minimum acceptable
Max Offer Calculator Work Backwards
%
%
%
x
NOI (Underwritten)i $0
Max Price @ Target Cap Ratei $0
Max Price @ Target CoCi $0
Recommended Max Offeri $0
Seller Asking Price $0
Discount to Ask $0 (0%)
Our Offer Price $0
Offer Scenarios Price Sensitivity
Scenario Offer Price Cap Ratei DSCRi CoC Yr1i IRRi
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
Investor Package Cover
— units · — sqft · built —
Offer $— · $—/unit · $—/sqft
[Property photo placeholder — drop image in Drive folder]
Executive Summary Auto-generated

Sources & Uses Capital Stack
Uses$ AmountSources$ Amount
Purchase PriceSenior Debti
Renovation / CapExiEquityi
Closing & Acq Feesi  
Reservesi  
Total UsesTotal Sources
Returns Summary Risk · Debt · Returns
Returns
Levered IRR (5-yr)i
Unlevered IRRi
Equity Multiplei
Avg Cash-on-Cashi
Yield-on-Costi
Risk
Going-in Capi
Stabilized Capi
Exit Capi
Bear IRRi
Bull IRRi
Debt
Loan Amounti
LTVi
DSCR (Stab)i
Debt Yieldi
Loan Typei
5-Year Cash Flow Annual
MetricYr 1Yr 2Yr 3Yr 4Yr 5
Risk Factors Auto-flagged
    Disclaimer: Projections in this package are based on assumptions made by Cornerstone Investment Group and are subject to change. Past performance is not indicative of future results. This document is for discussion purposes only and does not constitute an offer to sell or a solicitation of an offer to buy any security. Recipients should conduct their own due diligence.
    Days to Close
    Deal Start
    Target Close
    DD Deadline
    📅 Deal Timeline
    Click any phase bar to edit dates
    Zoom:
    Phases:
    ℹ️
    Build a portfolio view by snapping the current deal into a slot. Load up to 8 properties to compare side-by-side with aggregate KPIs. Each snap captures a moment-in-time snapshot of the deal currently in the UW form.
    0 deals
    Portfolio Comparison Matrix Side-by-Side
    Use "Snap Current Deal" to add the property currently loaded in the UW form. Up to 8 properties.
    Portfolio Aggregate KPIs Blended View
    Add deals above to see aggregate portfolio metrics.
    BETA · ESTIMATES ONLY — Outputs are pro forma estimates only. Verify independently before submitting offers, financing requests, or investor commitments. Cornerstone Investment Group is not a registered investment advisor; UW App is for internal analysis only.