SMIF Portfolio
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAF
1
6/22/18NAU Student Managed Investment Fund
Yellow cells must be updated manually
Last update:4/3/2018
2
Green cells are automatically retrieved from Google Finance
3
4
Bond Portfolio
5
Symbol  Name Face ValueMost Recent Transaction DateAvg. Cost Each Total CostLast Price Market ValueCapital Gain / Loss ($) Capital Gain / Loss (%) % of Bond PortfolioCoupon RateMaturity DateS&P RatingMoody's RatingS&P Numerical RatingYTMModified DurationMaturity YearS&P Credit Watch?Moody's WatchlistCallable?First Call DateFirst Call PriceSector
6
023135AM8AMAZON.COM INC 3.3% 12/05/2151,0003/30/2015104.1160$53,099.16101.0543$51,537.69($1,561.47)-2.94%15.41%3.300%12/5/2021AA-Baa142.99%3.402021Consumer Discretionary
7
06050WBN4BANK AMER CORP 6.75%19 08/15/19 30,0003/14/2014119.6535$35,896.05103.8140$31,144.20($4,751.85)-13.24%9.31%6.750%8/15/2019A-A373.85%1.292019Financials
8
36966RMY9GENERAL ELECTRIC 6.75%18 04/15/1830,00011/04/13120.1342$36,040.27100.1172$30,035.16($6,005.11)-16.66%8.98%6.750%4/15/2018AA263.13%0.032018Industrials
9
38141ES34GOLDMAN SACHS 5.5% 12/15/1910,00003/27/15114.6000$11,460.00103.0481$10,304.81($1,155.19)-10.08%3.08%5.500%12/15/2019BBB+A383.63%1.592019Financials
10
386088AF5GRAND MET INVT COR 8% 09/15/2226,0004/21/2016132.3130$34,401.38118.3341$30,766.87($3,634.51)-10.57%9.20%8.000%9/15/2022A-A373.51%3.812022Consumer Staples
11
46625HJE1 JPMORGAN CHASE & 3.25%22 09/23/2225,00010/18/16104.8830$26,220.7599.4475$24,861.88($1,358.88)-5.18%7.44%8.000%9/23/2022A-A378.15%3.692022
12
91324PBM3UNITEDHEALTH GROUP 3.875% 10/15/2045,00003/27/15109.1470$49,116.15102.5290$46,138.05($2,978.10)-6.06%13.80%3.875%10/15/2020A+A352.83%2.362020Health Care
13
931142CP6WAL-MART STORES 4.125% 01/01/1920,00009/18/15108.4730$21,694.60101.4325$20,286.50($1,408.10)-6.49%6.07%4.13%1/1/2019AAAa232.17%0.732019Consumer Discretionary
14
Bond Portfolio Without ETF$237,000.00$267,928.36$245,075.15($22,853.21)-8.53%73.30%2.67%1.69
15
DODIXDODGE & COX INCOME FUND741.63803/06/1813.6651$10,134.5813.44$9,967.61$(166.97)-1.65%2.98%
16
SCHOSCHWAB SHORT TERM US TREAS. ETF011/17/1550.5800$0.0049.69$0.00$0.00#DIV/0!0.00%
17
SCHZSCHWAB US AGGREGATE BOND ETF1,27209/28/1752.3700$66,614.6450.49$64,223.28$(2,391.36)-3.59%19.21%6/22/2018Today
18
Cash:  $15,080.344.51%
19
Bond Portfolio With ETF$267,928.36$334,346.39$(25,244.57)-9.42%100.00%6/22/2018 16:37:58Last Trade
20
21
SMIF Fixed Inc.DJCBT
22
Value today$334,346.39372.11
https://us.spindices.com/indices/fixed-income/dow-jones-equal-weight-us-issued-corporate-bond-index
23
Value on 12/31/2017
$336,675.34382.98
24
Year to date return:
-0.69%-2.84%
25
YTD $ change:
($2,328.95)-10.87
26
27
28
Traditional Equity Portfolio
S&P 500 last price:
2754.88
29
Ticker Name  Qty Most Recent Transaction DateAvg. Cost Each Total CostLast Price Market ValueCapital Gain / Loss ($) Capital Gain / Loss (%) % of Equity PortfolioYear to Date ReturnPrice 12/31/17S&P SectorMarket CapP/E RatioBetaS&P 500 At PurchaseS&P 500 Return Since PurchaseSmall / Mid / LargeValue / Core / Growth
30
EGHT8X8 INC3,50012/2/147.7400$27,090.0019.60$68,600.00$41,510.00153.23%3.03%39.01%14.10Information Technology1,806,386,133.000.532066.5533.31%SmallGrowth14.3
31
ACNACCENTURE LTD CL AF7509/20/0738.8190$29,114.25159.63$119,722.50$90,608.25311.22%5.29%4.27%153.09Information Technology102,655,996,753.0027.061.031518.7581.39%LargeGrowth117.13
32
AGNALERGEN17012/03/1562.8416$10,683.07173.42$29,481.40$18,798.33175.96%1.30%6.02%163.58Health Care58,485,085,000.001.122049.6234.41%LargeGrowth210.01
33
AIGAMERICAN INTERNATIONAL GROUP1,37011/30/201233.4945$45,887.5154.46$74,610.20$28,722.6962.59%3.30%-8.59%59.58Financials48,887,836,652.00163.671.201416.1894.53%LargeValue65.31
34
AMGNAMGEN INCORPORATED32011/25/201556.8226$18,183.22185.15$59,248.00$41,064.78225.84%2.62%6.47%173.90Health Care122,514,875,748.0016.021.382088.8731.88%LargeGrowth146.21
35
ARTNAARTESIAN RES CORP CL A1,55011/15/1517.3854$26,947.3739.15$60,682.50$33,735.13125.19%2.68%1.53%38.56Utilities360,665,200.009.730.112053.1934.18%SmallValue31.94
36
BLLBALL CORPORATION1,16010/30/1521.8998$25,403.7735.91$41,655.60$16,251.8363.97%1.84%-5.13%37.85Materials12,541,205,546.0024.840.852079.3632.49%MidCore37.53
37
BABOEING CORP33001/26/18145.0335$47,861.06338.91$111,840.30$63,979.25133.68%4.94%14.92%294.91Industrials197,442,545,789.0025.031.382872.87-4.11%LargeCore155.68
38
CAHCARDINAL HEALTH INC57512/03/1585.8155$49,343.8953.98$31,038.50$(18,305.39)-37.10%1.37%-11.90%61.27Health Care16,770,774,916.0021.820.992049.6234.41%LargeCore71.97
39
CVXCHEVRON35004/30/13110.7407$38,759.25125.10$43,785.00$5,025.7612.97%1.93%-0.07%125.19Energy239,061,114,601.0029.301.141597.5772.44%LargeValue117.7
40
CCITIGROUP INC90012/09/1553.0599$47,753.9567.20$60,480.00$12,726.0526.65%2.67%-9.69%74.41Financials171,355,504,266.0011.671.512047.6234.54%LargeValue59.43
41
CGNXCOGNEX CORP1,72011/15/1629.3011$50,397.8145.11$77,589.20$27,191.3953.95%3.43%-26.24%61.16Information Technology7,801,704,685.0028.361.572180.3926.35%MidGrowth31.81
42
CMICUMMINS INC66811/01/16122.0132$81,504.81136.05$90,881.40$9,376.5911.50%4.01%-22.98%176.64Industrials22,417,355,044.0012.701.172111.7230.46%LargeValue136.67
43
CVSC V S CAREMARK CORP92711/17/1648.6464$45,095.2072.18$66,910.86$21,815.6648.38%2.96%-0.44%72.50Consumer Staples73,381,535,225.0014.311.002187.1225.96%LargeGrowth78.91
44
DFSDISCOVER FINANCIAL SVCS88002/21/1457.2344$50,366.2373.42$64,609.60$14,243.3728.28%2.85%-4.55%76.92Financials25,621,898,190.0011.031.461836.2550.03%LargeValue72.09
45
EIXEDISON INTERNATIONAL30005/01/1352.8460$15,853.8161.70$18,510.00$2,656.1916.75%0.82%-2.44%63.24Utilities20,102,554,312.0022.830.141582.7074.06%LargeValue71.99
46
ENBENBRIDGE INC1,55011/25/1335.0134$54,270.8131.73$49,181.50$(5,089.31)-9.38%2.17%-18.87%39.11Energy69,019,360,000.00231.390.661802.4852.84%LargeGrowth42.12
47
EQIXEQUINIX INC26111/25/14167.5038$43,718.50418.86$109,322.46$65,603.96150.06%4.83%-7.58%453.22Information Technology33,292,806,500.00130.080.512067.0333.28%MidGrowth357.41
48
GILDGILEAD SCIENCES INC37010/23/14106.7742$39,506.4571.07$26,295.90$(13,210.55)-33.44%1.16%-0.80%71.64Health Care92,409,537,857.0010.451.151950.8241.22%LargeCore71.61
49
HABTHABIT RESTAURANTS3,12010/21/1614.1979$44,297.3510.55$32,916.00$(11,381.35)-25.69%1.45%10.47%9.55Consumer Discretionary274,824,614.003.580.522141.1628.66%SmallGrowth17.25
50
HASHASBRO INC47005/01/1571.9911$33,835.8091.68$43,089.60$9,253.8027.35%1.90%0.87%90.89Consumer Discretionary11,736,134,607.0014.050.862108.2930.67%MidCore77.79
51
IPGPIPG PHOTONICS CORP51212/06/1697.6016$49,972.01234.25$119,936.00$69,963.99140.01%5.30%9.40%214.13Information Technology12,577,928,895.0030.071.902212.2324.53%MidGrowth98.71
52
MDTMEDTRONIC INC 90004/18/1345.3407$40,806.6586.81$78,129.00$37,322.3591.46%3.45%7.50%80.75Health Care116,869,026,700.0042.550.941541.6178.70%LargeCore71.23
53
PEPPEPSICO INCORPORATED60011/17/1164.3268$38,596.05108.37$65,022.00$26,425.9568.47%2.87%-9.63%119.92Consumer Staples153,652,297,315.0021.170.671216.13126.53%LargeCore104.63
54
VZVERIZON COMMUNICATIONS81011/04/1132.1039$26,004.1349.76$40,305.60$14,301.4755.00%1.78%-5.99%52.93Telecommunication Services205,603,160,118.0014.240.631253.23119.82%LargeValue53.38
55
WTFCWINTRUST FINANCIAL36911/29/1665.2217$24,066.7991.05$33,597.45$9,530.6639.60%1.48%10.54%82.37Financials5,124,560,584.0019.430.832204.6624.96%SmallCore72.57
56
WYNWYNDHAM WORLDWIDE CORP70004/17/1362.7408$43,918.55495.00$346,500.00$302,581.45688.96%15.30%3.13%480.00Consumer Discretionary98,164,242.0014.311552.0177.50%MidCore537.5
57
Stock Portfolio Total Without ETF$1,049,238.27$1,963,940.57$914,702.3086.74%
58
SCHBSCHW US BRD MKT ETF4,43703/26/1835.4166$157,143.3767.24$298,343.88$141,200.5189.85%13.18%4.22%64.523,434,409,000.0054.18
59
Cash:  $1,950.960.09%
60
Stock Portfolio Total With ETF$1,206,381.64$2,264,235.41$1,970,605.11100.00%Avg:65,189,258,874.71#REF!#REF!
61
62
SMIF Non-ESGSP500 TR
63
Schwabb Port. Total:
$1,939,339.325421.630
64
65
Difference$(324,896.09)
66
67
SMIF Non-ESGSP500 TR
68
Value on 12/31/2017
$2,015,019.135212.76
69
Year to date return:
12.37%4.01%
70
YTD change:$249,216.28208.87
71
72
73
74
75
76
ESG Equity Portfolio
77
78
Ticker Name  Qty Most Recent Transaction DateAvg. Cost Each Total CostLast Price Market ValueCapital Gain / Loss ($) Capital Gain / Loss (%) % of ESG PortfolioYear to Date ReturnPrice 12/31/17S&P SectorMarket CapP/E RatioBetaS&P 500 At PurchaseS&P 500 Return Since PurchaseSmall / Mid / LargeValue / Core / Growth
79
MMM3M COMPANY1643/9/17189.9392$31,150.03196.50$32,226.00$1,075.973.45%1.95%-16.51%235.37Industrials116,660,565,836.0023.541.162364.8716.49%LargeGrowth191.33
80
ATVIACTIVISION BLIZZARD45011/2/1765.2610$29,367.4575.98$34,191.00$4,823.5516.42%2.07%19.99%63.32Information Technology57,836,346,374.0059.321.202579.856.78%LargeGrowth
81
GOOGLALPHABET INC.664/12/16758.5656$50,065.331,169.29$77,173.14$27,107.8154.14%4.67%11.00%1,053.40Information Technology807,225,378,094.0031.011.062061.7233.62%LargeGrowth847.80
82
BRK.BBERKSHIRE HATHAWAY CLASS B3653/9/16138.7945$50,660.00188.91$68,952.15$18,292.1536.11%4.17%-4.70%198.22Financials470,701,054,703.000.030.881989.2638.49%LargeCore166.68
83
CIENCIENA CORP7805/4/1722.5728$17,606.8224.87$19,398.60$1,791.7810.18%1.17%18.82%20.93Information Technology3,552,124,148.003.691.342389.5215.29%SmallCore
84
COSTCOSTCO WHOLESALE CO33011/22/16152.3529$50,276.46211.10$69,663.00$19,386.5438.56%4.21%13.42%186.12Consumer Staples92,576,122,193.0032.370.952202.9425.05%LargeCore167.69
85
CVSCVS INC3709/28/1781.0134$29,974.9572.18$26,706.60$(3,268.35)-10.90%1.62%-0.44%72.50Health Care73,381,535,225.0014.311.002510.069.75%LargeCore
86
ECLECOLAB INC4304/22/16116.5818$50,130.18138.87$59,714.10$9,583.9219.12%3.61%3.50%134.18Materials40,066,830,983.0030.130.982091.5831.71%LargeGrowth125.34
87
GSGOLDMAN SACHS GROUP1122/1/18268.0442$30,020.95226.02$25,314.24$(4,706.71)-15.68%1.53%-11.28%254.76Financials85,371,839,117.0010.411.332821.98-2.38%LargeValue229.72
88
HDSHD SUPPLY HLDGS INC 1,3003/7/1742.7696$55,600.4944.46$57,798.00$2,197.513.95%3.50%11.07%40.03Industrials8,168,006,967.0031.171.252368.3916.32%MidGrowth41.13
89
INTCINTEL CORP1,3004/14/1631.7860$41,321.7652.50$68,250.00$26,928.2465.17%4.13%13.73%46.16Information Technology244,650,000,000.0015.210.952082.7832.27%LargeCore36.07
90
JPMJPMORGAN CHASE2303/19/18114.0215$26,224.95105.75$24,322.50$(1,902.45)-7.25%1.47%-1.11%106.94Financials360,055,149,455.0013.931.212712.921.55%LargeValue
91
MLMMARTIN MARIETTA MATERIALS32510/18/16166.5115$54,116.24227.43$73,914.75$19,798.5136.59%4.47%2.89%221.04Materials14,317,045,311.0034.131.172139.6028.76%MidGrowth218.25
92
MSFTMICROSOFT CORP8659/22/1657.7863$49,985.19100.41$86,854.65$36,869.4673.76%5.26%17.38%85.54Information Technology771,469,860,194.0027.871.042177.1826.53%LargeCore65.86
93
MHKMOHAWK INDUSTRIES23010/6/17163.3975$37,581.43211.87$48,730.10$11,148.6729.67%2.95%-23.21%275.90Consumer Discretionary15,805,224,086.0015.471.372549.338.06%MidCore229.49
94
NSRGYNESTLE SA3502/6/1882.2999$28,804.9575.83$26,540.50$(2,264.45)-7.86%1.61%-11.79%85.97Consumer Staples234,034,413,629.000.622695.142.22%LargeCore
95
NFLXNETFLIX INC.14010/6/1789.0164$12,462.30411.09$57,552.60$45,090.30361.81%3.48%114.15%191.96Consumer Discretionary178,697,791,264.00245.960.992549.338.06%LargeGrowth147.81
96
NEENEXTERA ENERGY INC3902/24/16115.8619$45,186.16164.30$64,077.00$18,890.8441.81%3.88%5.19%156.19Utilities77,457,009,681.0013.240.251929.8042.75%LargeCore128.37
97
NVDANVIDIA CORP25510/6/1786.2738$21,999.82250.95$63,992.25$41,992.43190.88%3.87%29.69%193.50Information Technology152,326,676,756.0043.211.542549.338.06%LargeGrowth108.93
98
PYPLPAYPAL HOLDINGS4003/22/1879.0124$31,604.9585.12$34,048.00$2,443.057.73%2.06%15.62%73.62Information Technology101,070,372,189.0049.442643.694.21%LargeGrowth
99
HSICSCHEIN HENRY INC62010/6/1681.2737$50,389.7274.69$46,307.80$(4,081.92)-8.10%2.80%6.88%69.88Health Care11,504,129,941.0021.311.002160.7727.50%MidGrowth84.99
100
SEDGSOLAREDGE INC1,65010/13/1615.2298$25,129.1350.05$82,582.50$57,453.38228.63%5.00%33.29%37.55Information Technology2,252,788,303.0018.61-0.532132.5529.18%SmallGrowth15.60
Loading...
 
 
 
Today
2018-03-31
S&P-Sectors
Equity Style Box
ESG Style Box
Daily Value
Equity Sector Weight
ESG Sector Weight
Relative Perf.
Spark Lines
Bond Ladder
Bond Ratings
Bond Sectors
Asset Allocation
Int. Rate Risk
Bond Rating Conversion
2017-09-30
2017-03-31
2016-12-31
2016-10-31
2016-03-31
2015-12-31
2013-11-30
2015-10-31
2015-09-30
2015-08-31
2015-04-30
2015-03-31
2015-03-15
2014-11-30
2014-03-31
2013-03-31
2012-09-30
2012-12-31
2012-03-31
2011-12-31
2011-09-30
2011-04-30
2011-03-31
2011-02-28
2011-01-31
2010-12-31
2010-10-30
2010-09-30
Trades
2010-03-31
2009-12-31
2008-12-31
2007-12-31