RivetRatio worksheet
CRE property analysis worksheet
Bring annual property income, operating expenses, and debt service into one place. See how NOI, cash flow after debt service, and DSCR relate before a lender conversation.
Annual property figures
Build a clear property snapshot
Enter amounts in U.S. dollars for one 12-month period. Nothing is saved or submitted.
Use total income for the same 12-month period.
Enter property operating expenses; do not include debt service here.
Enter annual principal and interest payments for the same period.
Calculated snapshot
What the figures show
Net operating income (NOI)
Annual income minus annual operating expenses.
Cash flow after debt service
NOI minus annual debt service.
Debt service coverage ratio (DSCR)
NOI divided by annual debt service.
Enter all three annual amounts to calculate your property snapshot.
How the calculations work
- NOI = annual property income − annual operating expenses.
- Cash flow after debt service = NOI − annual debt service.
- DSCR = NOI ÷ annual debt service.
Use this worksheet to organize figures for a lender conversation. It is not an underwriting decision, lender-specific advice, or a promise of approval.