| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | Instructions: Make a copy of this sheet for your own purposes | ||||||
2 | Fill in all cells in orange on the Summary tab and on the Marketable Securities Detail tab. | ||||||
3 | If you wish to skip filling in each marketable security's individual details, then simply override the formula | ||||||
4 | and fill in the total value of each type (stocks, bonds, etc) in the Summary tab | ||||||
5 | NOTE: Tired of entering all this data manually? Create your wallet for free at yourownwallet.com & never do this again! | ||||||
6 | |||||||
7 | NET WORTH | $0.00 | |||||
8 | |||||||
9 | TOTAL ASSETS (WHAT YOU OWN) | $0.00 | TOTAL LIABILITIES (WHAT YOU OWE) | $0.00 | |||
10 | |||||||
11 | Cash | Account Type | Current Balance | Credit Cards Payable | Current Balance | ||
12 | Chase | Checking | $0.00 | American Express | $0.00 | ||
13 | Enter Bank 1 Name | Savings | $0.00 | Capital One | $0.00 | ||
14 | Enter Bank 2 Name | Checking | $0.00 | VISA | $0.00 | ||
15 | Enter Bank 2 Name | Savings | $0.00 | Mastercard | $0.00 | ||
16 | Enter Bank 3 Name | Checking | $0.00 | Discover | $0.00 | ||
17 | Enter Bank 3 Name | Savings | $0.00 | Other | $0.00 | ||
18 | Total | $0.00 | Total | $0.00 | |||
19 | |||||||
20 | U.S. Gov't & Marketable Securities | Notes | Current Value | Notes Payable to Banks (Secured) | $0.00 | ||
21 | US Gov't Bonds | Enter on Marketable Sec tab | $0.00 | ||||
22 | Stocks | Enter on Marketable Sec tab | $0.00 | Notes Payable to Banks (Unsecured) | $0.00 | ||
23 | Bonds | Enter on Marketable Sec tab | $0.00 | ||||
24 | ETFs | Enter on Marketable Sec tab | $0.00 | Amounts Due to Brokers | $0.00 | ||
25 | Mutual Funds | Enter on Marketable Sec tab | $0.00 | ||||
26 | Cryptocurrency | Enter on Marketable Sec tab | $0.00 | Amounts Payable to Others (Secured) | $0.00 | ||
27 | Options | Enter on Marketable Sec tab | $0.00 | ||||
28 | Futures | Enter on Marketable Sec tab | $0.00 | Amounts Payable to Others (Unsecured) | $0.00 | ||
29 | Total | $0.00 | |||||
30 | Accounts & Bills Due | $0.00 | |||||
31 | Retirement Accounts & Non-Marketable Securities | Type | Current Value | ||||
32 | Retirement Account 1 | 401K | $0.00 | Other Unpaid Taxes & Interest | $0.00 | ||
33 | Retirement Account 2 | IRA | $0.00 | ||||
34 | Retirement Account 3 | Roth IRA | $0.00 | Other Unpaid Interest | $0.00 | ||
35 | Retirement Account 4 | IRA Crypto | $0.00 | ||||
36 | Non-Marketable Securities | $0.00 | Long-Term Loans Payable | ||||
37 | Total | $0.00 | Mortgage 1 Payable | $0.00 | |||
38 | Mortgage 2 Payable | $0.00 | |||||
39 | Securities Held by Broker in Margin Account | Type | Current Value | Car Loan Payable | $0.00 | ||
40 | Security 1 | Equity | $0.00 | Other Loan Payable | $0.00 | ||
41 | $0.00 | Total | $0.00 | ||||
42 | Total | $0.00 | |||||
43 | LIABILITIES + NET WORTH | $0.00 | |||||
44 | Restricted of control stocks | Type | Current Value | ||||
45 | Security 1 | Equity | $0.00 | ||||
46 | $0.00 | ||||||
47 | Total | $0.00 | |||||
48 | |||||||
49 | Partial Interest in Real Estate | Note | Current Value | ||||
50 | Property 1 | Calculate MV x % Owned--> | $0.00 | ||||
51 | Property 2 | Calculate MV x % Owned--> | $0.00 | ||||
52 | Total | $0.00 | |||||
53 | |||||||
54 | Real Estate Owned | Note | Current Value | ||||
55 | Property 1 | Current Market Value--> | $0.00 | ||||
56 | Property 2 | Current Market Value--> | $0.00 | ||||
57 | Total | $0.00 | |||||
58 | |||||||
59 | Loans / Notes Receivable | Note | Current Value | ||||
60 | Loan 1 | Value Outstanding --> | $0.00 | ||||
61 | Loan 2 | Value Outstanding --> | $0.00 | ||||
62 | Total | $0.00 | |||||
63 | |||||||
64 | Automobiles / Personal Property | Note | Current Value | ||||
65 | Automobile 1 | Current Market Value--> | $0.00 | ||||
66 | Automobile 2 | Current Market Value--> | $0.00 | ||||
67 | Other Property 1 | Current Market Value--> | $0.00 | ||||
68 | Other Property 2 | Current Market Value--> | $0.00 | ||||
69 | Total | $0.00 | |||||
70 | |||||||
71 | Cash Value of Life Insurance | Cash Value | |||||
72 | Life insurance policy | $0.00 | |||||
73 | |||||||
74 | Other Assets | Current Value | |||||
75 | Asset 1 | $0.00 | |||||
76 | Asset 2 | $0.00 | |||||
77 | Total | $0.00 | |||||
78 | |||||||
79 |