Personal Finance HW3

Create a personal balance sheet statement for your life as of right now using the Microsoft Excel
template that I provide on Mycourses.SIU.edu.
GUIDELINES:
Use bank statements, investment account statements, etc. to find the value of your various
checking, savings, and investment accounts (if applicable).
The majority of the class will not have very many current assets besides Cash on Hand and
Savings/Checking accounts.
If you OWN a residence, please list the current value using the most recent appraisal or
Zillow.com
If you OWN a car(s), use Kelley Blue Book to find the value. (kbb.com)
Please use your best judgement for Other assets.
Use Credit Card statements to find credit card balances.
FOR DEBTS, DO NOT PUT IN EXPENSES!!! Only put in amounts in amounts that you are past
due. For example, do not put in your current month rent as a liability. However, if you still have
not paid for several month’s past rent, then it would be a liability. Additionally, if you have not
paid your cell phone bill for 2 or more months, then the past due amount should be a liability.

[Enter Name]
Personal Balance Sheet
2/15/2024
Assets
Liabilities
Current Assets
Current Liabilities
Cash on hand
Checking accounts
Savings accounts
Certificates of Deposit < 1 year Accounts Receivable Other Total Current Assets Credit card 1 Credit card 2 Credit card 3 Loans from friends/family Home line of credit Other $ - Investments $ - Retirement Accounts 401(k) 403(b) 457 IRA - Roth IRA - Traditional Profit Sharing Pension Total Retirement Accounts $ - $ - Total Other Liabilities $ - Total Liabilities $ - Current Net Worth $ - Loans & Mortgages Stocks Mutual funds Certificates of Deposit > 1 year
Bonds
Corporate bonds
Other 1
Other 2
Total Investments
Total Current Liabilities
Primary residence loans
Secondary residence loans
Other property loans
Investment property
Vehicle 1
Vehicle 2
Recreational vehicle 1
Recreational vehicle 2
Student loans
Business loans
401(k) loan
Total Loans & Mortgages
Other Liabilities
$
–
Commitment to donate
Other 1
Other 2
Other 3
Property
Primary residence owned
Secondary residence owned
Rental property owned
Investment property
Vehicle 1
Vehicle 2
Recreational vehicle 1
Recreational vehicle 2
Total Property
Net Worth Ratios
$
–
Other Assets
Loans to friends/family
Life insurance cash surrender value
Jewelry
Furnishings
Antiques
Collectables
Other 1
Other 2
Liquidity Ratio
Solvency Ratio
Current Assets
Investments
Retirement
0%
Property
Other Assets
N/A
N/A
#DIV/0!
Breakdown of Assets#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Current Assets
Investments
Retirement
Property
Other Assets
Total Other Assets
$
–
Total Assets
$
–