Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Copy Table 1 below into a sheet that you name Active Funds . The table contains 5-year returns for actively managed mutual funds. Using Excels
Copy Table 1 below into a sheet that you name Active Funds. The table contains 5-year returns for actively managed mutual funds.
Using Excels vlookup function, in your Active Funds spreadsheet, calculate the 5-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 - Return for benchmark index.
| Total Ret Annlzd 5 Yr (%) | |
| 12.4 | |
Russell 2000 TR USD | 12.62 | |
Russell 2000 Value TR USD | 12.78 | |
S&P 500 Growth TR USD | 13.94 | |
S&P 500 TR USD | 13.6 | |
S&P 500 Value TR USD | 13.11 |
If it answer is correct, will rate!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started