ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAF
1
NAU Student Managed Investment Fund
Yellow cells must be updated manually
Last update:1/25/2019
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.61730$51,824.82($1,274.34)-2.40%16.84%3.300%12/5/2021AA-Baa142.71%2.712021Consumer Discretionary
7
00206RDG4 AT&T INC 6.375% 03/01/4110,00010/19/2018108.6898$10,868.98110.36940$11,036.94$167.961.55%3.59%6.375%3/1/2041BBBBaa295.55%12.012041
8
06050WBN4BANK AMER CORP 6.75%19 08/15/19 30,0003/14/2014119.6535$35,896.05101.79650$30,538.95($5,357.10)-14.92%9.92%6.750%8/15/2019A-A373.45%0.532019Financials
9
386088AF5DIAGEO INVESTMENT C 8% 09/15/2226,0004/21/2016132.3130$34,401.38115.41140$30,006.96($4,394.42)-12.77%9.75%8.000%9/15/2022A-A373.45%3.132022Consumer Staples
10
37045VAL4GENERAL MOTORS 6.75% 04/01/204610,00010/19/18100.6725$10,067.25100.55990$10,055.99($11.26)-0.11%3.27%6.750%4/1/2046BBBBaa396.70%12.162046
11
46625HJE1 JPMORGAN CHASE & 3.25%22 09/23/2225,00010/18/16104.8830$26,220.7599.83570$24,958.93($1,261.83)-4.81%8.11%8.000%9/23/2022A-A278.05%3.042022
12
38141EW96GOLDMAN SACHS 5.75% 06/15/204010,00010/19/2018107.2698$10,726.98109.44040$10,944.04$217.062.02%3.56%5.750%6/15/2040BBB+A385.02%12.592040
13
38141ES34GOLDMAN SACHS 5.5% 12/15/1910,00003/27/15114.6000$11,460.00101.35300$10,135.30($1,324.70)-11.56%3.29%5.500%12/15/2019BBB+A383.93%0.862019Financials
14
91324PBM3UNITEDHEALTH GROUP 3.875% 10/15/2045,00003/27/15109.1470$49,116.15101.10610$45,497.75($3,618.41)-7.37%14.79%3.875%10/15/2020A+A353.21%1.642020Health Care
15
912810FF0US TREASURY 5.25% 11/15/2810,00010/19/18119.8863$11,988.63121.51562$12,151.56$162.931.36%3.95%5.250%11/15/2028AAAAaa12.73%7.832028
16
931142CP6WAL-MART STORES 4.125% 02/01/1920,00009/18/15108.4730$21,694.60100.01170$20,002.34($1,692.26)-7.80%6.50%4.13%2/1/2019AAAa233.36%0.022019Consumer Discretionary
17
Bond Portfolio Without ETF$247,000.00$275,539.93$257,153.58($18,386.35)-6.67%83.57%3.31%2.92
18
DODIXDODGE & COX INCOME FUND760.13003/06/1813.6651$10,387.2812.76$9,699.26$(688.02)-6.62%3.15%
19
SCHOSCHWAB SHORT TERM US TREAS. ETF011/17/1550.5800$0.0024.32$0.00$0.00#DIV/0!0.00%
20
SCHZSCHWAB US AGGREGATE BOND ETF1,27209/28/1752.3700$66,614.6423.35$29,701.20$(36,913.44)-55.41%9.65%10/19/2024Today
21
Cash:  $11,169.183.63%
22
Bond Portfolio With ETF$275,539.93$307,723.22$(55,299.79)-20.07%100.00%10/18/2024 16:39:08Last Trade
23
24
SMIF Fixed Inc.DJCBT
25
Value today$307,723.22373.62
https://us.spindices.com/indices/fixed-income/dow-jones-equal-weight-us-issued-corporate-bond-index
26
Value on 12/31/2017
$336,675.34382.98
27
Year to date return:
-8.60%-2.44%
28
YTD $ change:($28,952.12)-9.36
29
30
31
Traditional Equity Portfolio
S&P 500 last price:
5864.67
32
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 Sector (New System)Market CapP/E RatioBetaS&P 500 At PurchaseS&P 500 Return Since PurchaseSmall / Mid / LargeValue / Core / GrowthS&P Sector (Old System)
33
EGHT8X8 INC3,50012/2/147.7400$27,090.001.98$6,930.00$(20,160.00)-74.42%0.32%-85.96%14.10Communication Services254,093,798.001.562066.55183.79%SmallGrowth14.3Information Technology
34
ACNACCENTURE LTD CL AF7509/20/0738.8190$29,114.25376.86$282,645.00$253,530.75870.81%13.22%146.17%153.09Technology253,507,946,188.0032.961.251518.75286.15%LargeCore117.13Information Technology
35
AGNALERGEN17012/03/1562.8416$10,683.070.09$15.30$(10,667.77)-99.86%0.00%-99.05%9.47Health Care2,191,649.002049.62186.13%LargeValue7.62Health Care
36
AMGNAMGEN INCORPORATED32011/25/201556.8226$18,183.22321.66$102,931.20$84,747.98466.08%4.81%84.97%173.90Health Care172,837,312,439.0055.370.612088.87180.76%LargeValue146.21Health Care
37
ARTNAARTESIAN RES CORP CL A1,55011/15/1517.3854$26,947.3735.49$55,009.50$28,062.13104.14%2.57%-7.96%38.56Utilities365,180,050.0019.970.192053.19185.64%SmallCore31.94Utilities
38
BLLBALL CORPORATION1,16010/30/1521.8998$25,403.7762.02$71,943.20$46,539.43183.20%3.36%#N/A#N/AConsumer Discretionary20,414,773,150.002079.36182.04%MidValue#N/AMaterials
39
BABOEING CORP33001/26/18145.0335$47,861.06155.00$51,150.00$3,288.956.87%2.39%-47.44%294.91Industrials95,505,900,500.001.572872.87104.14%LargeGrowth155.68Industrials
40
CVXCHEVRON35004/30/13110.7407$38,759.25150.75$52,762.50$14,003.2636.13%2.47%20.42%125.19Energy275,709,237,750.0014.961.091597.57267.10%LargeCore117.7Energy
41
CCITIGROUP INC90012/09/1553.0599$47,753.9562.85$56,565.00$8,811.0518.45%2.64%-15.54%74.41Financial Services119,904,912,838.0018.191.442047.62186.41%LargeValue59.43Financials
42
CGNXCOGNEX CORP1,72011/15/1629.3011$50,397.8140.75$70,090.00$19,692.1939.07%3.28%-33.37%61.16Technology6,988,657,600.0089.861.412180.39168.97%MidGrowth31.81Information Technology
43
CMICUMMINS INC66811/01/16122.0132$81,504.81335.51$224,120.68$142,615.87174.98%10.48%89.94%176.64Industrials45,980,841,614.0024.340.982111.72177.72%LargeValue136.67Industrials
44
CVSC V S CAREMARK CORP92711/17/1648.6464$45,095.2060.34$55,935.18$10,839.9824.04%2.62%-16.77%72.50Health Care75,906,453,051.0010.740.542187.12168.15%LargeValue78.91Consumer Staples
45
DFSDISCOVER FINANCIAL SVCS88002/21/1457.2344$50,366.23148.68$130,838.40$80,472.17159.77%6.12%93.29%76.92Financial Services37,318,678,161.0012.001.421836.25219.38%LargeValue72.09Financials
46
EIXEDISON INTERNATIONAL30005/01/1352.8460$15,853.8185.43$25,629.00$9,775.1961.66%1.20%35.09%63.24Utilities32,991,075,598.0034.350.911582.70270.55%LargeValue71.99Utilities
47
ENBENBRIDGE INC1,55011/25/1335.0134$54,270.8141.98$65,069.00$10,798.1919.90%3.04%7.34%39.11Energy91,753,669,959.0022.270.931802.48225.37%LargeValue42.12Energy
48
EQIXEQUINIX INC26111/25/14167.5038$43,718.50895.20$233,647.20$189,928.70434.44%10.92%97.52%453.22Technology84,994,756,206.0081.960.722067.03183.72%LargeGrowth357.41Information Technology
49
HABTHABIT RESTAURANTS3,12010/21/1614.1979$44,297.35$0.00$(44,297.35)-100.00%0.00%#N/A#N/AConsumer Discretionary#N/A2141.16173.90%SmallGrowth#N/AConsumer Discretionary
50
HASHASBRO INC47005/01/1571.9911$33,835.8072.94$34,281.80$446.001.32%1.60%-19.75%90.89Consumer Discretionary10,168,354,214.000.612108.29178.17%MidCore77.79Consumer Discretionary
51
MDTMEDTRONIC INC 90004/18/1345.3407$40,806.6592.24$83,016.00$42,209.35103.44%3.88%14.23%80.75Health Care118,296,874,860.0031.030.841541.61280.43%LargeCore71.23Health Care
52
PEPPEPSICO INCORPORATED60011/17/1164.3268$38,596.05175.06$105,036.00$66,439.95172.14%4.91%45.98%119.92Consumer Staples240,180,400,000.0025.800.531216.13382.24%LargeValue104.63Consumer Staples
53
VZVERIZON COMMUNICATIONS81011/04/1132.1039$26,004.1343.99$35,631.90$9,627.7737.02%1.67%-16.89%52.93Communication Services185,176,835,855.0016.490.421253.23367.96%LargeValue53.38Telecommunication Services
54
WTFCWINTRUST FINANCIAL36911/29/1665.2217$24,066.79115.37$42,571.53$18,504.7476.89%1.99%40.06%82.37Financial Services7,672,149,023.0012.011.162204.66166.01%MidCore72.57Financials
55
WYNDWYNDHAM WORLDWIDE CORP70004/17/1327.7565$19,429.56$0.00$(19,429.56)-100.00%0.00%#N/A#N/AConsumer Discretionary#N/A1552.01277.88%MidValue#N/AConsumer Discretionary
56
Stock Portfolio Total Without ETF$840,039.42$1,785,818.39$945,778.9783.50%
57
SCHBSCHW US BRD MKT ETF4,43703/26/1835.4166$157,143.3722.62$100,364.94$(56,778.43)-36.13%4.69%110.42%10.75#N/A9.03
58
Cash:  $252,573.4411.81%
59
Stock Portfolio Total With ETF$997,182.79$2,138,756.77$1,834,779.51100.00%Avg:#N/A#REF!#REF!
60
61
SMIF Non-ESGSP500 TR
62
Schwabb Port. Total:
$1,927,224.1012840.300
63
64
Difference$(211,532.67)
65
66
SMIF Non-ESGSP500 TR
67
Value on 12/31/2017
$2,015,019.135212.76
68
Year to date return:
6.14%146.32%
69
YTD change:$123,737.647,627.54
70
71
72
73
74
75
ESG Equity Portfolio
76
77
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
78
ATVIACTIVISION BLIZZARD45011/2/1765.2610$29,367.450.00$0.00$(29,367.45)-100.00%0.00%-100.00%1,246.50Information Technology74,289,500,000.002579.85127.33%LargeGrowth
79
ADDYYADIDAS ADR 1 ADR REPS 0.5 ORD SHS21510/18/18113.5230$24,407.45123.76$26,608.40$2,200.959.02%1.05%23.98%99.82Consumer Discretionary44,430,730,000.001.122768.78111.81%LargeGrowth
80
ALBALBEMARLE CORP2409/25/18103.5206$24,844.9595.14$22,833.60$(2,011.35)-8.10%0.90%-25.61%127.89Materials11,182,108,576.001.542915.56101.15%MidCore
81
GOOGLALPHABET INC.664/12/16758.5656$50,065.33163.42$10,785.72$(39,279.61)-78.46%0.42%210.27%52.67Information Technology2,020,551,004,560.0023.441.042061.72184.46%LargeGrowth42.39
82
BRK.BBERKSHIRE HATHAWAY CLASS B3653/9/16138.7945$50,660.00464.80$169,652.00$118,992.00234.88%6.67%134.49%198.22Financials1,004,535,202,000.000.010.861989.26194.82%LargeCore166.68
83
CATCATERPILLAR INC12011/6/18129.0413$15,484.95393.86$47,263.20$31,778.25205.22%1.86%149.94%157.58Industrials190,981,997,948.0017.941.102755.45112.84%LargeValue
84
CIENCIENA CORP7805/4/1722.5728$17,606.8265.33$50,957.40$33,350.58189.42%2.00%212.14%20.93Information Technology9,435,429,240.0069.660.942389.52145.43%SmallCore
85
COSTCOSTCO WHOLESALE CO33011/22/16152.3529$50,276.46889.56$293,554.80$243,278.34483.88%11.55%377.95%186.12Consumer Staples394,140,461,578.0053.700.802202.94166.22%LargeCore167.69
86
CVSCVS INC3709/28/1781.0134$29,974.9560.34$22,325.80$(7,649.15)-25.52%0.88%-16.77%72.50Health Care75,906,453,051.0010.740.542510.06133.65%LargeCore
87
ECLECOLAB INC4304/22/16116.5818$50,130.18261.46$112,427.80$62,297.62124.27%4.42%94.86%134.18Materials74,395,198,464.0043.841.132091.58180.39%LargeGrowth125.34
88
FBFACEBOOK INC CLASS A904/12/18164.0550$14,764.95185.26$16,673.40$1,908.4512.93%0.66%#N/A#N/AInformation Technology1,458,362,955,404.002663.99120.15%LargeGrowth
89
GSGOLDMAN SACHS GROUP1122/1/18268.0442$30,020.95528.50$59,192.00$29,171.0597.17%2.33%107.45%254.76Financials166,900,088,600.0015.511.352821.98107.82%LargeValue229.72
90
INTCINTEL CORP1,0754/14/1631.7860$34,169.9122.77$24,477.75$(9,692.16)-28.36%0.96%-50.67%46.16Information Technology97,159,569,183.00102.271.022082.78181.58%LargeCore36.07
91
ISRGINTUITIVE SURGICAL1204/12/18415.0413$49,804.95521.15$62,538.00$12,733.0525.57%2.46%328.40%121.65Health Care185,192,797,890.0083.771.392663.99120.15%LargeGrowth
92
JPMJPMORGAN CHASE2303/19/18114.0215$26,224.95225.37$51,835.10$25,610.1597.66%2.04%110.74%106.94Financials641,214,596,787.0012.541.112712.92116.18%LargeValue
93
LRCXLAM RESEARCH CORP1659/27/18151.0270$24,919.4572.84$12,018.60$(12,900.85)-51.77%0.47%295.65%18.41Information Technology94,408,939,013.0025.121.472914.00101.26%LargeCore
94
MLMMARTIN MARIETTA MATERIALS32510/18/16166.5115$54,116.24581.00$188,825.00$134,708.76248.92%7.43%162.85%221.04Materials35,509,000,240.0017.660.912139.60174.10%MidGrowth218.25
95
MSFTMICROSOFT CORP6809/22/1657.7863$39,294.72418.16$284,348.80$245,054.08623.63%11.19%388.85%85.54Information Technology3,108,199,197,300.0035.440.902177.18169.37%LargeCore65.86
96
NSRGYNESTLE SA3502/6/1882.2999$28,804.9599.18$34,713.00$5,908.0520.51%1.37%15.37%85.97Consumer Staples260,214,400,000.0020.110.572695.14117.60%LargeCore
97
NFLXNETFLIX INC.14010/6/1789.0164$12,462.30763.89$106,944.60$94,482.30758.15%4.21%297.94%191.96Consumer Discretionary327,834,552,580.0047.731.262549.33130.05%LargeGrowth147.81
98
NEENEXTERA ENERGY INC3902/24/16115.8619$45,186.1684.38$32,908.20$(12,277.96)-27.17%1.29%116.08%39.05Utilities173,361,404,517.0027.400.561929.80203.90%LargeCore32.09
99
NVDANVIDIA CORP25510/6/1786.2738$21,999.82138.00$35,190.00$13,190.1859.96%1.38%2751.24%4.84Information Technology3,385,140,000,000.0064.821.662549.33130.05%LargeGrowth2.72
100
PYPLPAYPAL HOLDINGS4003/22/1879.0124$31,604.9580.94$32,376.00$771.052.44%1.27%9.94%73.62Information Technology82,747,660,000.0019.601.442643.69121.84%LargeGrowth