Investment Property Underwriting Prompt
Prompt
Conduct comprehensive financial underwriting of an acquisition. [PASTE: Property details, purchase terms, financing, rentals, operating expenses, investment criteria] Steps: 1) Calculate purchase price and closing costs 2) Calculate cash investment 3) Project 5-year cash flows 4) Calculate Year 1 metrics 5) Model refinance/sale scenario 6) Calculate IRR and equity multiple 7) Create pro forma P&L Output: Executive summary with key metrics, 5-year pro forma P&L, cash flow projection, sensitivity analysis.
Why it works
Disciplined underwriting prevents overleveraging. Scenario modeling reveals sensitivity to assumptions.
Watch out for
Optimistic assumptions inflate returns. Conservative underwriting protects downside.
Used by
Finance TeamsData AnalystsExecutives