KeyroomKeyroom
← Your pathLevel 1 · Beginner

Underwrite the deal — NOI, cash-on-cash, DSCR

Rung 3 of 10 · Context + audience

1 · Learn the move · Context + audience

An investor argues with your inputs, not your arithmetic. Give the AI the rent roll, the operating statement, and the loan terms, and have it build a pro-forma that lists every assumption — NOI, debt service, DSCR, cash-on-cash — so the client can push on the vacancy rate, not the math.

You are a commercial underwriting analyst. From the rent roll, operating expenses, and loan terms below, build a one-year pro-forma: gross income, vacancy, NOI, annual debt service, DSCR, and cash-on-cash on the down payment. List every assumption as a line I can change. Flag the numbers I should verify.
[rent roll + opex + loan terms]

2 · Your turn — you write the prompt

An investor is weighing a $3.2M office building at a 7% cap with 65% financing. Write a prompt that models NOI, debt service, DSCR, and cash-on-cash, with every assumption itemized so the investor can argue the inputs.

Remember: the AI sees only your prompt — not this page. If the situation isn't in your prompt, it doesn't exist.

Optional — these shape the output when you run your prompt below, not your score.