In this extension, you will complete a personal financial statement to detail your “assets,”
“liabilities,” and “net worth” outside of your business.
“Assets” are resources that you own and don’t owe payment on, such as cash, investments,
homes, and cars.
“Liabilities” are debts or bank notes that you must pay back.
“Net worth” is the total of your assets minus your liabilities.
You’ll need to provide this information to lenders and investors to be considered
for a loan.
To complete your personal financial statement, you will:
List assets and liabilities, Use functions and formulas to perform calculations,
And link your business plan to your spreadsheet.
To begin, open the personal financial statement spreadsheet that accompanies this extension.
Make a copy and rename it.
Enter your name, title, and the date.
Next, list your assets.
“Assets” are anything that you can sell or cash out to generate income.
It’s okay to estimate these amounts for now.
Update your assets before meeting with lenders to ensure that your information is accurate.
Your spreadsheet will automatically total your assets using the “SUM function.”
Next, list your “liabilities.”
“Liabilities” are debts or expenses that you owe money on.
These include credit cards, personal loans known as “notes payable,” taxes owed,
and mortgages on real estate.
You should include anything that you owe money on, long- or short-term.
Your total liabilities are automatically calculated in the spreadsheet.
It also automatically calculates your net worth by subtracting your total liabilities
from your total assets.
If you print your personal financial statement to share with lenders, sign and date it.
This certifies that the information is correct and up to date.
If you like, complete the second half of the spreadsheet in order to provide more details.
Lastly, add a link to your spreadsheet in your business plan under the “Startup Expenses
and Capital” subheading of your “Financing Information” section.
Now, it’s your turn: Make a copy of the personal financial statement
spreadsheet and rename it, List assets and liabilities,
Use functions and formulas to perform calculations, And link your business plan to your spreadsheet.