Once you are in the main page of Yahoo finance for tmobile, click onHistorical Datatab.

- Specify theTime Period: From May 31, 2017 to June 29, 2020and Frequency MonthlyforShow: historical pricesand pressapply.

- Once you download the data, obtain only the values from the Adj Close** column and paste them to a separate blank column in Excel.

- These values stand for adjusted closing price. To estimate return, you need to estimate the following:

Rt=(pt- pt-1)/(pt-1)

ORyou may choose to estimate the log returns instead:

rt=ln(pt/pt-1)

- Repeat the same steps above to obtain the market returns forS&P 500 (^GSPC).

- Obtain risk-free rate that will also be needed for the regressions.

The steps to get the 1-month T bill return are as follows:

1- Go to the link below:

https://mba.tuck.dartmouth.edu/pages/faculty/ken.french/data_library.html(Links to an external site.)

2- Click on the CSV link of the Fama/French 3 Factors as shown in the screenshothere.

3- Obtain the last Rf column for the needed time interval.

4- Make sure you have two main columns of data: (1) firm return minus Rf and (2) market return minus Rf.

Please follow these last steps to estimate your betas:

- Click on Data Analysis in the Data tab in Excel.

- Choose Regression.

- In the Regression box you should specify the dependent (Y) and independent (X) variables.

Y=Firm-excess return

X=Market-excess return

- Once you click Ok, you will be able to see the generated output table and a graph plotting the data.

- Slope coefficient of your graph is the Beta estimate. It also appears in the results' table.

- To double check, you may use the slope function in Excel. Y and X variables are still as defined above.

- Compare your Beta estimate to the one available in Yahoo Finance.