Please answer the problems in the attached Excel and return the Excel spreadsheet. A template Excel file “Finance for Executives – Problem Set #2” that contains the relevant data is provided. Please type put your answers in the yellow highlighted cells that correspond to each question. These cells have been formatted to display the correct number of decimal places. No rounding should be necessary. You can add additional calculations elsewhere in the spreadsheet, but please put your answers in the highlighted cells. You may want to consult the handout “Finance for Executives – Formulas” which contains formulas – also attached.
- Consider a 10-year zero coupon bond with a face amount of $1,000 and an annually compounded yield of 3%?
- What is its price?
- What will the price of the bond be in 1 year if the yield rises to 4%? Drops to 2%?
- Consider a 3-year, risk-free bond with a coupon rate of 6% (annual coupons) and a face amount of $1,000.
- What is price of this bond if the YTM is 5%? 6%? 7%?
- What is the YTM if the price is $1,100 (in percent)?
- The yields on 1-year, 2-year and 3-year, risk-free, zero-coupon bonds are 2%, 2.5% and 3%, respectively. What is the value of a 3-year, risk-free bond with a coupon rate of 4% (annual coupons) and a face amount of $1,000?
- Assume that over the next year you believe there are only 2 possible states of the world, each with probability 50%. The table below gives the returns on the US and Brazilian equity markets in these two scenarios.
- What are the expected returns on the US and Brazil (in percent)?
- What are the volatilities (standard deviations) of the returns on the US and Brazil (in percent)?
- What is the covariance between the returns on the US and Brazil?
- What is the correlation between the returns on the US and Brazil?
- Consider portfolios with positions in the US and Brazilian equity markets. The (annual) expected return and standard deviation of returns for the 2 markets are as follows:
The correlation between the returns is 0.3, and the (annual) risk-free (T-bill) rate is 2%.
- Calculate the expected returns (in percent), standard deviations (in percent), and Sharpe ratios of the portfolios for weights in the US ranging from 100% to 0% (in 10% increments), with the remainder invested in Brazil. (The spreadsheet will plot the investment opportunity set given these calculations.)
- Find the weights in the US and Brazil for a portfolio with an expected return of 15%. What is the standard deviation of this portfolio (in percent)?
- What are the approximate weights (to the nearest 1%) in the US and Brazil in the maximum Sharpe ratio portfolio, i.e., the tangency portfolio? What is the expected return (in percent), standard deviation (in percent), and Sharpe ratio of this portfolio? (The spreadsheet will plot the CAL for this portfolio given these calculations.) (Trial and error is a viable strategy, but you can also use the Solver tool in Excel. The pre-module materials take you through how to install and use Solver.)
- Calculate the expected returns (in percent), standard deviations (in percent) and Sharpe ratios of the following portfolios: (i) 50% in the risk-free asset, 50% in the US (ii) 50% in the risk-free asset, 50% in a portfolio that itself is invested 40% in the US and 60% in Brazil.
- What are the portfolio weights in the risk-free asset, the US, and Brazil in the portfolio in part d(ii).
- Find the weights (T-bill, US, Brazil) for a portfolio with the same expected return as Brazil (10%), using only a combination of the risk-free asset and the 40/60 portfolio from d(ii)? What is the standard deviation of this portfolio?
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."
