**How to calculate Beta of a stock using Excel**

If you go for an interview for the post of equity research analyst, you’ll face the question: “**How to calculate Beta value?”**

As an equity research analyst, you need to know how to calculate Beta of a stock. To find Beta of stocks, yo need two steps:

**1. Data collection:**

Here you’ll collect the closing price of the stock and the closing price of the benchmark index.

**2. Calculate stock Beta in Excel:**

In this step, you’ll understand how to calculate market Beta.

I’ve explained the first part (data collection) of the process How to Calculate Beta of a Stock Using Excel in the video below.

Watch Part -2. Have any queries? Write in ‘Comments’ below.

**Financial Modeling Investment Banking**Course (6 Weeks) starts on 26th October, 2015 and 10 Day Weekend Workshop starts on 17th October, 2015 in

**New Delhi, India**.

Only few seats remain. Interested candidates can contact me.

Chandresh says

Hi,

video uploaded for ‘how to calculate beta of stock using excel’ does not describe it completely.

kindly uplaod full video.

Avadhut says

Hi Chandresh,

What you watched was the first part, here’s the second part – http://www.financewalk.com/2013/calculate-beta-stock-excel-part-2/