Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use Delta Airlines and General Electric - estimate the cost of equity using the Capital Asset Pricing Model (CAPM). Here is the formula: RS =

Use Delta Airlines and General Electric - estimate the cost of equity using the Capital Asset Pricing Model (CAPM). Here is the formula: RS = RF + Beta (RM-RF).

So, you need to collect or calculate RM and RF to and beta of your stocks to estimate Rs. How to get RM and RF to and beta? Go to Yahoo Finance or Google Finance and find Beta for your stocks. S&P 500 index is a good proxy for return on the market (RM).

To find RM, go to Yahoo!Finance to get the monthly close price of S&P 500 Index for the last 30 years (January 1, 1985 to December 31, 2014) , click on this link (http://finance.yahoo.com/q/hp?s=%5EGSPC+Historical+Prices (Links to an external site.) ), which will take you to historical price of S&P 500 index. Then click on historical price, change the start date and end date, select monthly and then click on get price. If you scroll down you will see download to spreadsheet.

Once you download the data, just leave date and adjusted close price.

Then calculate monthly return using adjusted close price of S&P 500 index and calculate average return using average function in Excel.

You can use the average return as RM. To find RF go to Federal Reserve Website ( http://www.federalreserve.gov/releases/h15/data.htm (Links to an external site.) ) and get Treasury constant maturities 7-year monthly rates for the last 30 years (January 1, 1985 to December 31, 2014).

Download the monthly rates and calculate the average rate using average function in excel. You can use the average rates on Treasury as RF.

Now you have RM, RF and Beta.

Put them in the following formula to get RS for your companies: RS = RF + Beta (RM-RF).

EXPLAIN ANSWER AND SHOW YOUR WORK

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Banker To The World

Authors: William Rhodes

1st Edition

0071704256, 978-0071704250

More Books

Students also viewed these Finance questions

Question

1. Describe the types of power that effective leaders employ

Answered: 1 week ago