User Account

All Pages

Calculate excess returns for c and spy

Assignment Help Finance Basics
Reference no: EM133059869

You will estimate Citigroup's equity beta in this problem. You must follow the instructions carefully.

Step 1: Download historical data for Citigroup stock prices from Yahoo! Finance website.Visit the website finance.yahoo.com in a web browser. In the search box, enter ticker C for Citigroup stock. Click on tab for Historical Data. Change time period to January 1, 2016to January 2, 2021. Change Frequency to Monthly. Click "Apply" button. Then click link labeled "Download Data" to download a csv file.Similarly download historical prices for ticker SPY of an exchange traded fund on S&P 500, a proxy for market portfolio. Finally, download historical prices for ticker ˆIRX for short-termTreasury rate, a measure of risk-free rate (note the ˆ sign in front of IRX).

Step 2: You will use only two columns from each csv file: dates and adjusted close prices.Combine data in a single spreadsheet to keep one column of dates and three columns of adjusted prices. Calculate monthly returns for C and SPY by dividing each price by the pricein the previous month and subtracting one. For example, return in January 2016 is (Price at the beginning of February 2016 dividend by Price at the beginning of January 2016) - 1.

Step 3: Next calculate monthly risk-free rate. Divide each value of ˆIRX by 12 to convert from annual rate to monthly rate. Then divide by 100 because it is reported as a percentage. Specifically, a value of 0.6 for ˆIRX is converted to 0.6% = 0.006 per year = 0.006/12 =0.0005 per month.

Step 4: Then calculate excess returns for C and SPY. For this, subtract the previous month'smonthly risk-free rate that you just calculated. For example, the last monthly return is for the month of December 2020. It is calculated using the prices (for C or SPY) from Dec 1,2020 and Jan 1, 2021. To get excess return from this return, subtract the risk-free rate that you calculated in Step 4 for Dec 1, 2020. At the end of this step, you have 60 excess returnsfor C and 60 excess returns for the market (represented by SPY).

(a) Provide a scatter plot with Citigroup's monthly returns on vertical axis and market's(SPY's) monthly returns on horizontal axis.

(b) Estimate beta of Citigroup. You can use Excel's SLOPE function or LINEST functionor any other method or software.

You must provide both to get credit. Do not provide any other calculations or spreadsheets.

Reference no: EM133059869

Questions Cloud

Why you think adopting digital transformations is important : Efficient decision making plays a vital role in current business requirements. Discuss how technology contributes towards better decision making
What is the expected market return : The beta and expected return of one stock are 1.2 and 9.45%. What is the expected market return if the 91-day T-bill rate is 3.2%?
What is the firm current cost of equity : Ecolab Inc. sells chemicals and systems for cleaning, sanitizing, and maintenance. It reported earnings per share of $2.35 in 1993, and expected earnings growth
Customer service life cycle analysis : You should be familiar now with the different frameworks and analytical models to evaluate strategic IS initiatives. Customer service life cycle analysis.
Calculate excess returns for c and spy : You will estimate Citigroup's equity beta in this problem. You must follow the instructions carefully.
Compute the gross profit rate for November : Question - Wildhorse Company reported the following information for November and December 2022. Compute the gross profit rate for November
Experienced working for both male and female supervisor : During the course of your employment you may have experienced working for both a male and female supervisor.
Compute the 4 year forward interest rate : The CFO of Star Asset Management observes the current prices and characteristics of zero-coupon treasury bonds as summarized in the following table.
Why did the conflict escalate : Background and history that led to the conflict. How/why did the conflict escalate?

Reviews

Write a Review

Finance Basics Questions & Answers

  Receive a lump sum payment

In March 2014, Warren Buffett, one of the most successful investors and the CEO of Berkshire Hathaway Inc. offered $1 billion for the winner who has a perfect M

  Justify comment on the given statement

Please comment (and justify comment/answer) on the following statement: In finding the future value, simple interest gives answers close enough to compound.

  Encourage others to self-manage emotions

As a team member, what can an individual do to encourage others to self-manage their emotions?

  Calculate the npv of the homenet project assuming a cost

In September 2008, the IRS changed tax laws to allow banks to utilize the tax loss carryforwards of banks they acquire to shield their future income from taxes (prior law restricted the ability of acquirers to use these credits). Suppose Fargo Bank a..

  Difference in the effective annual rates charged

Partners Bank offers to lend you $50,000 at a nominal rate of 5.0%, simple interest, with interest paid quarterly. An offer to lend you the $50,000

  Analysis of loan demand

Analysis of loan demand from the lender's point of view using credit analysis the five Cs (5 Cs of credit analysis) as a guide in deciding whether to lend!

  What the highest price will be paid per share

ABC Ltd. is considering a takeover of XYZ Corp. ABC has 12 million shares outstanding with $45 per share. XYZ has 6 million shares outstanding which sell for $2

  What option should raymond choose to receive prize

Raymond has just won a lottery and he has been given the choice to receive the $1 million prize in one of the following ways:

  What is the expected npv of the project

If Vance's expected cost of capital is 0.19, what is the expected NPV of the project?

  Antiques lsquor us is a mature manufacturing firm the

antiques lsquor us is a mature manufacturing firm. the company just paid a dividend of 11.70 but management expects to

  Residual dividend policy

FarmCo, Inc. follows a policy of paying out cash dividends equal to the residual amount that remains after funding 40 percent of its planned capital expenditure

  Discussion of key statistics

Discussion of key statistics provided by sources like Yahoo finance

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