How to List 2-4 Unit and Multifamily Properties on the Portfolio Spreadsheet

When completing the Rental Home Financing portfolio spreadsheet for 2-4 unit properties and multifamily buildings, each unit must be listed as a separate line item. This allows our underwriting team to evaluate the individual rental income, unit size, and bedroom/bathroom count for every unit in the property, which is essential for accurate DSCR calculations and cash flow analysis.

Get Your Custom Loan Quote

No application fees, no tax returns required. Most loans close in 2-4 weeks with competitive rates based on your portfolio.

Apply Now Call 888-375-7977

Per-Unit Listing

Each unit in a multi-unit property gets its own line with rent, bedrooms, and square footage.

Clear Formatting

Property-level details like taxes and value go on the first line for each address.

Transparent Costs

All closing costs detailed on your term sheet before you commit -- no surprises.

Prepayment Options

5-year yield maintenance and 10-year declining penalty structures available.

Multi-unit apartment building with units listed individually on portfolio spreadsheet

List each unit as a separate line item for accurate DSCR calculations and cash flow analysis

Free Cash Flow Calculator

Calculate your rental property's true monthly cash flow, NOI, and cash-on-cash return.

How to Format Multi-Unit Properties

For a property with multiple units, break each unit out on its own row with the unit-specific rental details:

  • Unit identification -- list each unit separately (e.g., 123 Main St Unit 1, 123 Main St Unit 2, 123 Main St Unit 3)
  • Per-unit details -- include the monthly rent, number of bedrooms, number of bathrooms, and square footage for each individual unit
  • Property-level details -- taxes, insurance, property value, and purchase date can remain on the first line item for the property
  • Apartment buildings -- the same format applies to larger multifamily buildings (5+ units); list each unit on a separate line

What About Prepayment Penalties and Closing Costs?

Two common questions come up alongside the spreadsheet submission. Here are the key terms to understand:

Prepayment penalties:

  • 5-year fixed term -- 4.5 years of yield maintenance (guaranteed interest to the lender), with the loan becoming assumable for 1%
  • 10-year fixed term -- 2-year lockout period followed by a declining prepayment penalty (8%, 7%, 6%, 5%, 4%, 3%, 2%, 1%)

Origination and closing costs:

  • Origination fee -- 1-2% of loan amount (varies based on loan size, leverage, and cash flow); paid from loan proceeds
  • Appraisal fees -- $450-$875 per door; multifamily rates are individually quoted
  • Per-door due diligence -- $165 per door covering title review, deed verification, tax review, lease review, flood certification, seismic certification, and insurance review
  • Background check -- $375
  • Underwriting fee -- $1,295 to $2,995

All closing costs are detailed on your term sheet before you commit, so there are no surprises. Most costs are paid from loan proceeds at closing rather than out of pocket upfront.

Portfolio Spreadsheet Checklist

  • List each unit on a separate line with unit-specific rental details
  • Include monthly rent, bedrooms, bathrooms, and square footage per unit
  • Property-level taxes, insurance, and value on the first line item
  • Appraisal fees: $450-$875 per door
  • Per-door due diligence fee of $165 covering title, deed, tax, and lease review

Ready to Submit Your Portfolio Spreadsheet?

List your properties with unit-level detail and we will provide a term sheet with exact pricing, fees, and loan structure within days.

Apply Now Call (888) 375-7977

Review the terms and features of our blanket and multifamily loan programs before submitting your application.