Financial Model Sample- *Marketing Use*

	A	B	C	D	E	F	G	H
1
2
3
4	Client Profile 👤
5	Cole Heath & Amelia Heath
6	Profile	First Name	Last Name	Birthdate (mm/dd/yy)	Age	Retirement Age	Tax Filing Status	State
7	Client 1	Cole	Heath	12/5/1986	38	50	married jointly	CO
8	Client 2	Amelia	Heath	8/10/1987	37	50	married jointly	CO
9
10	Children	First Name	Last Name	Birthdate (mm/dd/yy)	Age	Kindergaten Year
11	Child 1	Jason	Heath	10/12/21	3	2027
12	Child 2	Carol	Heath	12/18/24	0	2030
14	Child 3
15
16	Net Worth 📈
17	Assets
18	Liquid Assets	Client Name	Account Type/Number	Institution	Balance
19		Joint	CD / x0000	Ally Bank (5% APY)	$159,470
20		Joint	Savings Account / x0000	Ally Bank (4.2% APY)	$110,684
21		Joint	Business Checking / x0000	Chase Bank	$11,649
34
35			Total Liquid Assets		$281,803
36
37	Education	Child First Name	Account Type/Number	Institution	Balance
38		Jason	529 / x0000	College Invest	$9,525
43
44			Total Education Funds		$9,525
45
46	Other Investments	Client Name	Account Type/Number	Institution	Balance
47		Cole	Brokerage / x0000	Fidelity	$155,353
48		Amelia	Brokerage / x0000	Fidelity	$17,865
49		Amelia	Stock Options / x0000	Fidelity	$101,522
55
56			Total Other Investments		$274,740
57
58	Retirement Assets	Client Name	Account Type/Number	Institution	Balance
59		Cole	Roth IRA / x0000	Charles Schwab	$125,682
60		Cole	Rollover IRA / x0000	Charles Schwab	$4,233
61
62
63		Amelia	401(k) / x0000	Fidelity	$373,927
64		Amelia	Roth IRA / x0000	Charles Schwab	$37,815
65		Amelia	HSA / x0000	Health Equity	$88,939
66
67			Total Retirement Assets		$630,596
68
69	Personal Assets	Client Name	Asset Name	Asset Type	Value
70			3398 Virgil St, Fort Walton, FL 32548	Primary Residence	$976,000
71			Personal Property	Personal Property	$100,000
72
73
74
75
76			Total Personal Assets		$1,076,000
77
78			Total Assets		$2,272,664
79
80	Liabilities
81	Mortgages	Client Name	Property Address	Lending Institution	Balance	Rate
82			3398 Virgil St, Fort Walton, FL 32548	Rocket Mortgage	$527,527	3.5%
83
84
85
86			Total Mortgages		$527,527
87
88	Car Loans	Client Name	Make/Model	Lending Institution	Balance	Rate
89
90
91
92
93			Total Car Loans		$0
94
95	Student Loans	Client Name	Loan Type	Lending Institution	Balance	Rate
96
97
98
99
100
101
102			Total Student Loans		$0
103
104	Credit Cards	Client Name	Credit Card	Lending Institution	Balance	Rate
105
106
107
108
109
110
111			Total Credit Cards		$0
112
113	Other Loans	Client Name	Debt Type	Lending Institution	Balance	Rate
114
115
116
117
118			Total Other Loans		$0
119
120			Total Liabilities		$527,527
121
122			Net Worth		$1,745,137