Using Excel’s vlookup function, in your Active Funds spreadsheet, calculate the year-to-date (YTD), 5-year, and 10-year benchmark-adjusted return for each of the mutual funds. Please be carefully follow the instructions to complete the excel.FINANCE 333 – INVESTMENT MANAGEMENT
SPREADSHEET ASSIGNMENT 1
Due date: Friday, October 23, 2020
Prof. D. M. Smith
In this assignment you will use VLOOKUP and Pivot tables to evaluate the success of active equity
mutual fund managers, graph the market’s dividend yield over time, and use various Text functions
to manipulate cell contents.
GENERAL INSTRUCTIONS:
Answer the following question in a file, sheet, and cells exactly as instructed. Unless the question states
otherwise, wherever possible use Excel functions. It is important to leave the function in the solution cell
(i.e., don’t change “=NPV…” to a number).
Create one file named YourLastName_FirstInitial #1.xlsx for your answers to this assignment. By 11:59
p.m. on the due date, send the file to ds693@yahoo.com.
This assignment must be completed as stated in the course syllabus. That means no collaboration with
other students on any step of this project. Here is the line: although you are permitted to speak with each
other, if another student’s file is on the screen, you must not touch the mouse or keyboard or touchscreen.
1. Copy Table 1 below into a sheet that you name Active Funds. The table contains returns for actively
managed US equity mutual funds. Table 2 below contains benchmark index returns. Copy Table 2
into an adjacent sheet in your Excel file, and name the sheet Indexes.
a) Using Excel’s VLOOKUP function, in your Active Funds spreadsheet, calculate the year-to-date
(YTD), 5-year, and 10-year benchmark-adjusted return for each of the mutual funds. For each
fund, benchmark-adjusted return is calculated as:
Benchmark-adjusted return = Individual mutual fund return − Benchmark index return
b) Do this in a new sheet that you name Pivot Tables: For the benchmark-adjusted returns, create a
pivot table showing the proportion of each Morningstar category’s funds that beat or equaled the
index (i.e., Outperformed). Your pivot table should appear in the following basic format.
Count of Performance
Column Labels
Row Labels
Outperform
Underperform Grand Total
Russell 2000 Growth TR USD
0%
100%
100%
Russell 2000 TR USD
18%
82%
100%
Russell 2000 Value TR USD
33%
67%
100%
S&P 500 TR USD
10%
90%
100%
Grand Total
11%
89%
100%
c) Follow the same instructions for all three return series. In a text box nearby, describe the results
of the analysis in the pivot tables. Has active management worked? Address the following:
i) Identify which categories underperformed and which outperformed.
ii) State what your overall results indicate about the validity of active management.
FINANCE 333 SPREADSHEET PROJECT #1 (FALL 2020)
PAGE 2
2. Answer this question in a sheet that you name Dividend Yield.
Relevant data for this question can be found at http://www.econ.yale.edu/~shiller/data/ie_data.xls.
Copy the data into your spreadsheet.
a) In a new column on the right, graph the dividend yield from the start of the data until the most
recent month the value is available. Date (Year) should be on the x-axis and Dividend Yield on
the y-axis. Move the graph to its own (new) sheet that you name Div. Yield.
b) Considering your graph, answer this question in a nearby text box. Assuming that the average
annual stock return is 11%, explain whether investors are currently relying on dividends for more
or less of their returns than they did in the past.
3. Copy Tables 3, 4, and 5 into a sheet that you name Text Functions. Do the following entirely using
Excel functions, and leave the functions intact.
a) First, in a new column to the right of the data in Table 3, use the TRIM function to remove the
spaces from the left and right of each cell.
b) Next, using whichever of the “Text Functions” you need from the list in Exhibit 15.3 below,
split the Table 3 data so that tickers all appear in one column and the company names all appear
in the adjacent column. Leave the Excel function names in all the cells.
c) Next, using whichever text functions you need, combine the two columns of data from Table
4 into a single column. The format of each cell in the column should be first name, then a space,
then last name.
d) Using Excel’s manipulation functions, switch the order of the first and last names for each person
in Table 5, and insert a middle initial “X.” for each. (e.g., David X. Smith)
Leave the Excel function names in all the cells.
Extracted from “Best
Practices for Equity
Research Analysts,” by
James J. Valentine,
McGraw-Hill, 2011. (A
great book!!)
Table 1: Actively Managed US Equity Mutual Fund Returns
Mutual Fund Name
Primary Prospectus Benchmark
YTD Return
AB Small Cap Core Z
Russell 2000 TR USD
-8.26
Aberdeen US Mid Cap Equity Institutional
Russell Mid Cap TR USD
15.41
Aberdeen US Small Cap Equity Inst Svc
Russell 2000 TR USD
9.65
10.19%
Adara Smaller Companies
Russell 2000 TR USD
1.78
9.71%
AIG Focused Alpha Large-Cap A
Russell 1000 TR USD
14.85
10.53%
AIG Select Dividend Growth W
Russell 1000 TR USD
-5.79
7.83%
AIG Small-Cap W
Russell 2000 TR USD
-9.61
8.66%
AllianzGI Small-Cap Institutional
Russell 2000 TR USD
-4.07
9.39%
American Beacon Zebra Small Cap Eq R5
Russell 2000 TR USD
-14.04
8.39%
American Century Small Company Inv
Russell 2000 TR USD
-6.71
4.81%
10.69%
AMG GW&K Small Cap Core N
Russell 2000 TR USD
-1.19
9.00%
12.85%
AMG SouthernSun Small Cap N
Russell 2000 TR USD
-7.45
3.85%
11.83%
Aperture Discover Equity Instl
Russell 2000 TR USD
29.77
AQR Large Cap Defensive Style I
Russell 1000 TR USD
7.27
13.40%
AQR Large Cap Momentum Style I
Russell 1000 TR USD
17.83
10.65%
AQR Large Cap Multi-Style I
Russell 1000 TR USD
5.22
8.01%
AQR Small Cap Momentum Style I
Russell 2000 TR USD
1.91
7.38%
AQR Small Cap Multi-Style I
Russell 2000 TR USD
-5.24
5.77%
AQR TM Large Cap Momentum Style I
Russell 1000 TR USD
19.27
10.32%
AQR TM Large Cap Multi-Style R6
Russell 1000 TR USD
7.20
AQR TM Small Cap Momentum Style I
Russell 2000 TR USD
2.74
AQR TM Small Cap Multi-Style R6
Russell 2000 TR USD
-6.96
Aquila Three Peaks Opportunity Growth A
Russell Mid Cap TR USD
-5.77
Argent Small Cap Institutional
Russell 2000 TR USD
-15.78
Aristotle Small Cap Equity I
Russell 2000 TR USD
-11.42
Artisan Mid Cap Investor
Russell Mid Cap TR USD
34.15
5-year Return
10-year Return
13.06%
13.90%
12.81%
12.20%
7.82%
9.04%
12.97%
10.10%
13.72%
FINANCE 333 SPREADSHEET PROJECT #1 (FALL 2020)
PAGE 4
Artisan Small Cap Investor
Russell 2000 TR USD
28.89
13.99%
15.27%
BlackRock Advantage Large Cap Core Instl
Russell 1000 TR USD
11.21
10.55%
12.18%
BlackRock Advantage Small Cap Core Instl
Russell 2000 TR USD
-4.71
10.09%
BMO Low Volatility Equity I
Russell 1000 TR USD
-4.22
9.55%
BNY Mellon Active MidCap A
Russell Mid Cap TR USD
-5.12
5.28%
10.27%
BNY Mellon Mid Cap Multi-Strategy M
Russell Mid Cap TR USD
5.07
8.92%
11.79%
BNY Mellon Opportunistic Small Cap Inv
Russell 2000 TR USD
-2.19
6.53%
10.86%
BNY Mellon Small Cap Multi-Strategy M
Russell 2000 TR USD
5.99
8.69%
11.36%
Bogle Investment Mgmt Sm Cp Gr Instl
Russell 2000 TR USD
-0.21
6.16%
12.14%
Boston Trust Midcap
Russell Mid Cap TR USD
-3.58
10.77%
13.38%
Boston Trust Walden Small Cap
Russell 2000 TR USD
-10.10
10.23%
11.64%
Brandes Small Cap Value R6
Russell 2000 TR USD
-0.34
Calvert Mid-Cap A
Russell Mid Cap TR USD
-1.15
7.40%
11.77%
Calvert Small-Cap A
Russell 2000 TR USD
-3.35
9.54%
12.33%
Carillon Scout Mid Cap I
Russell Mid Cap TR USD
6.73
10.15%
12.60%
Cavanal Mid Cap Core Equity Instl
Russell Mid Cap TR USD
-0.55
Champlain Mid Cap Adv
Russell Mid Cap TR USD
12.64
13.30%
14.25%
Champlain Small Company Adv
Russell 2000 TR USD
3.01
11.10%
13.11%
CIBC Atlas Equity Income Institutional
Russell 1000 TR USD
3.69
9.95%
Clarkston Founders Institutional
Russell Mid Cap TR USD
4.60
Clarkston Institutional
Russell 1000 TR USD
-2.57
ClearBridge Mid Cap A
Russell Mid Cap TR USD
-1.40
7.64%
11.50%
ClearBridge Small Cap C
Russell 2000 TR USD
-17.23
9.29%
10.12%
Columbia Contrarian Core Inst
Russell 1000 TR USD
11.70
10.51%
13.19%
Columbia Dividend Income Inst
Russell 1000 TR USD
-0.70
11.05%
12.64%
Cove Street Capital Small Cap Val Instl
Russell 2000 TR USD
-22.46
5.10%
10.64%
Crawford Small Cap Dividend
Russell 2000 TR USD
-13.27
9.64%
Dana Small Cap Equity Institutional
Russell 2000 TR USD
-9.21
Davenport Equity Opportunities
Russell Mid Cap TR USD
6.08
9.33%
Davenport Small Cap Focus
Russell 2000 TR USD
7.19
10.68%
FINANCE 333 SPREADSHEET PROJECT #1 (FALL 2020)
PAGE 5
Delaware Small Cap Core I
Russell 2000 TR USD
-6.29
8.34%
13.29%
Destinations Large Cap Equity I
Russell 1000 TR USD
Destinations Small-Mid Cap Equity I
Russell Mid Cap TR USD
DFA Tax-Managed US Small Cap
Russell 2000 TR USD
-10.49
7.24%
12.06%
DFA US Hi Relatv Profitability Instl
Russell 1000 TR USD
10.98
DFA US Large Cap Equity Institutional
Russell 1000 TR USD
8.12
11.00%
DFA US Micro Cap I
Russell 2000 TR USD
-14.42
7.50%
12.40%
DFA US Small Cap I
Russell 2000 TR USD
-9.86
7.10%
12.11%
Diamond Hill Large Cap A
Russell 1000 TR USD
-2.98
9.99%
11.78%
Diamond Hill Mid Cap Y
Russell Mid Cap TR USD
-17.18
8.40%
Diamond Hill Small Cap A
Russell 2000 TR USD
-19.18
4.59%
8.95%
DWS Core Equity S
Russell 1000 TR USD
6.58
11.60%
13.34%
DWS ESG Core Equity Institutional
Russell 1000 TR USD
7.98
6.50%
10.67%
DWS Small Cap Core S
Russell 2000 TR USD
-9.57
7.39%
11.23%
Eaton Vance Atlanta Capital Sel Eq I
Russell 1000 TR USD
1.57
12.47%
Eaton Vance Small-Cap A
Russell 2000 TR USD
-4.57
9.87%
11.45%
Eaton Vance Tx-Mgd Small-Cap A
Russell 2000 TR USD
-4.96
9.79%
11.46%
Elements U.S. Portfolio
Russell 1000 TR USD
11.43
Elements U.S. Small Cap Portfolio
Russell 2000 TR USD
-4.67
ERShares US Small Cap Fund™ Inst
Russell 2000 TR USD
10.22
F/m Investments Large Cap Focused Inst
Russell 1000 TR USD
37.33
FAM Dividend Focus Fund Investor
Russell Mid Cap TR USD
-0.27
12.52%
FAM Small Cap Investor
Russell 2000 TR USD
-9.30
7.59%
FAM Value Investor
Russell Mid Cap TR USD
-2.97
10.20%
12.27%
Federated Hermes MDT Small Cap Core IS
Russell 2000 TR USD
-7.07
9.57%
13.40%
Fidelity Advisor® Series Small Cap
Russell 2000 TR USD
-0.95
6.70%
Fidelity Advisor® Small Cap I
Russell 2000 TR USD
-1.54
6.31%
Fidelity® Flex Mid Cap Index
Russell Mid Cap TR USD
-0.23
Fidelity® Flex Small Cap
Russell 2000 TR USD
2.41
Fidelity® Flex Small Cap Index
Russell 2000 TR USD
-5.38
9.22
-2.46
11.07%
13.40%
9.42%
FINANCE 333 SPREADSHEET PROJECT #1 (FALL 2020)
PAGE 6
Fidelity® Low-Priced Stock
Russell 2000 TR USD
-6.35
7.92%
11.71%
Fidelity® Low-Priced Stock K6
Russell 2000 TR USD
-6.29
Fidelity® Mid Cap Enhanced Index
Russell Mid Cap TR USD
-1.49
8.07%
12.58%
Fidelity® Mid Cap Index
Russell Mid Cap TR USD
-0.40
9.33%
Fidelity® Series All-Sector Equity
Russell 1000 TR USD
12.75
10.84%
Fidelity® Series Small Cap Discovery
Russell 2000 TR USD
-8.87
7.10%
Fidelity® Series Small Cap Opps
Russell 2000 TR USD
-5.71
9.01%
11.91%
Fidelity® Small Cap Discovery
Russell 2000 TR USD
-10.85
5.98%
12.54%
Fidelity® Small Cap Enhanced Index
Russell 2000 TR USD
-7.65
6.80%
11.71%
Fidelity® Small Cap Index
Russell 2000 TR USD
-5.46
8.43%
Fidelity® Small Cap Stock
Russell 2000 TR USD
-2.76
8.55%
9.42%
Fidelity® Small Cap Stock K6
Russell 2000 TR USD
-2.44
Fidelity® Stock Selector Small Cap
Russell 2000 TR USD
-2.16
8.94%
12.23%
FMI Common Stock Investor
Russell 2000 TR USD
-12.52
7.75%
11.13%
Fuller & Thaler Behavioral Sm-Cp Eq R6
Russell 2000 TR USD
-5.56
10.48%
Glenmede Quant US Large Cap Core Eq
Russell 1000 TR USD
-3.70
9.87%
13.83%
Glenmede Quant US Small Cap Equity
Russell 2000 TR USD
-11.70
Glenmede Responsible ESG US Equity
Russell 1000 TR USD
-1.96
Glenmede Small Cap Equity Adv
Russell 2000 TR USD
-7.92
6.21%
11.84%
Glenmede Women in Leadership US Eq
Russell 1000 TR USD
-4.38
Goldman Sachs Capital Growth A
Russell 1000 TR USD
11.60
11.98%
13.06%
Goldman Sachs Small Cap Eq Insghts Instl
Russell 2000 TR USD
-11.50
9.10%
12.56%
Great Lakes Small Cap Opportunity Instl
Russell 2000 TR USD
-16.06
6.50%
11.57%
GuideMark® Large Cap Core Service
Russell 1000 TR USD
10.33
9.58%
11.35%
GuideStone Funds Small Cap Equity Instl
Russell 2000 TR USD
-3.31
6.66%
11.48%
Hancock Horizon Burkenroad Sm Cp Inv
Russell 2000 TR USD
-13.79
5.43%
10.59%
Hartford Schroders US MidCap Opps I
Russell Mid Cap TR USD
-4.96
9.66%
11.92%
Hartford Schroders US Small Cap Opps I
Russell 2000 TR USD
-10.58
9.71%
11.67%
Hartford Stock HLS IA
Russell 1000 TR USD
2.94
11.63%
12.73%
Hennessy Cornerstone Growth Investor
Russell 2000 TR USD
-5.45
3.51%
9.07%
12.78%
FINANCE 333 SPREADSHEET PROJECT #1 (FALL 2020)
PAGE 7
Hennessy Cornerstone Large Growth Instl
Russell 1000 TR USD
-2.32
8.07%
12.07%
Hodges Blue Chip Equity Income Retail
Russell 1000 TR USD
11.07
10.30%
11.21%
Hodges Small Cap Retail
Russell 2000 TR USD
-7.95
2.50%
11.45%
Hodges Small Intrinsic Value Retail
Russell 2000 TR USD
-15.80
5.27%
Homestead Small Company Stock
Russell 2000 TR USD
3.50
2.62%
10.46%
Huber Capital Small Cap Value Inv
Russell 2000 TR USD
-24.27
3.92%
9.76%
Invesco Charter A
Russell 1000 TR USD
6.91
6.39%
8.69%
Invesco Endeavor A
Russell Mid Cap TR USD
-9.62
5.03%
9.70%
Invesco Low Volatility Equity Yield R5
Russell 1000 TR USD
-5.59
3.75%
8.20%
Invesco Oppenheimer MainStrt MdCp Y
Russell Mid Cap TR USD
-4.06
7.22%
11.70%
Invesco Select Companies A
Russell 2000 TR USD
-8.16
5.79%
10.38%
Invesco Small Cap Equity A
Russell 2000 TR USD
1.20
5.09%
10.03%
iShares Russell 1000 Large-Cap Idx K
Russell 1000 TR USD
10.35
11.39%
iShares Russell 2000 Small-Cap Idx Instl
Russell 2000 TR USD
-5.48
8.22%
iShares Russell Mid-Cap Index K
Russell Mid Cap TR USD
-0.36
Ivy Mid Cap Income Opportunities I
Russell Mid Cap TR USD
-6.14
10.13%
Ivy Small Cap Core A
Russell 2000 TR USD
-10.80
8.69%
10.73%
James Small Cap
Russell 2000 TR USD
-18.58
0.98%
8.33%
Janus Henderson US Managed Volatility I
Russell 1000 TR USD
7.80
9.93%
12.52%
JHancock Small Cap Core NAV
Russell 2000 TR USD
2.58
8.71%
JPMorgan Insurance Tr Small Cap Core 1
Russell 2000 TR USD
-11.59
7.56%
12.52%
JPMorgan Intrepid Mid Cap I
Russell Mid Cap TR USD
-4.56
6.58%
11.78%
JPMorgan Mid Cap Equity I
Russell Mid Cap TR USD
4.58
9.73%
13.44%
JPMorgan Small Cap Blend A
Russell 2000 TR USD
1.26
13.33%
14.67%
JPMorgan Small Cap Core R5
Russell 2000 TR USD
-11.51
7.60%
12.63%
JPMorgan Small Cap Equity A
Russell 2000 TR USD
-2.41
9.88%
13.49%
JPMorgan US Small Company L
Russell 2000 TR USD
-5.29
6.47%
12.02%
Knights of Columbus Small Cap I
Russell 2000 TR USD
-8.23
KP Large Cap Equity Institutional
Russell 1000 TR USD
10.28
11.54%
KP Small Cap Equity Institutional
Russell 2000 TR USD
-4.17
8.68%
11.77%
FINANCE 333 SPREADSHEET PROJECT #1 (FALL 2020)
PAGE 8
LKCM Small Cap Equity Instl
Russell 2000 TR USD
5.42
6.92%
10.80%
Longleaf Partners Small-Cap
Russell 2000 TR USD
-9.72
6.65%
11.98%
Lord Abbett Alpha Strategy A
Russell 2000 TR USD
0.98
8.05%
11.18%
Madison Mid Cap Y
Russell Mid Cap TR USD
-3.11
11.35%
13.54%
Madison Small Cap Y
Russell 2000 TR USD
-0.27
5.35%
10.53%
MainStay MacKay Small Cap Core I
Russell 2000 TR USD
-11.13
4.87%
9.74%
MainStay MacKay U.S. Equity Opports I
Russell 1000 TR USD
0.98
9.40%
13.14%
MassMutual Premier Small Cap Opps A
Russell 2000 TR USD
-3.01
7.04%
12.05%
MassMutual Select Equity Opports R5
Russell 1000 TR USD
-1.29
10.74%
14.32%
MassMutual Select TRP Large Cap Blend I
Russell 1000 TR USD
11.68
Mercer US Large Cap Equity Y3
Russell 1000 TR USD
8.24
10.43%
12.61%
MFS Blended Research Mid Cap Eq R6
Russell Mid Cap TR USD
MFS Blended Research Small Cap Eq R6
Russell 2000 TR USD
-13.50
MM Russell 2000® Small Cap Index I
Russell 2000 TR USD
-5.59
Mondrian US Small Cap Equity
Russell 2000 TR USD
-24.11
Morgan Stanley Pathway Large Cap Eq
Russell 1000 TR USD
7.56
10.27%
Multi-Manager Small Cap Eq Strat Inst
Russell 2000 TR USD
-4.34
8.37%
Nationwide Small Cap Index R6
Russell 2000 TR USD
-5.41
8.16%
11.78%
Nationwide WCM Focused Sm Cp Instl Svc
Russell 2000 TR USD
-13.82
9.57%
14.00%
Needham Small Cap Growth Retail
Russell 2000 TR USD
25.58
14.39%
12.15%
Neuberger Berman Genesis Inv
Russell 2000 TR USD
7.01
10.59%
12.19%
North Square Dynamic Small Cap I
Russell 2000 TR USD
-3.00
Northern Small Cap Core I
Russell 2000 TR USD
-7.57
7.65%
11.85%
Northern Small Cap Index
Russell 2000 TR USD
-5.81
8.08%
11.62%
Northern US Quality ESG K
Russell 1000 TR USD
11.25
Nuveen Large Cap Core I
Russell 1000 TR USD
3.91
7.90%
Nuveen Small Cap Select I
Russell 2000 TR USD
-4.88
8.57%
Pacific Funds Small-Cap R6
Russell 2000 TR USD
-10.09
7.09%
Parnassus Mid-Cap
Russell Mid Cap TR USD
0.42
9.88%
12.76%
PartnerSelect Smlr Coms Instl
Russell 2000 TR USD
-11.57
5.49%
9.58%
-3.20
8.19%
12.51%
11.10%
FINANCE 333 SPREADSHEET PROJECT #1 (FALL 2020)
PAGE 9
Pax ESG Beta Dividend Fund Institutional
Russell 1000 TR USD
5.78
Pax ESG Beta Quality Individual Investor
Russell 1000 TR USD
5.68
9.97%
12.16%
Pax Small Cap Institutional
Russell 2000 TR USD
-9.65
5.32%
11.13%
Pear Tree Polaris Small Cap Ord
Russell 2000 TR USD
-21.37
6.88%
9.62%
Penn Capital Special Sits Sm Cp Eq Inst
Russell 2000 TR USD
-10.29
Perritt MicroCap Opportunities Investor
Russell 2000 TR USD
-10.40
2.63%
7.94%
Perritt Ultra MicroCap
Russell 2000 TR USD
-6.85
2.15%
8.38%
PGIM Jennison Small-Cap Core Equity R6
Russell 2000 TR USD
7.12
PIMCO StocksPLUS® Small Institutional
Russell 2000 TR USD
-6.77
8.85%
14.31%
Pinnacle Value
Russell 2000 TR USD
-12.61
1.34%
5.30%
Principal Edge MidCap Institutional
Russell Mid Cap TR USD
-3.83
Principal MidCap R5
Russell Mid Cap TR USD
5.16
13.15%
15.97%
Principal SmallCap R5
Russell 2000 TR USD
-1.96
8.34%
12.40%
Private Capital Management Value I
Russell 2000 TR USD
-15.81
4.19%
ProFunds Small Cap Inv
Russell 2000 TR USD
-7.84
6.11%
9.94%
Prospector Opportunity
Russell 2000 TR USD
-6.81
10.22%
11.51%
QS US Large Cap Equity IS
Russell 1000 TR USD
7.75
9.05%
12.28%
QS US Small Capitalization Equity I
Russell 2000 TR USD
-10.38
4.92%
10.92%
RBC Small Cap Core I
Russell 2000 TR USD
-8.73
4.21%
10.37%
Rice Hall James Small Cap Instl
Russell 2000 TR USD
-3.50
3.81%
10.17%
RMB Small Cap I
Russell 2000 TR USD
-4.84
8.32%
10.98%
Royce Dividend Value Svc
Russell 2000 TR USD
-9.49
7.73%
10.43%
Royce Pennsylvania Mutual Invmt
Russell 2000 TR USD
-6.99
8.28%
10.52%
Royce Premier Invmt
Russell 2000 TR USD
-6.99
10.52%
11.30%
Royce Smaller-Companies Growth Svc
Russell 2000 TR USD
15.77
7.03%
9.16%
Royce Total Return Invmt
Russell 2000 TR USD
-12.62
7.49%
10.36%
Russell Inv Multifactor US Equity Y
Russell 1000 TR USD
3.88
10.98%
Russell Inv US Small Cap Equity Y
Russell 2000 TR USD
-10.99
7.40%
Russell Inv US Strategic Equity S
Russell 1000 TR USD
10.61
9.60%
Rydex Russell 2000 A
Russell 2000 TR USD
-6.72
6.38%
11.57%
10.09%
FINANCE 333 SPREADSHEET PROJECT #1 (FALL 2020)
PAGE 10
SA US Small Company Investor
Russell 2000 TR USD
-8.18
6.77%
11.57%
Saratoga Mid Capitalization C
Russell Mid Cap TR USD
-7.95
3.48%
8.97%
Saratoga Small Capitalization I
Russell 2000 TR USD
-0.58
4.11%
7.71%
Schwab ® US Mid-Cap Index
Russell Mid Cap TR USD
-0.46
Schwab Small Cap Index
Russell 2000 TR USD
-5.43
8.27%
12.08%
Schwab Small-Cap Equity
Russell 2000 TR USD
-11.11
6.30%
12.13%
Segall Bryant &Hamill Small Cap Cre Ins
Russell 2000 TR USD
1.60
Segall Bryant&Hamill Workplace Eq Ret
Russell 1000 TR USD
-2.27
8.73%
11.02%
SEI Large Cap A (SIIT)
Russell 1000 TR USD
1.63
9.51%
12.31%
SEI Large Cap F (SIMT)
Russell 1000 TR USD
1.50
9.60%
11.90%
SEI Large Cap Index A (SIIT)
Russell 1000 TR USD
10.37
11.45%
13.50%
SEI Large Cap Index F (SIMT)
Russell 1000 TR USD
10.24
SEI Mid-Cap F (SIMT)
Russell Mid Cap TR USD
-7.02
8.53%
12.20%
SEI Small Cap A (SIIT)
Russell 2000 TR USD
-7.32
6.55%
10.38%
SEI Small Cap F (SIMT)
Russell 2000 TR USD
-7.26
4.98%
9.46%
SEI Small Cap II A (SIIT)
Russell 2000 TR USD
-5.66
7.35%
SEI Tax-Managed Large Cap F (SIMT)
Russell 1000 TR USD
2.28
9.19%
11.92%
SGI US Small Cap Equity I
Russell 2000 TR USD
-18.65
SIM US Core Managed Volatility Z
Russell 1000 TR USD
-6.07
Sit Small Cap Dividend Growth I
Russell 2000 TR USD
-1.26
State Street Dynamic Small Cap N
Russell 2000 TR USD
-10.09
7.18%
12.77%
State Street Instl Small-Cap Equity Inv
Russell 2000 TR USD
-6.27
9.10%
12.82%
T. Rowe Price Instl Small-Cap Stock
Russell 2000 TR USD
1.60
11.58%
15.15%
T. Rowe Price Small-Cap Stock
Russell 2000 TR USD
1.74
11.34%
14.68%
TCW New America Premier Equities I
Russell 1000 TR USD
11.62
TETON Westwood SmallCap Equity AAA
Russell 2000 TR USD
-15.54
9.83%
11.17%
Thomas White American Opportunities Inv
Russell Mid Cap TR USD
-5.46
7.73%
11.32%
Thompson MidCap
Russell Mid Cap TR USD
-12.72
5.72%
10.84%
Thrivent Mid Cap Stock A
Russell Mid Cap TR USD
1.31
11.12%
13.04%
Thrivent Small Cap Stock A
Russell 2000 TR USD
-6.54
10.81%
11.67%
FINANCE 333 SPREADSHEET PROJECT #1 (FALL 2020)
PAGE 11
TIAA-CREF Quant Small-Cap Equity Instl
Russell 2000 TR USD
-11.84
8.54%
12.16%
TIAA-CREF Small-Cap Blend Idx Inst
Timothy Plan Small Cap Value A
Russell 2000 TR USD
-5.38
8.42%
11.99%
Russell 2000 TR USD
-13.83
7.23%
12.15%
Tocqueville Phoenix Fund
Russell 2000 TR USD
-17.88
2.00%
6.74%
Touchstone Large Cap Institutional
Russell 1000 TR USD
3.76
8.20%
Touchstone Mid Cap Y
Russell Mid Cap TR USD
-0.40
11.64%
14.48%
Touchstone Small Cap Institutional
Russell 2000 TR USD
-8.09
4.75%
10.04%
Touchstone Small Company A
Russell 2000 TR USD
-9.98
8.86%
11.91%
Tributary Small Company Instl
Russell 2000 TR USD
-18.95
8.17%
11.59%
USAA Small Cap Stock
Russell 2000 TR USD
-5.25
7.57%
11.30%
VALIC Company I Core Equity
Russell 1000 TR USD
7.81
9.92%
11.96%
VALIC Company I Large Cap Core
Russell 1000 TR USD
11.50
10.46%
13.26%
VALIC Company I Small Cap
Russell 2000 TR USD
-0.59
8.49%
12.58%
VALIC Company I Small Cap Index
Russell 2000 TR USD
-5.77
8.02%
11.62%
VALIC Company I Systematic Core Fund
Russell 1000 TR USD
11.87
10.61%
11.80%
Value Line Small Cap Opportunities Inv
Russell 2000 TR USD
6.64
10.33%
13.68%
Vanguard Dividend Growth Inv
Russell 1000 TR USD
3.42
11.55%
13.09%
Vanguard Tax-Managed Capital App I
Russell 1000 TR USD
10.74
11.77%
13.66%
Victory Munder Mid-Cap Core Growth Y
Russell Mid Cap TR USD
4.59
6.88%
11.49%
Virtus KAR Mid-Cap Core I
Russell Mid Cap TR USD
9.68
12.31%
14.11%
Virtus KAR Small-Cap Core I
Russell 2000 TR USD
4.63
17.10%
16.11%
Voya Russell Mid Cap Index Port I
Russell Mid Cap TR USD
-0.69
8.91%
12.79%
Voya Russell Small Cap Index Port I
Russell 2000 TR USD
-5.70
7.96%
11.65%
Voya Small Company I
Russell 2000 TR USD
-10.78
7.47%
11.13%
Voya Small Company Port I
Russell 2000 TR USD
-10.67
7.86%
11.52%
Voya US High Dividend Low Volatility I
Russell 1000 TR USD
-4.06
VY® Columbia Contrarian Core I
Russell 1000 TR USD
11.41
10.68%
11.85%
VY® JPMorgan Small Cap Core Equity S
Russell 2000 TR USD
-6.77
8.88%
13.08%
Walden Midcap
Russell Mid Cap TR USD
-3.69
10.58%
Wasatch Core Growth
Russell 2000 TR USD
12.63
12.90%
14.77%
FINANCE 333 SPREADSHEET PROJECT #1 (FALL 2020)
PAGE 12
Weitz Hickory
Russell Mid Cap TR USD
-8.00
5.27%
10.97%
Wellington Shields All-Cap Instl
Russell 1000 TR USD
12.59
7.98%
9.93%
Wells Fargo Disciplined Small Cap Adm
Russell 2000 TR USD
-9.63
6.21%
9.92%
Wells Fargo Low Volatility US Eq R6
Russell 1000 TR USD
2.47
WesMark Small Company Growth
Russell 2000 TR USD
11.73
4.92%
9.09%
Wilmington Large-Cap Strategy Instl
Russell 1000 TR USD
10.63
11.43%
13.13%
Zacks Small-Cap Core Inv
Russell 2000 TR USD
-18.06
7.77%
Table 2: Benchmark Index Returns
Benchmark Index
YTD Return
5-year Return
10-year Return
Russell 1000 TR USD
10.43
11.48%
13.54%
Russell 2000 TR USD
-5.53
8.23%
11.83%
Russell Mid Cap TR USD
-0.41
9.33%
13.19%
TABLES 3, 4, AND 5 FOLLOW
Table 3. Tickers and Company Names
AAPL Apple Inc.
ABT Abbott Laboratories
ACN Accenture plc
AEP American Electric Power Co.
ALL Allstate Corp.
AMGN Amgen Inc.
AMZN Amazon.com
APA Apache Corp.
APC Anadarko Petroleum Corporation
FINANCE 333 SPREADSHEET PROJECT #1 (FALL 2020)
AXP American Express Inc.
BA Boeing Co.
BAC Bank of America Corp
BAX Baxter International Inc
BHI Baker Hughes
BK Bank of New York
BMY Bristol-Myers Squibb
BRK.B Berkshire Hathaway
CAT Caterpillar Inc
C Citigroup Inc
CL Colgate-Palmolive Co.
CMCSA Comcast Corporation
COF Capital One Financial Corp.
COP ConocoPhillips
COST Costco
CSCO Cisco Systems
CVS CVS Caremark
CVX Chevron
DD DuPont
DELL Dell
DIS The Walt Disney Company
DMS DMS Industries
DOW Dow Chemical
DVN Devon Energy
EBAY eBay Inc.
EMC EMC Corporation
EMR Emerson Electric Co.
EXC Exelon
PAGE 13
FINANCE 333 SPREADSHEET PROJECT #1 (FALL 2020)
F Ford Motor
FCX Freeport-McMoran
FFF Fall Corp
GD General Dynamics
GE General Electric Co.
GILD Gilead Sciences
GOOG Google Inc.
GS Goldman Sachs
HAL Halliburton
HD Home Depot
HNZ H. J. Heinz Company
HON Honeywell
HPQ Hewlett Packard Co
IBM International Business Machines
INTC Intel Corporation
JNJ Johnson & Johnson Inc
JPM JP Morgan Chase & Co
KFT Kraft Foods Inc
KO The Coca-Cola Company
LLY Eli Lilly and Company
LMT Lockheed-Martin
LOW Lowe’s
MA Mastercard Inc
MCD McDonald’s Corp
MDT Medtronic Inc.
MET Metlife Inc.
MMM 3M Company
MO Altria Group
PAGE 14
FINANCE 333 SPREADSHEET PROJECT #1 (FALL 2020)
MON Monsanto
MRK Merck & Co.
MS Morgan Stanley
MSFT Microsoft
NKE Nike
NOV National Oilwell Varco
NSC Norfolk Southern Corp
NWSA News Corp.
PEP Pepsico Inc.
PFE Pfizer Inc
PG Procter & Gamble Co
PM Phillip Morris International
QCOM Qualcomm Inc.
RTN Raytheon Co (NEW)
SHS Stewart’s Shoppes
SSS Summer Corporation
SLB Schlumberger
SO Southern Company
SPG Simon Property Group, Inc.
T AT&T Inc
TGT Target Corp.
TWX Time Warner Inc.
TXN Texas Instruments
UNH UnitedHealth Group Inc.
UNP Union Pacific Corp.
UPS United Parcel Service Inc
USB US Bancorp
UTX United Technologies Corp
PAGE 15
FINANCE 333 SPREADSHEET PROJECT #1 (FALL 2020)
V Visa Inc.
VZ Verizon Communications Inc
WAG Walgreens
WFC Wells Fargo
WWW Winter Companies
WMT Wal-Mart
XOM Exxon Mobil Corp
Table 4. Federal Reserve Chair Names
LastName
FirstName
Powell
Jerome
Yellen
Janet
Bernanke
Ben
Greenspan
Alan
Volcker
Paul
Miller
William
Burns
Arthur
Table 5. Student Names
Name
Acosta,Beatriz
Adamczak,Tyler
Adams,Alex
Aderonmu,Mo
Afzaal,Sidrah
Arjune,Sachin
Armitage,Noah
Baek,James
PAGE 16
FINANCE 333 SPREADSHEET PROJECT #1 (FALL 2020)
Baglio,Nicholas
Campbell,Thalia
Campion,Kayleen
Casimir,Briana
Conlon,Aidan
Danko,Joseph
Deangelo,Luciano
Debus,Brian
Dolson,Kimberly
Dombrowski,Lauren
Estevez,Edgar
Fiore,Nicholas
Herrera,Giovanni
Herrera,Stephany
Jain,Gaurav
Kim,Jae Yung
Lange,Cassidy
Locastro,Marisa
Mercado,Gladys
Miller,Jacob
Moffatt,Breanna
Morcerf,Brian
Mulligan,Jon
Muncil,Robert
Nguyen,Thao
Nicholson,Bryan
Ogbuji,Zina
Patel,Krupa
Polini,Vincent
Ryan,Trey
PAGE 17
FINANCE 333 SPREADSHEET PROJECT #1 (FALL 2020)
Scales,Dylan
Schannauer,Rachel
Sepa,Kristen
Sevilla,Breystar
Sgambellone,Anthon
y
Sinn,Michael
Stewart,Angel
Taylor,Jake
Thomas,Nicholas
Tomczak,Aaron
Toskos,George
Trinidad,Ileeanna
Tyndell,Madison
Verde,Zach
Wang,Jercy
Zhang,Zihan
Zupo,Louis
PAGE 18
Purchase answer to see full
attachment
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.