Watch the actual Excel worksheets while Paul explains each field. Includes highlighted cells, illustrative calculations and captions. AI-generated presenter using Paul's approved likeness and voice. Use full screen for a larger view.
4 minutes 33 seconds. Pause as you complete each section, or use the chapter buttons above. Open video in a new tab.
Read the complete walkthrough
Hello, I'm Paul Singh. This is my AI-generated presenter, using my likeness and voice. Let's walk through your commercial loan personal financial statement package.
You do not have to know banking terminology to get started. Download the Excel workbook for automatic totals, or use the fillable PDF. These are preparation worksheets. We can provide the lender's required form, and the lender may ask for additional information.
Start with your name and one as-of date. Use that same date for your account balances and debts. Yellow cells in Excel are for your entries. The calculated cells update automatically. Enter zero when a required amount is truly zero. Leave unknown amounts blank and make a note.
First, list your assets. These may include checking, savings, investments, retirement accounts, vehicles, business ownership interests, and life insurance cash surrender value. Cash surrender value is different from the policy's death benefit. Use reasonable current values, explain estimates, and enter your ownership percentage. A fifty-thousand-dollar asset owned fifty percent gives you twenty-five thousand dollars of attributable value. Keep retirement money separate from cash available for closing.
Second, list your debts. Include credit cards, auto and student loans, personal loans, tax balances, and other amounts you owe. Enter the current balance and required monthly payment separately. A twenty-thousand-dollar balance is not a twenty-thousand-dollar monthly payment. Use the amount you are responsible for reporting, and explain joint obligations. Do not automatically divide a joint debt by your ownership percentage.
Third, complete the real estate schedule. Include your home, rental properties, land, and commercial buildings you already own. Record the address, ownership, estimated market value, all property loan balances, and your reportable liability. Include second mortgages and drawn home equity lines. Put these mortgages here only, so the workbook does not count them again on the debt sheet. Your proposed purchase belongs in your project file, not among property you already own.
For each property, enter your monthly mortgage payments, taxes, insurance, and association charges as one total, counting each expense once. If taxes and insurance are escrowed in the payment, don't add them again. Record gross rent separately. Gross rent is not profit.
Fourth, complete monthly obligations. The workbook brings over debt payments and property obligations. Add household expenses and commitments that are not already included. Convert an annual bill to a monthly amount by dividing by twelve. Keep business operating expenses separate unless they are personally paid obligations you need to explain.
Finally, review guarantees, contingent obligations, missing documents, and any estimates. The summary shows entered assets, reported liabilities, net worth, and monthly obligations. It does not determine loan approval. A high net worth does not mean all of that money is available for a down payment.
Save a private copy. Do not enter Social Security numbers or full account numbers in these worksheets. Ask our team for the correct commercial application and a verified secure upload link. Please keep completed financial documents out of public website forms and ordinary email.
Visit Paul Singh Mortgages dot com, or call eight five six, five zero three, nine three nine six. We will help you organize your next step. Paul Singh, N M L S number four zero six three three two. Petra Cephas Incorporated, N M L S number one two two two three zero zero. Mortgage broker only. All loans subject to lender approval. Equal Housing Opportunity.