User Account

All Pages

Calculate excess returns for series of prices downloaded

Assignment Help Finance Basics
Reference no: EM132616005

Using the Yahoo! Finance website, search for Bank of Nova Scotia (BNS.TO) by finding its stock symbol. If you are unable to locate the prices for BNS.TO, use prices for BNS (the Bank of Nova Scotia observed in U.S. dollars at the New York Stock Exchange). For the purpose of this question, assume that the Canadian dollar and the U.S. dollar have been exchanged one for one.

Download the following sources of data and answer the questions below.

  • From the Yahoo! Finance website, download historical prices for the stock from January 1, 2004 through January 1, 2012, on a monthly basis.
  • Also from the Yahoo! Finance website, download corresponding monthly prices for the S&P/TSX Comp index.
  • historical data for 3-month T-Bill rates (Excel file).

Note: Where appropriate, include your answer to this problem in the same Word file as your other answers. Also submit an Excel file to show your work.

1. Calculate excess returns for both series of prices downloaded from the Yahoo! Finance website (BNS and S&P/TSX Comp Index). Prior to that, make sure the data is sorted in ascending order (i.e., first row has the oldest data). The final spreadsheet should have the two series of returns you downloaded and calculated from Yahoo! Finance. Make sure all data is expressed in the same units.

2. Using the Tools menu in Excel (Tool Pack has to be installed if Excel does not show it), perform regression analyses using the Market Model for BNS. 

Clearly provide the regression results in a table with an explanation for the coefficients obtained, and clear interpretation. Specifically, for each regression provide:

  • Dependent Variable
  • Independent Variable
  • Intercept
  • Beta Value
  • Firm Specific Risk

3. Answer the questions below.

a. How well does the S&P/TSX Comp Index movement explain the variability of the return on BNS stock?

b. What is the alpha of the BNS stock?

c. Calculate the standard deviation of the stock return (using the equation for R2 =β2σM2/σ2,and the individual regression results).

d. Calculate systematic risk and firm specific risk for the stock.

Reference no: EM132616005

Questions Cloud

Calculate the new pe ratio of the firm : Atlantic Energy has a new project that will increase earnings by $219,000 in perpetuity. Calculate the new PE ratio of the firm.
Challenges confronting human resources managers : Identify the challenges confronting human resources managers within the context of global environment, international and domestic issues,
Explain your legal obligations in the given scenario : Amber, a 20-year-old college student is seeking mental health services for depression at the local community mental health center. During your meeting with.
Determine the type of intellectual property protection : Determine the type of intellectual property protection you will need to pursue for that asset
Calculate excess returns for series of prices downloaded : Calculate excess returns for both series of prices downloaded from the Yahoo! Finance website (BNS and S&P/TSX Comp Index).
What is the coupon payment of the bond : Unless otherwise specified, the face value M of all bonds at all maturities discussed is $100 (per unit);
Would you recommend buying Spirit to your CEO : Goldman Sachs tells you that they think Spirit might sell for a 20% premium over its Base Value. Would you recommend buying Spirit to your CEO
What is the difference between private and public policies : What is the difference between private and public policies?
How to successfully get customers to pay for your products : Explain how to successfully get customers to pay more for your products. Reference the article in support of your response. Explain how a specific pricing.

Reviews

Write a Review

Finance Basics Questions & Answers

  Employee of a federal reserve district bank

The prime rate, and other interest rates, offered by banks often change in the same direction as a change in the Fed's target for the federal funds rate. As an employee of a Federal Reserve District Bank, you have been told that your District Bank..

  Write a review of the article is beta dead

Write a review of the article "Is Beta Dead?" by Justin Timpano and Frank Bacon, Longwood University, which is located in the KU Online Library.

  What is the estimated cost of common equity using capm

Brook-sisters has a beta of 0.85. The yeild on a 3 - months T-bill is 3.75%, and the yeild on the 10 year government bond is 5.5% The market risk premium is 6.7

  Appropriate cost of capital

What is the projects NPV if the appropriate cost of capital is 10%? Round your answer to the nearest dollar.

  What are some aspects of the stadium and arena development

What are some aspects of the stadium and arena development that are usually overstated and what are the economic realities?

  Evaluate the worker appraisal in case

1. How do you evaluate the worker's appraisal in this case? 2. Do you suggest any techniques to avert politics creeping into the process of performance apprais

  Determine the maximum you would be willing to pay

The cash flow from the investment is expected to increase by 3 percent per year forever. If alternative investments of similar risk earn a return of 11 percent

  Current value of a share of common stock

What is the current value of a share of this common stock if your required rate of return is 18 percent?

  Show the entry for the sale of investments by the jan 2,2013

As of January 1, 2013, the Baber School District notifies the pool it needs to withdraw $1,000,000 cash from the pool, so the pool management sells investments to obtain $700,000 cash. The investments sold had been carried in the Investment Trust Fun..

  Individual or component costs of capital

Your firm is considering a new investment proposal and would like to calculate its weighted average cost of capital. To help in this, compute the cost of capital for the firm for the following:

  Determine the premium charges

Research indicates that the 1,000,000 cars in your city experience unrecoverable losses of $250,000,000 every year from theft, collisions, etc.

  Discussing the capital investment decisions

Compare and contrast up to three concepts associated with making capital investment decisions such as cash flows, sunk costs, opportunity costs, or others.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd