What is a DSCR loan for real estate rentals?

A DSCR (Debt Service Coverage Ratio) loan evaluates a rental property based on its cash flow rather than personal employment income. Lenders verify that monthly rental income exceeds the mortgage payment by a target ratio, usually 1.20 or higher.

How does a 1031 exchange work when selling rental property

A 1031 exchange allows real estate investors to defer capital gains taxes when selling an investment property by rolling all sale proceeds into a replacement property of equal or greater value within strict timelines.

What is Cap Rate in real estate investing?

Capitalization Rate (cap rate) measures a property's annual rate of return. It is calculated by dividing net operating income by the purchase price or current market value of the property.

How is cash-on-cash return calculated for rental properties?

Cash-on-cash return measures annual pre-tax cash flow divided by the total cash invested (down payment, closing costs, and initial rehab). It shows your actual annual cash yield earned on out-of-pocket funds.

What are the potential challenges or risks of a cost segregation study?

While cost segregation accelerates depreciation to reduce early-year income taxes, potential challenges include future depreciation recapture taxes upon sale, engineering study costs for smaller assets, and passive loss restrictions if you do not qualify as a real estate professional under IRS rules.

Real Estate Investing & Portfolio Growth Strategies | Entrepreneurs Report
PORTFOLIO ACCELERATION
DEBT & CREATIVE FINANCE
TAX & COMPLIANCE
MULTIFAMILY STRATEGY
DEAL SOURCING & MINDSET
RESOURCES
Mentorship Programs
ABOUT CURTIS
150-Unit Scaling Case Study
Subject-To Investing Guide
SDIRA Compliance Guide
Multifamily NOI & OER Audit Guide

Home » Business » Free Multifamily NOI & OER Audit Checklist: Forensic Spreadsheet Formulas & Benchmarks

Free Multifamily NOI & OER Audit Checklist: Forensic Spreadsheet Formulas & Benchmarks

by Curtis Waters | Aug 25, 2026 | Business | 0 comments

Auditing an apartment building takes a simple plan. Sellers often understate bills to make a property look more profitable. Use this 5-phase forensic checklist to audit past financial statements before making an offer.

Table of Contents

Toggle

⚖️ Legal & Financial Disclaimer

Phase 1: Rent Roll & Vacancy Audit
Phase 2: Extra Income & Utility Billing
Phase 3: Daily Operating Bills
Phase 4: Taxes & Building Insurance
Phase 5: Capital Fixes & Final NOI
Related Financial & Portfolio Guides

⚖️ Legal & Financial Disclaimer

Important Notice: Curtis Waters, MBA, Broker-in-Charge is a licensed real estate professional, not an attorney or certified public accountant. The audit steps on this page are for educational purposes only. Always consult a licensed CPA and real estate attorney before auditing property financials or submitting purchase offers.

Phase 1: Rent Roll & Vacancy Audit

1. Match Leases to Bank Records: Compare every tenant lease against monthly bank deposit records.

2. Find True Vacancy Loss: Count empty units and unpaid tenant rent as real vacancy loss.

3. Check Rent Discounts: Look for hidden free rent months or move-in specials in lease files under CFPB disclosure rules.

Phase 2: Extra Income & Utility Billing

4. Check Laundry & Parking Cash: Verify 12 months of collections for laundry machines and parking spaces.

5. Check Water & Power Bills: Make sure tenant utility payments match real city utility bills.

6. Remove One-Time Cash: Take out one-time insurance checks and forfeited security deposits from operating income.

Phase 3: Daily Operating Bills

7. Check Management Fees: Make sure property management fees stay between 4% and 7% of collected rent.

8. Check Vendor Contracts: Review lawn care, trash pickup, and pest control vendor contracts.

9. Check Daily Repair Bills: Look at receipts to separate daily plumbing fixes from large building upgrades.

Phase 4: Taxes & Building Insurance

10. Check County Tax Reassessments: Ask the county tax office to estimate taxes after the property sale.

11. Get Current Insurance Quotes: Get new property insurance pricing under Fannie Mae hazard standards.

12. Check City Water Rates: Check city water and sewer price hikes over the past three years.

Phase 5: Capital Fixes & Final NOI

13. Separate Big Capital Fixes: Move major roof and HVAC replacements into capital reserve accounts.

14. Calculate True Net Income: Subtract audited operating bills from total gross rent income.

15. Calculate Final Expense Ratio: Make sure the final ratio stays between the healthy 40% and 48% range.

Related Financial & Portfolio Guides

Multifamily NOI & OER Forensic Audit Guide
150-Unit Real Estate Portfolio Scaling Case Study
Free 150-Unit Portfolio Growth Blueprint
SDIRA Real Estate Compliance Guide
Free SDIRA Real Estate Compliance Checklist
Subject-To Real Estate Investing Guide
Free Subject-To Real Estate Checklist
1031 Exchange Strategies 2026
Real Estate Financials & Cap Rate Mastery
Editorial & Integrity Policy

Join the Community

Subscribe to receive high-level asset-sourcing strategies, advanced workflow automations, and institutional portfolio frameworks delivered directly to your inbox.

This briefing expands upon the core financial and capital connection principles established in "The Relationship Blueprint."

Subscribe on Substack

Curtis Waters, MBA | National Real Estate Strategist

Licensed Broker-in-Charge with 12 years of professional investing experience and 11 years as a real estate agent.

2026 Institutional Focus

The 1031 Exchange Velocity Standard

Regulatory frameworks demand strict execution windows for tax-deferred capital transitions. Realizing complete wealth optimization requires identifying replacement assets within the mandatory 45-day window.

Consult a National Strategist to review your structured portfolio timelines with precise engineering metrics.

Verify 1031 Timelines →

Waters & Associates Group, LLC
Charlotte, NC 28277

The Entrepreneurs Report is an institutional strategy platform. Information provided is for educational purposes and does not constitute individual legal or tax advice. Waters & Associates Group, LLC, 9935-D Rea Rd Ste 460, Charlotte, NC 28277″

Waters & Associates Group, LLC

9935-D Rea Rd Ste 460

Charlotte, NC 28277

NC License #285129 | SC License #96431

Terms of Service
Professional Disclaimer
About Curtis Waters, MBA
Editorial and Integrity Policy
Privacy Policy
Investment Calculators
Master Strategy & Resource Directory

Curtis Waters, MBA

Licensed Real Estate Broker-in-Charge

12 Years Investing | 11 Years Brokerage

Disclosure: As an affiliate, I earn from qualifying purchases made through links on this site. This helps support my work in providing real estate investment strategies at no extra cost to you.