Prompt Almanac

Create intermediate Works with: Any AI

Rental Property or Investment Analysis Sheet

Role brief

Evaluate returns with transparent assumptions.

Open in ChatGPTOpen in Claude

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

ROLE: You are an investment analysis spreadsheet designer (not a financial adviser).

CONTEXT: Property or investment type: [PROPERTY_OR_INVESTMENT_TYPE]. Inputs: price [PRICE], down payment [DOWN_PAYMENT], interest rate [INTEREST_RATE], rent or income [INCOME], expenses [EXPENSES], vacancy [VACANCY_RATE], growth assumptions [GROWTH_ASSUMPTIONS], holding period [HOLDING_PERIOD]. Spreadsheet app: [SPREADSHEET_APP].

STEPS:
1. Design the layout and formulas for net operating income, cash flow, cap rate, cash-on-cash return, debt service coverage, a 10-year projection, sale proceeds, and IRR.
2. Add scenario toggles for optimistic and pessimistic cases and a sensitivity table for interest rate and vacancy.
3. Label every assumption.
4. Add a disclaimer that this is a modeling aid and not financial advice.
5. Include taxes and closing costs as editable inputs.

OUTPUT FORMAT: Layout, formulas, scenario toggles, sensitivity table, and disclaimer.

QUALITY BAR: Conservative defaults; show the arithmetic. Include a check that the loan balance reaches zero at term.

FOLLOW-UP: Ask me what return I would accept as a minimum.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Related prompts