Investment Barbell Strategy framework support.xlsx

	B	C	D	E	F	G	H	I	J	K	M	N	P	R	T	V	AF	AH	AI	AJ	AK
1
2	Categories		Dimension Inputs		Other Inputs				Outcome Calcs		Input Build
3	Asset Category	Portfolio	Diversification	Volatility	Retirement?	Leverage	Income Efficiency?	Equity	Percent of Equity	Investment Category	Value (000's)	Loan Balance (000's)						1	2	3	4
4	Financial	Cash	1	1	N	0%	n/a	$ 250	5%	1			Investment Barbell Strategy Health check report		How diversified is the investment?		1	5%	0	0	0
5	Financial	Financial Portfolio 1	1	4	N	0%	n/a	$ 260	5%	2					How diversified is the investment?		2.5	0	5%	0	0
6	Financial	Financial Portfolio 2	1	4	Y	0%	n/a	$ 160	3%	2					Very!	Not Much	2.5	0	3%	0	0
7	Financial	Financial Portfolio 3	1	4	Y	0%	n/a	$ 1,300	25%	2					Very!	Not Much	2.5	0	25%	0	0
8	Financial	Financial Portfolio 4	1	4	Y	0%	n/a	$ 100	2%	2			How volatile is the investment?	Low	5%	40%	2.5	0	2%	0	0
9	Financial	Financial Portfolio 5	5	5	Y	0%	n/a	$ 250	5%	4				Low	5%	40%	5	0	0	0	5%
10	Financial	Financial Portfolio VA	1	4	Y	0%	n/a	$ 800	15%	2				Hi	50%	5%	2.5	0	15%	0	0
11	Real	Real Estate 1	5	2	N	66%	N	$ 1,300	25%	3	1,900	1,250		Hi	50%	5%	3.5	0	0	25%	0
12	Real	Real Estate 2	5	2	N	30%	Y	$ 800	15%	3	500	150					3.5	0	0	15%	0
13
14		Total				27%		$ 5,220			$ 2,400	$ 1,400						5%	0.5019157088	0.4022988506	0.04789272031
15
16	Key:										value from
17	Diversification										www.zillow.com
18	A number between 1 and 5.
19	1	Well Diversified with rebalancing. This is usually a robo-advisor or 401(k) account.
20	5	Not well diversified. This can be a single project, company, or a single market segment.
21
22	Volatility
23	A number between 1 and 5.
24	1	Low volatility - this is usually cash, short-term investments or conservative long-term investments. Generally, robo-advisors and 401(k) providers require their customers to set the volatity (or "risk") threshold.
25	5	High Volatility - this is usually higher growth investments that may have significant market swings.
26
27	Retirement?
28	Is the Portfolio have tax retirement advantages?
29
30	Leverage?
31	How much is borrowed against the notional value?
32
33	Income Efficiency?
34	For real estate, does the project produce income?
35
36	Equity
37	What is the current value of the portfolio, less any loans?
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