Run a regression estimating the alpha and beta for capm

Assignment Help Financial Econometrics

Reference no: EM132523569

Read THE FOLLOWING BELLOW and do the homework make a new EXCEL SPREADSHEET: The attached spreadsheet has 60 monthly returns for January 2013 through December 2017.

Column C - returns for MSFT

Column E - returns for AAPL

Column G - returns for BA

Column I - returns for PFE

Column J - returns for RMRF

Column K - returns for SMB

Column L - returns for HML

Using the data in the attached spreadsheet, pick ONE of the four stocks (Microsoft, Apple, Boeing, or Pfizer), and run a regression estimating the alpha and beta for CAPM and run a second regression estimating the alpha and three betas for FFTFM.

Attachment:- Homework Monthly returns for CAPM.rar

Reference no: EM132523569

Questions Cloud

Should the company sell product xy as is or process : The company could incur further processing costs of $8 per unit and sell the resulting product. Should the company sell Product XY as is or process?

Discuss on federated systems : Discuss on federated systems. Use at least three sources. Include total of 3 quotes in each paragraph from your sources enclosed in quotation marks

Which project should the company select and why : Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the same start-up costs. Project A will produce annual cash flows

Find how would the costs be considered in product costing : Manufacturing costs, What specific types of SG&A costs would the company incur? How would these costs be considered in product costing?

Run a regression estimating the alpha and beta for capm : Run a regression estimating the alpha and beta for CAPM and run a second regression estimating the alpha and three betas for FFTFM.

Calculate the static budget variance : Calculate the Static Budget Variance. You must correctly identify the amount of the variances and if they are F (favorable) or U (unfavorable).

Current fair price of stock according to capm : Stock A is expected to pay a dividend of $2 at the end of this year, and its expected end-of-year price is $40. If the stock's beta is 0.9, market risk premium

Determine the ending balance due use the US Rule : After 70 days, Shawn paid $3,700 on the note. On day 115, Shawn paid an additional $5,700. Use ordinary interest. Determine the ending balance due use US Rule

Find the cash flows in post-depreciation of sf : Consider a Swiss subsidiary (Swiss AS) of a US firm, Kendall Systems.

Reviews

len2523569

5/23/2020 12:05:29 AM

PLEASE DO "Homework excel file" read THE FOLLOWING BELLOW and do the homework make a new EXCEL SPREADSHEET: The attached spreadsheet has 60 monthly returns for next month through prior month Please I need this homework to be done by next week night eastern time.

Write a Review

Required(*) Message

Financial Econometrics Questions & Answers

A project report on banking system

The objective of this business report is to focus upon evaluating the current portfolio of Baituna home loans product of Bank Muscat and its volumes. It focus upon the current standing of the product in Oman and its performance on the basis of its vo..

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

User Account

All Pages