real-estate-investment

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

Real Estate Investment Analysis

房地产投资分析

Comprehensive real estate investment analysis — from deal screening through financial modeling to investor-ready output. Covers all property types, standard and advanced metrics, code generation, and tax-aware structuring.

全面的房地产投资分析能力——覆盖从交易筛选、财务建模到符合投资者要求的输出全流程，支持所有房产类型、标准及进阶指标、代码生成，以及税务优化结构设计。

Analysis Workflow

分析工作流

Follow this 6-step process for any deal or market analysis:

Define scope — Identify property type, investment strategy, and target output format
Gather data — Collect property financials, market data, and comps (use API reference if automating)
Build pro forma — Construct income statement: Gross Rent → Vacancy → EGI → OpEx → NOI → Debt Service → Cash Flow
Calculate returns — Apply appropriate metrics (see Quick Reference below)
Stress test — Run sensitivity analysis, scenarios, or Monte Carlo simulation
Report — Generate investor-ready output with recommendations

所有交易或市场分析都遵循以下6步流程：

明确范围——确定房产类型、投资策略和目标输出格式
收集数据——采集房产财务数据、市场数据和可比房源（comps），如果是自动化流程可参考API文档
构建预估财务模型（pro forma）——搭建利润表：总租金 → 空置成本 → 有效总收入（EGI） → 运营支出（OpEx） → NOI → 债务偿付 → 现金流
计算收益——选用适配的指标（参考下方速查手册）
压力测试——运行敏感性分析、多场景模拟或Monte Carlo模拟
输出报告——生成符合投资者要求的结果及对应建议

Quick Reference — Core Metrics

核心指标速查

Metric	Formula	Typical Range
NOI	Effective Gross Income - Operating Expenses	Varies by asset
Cap Rate	NOI / Property Value	4-10% (market-dependent)
Cash-on-Cash	Annual Pre-Tax Cash Flow / Total Cash Invested	8-12% target
DSCR	NOI / Annual Debt Service	1.2x+ (lender minimum)
IRR	Discount rate zeroing NPV of all cash flows	15-20% target
Equity Multiple	Total Distributions / Total Capital Invested	2.0x+ over hold
GRM	Property Price / Annual Gross Rent	8-15 (lower = better)
Break-even Occ.	(OpEx + Debt Service) / Potential Gross Income	<85% preferred

For complete formulas, Python code, and Excel equivalents → load

references/financial-metrics.md

指标	公式	典型区间
NOI	有效总收入 - 运营支出	随资产类型变化
Cap Rate	NOI / 房产价值	4-10%（随市场变化）
Cash-on-Cash	年度税前现金流 / 总投入现金	目标值8-12%
DSCR	NOI / 年度债务偿付额	1.2x+（放贷机构最低要求）
IRR	使所有现金流净现值为0的折现率	目标值15-20%
Equity Multiple	总分派收益 / 总投入资本	持有期内2.0x+
GRM	房产价格 / 年度总租金	8-15（越低越好）
盈亏平衡入住率	(运营支出 + 债务偿付) / 潜在总租金	优先低于85%

如需完整公式、Python代码和Excel等效公式，请加载

references/financial-metrics.md

Property Type Router

房产类型路由

Select the analysis framework based on property type:

Property Type	Key Metrics	Rules of Thumb	Reference
SFR / Small Multi (1-4)	CoC, Cap Rate, DSCR	1% rule, 50% rule, 70% rule	`references/property-types.md` §Residential
BRRRR	ARV, Rehab ROI, Refi LTV	70% rule: Max buy = 70% ARV - repairs	`references/property-types.md` §Residential
House Hack	Effective housing cost, FHA terms	3.5% down FHA, self-sufficiency test	`references/property-types.md` §Residential
Large Multifamily (5+)	Per-unit metrics, NOI, Cap Rate	OpEx ratio 35-45%	`references/property-types.md` §Commercial
Commercial (Office/Retail)	Per-SF metrics, lease analysis	NNN vs Gross lease impact	`references/property-types.md` §Commercial
Short-Term Rental	RevPAR, ADR, Occupancy	Revenue = ADR x Occ x 365 - fees	`references/property-types.md` §STR
Land / Development	Absorption rate, dev pro forma	Total cost vs projected value	`references/property-types.md` §Land

根据房产类型选择分析框架：

房产类型	核心指标	经验法则	参考文档
独栋住宅/小型多户住宅（1-4户）	CoC, Cap Rate, DSCR	1%法则、50%法则、70%法则	`references/property-types.md` §住宅类
BRRRR	ARV、翻新ROI、再融资LTV	70%法则：最高买入价 = 70% ARV - 修复成本	`references/property-types.md` §住宅类
House Hack	有效居住成本、FHA条款	3.5%首付FHA贷款、自足性测试	`references/property-types.md` §住宅类
大型多户住宅（5户及以上）	单户指标、NOI、Cap Rate	运营支出占比35-45%	`references/property-types.md` §商业类
商业地产（写字楼/零售）	每平方英尺指标、租约分析	NNN与总租约的差异影响	`references/property-types.md` §商业类
短租物业	RevPAR、ADR、入住率	收入 = ADR × 入住率 × 365 - 费用	`references/property-types.md` §STR
土地/开发项目	去化率、开发预估财务模型	总成本 vs 预估价值	`references/property-types.md` §土地类

Analysis Type Router

分析类型路由

Select the analysis methodology based on what the user needs:

Need	Method	Reference File
Run the numbers on a deal	Pro forma + core metrics	`references/financial-metrics.md`
Stress test assumptions	Sensitivity analysis (bear/base/bull)	`references/advanced-analysis.md` §Sensitivity
Model uncertainty/risk	Monte Carlo simulation	`references/advanced-analysis.md` §MonteCarlo
Syndication distributions	Waterfall modeling (GP/LP splits)	`references/advanced-analysis.md` §Waterfall
Compare/score markets	Market scoring framework	`references/market-analysis.md` §Scoring
Pull market data via API	API integration patterns	`references/market-analysis.md` §APIs
Find and adjust comps	Comparable analysis	`references/market-analysis.md` §Comps
Optimize tax impact	Depreciation, cost seg, 1031	`references/tax-strategy.md`
Choose entity structure	LLC, LP, S-Corp comparison	`references/tax-strategy.md` §Entity

根据用户需求选择分析方法：

需求	方法	参考文件
核算交易收益	预估财务模型 + 核心指标	`references/financial-metrics.md`
假设条件压力测试	敏感性分析（熊市/基准/牛市场景）	`references/advanced-analysis.md` §敏感性分析
不确定性/风险建模	Monte Carlo模拟	`references/advanced-analysis.md` §MonteCarlo
联合投资收益分配	瀑布式收益建模（GP/LP分成）	`references/advanced-analysis.md` §Waterfall
市场对比/评分	市场评分框架	`references/market-analysis.md` §Scoring
通过API拉取市场数据	API集成模式	`references/market-analysis.md` §APIs
查找并调整可比房源	可比分析	`references/market-analysis.md` §Comps
优化税务影响	折旧、成本分隔、1031置换	`references/tax-strategy.md`
选择主体架构	LLC、LP、S-Corp对比	`references/tax-strategy.md` §Entity

Output Format Selection

输出格式选择

Adapt output to the user's request:

Spreadsheet-ready — Generate formatted tables with formulas. Use pandas DataFrames exported to CSV/Excel. Include Excel formula equivalents for each calculation.

Decision framework — Provide structured narrative analysis with go/no-go recommendation. Include risk factors, key assumptions, and sensitivity ranges.

Code generation — Produce Python scripts using numpy-financial and pandas. Include complete, runnable pro forma models, Monte Carlo simulators, or waterfall calculators.

Investor report — Combine all three: executive summary, financial tables, risk analysis, and appendix with methodology.

根据用户需求调整输出格式：

可直接导入表格——生成带公式的格式化表格，使用pandas DataFrames导出为CSV/Excel格式，每项计算都附带等效Excel公式。

决策框架——提供结构化的分析说明及是否推进的建议，包含风险因素、核心假设和敏感性波动范围。

代码生成——输出基于numpy-financial和pandas的Python脚本，包含完整可运行的预估财务模型、Monte Carlo模拟器或瀑布式收益计算器。

投资者报告——整合以上三类内容：执行摘要、财务表格、风险分析，以及带方法说明的附录。

Operating Expense Benchmarks by Property Type

不同房产类型的运营支出基准

Property Type	OpEx Ratio (% of EGI)	Management Fee
Single-Family Rental	35-50%	8-10%
Small Multifamily (2-4)	35-45%	8-10%
Large Multifamily (5+)	35-45%	5-8%
Office	35-55%	3-5%
Retail (NNN)	15-25%	3-5%
Retail (Gross)	60-80%	3-5%
Industrial	15-25%	3-5%
Short-Term Rental	50-65%	20-25%

房产类型	运营支出占比（占EGI的百分比）	管理费
独栋住宅租赁	35-50%	8-10%
小型多户住宅（2-4户）	35-45%	8-10%
大型多户住宅（5户及以上）	35-45%	5-8%
写字楼	35-55%	3-5%
零售地产（NNN）	15-25%	3-5%
零售地产（总租约）	60-80%	3-5%
工业地产	15-25%	3-5%
短租物业	50-65%	20-25%

Key Tax Thresholds (2025-2026)

核心税务阈值（2025-2026年）

Strategy	Key Detail
Depreciation	Residential: 27.5yr, Commercial: 39yr (straight-line)
Bonus Depreciation	100% for property placed in service Jan 20, 2025 – Dec 31, 2030
Cost Segregation	Reclassify 15-40% of building into 5/7/15-yr assets
Section 179	$2.5M max deduction (2025), phase-out at $4M
1031 Exchange	45-day ID period, 180-day closing, like-kind real property only
Opportunity Zones	Made permanent (2025), 10-year gain exclusion on QOF investment

For complete tax analysis with IRS code references → load

references/tax-strategy.md

策略	核心细节
折旧	住宅类：27.5年，商业类：39年（直线折旧）
Bonus Depreciation	2025年1月20日至2030年12月31日期间投入使用的房产可享受100% bonus折旧
成本分隔	将15-40%的建筑成本重分类为5/7/15年折旧资产
Section 179	2025年最高抵扣额250万美元，超过400万美元后逐步递减
1031 Exchange	45天标的确认期，180天完成交易，仅适用于同类房地产
机会区	2025年起永久生效，合格机会基金（QOF）投资持有满10年可豁免收益税

如需包含IRS代码参考的完整税务分析，请加载

references/tax-strategy.md

API Quick Reference

API速查

Provider	Best For	Pricing	Auth
Mashvisor	STR + LTR rental data	$30-$120/mo	x-api-key header
AirDNA	STR performance data	$12-$599/mo	Bearer token
ATTOM	Deep property data (155M+ properties)	$850-$2K/mo	apikey param
Rentcast	Rental estimates	Free-$449/mo (50 free/mo)	X-Api-Key header
Census Bureau	Demographics, housing	Free (API key required)	key param
Redfin Data Center	Market trends	Free (CSV download)	None

For endpoint URLs, Python examples, and integration patterns → load

references/market-analysis.md

服务商	适用场景	价格	认证方式
Mashvisor	短租+长租租赁数据	30-120美元/月	x-api-key请求头
AirDNA	短租表现数据	12-599美元/月	Bearer token
ATTOM	深度房产数据（1.55亿+房产）	850-2000美元/月	apikey请求参数
Rentcast	租金预估	免费-449美元/月（每月免费50次请求）	X-Api-Key请求头
Census Bureau	人口统计、住房数据	免费（需API密钥）	key请求参数
Redfin Data Center	市场趋势	免费（CSV下载）	无需认证

如需端点URL、Python示例和集成模式，请加载

references/market-analysis.md

Waterfall Distribution Quick Reference

瀑布式收益分配速查

Standard syndication tiers:

Tier	IRR Hurdle	LP Share	GP Share
1 (Return of Capital + Pref)	0-8%	100%	0%
2 (First Promote)	8-12%	90%	10%
3 (Second Promote)	12-18%	80%	20%
4 (Final Split)	18%+	60%	40%

Market data: 8% pref in 40% of deals, 10% pref in 30% of deals. 85% of waterfalls use IRR hurdles.

For complete waterfall mechanics, catch-up provisions, and Python calculator → load

references/advanced-analysis.md

标准联合投资分层：

层级	IRR门槛	LP分成比例	GP分成比例
1（本金返还+优先收益）	0-8%	100%	0%
2（第一级业绩分成）	8-12%	90%	10%
3（第二级业绩分成）	12-18%	80%	20%
4（最终分成）	18%+	60%	40%

市场数据：40%的交易优先收益率为8%，30%的交易优先收益率为10%，85%的瀑布式分配采用IRR门槛。

如需完整的瀑布式分配机制、追补条款和Python计算器，请加载

references/advanced-analysis.md

Reference File Index

参考文件索引

Load the appropriate reference file based on the analysis need:

File	Contents	When to Load
`references/financial-metrics.md`	12 metrics with formulas, Python functions, Excel formulas, complete RealEstateProForma class, amortization schedules	Building a pro forma, calculating returns, generating Python/Excel models
`references/advanced-analysis.md`	Sensitivity tables, Monte Carlo simulation (Python), waterfall calculator, syndication LP/GP mechanics	Stress testing deals, modeling risk, syndication analysis
`references/property-types.md`	BRRRR framework, house hack analysis, commercial underwriting, STR revenue modeling, land development feasibility	Analyzing a specific property type with tailored frameworks
`references/market-analysis.md`	Market scoring with 15+ indicators, 6 API integrations with Python code, comp adjustment methodology, submarket signals	Comparing markets, pulling data via APIs, running comps
`references/tax-strategy.md`	Depreciation schedules, cost segregation savings, 1031 exchange rules, bonus depreciation (2025-2030), opportunity zones, entity structure comparison	Tax-optimizing a deal, choosing entity structure, planning exchanges

根据分析需求加载对应的参考文件：

文件	内容	加载场景
`references/financial-metrics.md`	12项指标的公式、Python函数、Excel公式、完整的RealEstateProForma类、摊销计划表	构建预估财务模型、计算收益、生成Python/Excel模型
`references/advanced-analysis.md`	敏感性分析表、Monte Carlo模拟（Python）、瀑布式收益计算器、联合投资LP/GP机制	交易压力测试、风险建模、联合投资分析
`references/property-types.md`	BRRRR框架、自住房产投资分析、商业地产承保、短租收益建模、土地开发可行性	针对特定房产类型使用定制化框架进行分析
`references/market-analysis.md`	包含15+项指标的市场评分、6种API集成的Python代码、可比房源调整方法、子市场信号	市场对比、通过API拉取数据、可比房源分析
`references/tax-strategy.md`	折旧计划表、成本分隔收益、1031 exchange规则、bonus折旧（2025-2030）、机会区、主体架构对比	交易税务优化、选择主体架构、置换规划

Audience Adaptation

受众适配

Beginner investors: Explain metric meanings, recommend starting with the 1% rule and cash-on-cash return, walk through pro forma line by line
Experienced investors: Skip basics, lead with IRR and equity multiple, provide code/spreadsheet output, focus on sensitivity analysis and tax optimization
Default to expert-level analysis unless context suggests otherwise

新手投资者：解释指标含义，建议从1%法则和cash-on-cash return入手，逐行讲解预估财务模型的构成
资深投资者：跳过基础内容，优先展示IRR和equity multiple，提供代码/表格输出，重点关注敏感性分析和税务优化
如无特殊上下文说明，默认输出专家级分析