What is the required rate of return for this stock

Assignment Help Financial Management

Reference no: EM132125008

Assignment 1

1. Set up an amortization schedule in Excel that caters to possible prepayments (or excess payments). The loan details are: $38,500, 6.5% APR, 5 year loan with Monthly payments. Show, on the spreadsheet, the impact of an extra $6000 payment in month 11.

Assignment 2

1. From Yahoo Finance (or Bloomberg) download 3 years of daily stock price data for

a. a US corporation of your choice

b. GLD (gold etf)

c. ^GSPC (S&P 500 index)

Make sure the data are aligned and matched from earliest to most recent.

2. Run the Market Model regression for the corporation's returns (regression of returns on returns of the S&P 500 index). Interpret the R-square, intercept, and slope. What is the required rate of return for this stock (you will need the current T-bond yield for this)?

3. Run a regression of returns of GLD on returns of the S&P 500 index. Interpret the R-square, intercept, and slope.

Reference no: EM132125008

Questions Cloud

What is the probability that a randomly chosen applicant : What is the probability that a randomly chosen applicant has a graduate degree, given that they are female?

How these design elements encourage learning and transfer : Analyze how these design elements encourage learning and transfer.

How many categories are listed for analysis : How many categories are listed for analysis? What it the test statistic and what does it tell you about the probability?

Potential employee passing a training course : If you selected 15 potential employees and gave them the training course, what is the probability that more than 12 will pass the test?

What is the required rate of return for this stock : Set up an amortization schedule in Excel that caters to possible prepayments (or excess payments).

Which of the two sets of eggs is more likely to have a high : Suppose you select a set of 100 eggs at random in each station. Which of the two sets of eggs is more likely to have a high hatch rate?

American heart association publication circulation : According to an article in the American Heart Association's publication Circulation, 24% of patients who had been hospitalized for an acute myocardial

About the foreign corrupt practices act : What should the U.S. do about the Foreign Corrupt Practices Act?

What does moral imagination have in common with other types : Can you think of a time when you or someone whom you know used moral imagination? If so, what motivated you (or this individual) to use moral imagination?

User Account

All Pages