ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMAN
1
Valuation Models3/23/2021AnnualizedGrossGross
2
Name
Ticker
Market ValuePriceTarget Price
Upside (Downside)
Shares
Avg. Price
Basis
Total Returns (%)
Total Returns (%)
Total Returns ($)
Allocation
Target
Date Bought
Allocation vs Target
Asset ClassSectorIndustrySizeGrowthMarket Cap
Review Date
Morningstar Fair Value
Thesis Slides
WIC Enviromental Score
WIC Social Score
WIC Governance Score
WIC ESG Score
Yahoo Finance ESG Score
3
Core Portfolio-$695,021.52----$461,52511.08%50.59%233,496.1942.62%60%8/28/2016
Underallocated
----$664,817,004,728.46--
4
AppleAAPL$81,341.76$122.54$132.498.12%664$24.81$16,47277.49%393.82%64,869.754.99%4.00%2/23/2016OverallocatedEquityTechnologyConsumer ElectronicsLargeHybrid$2,057,213,789,369.00
Event Specific
723450761396
5
BoeingBA$47,968.68$241.25$265.009.84%199$263.04$52,300-1.22%-8.28%(4,331.74)2.94%3.00%6/2/2014UnderallocatedEquityIndustrialsAerospace & DefenseLargeHybrid$140,803,150,000.00
Event Specific
522004707007
6
CostcoCOST$14,974.96$340.34$281.97-17.15%44$125.17$5,50725.24%171.90%9,467.480.92%1.00%6/2/2014UnderallocatedEquity
Consumer Defensive
Discount StoresLargeGrowth$150,612,019,939.00
Event Specific
54625833528.3
7
WalmartWMT$44,869.90$133.94$146.859.64%335$143.31$48,009-6.54%-6.54%(3,138.95)2.75%3.00%10/9/2020UnderallocatedEquity
Consumer Defensive
Discount StoresLargeValue$377,318,630,557.00
Event Specific
1979345899
8
The Walt Disney Co.DIS$74,622.69$188.73$187.20-0.81%395$101.54$40,14929.43%85.87%34,473.914.58%3.00%4/23/2018OverallocatedEquityConsumer CyclicalMedia- DiversifiedLargeHybrid$342,594,766,964.00
Event Specific
653224670335
9
Dominion EnergyD$52,214.98$74.18$82.4211.11%704$76.43$53,801-1.51%-2.95%(1,586.17)3.20%5.00%4/12/2019UnderallocatedEquityUtilitiesUtilities- DiversifiedLargeValue$59,762,976,303.00
Event Specific
602274849842
10
Google (Alphabet)
GOOGL
$42,867.93$2,041.33$2,600.0027.37%21$708.08$14,87037.05%188.29%27,998.352.63%4.00%2/23/2016UnderallocatedEquityTechnology
Internet Content & Information
LargeGrowth$1,378,736,298,682.00
Event Specific
641818586194
11
Johnson & JohnsonJNJ$62,222.60$160.35$138.16-13.84%388$93.98$36,46910.37%70.62%25,753.293.82%4.50%6/2/2014UnderallocatedEquityHealth Care
Drug Manufacturers- Major
LargeValue$422,154,583,518.00
Event Specific
692600406851
12
MicrosoftMSFT$62,512.52$237.58$232.00-2.35%263$140.70$37,02148.80%68.86%25,491.183.83%2.00%10/25/2019OverallocatedEquityTechnologySoftware-InfrastructureLargeGrowth$1,791,879,691,090.00Fall 20202735735621
13
NextEra EnergyNEE$20,744.99$74.02$70.50-4.76%280$110.66$31,015-4.86%-33.11%(10,269.78)1.27%5.00%6/2/2014UnderallocatedEquityUtilitiesRegulated ElectricLargeHybrid$145,069,940,920.00
Event Specific
866974757.5
14
PACCAR INCPCAR$7,991.62$91.17$97.406.83%88$53.16$4,6606.93%71.50%3,331.810.49%0.5%12/1/2010UnderallocatedEquityIndustrialsTruck ManufacturingLargeValue$31,648,297,314.00
Event Specific
323764329
15
Procter & GamblePG$44,927.61$132.60$143.388.13%339$77.91$26,39710.31%70.20%18,530.302.75%3.00%6/2/2014UnderallocatedEquity
Consumer Defensive
Household & Personal Products
LargeValue$326,524,332,629.00
Event Specific
1877614742
16
Union PacificUNP$62,618.74$208.05$208.990.45%301$104.68$31,50714.50%98.75%31,112.093.84%3.50%6/2/2014OverallocatedEquityIndustrialsRailroadsLargeGrowth$140,198,447,506.00
Event Specific
2616962523
17
VerizonVZ$53,251.93$56.91$65.2014.57%936$46.06$43,1037.97%23.55%10,149.303.27%4.00%4/10/2018UnderallocatedEquity
Communication Services
Telecom ServicesLargeValue$235,502,058,958.00
Event Specific
2300483274
18
Wells FargoWFC$21,890.61$38.24$24.15-36.85%572$35.37$20,2451.19%8.13%1,645.361.34%2.00%6/2/2014UnderallocatedEquityFinancial ServicesBanks- GlobalLargeValue$158,089,673,499.00
Event Specific
914852388.5
19
20
Active Portfolio$694,130.48$561,304 10.21%23.66%132,826.1142.56%20.00%11/28/2018Overallocated
21
Anheuser-BuschBUD$24,492.00$62.80$91.0144.92%390$109.89$42,856-6.29%-42.85%(18,363.67)1.50%2.00%6/2/2014UnderallocatedEquity
Consumer Defensive
Beverages- BrewersLargeHybrid$105,786,033,514.00
Event Specific
#ERROR!-1023569664
22
AT&TT$28,246.56$30.00$36.1020.33%942$37.28$35,104-13.11%-19.54%(6,857.70)1.73%2.00%9/26/2019UnderallocatedEquity
Communication Services
Telecom ServicesLargeValue$213,952,890,000.009/26/20211235335055
23
Cardinal HealthCAH$34,818.01$57.70$63.179.48%603$52.07$31,4214.47%10.81%3,397.412.13%2.00%10/22/2018OverallocatedEquityHealth CareMedical DistributionMediumValue$16,944,643,824.00Fall 20191510927755
24
Carnival CorporationCCL$44,682.12$25.33$17.81-29.69%1764$24.26$42,7954.23%4.41%1,887.482.74%2.00%3/7/2020OverallocatedEquityConsumer CyclicalTravel ServicesLargeValue$27,934,633,155.00Fall 20201961411022
25
CBRE GroupCBRE$48,737.00$74.98$65.71-12.36%650$46.41$30,16620.04%61.56%18,570.552.99%2.00%2/26/2018OverallocatedEquityReal EstateReal Estate ServicesMediumHybrid$25,163,064,186.00Fall 20192103342709
26
Check Pt SoftwareCHKP$13,553.28$115.84$125.908.68%117$102.88$12,0373.74%12.60%1,516.520.83%2.00%11/9/2017UnderallocatedEquityTechnologySoftware ApplicationLargeHybrid$16,240,767,486.00Fall 2019583441597.4
27
CISCOCSCO$49,740.48$50.01$51.713.40%995$33.62$33,43612.39%48.76%16,304.843.05%2.00%4/17/2017OverallocatedEquityTechnology
Communication Equipment
LargeValue$211,131,510,773.00Fall 20192130981477
28
Enterprise Products PartnersEPD$29,949.57$22.30$23.023.23%1343$28.56$38,351-11.46%-21.91%(8,401.03)1.84%2.00%4/25/2019UnderallocatedEquityEnergyOil & Gas MidstreamLargeValue$48,649,633,735.002/21/20201305202217
29
iShares U.S. Medical Devices ETFIHI$79,575.09$324.26--245$246.16$60,40922.18%31.73%19,166.154.88%2.00%10/18/2019OverallocatedEquityHealth CareMedical DevicesLargeValue$5,771,828,173.00
Spring 2021
3481887645
30
Kraft Heinz CompanyKHC$45,399.40$38.92$33.52-13.87%1166$32.02 $37,35210.53%21.55%8,047.552.78%2.00%3/7/2019OverallocatedEquity
Consumer Defensive
Packaged FoodsLargeValue$47,605,968,760.003/7/20201976281351
31
PaypalPYPL$47,047.61$243.77$314.6729.08%193$41.30$7,970117.35%490.29%39,077.412.88%2.00%1/18/2017OverallocatedEquityFinancial ServicesCredit ServicesLargeGrowth$285,497,578,523.00Fall 20192011426470
32
QualcommQCOM$46,866.11$132.52$157.4318.80%354$75.06$26,54511.24%76.56%20,321.582.87%3.00%6/2/2014UnderallocatedEquityTechnologySemiconductorsLargeValue$150,542,724,853.00
Event Specific
1958628419
33
KraneShares MSCI China ESG Leaders ETF
KESG$76,026.40$32.77--2320$24.98$57,94331.21%31.21%18,083.254.66%4.00%9/25/2020OverallocatedEquity#N/A3352688214
34
Global X MSCI China Health Care ETF
CHIH$35,590.80$26.76--1330$22.57$30,01218.59%18.59%5,578.882.18%2.00%9/25/2020OverallocatedEquity#N/A1569518689
35
Equity ResidentialEQR$38,777.40$71.81--540$55.49$29,96729.40%29.40%8,810.422.38%2.00%9/26/2020OverallocatedEquityReal EstateREIT - ResidentialMediumValue$26,760,936,301.001710083340
36
Medical Properties TrustMPW$17,285.40$21.34--810$18.54$15,01715.11%15.11%2,268.811.06%2.00%9/27/2020UnderallocatedEquityReal Estate
REIT - Healthcare Facilities
MediumValue$12,377,200,088.00762303425.4
37
STORE CapitalSTOR$33,343.25$32.53--1025$29.20$29,92611.42%11.42%3,417.662.04%2.00%9/28/2020OverallocatedEquityReal EstateREIT - DiversifiedMediumHybrid$8,670,057,924.001470504012
38
39
Fixed Income$139,931.51$133,728.992.89%4.64%6,202.528.58%10%8/15/2019
Underallocated
40
iShares 7-10 Year Treasury Bond ETF
IEF$100,096.08$113.96--878$107.66$94,563.613.09%5.85%5,532.476.14%6%5/2/2019OverallocatedFixed Income----$13,777,763,889.00
Event Specific
4362887937
41
iShares Global Green Bond ETFBGRN$20,354.68$54.78--371.5714$53.89$20,025.381.64%1.64%329.301.25%1.50%5/7/2020UnderallocatedFixed Income----#N/A
Event Specific
894751080.2
42
iShares ESG USD Corporate Bond ETF
SUSC$19,480.75$26.87--725$26.40$19,140.001.78%1.78%340.751.19%1.50%5/7/2020UnderallocatedFixed Income----#N/A
Event Specific
856334808.5
43
44
Cash & Cash Equivalents$101,836.98-$101,836.98-%-%-6.24%10%
Underallocated
45
Cash & Money Market
CASHX
$101,836.98--%--$101,836.98-%-%-6.24%9%-Underallocated
Cash & Cash Equivalents
----NA
46
47
Total$1,630,920.49----$1,258,395.67+9.04%29.60%372,524.82100%100%12/13/2017
48
INFLATION-2.19%
49
REAL GROWTH6.85%
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