Apartment Finance Due Diligence Resources

A collection of helpful downloadable documents, forms, and templates for the due diligence on an apartment property loan.

Apartment Finance Due Diligence Resources

Organization is crucial to an apartment financing transaction. The otherwise tedious process is only more frustration when investors don't have the documents they need ready and on hand for when lenders request them. We've gone ahead and created some templates and gathered together some of the more widely requested items for investors who may not have such resources on hand.

Financing different types of multifamily housing will often require the same documentation with some slight differences, however this list provides a decent baseline for all apartment financing transactions. While every apartment loan transaction is unique and each lender varies with their requirements, repeat investors should find that these items are consistently what make up a comprehensive loan package.

To be used at your discretion:

Quick Qualification

For Quotes

For Closing

Having these items ready can help an investor quickly find out if they qualify for a desired LTV, LTC, loan amount etc.. These docs can only help create a very broad picture, but can also give a relatively fast positive/negative result as to the feasibility of a loan in question.

Refinance and underwriting downloads

The two files below come from the other side of the table: what a lender's underwriter asks once your refinance package is in, and what an underwriter looks for in the rent roll you send. Fill in the questions document before you apply and your answers are ready when the lender's list arrives. Run through the rent roll red flags before you send the rent roll, because a lender who finds an unexplained issue first will often size the loan on the worst reading of it. To run those rent roll checks automatically, paste your rent roll into the rent roll analyzer, which runs in your browser and never uploads the file. For the full document list in the order lenders ask for it, use the refinance checklist.

Excel

Refinance sizing model

Max loan by program (Fannie Small, Freddie Conventional Small, HUD 223(f), bank, your lender), the limit that binds, cash in or out, and a rate sensitivity table.

Download Excel
Excel

Loan maturity planner

Enter your maturity date and lender lead time; every milestone date recalculates, with a status flag for dates already past.

Download Excel
Excel

Lender term sheet comparison

Up to six quotes side by side: debt service, fees, balance at your hold date and effective annual cost from monthly cash flows.

Download Excel
Excel

T-12 to lender underwriting

Your operating statement next to the lender's view: vacancy floor, management fee floor, reserves and tax and insurance trending, with the loan each NOI supports.

Download Excel
Excel

Cash-out sources and uses

New loan sized by LTV and DSCR, then payoff, prepayment, closing costs and reserves down to the cash you take home.

Download Excel
Excel

Capex and replacement reserve schedule

A 10-year capital plan by building component with the per-unit reserve it implies: the schedule lenders ask for at underwriting.

Download Excel
PDF

Refinance checklist (PDF)

Every document a 5+ unit refinance needs, ordered by stage, with who provides it.

Download PDF
Word

Lender questions response pack

The questions underwriters ask on an apartment refinance, with space for your answers, so the package goes in complete.

Download Word
PDF

Rent roll red flags (PDF)

What underwriters look for in a rent roll and what to fix before you send it.

Download PDF
CSV

Sample rent roll (CSV)

The 12-unit sample the rent roll analyzer uses, in the column layout it reads.

Download CSV

Start here

Getting apartment financing should be easy. Now it is.

Click below for a free, no-obligation quote and to learn more about your loan options.

Prefer to talk? (561) 556-9997

Call Get a quote