Excess Return Calculator: Benchmark or CAPM
Use a supplied beta in a CAPM comparison of expected and observed returns.
Paste paired asset and benchmark returns for the same dates to estimate historical beta. The result measures past co-movement and does not forecast future risk.
Beta describes how an asset's returns moved alongside a benchmark in the observations you supply. It is a regression slope, not the asset's own volatility or the probability that its price will fall.
Only paired periods are meaningful. Prepare matching dates and return intervals before pasting; the calculator does not download or repair missing market data.
Each observation is compared with its series mean. This removes the average level before measuring whether the asset and benchmark deviate together.
The sum of paired deviations is divided by the benchmark's squared deviations. A benchmark with no variation cannot identify a slope, even if the asset varies.
Sample inputs demonstrate the method. They are not a forecast or product offer.
In the first example, asset returns of 2%, 4% and 6% accompany benchmark returns of 1%, 2% and 3%. Every asset deviation is twice the corresponding benchmark deviation, so the fitted beta is 2.
Sample inputs demonstrate the method. They are not a forecast or product offer.
A beta above one indicates a larger fitted response to benchmark changes in this dataset. A negative beta indicates an opposite fitted direction, not a guaranteed hedge.
The reported intercept is the fitted return when the benchmark return is zero for one observation period. Neither the slope nor intercept becomes an annual forecast merely because dates were entered.
Estimate historical beta from paired asset and benchmark returns for the same dates.
Historical co-movement is not a forecast of future risk.
Read our calculation and testing approach.