This dataset contains stock betas, 10-year government bond yields, market returns, and CAPM expected return calculations for Microsoft, Apple, Cisco Systems, Alphabet, and Johnson & Johnson.

Published: 15 September 2026| Version 1 | DOI: 10.17632/b6ywhpnj9z.1
Contributor:
Musarat Alam

Description

This dataset contains stock betas, 10-year government bond yields, market returns, and CAPM expected return calculations for Microsoft, Apple, Cisco Systems, Alphabet, and Johnson & Johnson.

Files

Steps to reproduce

Collect 10-year Treasury bond yields as the risk-free rate, stock betas from Yahoo Finance, and market return indices. Input these values into the CAPM formula: Expected Return = Risk-Free Rate + Beta * (Market Return - Risk-Free Rate) using Microsoft Excel.

Institutions

Categories

Economics, Finance, Corporate Finance, Stock Market Valuation, Capital Asset Price Model

Licence