Question

How to calculate company's beta when balance sheet given?

Answer 1

To calculate beta in Excel:

Download historical security prices for the asset whose beta you want to measure.

Download historical security prices for the comparison benchmark.

Calculate the percent change period to period for both the asset and the benchmark.