Prepared by Pillar Private Lending
Investor Resources
Start with the income and expense stack
Rental cash-flow analysis converts scheduled rent into investor cash after operating expenses and debt service. Keep property-level income metrics separate from financing metrics so you can see whether a weak result is an operations problem, a leverage problem, or both.
Pillar’s rental cash-flow analyzer follows a standard stack: build effective gross income, subtract operating expenses to get NOI, then subtract annual debt service to get cash flow.
Effective gross income (EGI)
Gross scheduled rent is the annual rent assuming full occupancy at the modeled rents. Vacancy loss reduces that figure. Other income—such as parking, laundry, or storage, when realistically collectible—is then added.
In formula terms aligned with the analyzer: EGI = gross scheduled rent − vacancy + other income.
- Gross scheduled rent = monthly rent × 12
- Vacancy loss = gross scheduled rent × vacancy rate
- Other income is modeled annually (or monthly × 12)
- EGI is the income base before operating expenses
Net operating income (NOI)
NOI equals EGI minus operating expenses. Typical operating expenses include property taxes, insurance, HOA dues, management, maintenance, utilities paid by the owner, and other recurring operating costs. Capital expenditures may be reserved in a planning model even when a lender treats them differently.
NOI does not subtract mortgage principal or interest. Mixing debt service into NOI conflates property yield with financing structure.
| Metric | Formula | What it answers |
|---|---|---|
| EGI | Gross scheduled rent − vacancy + other income | Collectible operating income |
| NOI | EGI − operating expenses | Property income before debt |
| Annual cash flow | NOI − annual debt service | Cash after the loan payment |
Cash flow, cap rate, and cash-on-cash
Annual cash flow equals NOI minus annual debt service. Cap rate equals NOI divided by purchase price and measures unlevered income yield. Cash-on-cash equals annual cash flow divided by cash invested and measures levered equity yield for the modeled year.
Cash invested in a planning model often includes down payment, closing costs, and initial repairs. Changing any of those inputs can move cash-on-cash without changing NOI.
- Cap rate = NOI ÷ purchase price
- Cash-on-cash = annual cash flow ÷ cash invested
- DSCR = NOI ÷ annual debt service
- A strong cap rate with weak cash-on-cash often signals expensive or heavy debt service
Where DSCR fits in the same model
DSCR compares NOI with annual debt service. A ratio above 1.00 means modeled NOI exceeds modeled debt service; below 1.00 means a shortfall under those assumptions.
Lender DSCR methodologies may use different rent, vacancy, expense, or payment definitions than an investor planning model. Use the analyzer for economics, then confirm the underwriting formula for financing eligibility.
Illustrative worked example
Figures below are illustrative for teaching the formulas. They are not Pillar quotes, appraisals, or loan terms.
Worked example
Illustrative single-rental stack
Assume gross scheduled rent of $36,000, 5% vacancy, $1,200 other income, $14,000 operating expenses, purchase price of $400,000, cash invested of $110,000, and annual debt service of $18,000.
- 1Vacancy loss: $36,000 × 5% = $1,800
- 2EGI: $36,000 − $1,800 + $1,200 = $35,400
- 3NOI: $35,400 − $14,000 = $21,400
- 4Annual cash flow: $21,400 − $18,000 = $3,400
- 5Cap rate: $21,400 ÷ $400,000 = 5.35%
- 6Cash-on-cash: $3,400 ÷ $110,000 ≈ 3.1%
- 7DSCR: $21,400 ÷ $18,000 ≈ 1.19x
The illustrative property produces positive cash flow and coverage above 1.00 under these assumptions, but cash-on-cash remains modest relative to equity invested.
Stress vacancy, expenses, and debt service
A base case is only a starting point. Re-run the stack with higher vacancy, higher insurance or taxes, deferred maintenance, and a larger payment. Break-even occupancy thinking asks how much effective income is required before operating expenses and debt service consume the cushion.
Investors often discover that a deal which looks acceptable at full rent becomes fragile after a longer vacancy or a tax reassessment.
Use the analyzer before you commit capital
Enter rent, vacancy, other income, operating expenses, purchase price, cash invested, and loan terms in the rental cash-flow analyzer. Review NOI, annual cash flow, cap rate, cash-on-cash, and DSCR together rather than optimizing one metric in isolation.
Then connect the cash-flow view to the financing path you expect to use—DSCR, conventional investment, bridge takeout, or another structure—and confirm that program’s actual methodology.
Separate operating expenses from capital reserves
Operating expenses support day-to-day property operations—taxes, insurance, management, repairs, owner-paid utilities, and similar recurring costs. Capital expenditures and replacement reserves cover roof cycles, HVAC replacements, unit turns beyond routine maintenance, and other large, irregular outlays.
A planning model that ignores capex reserves can show attractive NOI and cash flow while still leaving the investor underfunded for predictable capital work. Lenders may treat reserves differently than an investor’s full economic model, so keep both views labeled.
- List recurring opex separately from planned capital projects
- Set a replacement-reserve assumption that matches asset age and condition
- Revisit insurance and tax lines after underwriting or reassessment risk
- Do not treat lender-required reserves as a substitute for your full opex and capex plan
Financing inputs that move year-one cash flow
Interest rate, amortizing versus interest-only structure, loan amount, and whether points or closing costs are financed or paid in cash can change annual debt service and cash invested without changing EGI or NOI. That is why two investors can report different cash-on-cash results on the same rental.
When comparing scenarios, change one financing variable at a time, then re-run vacancy and expense stress. A payment that clears a lender DSCR test may still leave thin investor cash flow after realistic management and maintenance assumptions.
This guide is educational and is not individualized financial, legal, tax, or investment advice. Exact requirements and terms vary by lender, property, borrower, and transaction.
Discuss the actual transaction
Move from research to a deal-specific review
Educational examples are useful for planning. Actual eligibility, structure, and terms depend on the property, borrower, lender, and transaction.