build_dcf_model
Build a levered DCF model using live Federal Reserve rates. Automatically fetches current SOFR to derive the loan rate if not provided. Returns: annual cash flows, IRR, equity multiple, cash-on-cash, DSCR, and exit analysis.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| loan_rate | No | Loan interest rate % — if None, fetches live SOFR + 175bps | |
| noi_year1 | Yes | Year 1 Net Operating Income ($) | |
| equity_pct | No | Equity as % of purchase price (default 35%) | |
| hold_years | No | Hold period in years (default 10) | |
| exit_cap_rate | No | Exit cap rate % — if None, uses entry cap + 25bps (conservative) | |
| purchase_price | Yes | Acquisition price ($) | |
| noi_growth_rate | No | Annual NOI growth rate % (default 3.0) | |
| amortization_years | No | Loan amortization period (default 30 years) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||