Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

H3

Factor Models

Unless stated otherwise, round your answers to three decimals, and do not round intermediate calculations.

Fama-French Three-Factor Model.

In this problem, you will analyze the risk-factors associated with some stocks in your portfolio. To limit the amount of work, consider only the three largest holdings in your portfolio by market value.

Download the Excel spreadsheet. The file contains the monthly
excess returns in percent for a wide range of stocks and for QQQ (Nasdaq ETF), IWM (Russell ETF), and MCHI (China ETF). Additionally, the file contains the time series
ExcMkt,
SMB,
and
HML, representing the excess market return, the small-minus-big return, and the high-minus-low return – these are the factors of the Fama-French Three-Factor model.

Since not all companies are going to be available in the Excel file, we cannot use them for our analysis. Please research the QQQ, IWM, and MCHI ETFs to see if you can use them as a replacement for missing stocks. For example, Alibaba (BABA) has not been listed for the entire time period we will study. However, MCHI can serve as a decent albeit not perfect replacement in your analysis. (If none of these fit, do not use the stock and instead include your next-largest holding.)

With your three largest positions and the data from the Excel file, solve the following problems:

a) Calculate using the single-factor model.

b) Estimate their risk (systematic and firm-specific) according to the single-factor model.

c) Calculate the weights of the stocks in your portfolio. Remember, stocks you’re selling short have negative weights, and the weights need to sum up to one.

d) Produce a return time series for your portfolio of the largest three stocks, using . Estimate your portfolio’s sensitivity to Fama-French’s three factors, that is, run the regression

Remember: is a proxy to how much market risk your portfolio carries; is your exposure to small over big firms; is your exposure to firms with a high book value compared to their market capitalization. These three betas are assumed to be non-diversifiable risk factors, and in the long run investors should be rewarded for their risk of having greater betas.

e) Analyze your results. This includes, but is not limited to: classifying your portfolio in terms of aggressiveness, small vs large cap, value vs growth; identifying which of your holdings potentially contribute to the portfolio classification how; going back to your portfolio philosophy statement and discussing if your holdings reflect your investment goal; using the expected values of to compute the expected return of your portfolio in the coming month.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Econ Excel Project $25

Please see instructions and excel spreadsheet attached . $25 is all i have. Cannot increase. Excel spread sheet attached Academic major upon graduation: Health Information Management Instructions Follow the steps below.  1.   You need to prepare a 12-month Cash Budget for yourself. Use the excel template attached. 2.    To do this, you

Graduate diploma management

STUDENT VERSION LEAD STRATEGIC TRANSFORMATION BSBLDR811 PROJECT PORTFOLIO Student name: Assessor: Date: Business this assessment is based on: Documents reviewed: Section 1: Preparation Provide an overview of the current situation facing the business including: The organisational mission, purpose and values Analysis of the company’s organisational objectives and identification of strategic

Graduate diploma in management

TAELED803 IMPLEMENT IMPROVED LEARNING PRACTICE PROJECT PORTFOLIO Student name: Assessor: Date: Organisation you are basing this project on: Relevant qualification, skill set or unit: Section 1: Evaluation and planning Describe the organisation and the course you are basing this project on. Describe the cohort of learners you are basing this

Slides

1. Please read the attachment 2. Create a slideshow. Less than 5 minutes.    Introduction Company Profile A leading nonprofit healthcare organization in the US, Kaiser Permanente integrates health insurance, hospitals, and medical groups into a unified system. The company was founded in 1945 by businessman Henry J. Kaiser and

Case Study 2

Follow all instruction and rubric.  This is a 3 part assignment. First case study is completed and i have attached for your reference. 

Economy

Follow the steps below.  1.   You need to prepare a 12-month Cash Budget for yourself. Use the excel template attached. Personal budget Spring 2023 (1) (1).xlsx 2.    To do this, you need to find the starting salary for your academic major upon graduation. Use the average starting salary for a job that

Case Study 2

BUSI 690 Case Study: Historical Financial Analysis Assignment Instructions Overview Complete a case study of ABC Corporation. You will find the case in the case section of the text. A formal, in-depth case study analysis requires you to utilize the entire strategic management process. Assume you are a consult asked

Week 2 Discussion- Delivery of Healthcare

   Value-Based Care Posting Information for This Discussion To prepare for your Week 3 Assignment, in this week’s Discussion, you will focus on your current understanding of value-based care delivery in the United States. Based on your understanding, you will then analyze the rationale for the shift from pay for

Economy

Follow the steps below.  1.   You need to prepare a 12-month Cash Budget for yourself. Use the excel template attached. Personal budget Spring 2023 (1) (1).xlsx 2.    To do this, you need to find the starting salary for your academic major upon graduation. Use the average starting salary for a job that

Tourism Presentation & Report

Create a PowerPoint presentation including all the data from the attachments. Use visuals and easy-to-read charts. Add a more detailed recommendation section to the report. 

Business & Finance HOMEWORK

Required Course Textbook(s) · Introduction to Information Systems, 5th Edition By: Wallace, Patricia ISBN: 978-0-13-791844-7

W5

Course Project: Source Selection Criteria Instructions This week, you are required to produce your Source Selection Criteria deliverable. The Source Selection Criteria is a required deliverable to define how the evaluation of each response will be executed. Typically, evaluations are executed following multiple considerations, including (1) demonstrated competence, (2) compliance,

week 4 pj

 U.S. manufacturing over the last half century  Course Objectives: Students will apply international business theories and concepts to a various multinational organization. Questions: 1. Reflect on the changes in U.S. manufacturing over the last half century. Why did the United States lose so many jobs? 2. What impact did that job loss

MBA510 Week One Discussion Post 2. Please answer the discussion post in 250 min

Instructions How might companies incorporate AI into their value chain to improve operating efficiencies? Length: 250-400 words  Contributions must display original thinking and good knowledge of the subject matter, including links and references to sources to support your arguments. Additionally, make sure you cite sources you reference in-text and under a

MBA510 Week One Discussion Post 1. Please answer the discussion post in 250 min

Instructions · How do you think business structures might change in a world with AI? Length: 250-400 words  Contributions must display original thinking and good knowledge of the subject matter, including links and references to sources to support your arguments. Additionally, make sure you cite sources you reference in-text and under