Underwrite the deal. NOI, cash-on-cash, DSCR
Lesson 3 of 13 · Commercial deals
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.