Prompt Details

Model

Chat - (gpt-5.6)

Token size

366

Example input

[Investment Asset & Capital Outlay]: Acquisition and capital repositioning of a 48-unit multi-family apartment complex; Initial Equity Outlay: $3,200,000; Total Capitalized Cost: $11,500,000 ($8,300,000 senior agency debt at 6.25% fixed interest) [Projected Cash Inflows & Horizon]: 5-year investment horizon; Year 1 Net Operating Income (NOI): $680,000 ramping to $940,000 by Year 4 post-renovation ($8,000/unit interior upgrade program); Exit cap rate assumed at 6.0% in Year 5 [Cost of Capital & Hurdle Criteria]: Target Limited Partner (LP) Hurdle Rate: 8.0% preferred return; Target Equity Multiple: 1.85x; Minimum Project IRR threshold: 14.0% [Downside Risk Drivers & Stress Parameters]: Physical vacancy spikes to 14% (due to regional tenant market softening); renovation supply-chain cost overrun of 25%; exit capitalization rate expands by 125 bps to 7.25%

Example output

*Administrative Disclaimer: The following financial schedules represent exploratory pro-forma scenario simulations for capital planning purposes. They do not constitute formal fiduciary appraisals, investment endorsements, or guaranteed financial performance.* ### 1. Executive Investment Snapshot & Multi-Scenario Performance Matrix | Investment Metric | Bear Case (Stressed) | Base Case (Underwritten) | Bull Case (Optimized) | Hurdle Benchmark | | :--- | :---: | :---: | :---: | :---: | | **Initial Equity Investment** | $3,400,000 *(+CapEx Overrun)* | $3,200,000 | $3,200,000 | $3,200,000 | | **Holding Horizon** | 5 Years | 5 Years | 5 Years | 5 Years | | **Gross Exit Valuation (Yr 5)** | $11,448,000 *(7.25% Cap)* | $15,666,000 *(6.00% Cap)* | $17,818,000 *(5.50% Cap)* | - | | **Net Equity Proceeds at Exit** | $3,412,000 | $7,748,000 | $9,862,000 | - | | **Project Levered IRR** | **5.84%** | **17.42%** | **23.15%** | **> 14.00%** | | **Equity Multiple (MOIC)** | **1.22x** | **2.18x** | **2.76x** | **> 1.85x** | | **Discounted NPV (@ 8% Pref)** | **($248,500)** | **$1,185,400** | **$2,140,200** | **> $0.00** | | **Capital Payback Horizon** | 5.0+ Years | 3.8 Years | 3.1 Years | < 4.0 Years | --- ### 2. Discounted Cash Flow (DCF) Schedule & Cumulative Capital Payback Waterfall #### Base Case Unlevered vs. Levered Cash Flow Schedule ($ in Thousands) | Timeline | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 (Exit) | | :--- | :---: | :---: | :---: | :---: | :---: | :---: | | **Gross Potential Rent** | - | $1,080 | $1,240 | $1,380 | $1,460 | $1,520 | | **Economic Vacancy (6.5%)** | - | ($70) | ($81) | ($90) | ($95) | ($99) | | **Operating Expenses** | - | ($330) | ($352) | ($374) | ($395) | ($418) | | **Net Operating Income (NOI)** | - | **$680** | **$807** | **$916** | **$970** | **$1,003** | | **Debt Service (P&I @ 6.25%)** | - | ($518) | ($518) | ($518) | ($518) | ($518) | | **CapEx Renovation Outlay** | ($384) | ($192) | - | - | - | - | | **Net Operating Cash Flow** | **($3,200)** | **($30)** | **$289** | **$398** | **$452** | **$8,233\*** | | **Cumulative Net Cash Flow** | ($3,200) | ($3,230) | ($2,941) | ($2,543) | ($2,091) | **+$6,142** | *\*Year 5 cash flow incorporates the terminal disposition net of loan principal payoff ($7,748k) and operating distributions ($485k).* --- ### 3. Two-Way Sensitivity & Breakeven Stress-Testing Matrix #### Levered Project IRR Sensitivity: Exit Cap Rate vs. Year 5 Net Operating Income | Exit Cap Rate \ Year 5 NOI | $850k (-15%) | $940k (-6%) | $1,003k (Base) | $1,080k (+7.6%) | $1,150k (+14.6%) | | :--- | :---: | :---: | :---: | :---: | :---: | | **7.25% (Severe Bear)** | 1.82% | 4.65% | 5.84% | 8.12% | 10.45% | | **6.75% (Moderate Bear)** | 5.10% | 8.42% | 10.15% | 12.30% | 14.85% | | **6.25% (Neutral)** | 8.90% | 12.10% | 14.22% | 16.70% | 19.40% | | **6.00% (Base Underwrite)**| **11.45%** | **14.80%** | **17.42%** | **19.85%** | **22.60%** | | **5.50% (Bull Expansion)** | 15.20% | 18.90% | 21.40% | 24.15% | 27.20% | * **Breakeven Physical Occupancy:** **81.4%** at the current debt service coverage floor ($518k annual P&I requires DSCR $\ge$ 1.05x). * **CapEx Sensitivity Threshold:** Every 10% increase in unit renovation cost ($38.4k) lowers terminal IRR by 38 basis points if rent premiums fail to materialize. --- ### 4. Investment Committee Decision Framework & Capital Risk Mitigation Playbook * **Investment Verdict:** **CONDITIONAL APPROVAL (Tier-2 Strategic Allocation)** * The asset clears the 14.0% project hurdle rate in the Base Case (17.42%) and produces a 2.18x multiple. However, the Bear Case IRR of 5.84% fails to clear the 8.0% preferred return, indicating vulnerability to terminal cap rate decompression. * **Mandatory Capital Preservation Safeguards:** 1. **CapEx Escrow Contingency:** Withhold $100,000 of general partner fees into an interest-bearing escrow until 50% of the interior unit turns are leased at target premiums ($175/unit lift). 2. **Interest Rate Risk Hedge:** The existing debt is fixed for 5 years; maintain a minimum DSCR covenant buffer of 1.25x before executing supplemental equity distributions. 3. **Staggered Renovation Pace:** Limit active construction to 4 units simultaneously to protect baseline economic occupancy above 88% throughout Year 1.