Active Balance Sheet (Public).xlsx

	B	C	D	E	G	H	I	J
1
2			Active Balance Sheet
3			John & Jane Doe
4
5	NET WORTH	$470,000	Projected Passive Growth		$11,300	Net Growth Rate		2.40%
6
7	ASSETS	Total Assets	Blended Rate	Equity Gain	LIABILITIES	Total Liabilities	Weighted Rate	Interest Loss
8	ASSETS	Total Assets	Blended Rate	Equity Gain	LIABILITIES	Total Liabilities	Weighted Rate	Interest Loss
9		$1,245,000	4.55%	$56,600		$775,000	5.85%	-$45,300
10
11	CASH/SAVINGS	Value	Rate	1-yr Gain	CREDIT	Balance	Rate	1-yr Cost
12	Total	$20,000		$100	Total	$35,000		-$10,150
13	HYSA	$5,000	2.00%	$100	Credit Card 1	$20,000	-29.00%	-$5,800
14	Checking	$10,000	0.00%	$0	Credit Card 2	$10,000	-29.00%	-$2,900
15	HSA	$5,000	0.00%	$0	Credit Card 3	$5,000	-29.00%	-$1,450
16
17	HOUSING	Value	Rate	1-yr Gain	MORTGAGE	Balance	Rate	1-yr Cost
18	Total	$950,000		$38,000	Total	$650,000		-$29,750
19	Primary	$500,000	4.00%	$20,000	Primary	$250,000	-2.80%	-$7,000
20	Investment 1	$450,000	4.00%	$18,000	HELOC	$100,000	-8.50%	-$8,500
21					Investment 1	$300,000	-4.75%	-$14,250
22	INVESTMENTS	Value	Rate	1-yr Gain
23	Total	$250,000		$18,500	SCHOOL LOANS	Balance	Rate	1-yr Cost
24	IRA	$50,000	7.00%	$3,500	Total	$40,000		-$2,400
25	401k	$100,000	6.00%	$6,000	Loan 1	$20,000	-5.00%	-$1,000
26	Brokerage Acct	$100,000	9.00%	$9,000	Loan 2	$20,000	-7.00%	-$1,400
27
28	OTHER	Value	Rate	1-yr Gain	OTHER	Balance	Rate	1-yr Cost
29	Total	$25,000		$0	Total	$50,000		-$3,000
30	Business Account	$25,000	0.00%	$0	Car Loan	$50,000	-6.00%	-$3,000
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100