Beta Calculation Worksheet

Compute the Beta needed for your CAPM as to calculate the expected return of a company's share

betacapital asset pricing modelcapmcovariance formulafinanceregression analysisslope methodvariance

Description
Step by Step Excel Template to calculate the CAPM Beta (Capital Asset Pricing Model) of MakeMyTrip. You can use this template to find Beta for other companies as well.

What is a CAPM Beta?

"Beta is a measure of the volatility, or systematic risk, of a security or a portfolio in comparison to the market as a whole. Beta is used in the capital asset pricing model (CAPM), a model that calculates the expected return of an asset based on its beta and expected market returns." (Investopedia)

This business tool includes
1 Excel Model

Dheeraj Vaidya, CFA, FRM offers you this business tool for free!

Download for free

Ask a question

Reviews

Any questions on Beta Calculation Worksheet?

The user community and author are here to help. Go ahead!

please wait...