Suppose you have daily returns 0.03990, 0.00429, -0.00045, -0.00544 ... -0.00544, .... for 252 trading days....
Suppose you have daily returns 0.03990, 0.00429, -0.00045, -0.00544 ... -0.00544, .... for 252 trading days. What is the compound return? How to get it in Excel? Thank you!!!
Homework Answers
| Daily Return =i | ||||
| Number of days | 252 | |||
| Compounded Return =R | ||||
| 1+R=(1+i)^252 | ||||
| R=((1+i)^252)-1 | ||||
| i | R=((1+i)^252)-1 | |||
| Daily Return | Compounded Return | |||
| 0.0399 | 19136.1697 | |||
| 0.00429 | 1.94105304 | |||
| -0.00045 | -0.107229315 | |||
| -0.00544 | -0.747064907 | |||
 |
Add Answer to:
Suppose you have daily returns 0.03990, 0.00429, -0.00045,
-0.00544 ... -0.00544, .... for 252 trading days....
Suppose portfolio returns are +1%, -0.5%, +1%, -0.5%, … for 252 trading days, and that the...
Suppose portfolio returns are +1%, -0.5%, +1%, -0.5%, … for 252 trading days, and that the risk-free rate is 0.01% per day. What is the annualized Sharpe ratio?
Please enter the return standard deviations for MICROSOFT INC. and for the portfolio during the last...
Please enter the return standard deviations for MICROSOFT INC. and for the portfolio during the last calendar year (2017). Please use daily returns, and make sure to show your work. Please keep in mind that the standard deviation you will get using daily data is the daily standard deviation. In finance, the practice is to annualize the standard deviation by multiplying the daily standard deviation by sqrt(252) - there are approximately 252 trading days in a year. This is especially...
For 300 trading days, the daily closing price of a stock (in $) is well modeled...
For 300 trading days, the daily closing price of a stock (in $) is well modeled by a Normal model with mean $196.12 and standard deviation $7.12 According to thismodel, what cutoff value of price would separate the a) lowest 11% of the days? b) highest 0.77%? c) middle 52%? d) highest 50%?
For 300 trading days, the daily closing price of a stock (in $) is well modeled...
For 300 trading days, the daily closing price of a stock (in $) is well modeled by a Normal model with mean $195.61 and standard deviation $7.15. According to this model, what cutoff value of price would separate the a) lowest 11% of the days? b) highest 0.86%? c) middle 58%? d) highest 50%?
You observed the following daily returns for two companies: ABC and DEF. Daily Returns ABC ...
You observed the following daily returns for two companies: ABC and DEF. Daily Returns ABC DEF Monday 3% 2% Tuesday 2% 8% Wednesday −8% 14% Thursday –10% 12% Friday 7% 3% Calculate, for each stock, the: A. Geometric mean daily return B. Arithmetic mean daily return C. Standard deviation of daily returns
7. You have accumulated 76 daily returns for your $150,000,000 portfolio. After ranking the returns from...
7. You have accumulated 76 daily returns for your $150,000,000 portfolio. After ranking the returns from the highest to lowest, you identify the lowest six returns as: -0.0011, -0.0019, -0.0025, -0.0034,-0.0096, and -0.010 i. Calculate the daily 5% VaR (in both percent and dollar terms) using this data history VARS- 0039-11.645 x ii. What does the VaR you computed mean?
Suppose the returns on long-term government bonds are normally distributed. Assume long-term government bonds have a...
Suppose the returns on long-term government bonds are normally distributed. Assume long-term government bonds have a mean return of 6 percent and a standard deviation of 9.6 percent. What is the probability that your return on these bonds will be less than −13.2 percent in a given year? Use the NORMDIST function in Excel® to answer this question. Probability % What range of returns would you expect to see 95 percent of the time? Expected range of returns ...
Suppose a bank holds a $2 million trading position in stocks that has a beta 2.0....
Suppose a bank holds a $2 million trading position in stocks that has a beta 2.0. Suppose that the daily changes in returns for the portfolio have a mean 0 and standard deviation 1%. Determine the bank's DEAR for this equity position using a 99 percent confidence level.
Let us consider a $5 million position in silver. In addition, let us consider that the returns of gold are normally (Gaussian) distributed. The standard deviation of silver returns on a daily basis...
Let us consider a $5 million position in silver. In addition, let us consider that the returns of gold are normally (Gaussian) distributed. The standard deviation of silver returns on a daily basis is 0.45%. (a) How much can this position potentially lose in one day with 99 percent confidence interval? (b)How much this position could lose in one month with 99 percent confidence interval if one holds this position. (There are 20 trading days in a month)
NEED EXCEL SOLUTION PLEASE: (EXCEL FORMULA) Suppose we have the following returns for the market and...
NEED EXCEL SOLUTION PLEASE: (EXCEL FORMULA) Suppose we have the following returns for the market and a stock: Year Market return Stock return 1 18% 7% 2 27% 25% 3 5% 21% 4 13% 4% 5 -17% -16% 6 6% 19% 7 -21% -38% 8 34% 29% 9 19% 15% 10 11% 16% What is the covariance and correlation of the returns between this stock and the market? Covariance: Use Covar Function Correlation: Use Correl Function Beta: Use Slope Function...
7. You have accumulated 76 daily returns for your $150,000,000 portfolio. After ranking the returns from the highest to lowest, you identify the lowest six returns as: -0.0011, -0.0019, -0.0025, -0.0034,-0.0096, and -0.010 i. Calculate the daily 5% VaR (in both percent and dollar terms) using this data history VARS- 0039-11.645 x ii. What does the VaR you computed mean?
Most questions answered within 3 hours.
-
VII. (10 pts) Match each description below with the appropriate
metabolic process(es). Please note that a...
asked 1 minute from now -
Calculate concentration of PNP dilution ( in uM ) if
concentration of stock solutions is 0.5...
asked 4 minutes ago -
Suppose you are the money manager of a $4.74 million investment
fund. The fund consists of...
asked 12 minutes ago -
An antacid tablet weighing 0.928 g contained calcium carbonate
as the active ingredient, in addition to...
asked 6 minutes ago -
What are the
conditions for Segment-Zero to occur? (no partial credits)
Question 1 options:
multiple
competitors...
asked 5 minutes ago -
A condenser has 0.073 kg/s of propane entering at 18 bar and
70°C, and leaving as...
asked 10 minutes ago -
What is a highly unreasonable omission or misrepresentation
involving an extreme departure from the standards of...
asked 35 minutes ago -
What are the three mechanisms that control hormone release and a
example of each.
asked 48 minutes ago -
What would happen to the price level and real GDP if new, large
reserves of petroleum...
asked 50 minutes ago -
2. According to economists, people pollute because
a. They have low self esteem
b. They are...
asked 44 minutes ago -
For this project you will be writing up a simple Clock program
to keep track of...
asked 51 minutes ago -
The December 31, 2018, adjusted trial balance for Fightin' Blue
Hens Corporation is presented below.
...
asked 55 minutes ago