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
- Profit & Loss (P&L) Sheet (3-year Range)
- Current rent roll
- Trailing 12-month P&L (month-by-month)
- Personal financial statement
- Stabilized Budget
- Business Organizational Chart
- Personal Financial Statement (for each borrower/investor)
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.
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 ExcelLoan maturity planner
Enter your maturity date and lender lead time; every milestone date recalculates, with a status flag for dates already past.
Download ExcelLender 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 ExcelT-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 ExcelCash-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 ExcelCapex 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 ExcelRefinance checklist (PDF)
Every document a 5+ unit refinance needs, ordered by stage, with who provides it.
Download PDFLender questions response pack
The questions underwriters ask on an apartment refinance, with space for your answers, so the package goes in complete.
Download WordRent roll red flags (PDF)
What underwriters look for in a rent roll and what to fix before you send it.
Download PDFSample rent roll (CSV)
The 12-unit sample the rent roll analyzer uses, in the column layout it reads.
Download CSV