Personal financial statement template for real estate investors
A personal financial statement (PFS) is a signed one-page summary of what you own, what you owe, your cash on hand, and your yearly income. Lenders commonly ask each guarantor on a commercial loan for one. Download our free Excel template and it totals everything as you type.
Free, no sign-up. One Excel sheet. File dated September 28, 2026.
Keep a completed statement private
A finished statement shows your balances and your net worth. Please do not send it through the scenario form on our homepage, and do not send it as a plain email attachment.
Call or text (813) 356-9448 and ask how to send it.
The file's last line still says to email it to info@aluracapital.com. Please use the option above instead.
The file does not ask for a Social Security number, a date of birth, or account numbers. Keep account numbers out of the Notes columns. Our scenario form never asks for your SSN either, and it does not need your financial statement: a short description of the deal is enough to start.
PrivacyWhen lenders ask for one
- Commercial loans. For five-plus unit multifamily, mixed use, and other income-producing property, our investor loan document checklist lists a personal financial statement for each guarantor, next to the T-12, the rent roll, and a schedule of real estate owned.
- Loans that close in an LLC. DSCR and commercial loans can close in your LLC or other entity, but most of them still ask for a personal guarantee. The statement is where a guarantor's own assets and debts show up.
- Our template covers assets, liabilities, liquidity, and net worth for commercial loans, plus a block for annual income.
What is in the file
The file has one sheet, named PFS. At the head you enter the borrower name, a co-borrower name if there is one, and the date. Then come four blocks: Assets, Liabilities, Net worth and liquidity, and Annual income. At the bottom is a certification with signature and date lines, and short notes.
Shaded cells are for your entries. Totals, net worth, liquidity, and total income update on their own. The head of the sheet stays in view as you scroll.
Assets, line by line
| Line in the file | The file's note | What to enter |
|---|---|---|
| Cash and savings | Checking, savings, money market | Current balances. |
| Retirement accounts | 401(k), IRA, Solo 401(k), vested | The vested balance only. |
| Marketable securities | Stocks, bonds, funds, brokerage | Current value. |
| Real estate owned, total market value | Your share, per the attached REO schedule | Your share of market value from your schedule of real estate owned. |
| Business interests | Your share, at estimated value | Your share of any business you own. |
| Vehicles | Current value | Current value. |
| Other assets | Describe | Anything else, with a short description. |
| Total assets | (formula) | Fills in on its own. |
Liabilities, line by line
| Line in the file | The file's note | What to enter |
|---|---|---|
| Mortgages on real estate owned | Your share, per the attached REO schedule | Your share of loan balances from the schedule of real estate owned. |
| Credit cards | Current balances | Today's balances. |
| Auto loans | (none) | Balance owed. |
| Student loans | (none) | Balance owed. |
| Lines of credit | Drawn balance, including HELOCs | What you have drawn, not the credit limit. |
| Contingent liabilities (guarantees) | Guarantees, co-signed loans for others | Loans you guaranteed or co-signed for someone else. |
| Other liabilities | Taxes owed, personal loans | Anything else you owe. |
| Total liabilities | (formula) | Fills in on its own. |
Net worth and liquidity
The file figures four measures and shows how each one is figured:
- Total assets: the sum of all assets.
- Total liabilities: the sum of all liabilities.
- Net worth: total assets minus total liabilities.
- Liquidity (cash plus securities): cash and savings plus marketable securities.
Retirement accounts, real estate, business interests, and vehicles count toward net worth, but not toward liquidity.
Annual income
| Source | The file's note |
|---|---|
| Salary and wages | W-2 wages or guaranteed payments |
| Rental income, net | Your share, after PITIA and expenses |
| Business income | Your share of net business income |
| Other income | Interest, dividends, other |
| Total annual income | (formula) |
The certification
The last block is a one-sentence certification that the statement is true and complete as far as you know, with signature and date lines for you and for a co-borrower. The file's instructions say to print it, then sign and date it.
What the example shows
The example figures add up to $3,747,500 of assets and $1,640,650 of liabilities, for a net worth of $2,106,850. Liquidity is $335,000, and total annual income is $255,480. The real estate, mortgage, and rental income lines match the example in our schedule of real estate owned. These are made-up figures, not a real borrower.
Mistakes the file's notes help you avoid
- Leaving out guarantees. The file has a line for guarantees and co-signed loans for others, and it counts them in total liabilities. Its notes say this keeps net worth conservative.
- Real estate figures that do not match your schedule. The notes say real estate value, mortgages, and net rental income should agree with the "your share" lines on your schedule of real estate owned, with rental income as monthly net cash flow times 12.
- Listing a credit limit instead of a balance. For lines of credit, the note asks for the drawn balance, including HELOCs.
- Counting retirement money that is not vested. The note on retirement accounts says vested.
- Leaving it unsigned. Print it, then sign and date the certification.
Preview: the blocks in the file
Blocks in the file, with the example figures.
-
Assets Asset Current value Notes Cash and savings $185,000 Checking, savings, money market Retirement accounts $420,000 401(k), IRA, Solo 401(k), vested Marketable securities $150,000 Stocks, bonds, funds, brokerage Real estate owned, total market value $2,652,500 Your share, per the attached REO schedule Business interests $250,000 Your share, at estimated value Vehicles $65,000 Current value Other assets $25,000 Describe Total assets $3,747,500 -
Liabilities Liability Balance owed Notes Mortgages on real estate owned $1,549,150 Your share, per the attached REO schedule Credit cards $6,500 Current balances Auto loans $28,000 Student loans $12,000 Lines of credit $40,000 Drawn balance, including HELOCs Contingent liabilities (guarantees) $0 Guarantees, co-signed loans for others Other liabilities $5,000 Taxes owed, personal loans Total liabilities $1,640,650
| Measure | Amount | How it is figured |
|---|---|---|
| Total assets | $3,747,500 | Sum of all assets |
| Total liabilities | $1,640,650 | Sum of all liabilities |
| Net worth | $2,106,850 | Total assets minus total liabilities |
| Liquidity (cash plus securities) | $335,000 | Cash and savings plus marketable securities |
| Source | Annual amount | Notes |
|---|---|---|
| Salary and wages | $145,000 | W-2 wages or guaranteed payments |
| Rental income, net | $42,480 | Your share, after PITIA and expenses |
| Business income | $60,000 | Your share of net business income |
| Other income | $8,000 | Interest, dividends, other |
| Total annual income | $255,480 |
Example figures from the file. Replace them with your own.
Ready to talk about the loan?
You do not need a finished statement to start. Run your scenario by us, 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.
Related templates
- Schedule of real estate owned: the source of your real estate, mortgage, and rental income lines.
- Investor loan document checklist: the rest of a commercial loan file.
- All templates
Frequently asked questions
What is a personal financial statement for a real estate loan?
It is a signed summary of what you own, what you owe, your cash and securities, and your yearly income. Lenders commonly ask each guarantor on a commercial loan for one. Our free Excel template totals your assets, liabilities, net worth, liquidity, and income as you type, then you print and sign it.
Who fills it out and signs it?
The borrower, plus a co-borrower if there is one. The file has a name line for each, and signature and date lines for both under the certification at the bottom. The instructions say to print it, then sign and date it. On a commercial loan, our checklist asks for one from each guarantor.
What counts as liquidity on the statement?
The file counts liquidity as cash and savings plus marketable securities. Retirement accounts, real estate, business interests, and vehicles count toward total assets and net worth, but not toward liquidity. So a large retirement balance raises your net worth without raising the liquidity line on this statement.
Why does the file include contingent liabilities?
The file has a line for guarantees and loans you co-signed for others, and it counts them in total liabilities. Its notes say this keeps net worth conservative. If you have guaranteed a loan for an LLC or co-signed for someone, enter that balance on the contingent liabilities line.
How does it connect to my schedule of real estate owned?
Three lines come from the schedule: real estate value, mortgages on that real estate, and net rental income. Each should match the "your share" lines on the schedule, with rental income figured as monthly net cash flow times 12. Our two example files already agree, so you can see how the numbers carry over.
How should I send a completed statement?
Not through the scenario form on our homepage, and not as a plain email attachment, because a finished statement shows your balances and net worth. Call or text (813) 356-9448 and ask how to send it. To start a loan conversation, the scenario form needs only a short description of your deal.
