CRE商業不動産で使えるメモ

CREでよく出てくる言葉やファイナンシャルモデルを集めました。単語をクリックすると詳細が見られます。（徐々にリンクを増やしていきます！）

Real Estate Investment Analysis

Key Real Estate Investment Analysis Metrics	Capitalization (Cap Rate)	Net Present Value (NPV)	Internal Rate of Return (IRR)
Equity Multiple	Cash-on-Cash Return	Positive VS Negative Leverage	XNPV & XIRR
General Partner	Limited Partner

Real Estate Pro Forma Modeling

Proforma	Monthly Cash Flow Modeling	Monthly Growth & Toggle Triggers	Modeling NOI
Modeling Capital Expenses	Modeling Principal & Interest Payment	Modeling Purchase and Sale Metrics	Modeling Loan Proceeds &b Loan Payoffs
Modeling Return Metrics

Real Estate Debt Modeling

Long Terms & Amortization VS Term	Loan Functions & PMT	IPMT & PPMT	CUMIPMT & CUMPRINC
Building a Loan Amortization Schedule	Loan-to-Value (LTV)	Loan-to-Cost (LTC)	Debt Service Coverage Ratio (DSCR)
Debt Yield	The Loan Consumer	Loan Sizing (LTV & LTC)	Loan Sizing (DSCR & DEBT YIELD)
Dynamic Loan Sizing Build

Property Operation

Present Value (PV)	Future Value (FV)	NPER	RATE
PMT	CPR, Vacancy & Credit Loss	Percentage Rent	Prorata Share
NNN Reimbursement	FSG Reimbursement	MG Reimbursement	BYS Reimbursement
Operation Expense Ratio	Renewal Probability Modeling	Cashflow Modeling with Renewal Provability	Leasing Commission
​Tenant Improvement Allowance