Apply now on NEXA Mortgage's site, opens in a new tab

Free templates for real estate investor loans

These are the free templates and guides we give real estate investors: the files lenders commonly ask for, a document checklist, a workbook to run the numbers, a 1031 tracker, and a guide to retirement-account loans. Every one is free, with no sign-up.

The templates

Each template, what it is, its file format, and a direct download
TemplateWhat it isFormatDownload
Investor loan document checklistWhat to gather for DSCR, commercial, bridge, construction, 1031, IRA, and VA loans.PDF · 114 KBDownload the investor loan document checklist
Schedule of real estate ownedYour portfolio on one page, with portfolio LTV and DSCR.Excel · 55 KBDownload the schedule of real estate owned template
Personal financial statementAssets, liabilities, liquidity, and net worth for commercial loans.Excel · 52 KBDownload the personal financial statement template
Rent rollUnits, leases, rents, and occupancy in the format lenders ask for.Excel · 54 KBDownload the rent roll template
T-12 operating statementTrailing twelve months of income and expenses, NOI, and expense ratio.Excel · 54 KBDownload the T-12 operating statement template
Deal analyzer workbookRental analysis, 5-year pro forma with IRR, flip and BRRRR, commercial loan sizing.Excel · 243 KBDownload the deal analyzer workbook
1031 exchange trackerDay-45 and day-180 deadlines, a trade-up check, and the identification rules.Excel · 14 KBDownload the 1031 exchange tracker
Self-directed IRA and Solo 401(k) guideHow non-recourse financing works inside a retirement account, and the rules to know.PDF · 113 KBDownload the self-directed IRA and Solo 401(k) guide

Which templates fit your loan

Our investor loan document checklist sorts what lenders commonly ask for by loan type. Here is where our templates fit:

Templates that fit each loan type
Loan typeTemplates that fit
Every investor loanSchedule of real estate owned
DSCR rental loanRent roll, for 2 to 4 unit properties
Commercial: 5+ units, mixed use, other income propertyT-12 operating statement, current rent roll, personal financial statement for each guarantor, schedule of real estate owned
1031 exchange replacement purchaseThe 1031 exchange tracker for your own dates and identified list (the lender asks for your identification letter, QI agreement, and sale closing statement)
Self-directed IRA or Solo 401(k)The IRA and Solo 401(k) guide, before the account signs a contract
Bridge, rehab, and constructionNo template. The checklist lists a scope of work and budget, contractor details, comps, a track record, plans, permits, and a draw schedule.

Every lender is different, so your loan officer confirms the final list for your loan.

How the files fit together

  • Schedule of real estate owned to personal financial statement. The schedule's "your share" lines carry straight to the statement's real estate, mortgage, and net rental income lines. The two example files use the same numbers, so you can see the hand-off.
  • Rent roll and T-12. The rent roll is a snapshot of who pays what today. The T-12 is twelve months of income and expenses ending in NOI. Both example files describe the same made-up 12-unit building.
  • Deal analyzer and our online calculators. The workbook covers much of what our seven free calculators do (rental DSCR and cash flow, flip and BRRRR, and commercial loan sizing) and adds a 5-year pro forma with IRR. Open the investor tools.

What every file includes

Each file carries our licensing lines: George Schembri III, NMLS 2103836, licensed in Florida, with loans originated by NEXA Mortgage LLC, NMLS 1660690. Each also says it is for planning only, not a commitment to lend, and not tax, legal, or investment advice, with the Equal Housing Opportunity line.

The spreadsheets open with made-up example figures, so the math runs right away. Type over the shaded or gold cells with your own numbers, and the formulas do the rest.

Keep completed files private

A completed template holds private financial details. Please do not paste one into the scenario form on our homepage; that form is for a short description of your deal. Do not send a completed personal financial statement as a plain email attachment.

Ready to talk about a loan?

Run your scenario by us. Two minutes, no credit pull, and a licensed loan officer calls you back the same business day.

The application opens on NEXA Mortgage's site, the licensed mortgage company our loans run through.

How it works

Frequently asked questions

Are the templates really free?

Yes. Every template and guide on this page is free to download, with no sign-up and no form to fill in first. The spreadsheets are Excel files and the checklist and guide are PDFs. They are planning tools, not a loan application and not a commitment to lend.

Which templates do I need for a DSCR loan?

Our checklist lists a schedule of real estate owned for every investor loan, and a rent roll for 2 to 4 unit DSCR properties. For a single rental, it lists the lease, or a market rent estimate if the property is vacant. Your loan officer confirms the final list for your loan.

Which templates do I need for a commercial loan?

For five-plus unit multifamily, mixed use, and other income property, the checklist lists a T-12 operating statement, a current rent roll, a personal financial statement for each guarantor, and a schedule of real estate owned. It also lists property details and photos, and tax returns if the lender asks.

Is filling in a template the same as applying?

No. The templates are for planning only and are not a commitment to lend. When you are ready to apply, the application opens on NEXA Mortgage's site, the licensed mortgage company our loans run through. To talk first, run your scenario by us and a licensed loan officer calls you back.

Why do the files show example numbers?

Each spreadsheet opens with made-up example figures, so the formulas run as soon as you open it. Example names such as "Example Holdings LLC" and "Tenant A" show they are not real. Replace them with your own numbers. The deal analyzer says its examples are not a quote, a rate offer, or an appraisal.

Where should I send a completed template?

Not through the scenario form on our homepage, which is for a short description of your deal, and never send a completed personal financial statement as a plain email attachment. The lender templates' last line names info@aluracapital.com. Call or text (813) 356-9448 if you are unsure how to send a file.