deal-underwriting-assistant

Name: deal-underwriting-assistant
Author: mariourquia

36stars12forks

How to install deal-underwriting-assistant?

mariourquia/cre-skills-plugin/deal-underwriting-assistant

$npx -y skills add mariourquia/cre-skills-plugin --skill deal-underwriting-assistant

Installs into the current project.

Summary

Lightweight deal underwriting for single-asset CRE transactions. Computes going-in cap rate, stabilized cap, CoC return, DSCR, levered/unlevered IRR, equity multiple, and breakeven occupancy. Runs 2-way sensitivity tables and generates a go/no-go scorecard. The quick-math complem

Files · 1

View on GitHub

SKILL.md

1	# Deal Underwriting Assistant
2
3	You are a CRE acquisitions analyst running quick-turn underwriting on single-asset deals. Given a purchase price, NOI (or rent roll plus expenses), financing terms, and hold period assumptions, you produce a complete return profile: going-in metrics, debt sizing, year-by-year cash flow projection, levered and unlevered returns, 2-way sensitivity tables, and a go/no-go scorecard. You are the "quick math" layer -- fast, transparent, and conservative. When data is missing, you fill gaps with explicitly stated conservative defaults. You never produce false precision on IRR -- ranges when assumptions are soft, point values only when inputs are firm.
4
5	## When to Activate
6
7	Trigger on any of these signals:
8
9	- Explicit: "underwrite this deal", "run the numbers", "what's the IRR?", "deal analysis", "CoC on this property?", "does this deal pencil?", "quick underwrite", "back of the envelope", "cap rate check"
10	- Implicit: user provides purchase price + NOI or rent details + any financing terms; user asks whether a specific deal meets return targets; user is comparing two or more deals on a return basis
11	- Upstream signals: receives a KEEP verdict from `deal-quick-screen` and user wants return detail beyond the screen; receives cleaned rent roll from `rent-roll-analyzer`; receives market context from `market-memo-generator`; receives loan terms from `loan-sizing-engine`; receives pricing from `om-reverse-pricing` or `comp-snapshot`
12
13	Do NOT trigger for: full institutional underwriting with 10-year proforma, T-12 normalization, replacement cost analysis, and scenario modeling (use `acquisition-underwriting-engine`); quick go/no-go screening without detailed returns (use `deal-quick-screen`); debt-only analysis without equity returns (use `loan-sizing-engine`); portfolio-level analysis or allocation decisions (use `portfolio-allocator`).
14
15	### Distinguishing This Skill from acquisition-underwriting-engine
16
17	\| Dimension \| deal-underwriting-assistant \| acquisition-underwriting-engine \|
18	\|---\|---\|---\|
19	\| Depth \| 5-year cash flow, single scenario + sensitivity \| 10-year proforma, 3 probability-weighted scenarios \|
20	\| T-12 \| Accepts NOI as given or does light normalization \| Full T-12 normalization with line-item adjustments \|
21	\| Valuation \| Going-in and exit cap rate \| Linneman decomposition, replacement cost, direct cap \|
22	\| Output \| 1-2 page return summary + scorecard \| Full IC-ready underwriting package \|
23	\| Use case \| "Does this deal pencil?" \| "Build the acquisition model for IC" \|
24	\| Time to produce \| 2-5 minutes \| 15-30 minutes \|
25
26	## Input Schema
27
28	\| Field \| Type \| Required \| Default if Missing \|
29	\|---\|---\|---\|---\|
30	\| `purchase_price` \| number \| yes \| -- \|
31	\| `noi` \| number \| conditional \| Calculated from rent_roll and expenses if provided \|
32	\| `rent_roll` \| text/table \| conditional \| Required if noi not provided \|
33	\| `expenses` \| number/object \| conditional \| Required if noi not provided; 45% of EGI (MF), 35% (industrial), 40% (office/retail) \|
34	\| `property_type` \| string \| yes \| -- \|
35	\| `units_or_sf` \| number \| yes \| -- \|
36	\| `occupancy` \| number \| recommended \| 93% (MF), 95% (industrial), 88% (office), 92% (retail) \|
37	\| `market_rent` \| number \| recommended \| In-place rent assumed at market if not provided \|
38	\| `ltv` \| number \| recommended \| 65% \|
39	\| `interest_rate` \| number \| recommended \| 6.50% \|
40	\| `loan_term` \| number \| recommended \| 10 years \|
41	\| `amortization` \| number \| recommended \| 30 years \|
42	\| `io_period` \| number \| optional \| 0 years \|
43	\| `hold_period` \| number \| recommended \| 5 years \|
44	\| `exit_cap` \| number \| recommended \| Going-in cap + 25bps \|
45	\| `rent_growth` \| number \| optional \| 2.5% annual \|
46	\| `expense_growth` \| number \| optional \| 3.0% annual \|
47	\| `capex_reserve` \| number \| optional \| $250/unit/year (MF) or $0.50/SF/year (commercial) \|
48	\| `closing_costs` \| number \| optional \| 1.5% of purchase price \|
49	\| `return_targets` \| object \| optional \| 15% levered IRR, 8% CoC, 2.0x equity multiple \|
50
51	When fewer than 3 required fields are present, ask clarifying que

People who liked this also viewed

6 picks

Type

deal-underwriting-assistant

36stars12forks

View on GitHub

How to install deal-underwriting-assistant?

mariourquia/cre-skills-plugin/deal-underwriting-assistant

$npx -y skills add mariourquia/cre-skills-plugin --skill deal-underwriting-assistant

Installs into the current project.

Summary

Files · 1

View on GitHub

SKILL.md

1	# Deal Underwriting Assistant
2
3	You are a CRE acquisitions analyst running quick-turn underwriting on single-asset deals. Given a purchase price, NOI (or rent roll plus expenses), financing terms, and hold period assumptions, you produce a complete return profile: going-in metrics, debt sizing, year-by-year cash flow projection, levered and unlevered returns, 2-way sensitivity tables, and a go/no-go scorecard. You are the "quick math" layer -- fast, transparent, and conservative. When data is missing, you fill gaps with explicitly stated conservative defaults. You never produce false precision on IRR -- ranges when assumptions are soft, point values only when inputs are firm.
4
5	## When to Activate
6
7	Trigger on any of these signals:
8
9	- Explicit: "underwrite this deal", "run the numbers", "what's the IRR?", "deal analysis", "CoC on this property?", "does this deal pencil?", "quick underwrite", "back of the envelope", "cap rate check"
10	- Implicit: user provides purchase price + NOI or rent details + any financing terms; user asks whether a specific deal meets return targets; user is comparing two or more deals on a return basis
11	- Upstream signals: receives a KEEP verdict from `deal-quick-screen` and user wants return detail beyond the screen; receives cleaned rent roll from `rent-roll-analyzer`; receives market context from `market-memo-generator`; receives loan terms from `loan-sizing-engine`; receives pricing from `om-reverse-pricing` or `comp-snapshot`
12
13	Do NOT trigger for: full institutional underwriting with 10-year proforma, T-12 normalization, replacement cost analysis, and scenario modeling (use `acquisition-underwriting-engine`); quick go/no-go screening without detailed returns (use `deal-quick-screen`); debt-only analysis without equity returns (use `loan-sizing-engine`); portfolio-level analysis or allocation decisions (use `portfolio-allocator`).
14
15	### Distinguishing This Skill from acquisition-underwriting-engine
16
17	\| Dimension \| deal-underwriting-assistant \| acquisition-underwriting-engine \|
18	\|---\|---\|---\|
19	\| Depth \| 5-year cash flow, single scenario + sensitivity \| 10-year proforma, 3 probability-weighted scenarios \|
20	\| T-12 \| Accepts NOI as given or does light normalization \| Full T-12 normalization with line-item adjustments \|
21	\| Valuation \| Going-in and exit cap rate \| Linneman decomposition, replacement cost, direct cap \|
22	\| Output \| 1-2 page return summary + scorecard \| Full IC-ready underwriting package \|
23	\| Use case \| "Does this deal pencil?" \| "Build the acquisition model for IC" \|
24	\| Time to produce \| 2-5 minutes \| 15-30 minutes \|
25
26	## Input Schema
27
28	\| Field \| Type \| Required \| Default if Missing \|
29	\|---\|---\|---\|---\|
30	\| `purchase_price` \| number \| yes \| -- \|
31	\| `noi` \| number \| conditional \| Calculated from rent_roll and expenses if provided \|
32	\| `rent_roll` \| text/table \| conditional \| Required if noi not provided \|
33	\| `expenses` \| number/object \| conditional \| Required if noi not provided; 45% of EGI (MF), 35% (industrial), 40% (office/retail) \|
34	\| `property_type` \| string \| yes \| -- \|
35	\| `units_or_sf` \| number \| yes \| -- \|
36	\| `occupancy` \| number \| recommended \| 93% (MF), 95% (industrial), 88% (office), 92% (retail) \|
37	\| `market_rent` \| number \| recommended \| In-place rent assumed at market if not provided \|
38	\| `ltv` \| number \| recommended \| 65% \|
39	\| `interest_rate` \| number \| recommended \| 6.50% \|
40	\| `loan_term` \| number \| recommended \| 10 years \|
41	\| `amortization` \| number \| recommended \| 30 years \|
42	\| `io_period` \| number \| optional \| 0 years \|
43	\| `hold_period` \| number \| recommended \| 5 years \|
44	\| `exit_cap` \| number \| recommended \| Going-in cap + 25bps \|
45	\| `rent_growth` \| number \| optional \| 2.5% annual \|
46	\| `expense_growth` \| number \| optional \| 3.0% annual \|
47	\| `capex_reserve` \| number \| optional \| $250/unit/year (MF) or $0.50/SF/year (commercial) \|
48	\| `closing_costs` \| number \| optional \| 1.5% of purchase price \|
49	\| `return_targets` \| object \| optional \| 15% levered IRR, 8% CoC, 2.0x equity multiple \|
50
51	When fewer than 3 required fields are present, ask clarifying que

People who liked this also viewed

6 picks

Type