What are ChatGPT prompts for CRE underwriting? ChatGPT prompts for CRE underwriting are ready to use instructions that commercial real estate investors paste directly into ChatGPT to automate financial analysis, generate pro forma projections, evaluate deal economics, and accelerate the underwriting process. These prompts transform ChatGPT from a general purpose AI into a specialized CRE analyst capable of parsing operating statements, modeling scenarios, and flagging risks. For a complete guide to AI tools available to CRE investors, see our AI tools for real estate investors guide.

Key Takeaways

How to Get the Best Results from ChatGPT

Before diving into specific prompts, here are principles that make every prompt more effective for CRE underwriting:

For more ways CRE investors are using ChatGPT, see our guide on 10 ways CRE investors use ChatGPT.

Prompt 1: Initial Deal Screening

Copy and paste this prompt:

"You are an experienced CRE underwriting analyst. I am evaluating a [PROPERTY TYPE] property with the following details: Location: [CITY, STATE]. Units/SF: [NUMBER]. Asking Price: [PRICE]. Current NOI: [NOI]. Current Occupancy: [OCCUPANCY %]. Year Built: [YEAR]. Please provide: (1) Implied cap rate at asking price, (2) Price per unit or per square foot compared to market averages, (3) Initial assessment of whether this deal warrants deeper analysis, (4) Top 3 risks to investigate, (5) Top 3 potential value drivers. Format as a structured deal screening memo."

Prompt 2: T12 Operating Statement Analysis

Copy and paste this prompt:

"Analyze this T12 operating statement for a [NUMBER] unit multifamily property. Break down: (1) Gross Potential Rent, (2) Vacancy and concession losses, (3) Effective Gross Income including all other income sources, (4) Each operating expense line item as a percentage of EGI, (5) Net Operating Income. Flag any expense ratios that fall outside typical ranges for [ASSET CLASS] in [MARKET]. Note: NOI equals Gross Revenue minus Operating Expenses. Do NOT include debt service, capital expenditures, or depreciation in the NOI calculation. Here is the data: [PASTE YOUR T12 DATA]"

Prompt 3: Cap Rate Sensitivity Analysis

Copy and paste this prompt:

"Using an NOI of [AMOUNT], create a cap rate sensitivity table showing property values at cap rates from 4.5% to 7.5% in 25 basis point increments. Remember: Cap Rate equals NOI divided by Property Value, so Property Value equals NOI divided by Cap Rate. For each cap rate, show: (1) Implied property value, (2) Difference from asking price of [PRICE], (3) Percentage premium or discount to asking. Present as a formatted table. Also calculate what cap rate the asking price implies."

Prompt 4: Debt Service Coverage Ratio Analysis

Copy and paste this prompt:

"Calculate the DSCR for this property under multiple financing scenarios. NOI: [AMOUNT]. Scenario 1: [LOAN AMOUNT] at [RATE]% interest, [TERM] year amortization. Scenario 2: [LOAN AMOUNT] at [RATE]% interest, [TERM] year amortization. Scenario 3: [LOAN AMOUNT] at [RATE]% interest, [TERM] year amortization. DSCR equals NOI divided by Annual Debt Service. Present as a table with columns for: Loan Amount, Interest Rate, Amortization, Monthly Payment, Annual Debt Service, DSCR, and whether it meets a 1.25x lender minimum. Note: DSCR is a ratio, not a percentage."

Prompt 5: Cash on Cash Return Analysis

Copy and paste this prompt:

"Calculate the cash on cash return for this acquisition. Purchase Price: [PRICE]. Loan Amount: [LOAN]. Down Payment: [AMOUNT]. Closing Costs: [AMOUNT]. Total Cash Invested: [AMOUNT]. Annual NOI: [NOI]. Annual Debt Service: [DEBT SERVICE]. Cash on Cash Return equals Annual Pre Tax Cash Flow divided by Total Cash Invested, where Annual Pre Tax Cash Flow equals NOI minus Annual Debt Service. Note: Cash on cash return accounts for debt service, unlike cap rate. Show the full calculation step by step."

Prompt 6: Value Add Underwriting

Copy and paste this prompt:

"Model a value add scenario for a [NUMBER] unit multifamily property. Current average rent: [AMOUNT] per unit. Renovation plan: [NUMBER] units at [COST] per unit. Expected rent premium after renovation: [AMOUNT] per month per renovated unit. Renovation timeline: [MONTHS] months. Calculate: (1) Total renovation cost, (2) Incremental annual revenue at stabilization, (3) Impact on NOI assuming [VACANCY]% downtime per unit during renovation, (4) New property value at [CAP RATE]% exit cap, (5) Total value created versus renovation investment. Present a month by month renovation schedule showing cumulative costs, completed units, and incremental revenue."

Prompt 7: Rent Comp Analysis

Copy and paste this prompt:

"I am evaluating rents for a [NUMBER] unit [ASSET CLASS] property in [LOCATION]. Current average in place rent is [AMOUNT] per unit. Here are comparable properties in the submarket: [PASTE COMP DATA]. Analyze: (1) How current rents compare to market comps, (2) Estimated loss to lease (difference between in place rents and achievable market rents), (3) Revenue upside if rents are brought to market, (4) Recommended rent growth assumptions for a 5 year pro forma. Format as a comparison table."

Prompt 8: Pro Forma Cash Flow Projection

Copy and paste this prompt:

"Build a 5 year pro forma cash flow projection for this property. Year 1 NOI: [AMOUNT]. Assume: Rent growth [X]% annually, Expense growth [X]% annually, Vacancy stabilized at [X]%, Capital reserves of [AMOUNT] per unit per year. For each year show: Gross Potential Rent, Vacancy Loss, Other Income, Effective Gross Income, Total Operating Expenses (broken into major categories), NOI, Debt Service, Before Tax Cash Flow, and Cash on Cash Return. Present as a year by year table."

Prompt 9: Investment Committee Summary

Copy and paste this prompt:

"Based on the analysis below, draft a one page investment committee summary for this acquisition. Include: Executive Summary (3 sentences), Key Financial Metrics (NOI, Cap Rate, DSCR, Cash on Cash Return, projected IRR), Investment Thesis (why this deal makes sense), Key Risks and Mitigants, Comparable Transactions, and Recommended Action. Write in a professional, concise tone suitable for institutional investors. Here is the analysis: [PASTE PRIOR CHATGPT ANALYSIS]"

Prompt 10: Market Research and Submarket Analysis

Copy and paste this prompt:

"Analyze the [CITY/SUBMARKET] market for [ASSET CLASS] investment. Cover: (1) Population and job growth trends, (2) Major employers and economic drivers, (3) Current supply pipeline and construction activity, (4) Historical rent growth and vacancy trends, (5) Cap rate trends over the past 3 years, (6) Key risks specific to this market, (7) Overall investment attractiveness rating from 1 to 10 with justification. Cite specific data points where possible."

Building a Complete Underwriting Workflow

The most powerful approach is chaining these prompts sequentially. Start with Prompt 1 for initial screening. If the deal passes, use Prompts 2 through 5 for detailed financial analysis. Apply Prompt 6 if it is a value add opportunity. Use Prompt 7 to validate rent assumptions. Build the pro forma with Prompt 8. Summarize everything with Prompt 9. According to CBRE Research, firms using structured AI workflows for underwriting report 40 to 60 percent faster deal evaluation with comparable or improved accuracy. This creates a systematic underwriting pipeline that produces consistent, thorough analysis for every deal.

For investors who want to take this further, see our guide on building a custom GPT for underwriting that stores your templates, market knowledge, and investment criteria for reuse across deals.

If you are ready to implement AI powered underwriting workflows that save your team 15 to 20 hours per deal, The AI Consulting Network specializes in building custom ChatGPT and Claude workflows for CRE investors. Connect with Avi Hacker, J.D. for a consultation.

Common Mistakes When Using ChatGPT for Underwriting

Frequently Asked Questions

Q: Do these prompts work with the free version of ChatGPT?

A: These prompts work with all versions of ChatGPT, but ChatGPT Plus ($20 per month) and ChatGPT Team ($25 per user per month) provide access to GPT-4o and the o3 reasoning model, which produce significantly better financial analysis. The free version uses a limited model that may struggle with complex multi step calculations.

Q: Can I upload financial documents directly to ChatGPT?

A: Yes. ChatGPT Plus and higher tiers support file uploads including PDFs, spreadsheets, and images. Upload your T12, rent roll, or OM directly and use the prompts above to analyze them. For large document packages, you may need to upload files across multiple messages.

Q: How do I save my favorite prompts for reuse?

A: ChatGPT's Custom Instructions feature lets you set persistent instructions that apply to every conversation. Alternatively, build a Custom GPT that stores your entire prompt library, investment criteria, and market knowledge. This creates a reusable CRE underwriting assistant that remembers your preferences.

Q: Are these prompts suitable for all CRE asset classes?

A: The prompts are designed with multifamily as the primary example but can be adapted for industrial, retail, office, self storage, and other commercial property types by changing the specific metrics and benchmarks. For example, replace "rent per unit" with "rent per square foot" for office or industrial analysis.