Valtrics - Deal Screening Engine

Project Details

Development Name
Location
Project Type
Asset Class
Class / Grade

Saved Projects

Sign in with Google (top right) to save this deal and reload it later. Your work autosaves to your account while signed in.

Ask Price

Ask Price ($)

$51.52 /SF

Section 1 - Asset Summary

Enter each building. Add or remove rows to fit the deal. Portfolio totals feed the entire model.

Building	Year Built	Total SF (BUA)	Total RSF
TOTAL PORTFOLIO		-	-

Section 2 - Rehabilitation Cost Budget

Line Item	Total Cost	$/Unit	QRE	Note
Structural / Envelope Repairs	-	-	Yes	Historic rehab - QRE eligible
MEP Systems (full replacement)	-	-	Yes	QRE eligible
Interior Build-Out (residential)	-	-	Yes	QRE eligible
Common Area / Amenities	-	-	Yes	QRE eligible
Elevator Upgrades (3 bldgs)	-	-	Yes	QRE eligible
Facade / Historic Preservation	-	-	Yes	Critical for HTC - QRE eligible
New Construction / Additions	-	-	No	NOT QRE - new construction
Site Work & Parking	-	-	No	NOT QRE - site work
HTC Dev Fee (%)	-	-	Yes	QRE eligible, not in project cost
Soft Costs (% of hard costs)	-	-	Yes	Arch, eng, permits
Management Fee (% of total)	-	-	No	% of total project cost
Contingency (% of hard+soft)	-	-	Yes	% of hard + soft
QRE Total	-	-
TOTAL REHABILITATION COST	-	-

Section 3 - Historic Tax Credit Analysis

Historic Tax Credits Apply?		Set to "No" for non-historic developments (no HTC benefit)
Federal HTC Rate (%)		20% of QRE - IRC Section 47
State HTC Rate (%)		% of QRE - state historic credit (adjust per jurisdiction)
Combined HTC Rate (%)	45%
Federal HTC ($)	-
State HTC ($)	-
TOTAL HISTORIC TAX CREDITS ($)	-
Federal HTC Syndication Rate (cents/$)		Market rate for HTC syndication
State HTC Syndication Rate (cents/$)		Market rate for HTC syndication
HTC Equity Proceeds ($)	-
Net Equity Required After HTC	-

Section 4 - Total All-In Project Cost

Ask Price	-
Acquisition Closing Costs (%)		-
Title & Insurance (% of purchase)		-
Due Diligence / Inspection
Marketing & Lease-up
Interest Reserves		Manually adjust
Total Rehabilitation Cost	-
Loan Fee		Manually adjust
TOTAL ALL-IN PROJECT COST	-	-

Section 5 - Income & NOI Build

Income by Use Type

Metric	Residential	Commercial	Retail
Area (SF)
Units
Avg Unit Size (SF)	-	-	-
Rent $/SF/Mo
Avg Rent $/Unit/Mo		-	-
Annual GPR (Yr 1)	-	-	-
TOTAL	-

Unit / Tenant Mix & Rents (optional)

Each use type has its own optional mix table. When a table has rows with units, that use's Units and Annual GPR above are built from the mix. Leave a table empty to use the average above instead (Residential uses Avg Rent $/Unit/Mo; Commercial & Retail use Rent $/SF/Mo), which you can edit directly.

Residential

Unit Type	# Units	Avg Size (SF)	Rent $/Unit/Mo	Monthly Rent
TOTAL	-	-	-	-

Commercial

Tenant / Unit Type	# Units	Avg Size (SF)	Rent $/Unit/Mo	Monthly Rent
TOTAL	-	-	-	-

Retail

Tenant / Unit Type	# Units	Avg Size (SF)	Rent $/Unit/Mo	Monthly Rent
TOTAL	-	-	-	-

Market & Operating Assumptions

Total Units (all uses)	-
Absorption / Mo
Annual Rent Growth (%)
Stabilized Vacancy (%)

Credit Loss (%)
Other Income (% of GPR)
OpEx (% of EGI)
OpEx Growth (%/yr)

Section 6 - Financing Assumptions

Construction Loan LTC (%)
Construction Loan Rate (%)
Construction Amortization (yrs)
Perm Loan LTV (%)
Perm Loan Rate (%)
Refi Amortization (yrs)

Loan Fee (%)
Months to Construct
Stabilisation Month
Interest Reserve (months)
Refi (Yes/No)
Months to Refi (Post Stab)
Months to Exit (Post Refi)

Capital Stack

Source	% of Total	Amount ($)
Construction Loan	-	-
HTC Equity Proceeds	-	-
Equity Required	-	-

Section 7 - Exit Valuation & Debt Service

Refi Cap Rate (%)
Exit Cap Rate (%)
Cost of Sale (%) at Exit
Market Cap Rate for YoC (%)

Gross Exit Value	-
Net Exit Proceeds	-
Refi Loan Amount	-
Net Gain at Exit	-

Development Name - Location

Deal Screening System & Price Discovery System · Reverse Price Engine

Key Drivers

Key Risks