Cash Flow Analysis

Property & Cash Flow Inputs

Enter underwriting assumptions to calculate NOI, DSCR, LTV, and supporting metrics.

🏢 Property Information

Property Name

Property Address

Property Type

Total Square Footage

Number of Units (Multifamily)

Occupancy Rate (%)

Property Value ($)

💵 Revenue

Gross Potential Rent ($/yr)

Vacancy & Collection Loss (%)

Other Income ($/yr)

🧾 Operating Expenses

Real Estate Taxes ($)

Property Insurance ($)

Utilities ($)

Management Fee (% of EGI)

Repairs & Maintenance ($)

Common Area Maintenance ($)

Janitorial ($)

Landscaping ($)

Security ($)

Professional Fees ($)

Marketing & Leasing ($)

Administrative & Other ($)

Capital Reserves ($/SF)

🛡️ Insurance & Risk Transfer

Insurable / Replacement-Cost Value ($)

Wind / Hail Deductible (% of insurable value)

Business-Interruption Coverage (months)

The annual premium is entered above under Operating Expenses. These fields drive the insurance benchmark, the wind/hail self-insured retention, and the business-interruption assumption in the stress tests.

🏦 Loan Terms

Loan Amount ($)

Interest Rate (%)

Amortisation Period (years)

Loan Term (years)

Interest-Only Period (months)

Upload Cash Flow Documents

📊 Rent Roll

💹 Operating Statement (T-12)

Property & Cash Flow Inputs

🏢 Property Information

💵 Revenue

🧾 Operating Expenses

🛡️ Insurance & Risk Transfer

🏦 Loan Terms

Cash Flow Results

Cash Flow Waterfall

Detailed Income & Expense Breakdown

Operating Expense Mix

🛡️ Insurance Check

🧾 Expense Reasonableness

Loan Analysis

Amortisation Schedule

Sensitivity Analysis

DSCR vs NOI Decline

DSCR vs Interest Rate Increase

DSCR vs Occupancy Drop

DSCR vs Insurance-Premium Increase