Bloomberg Terminal Exercise

Chapters 7 & 8: CAPM, Beta & Market Efficiency

BF422 — Investments

Name: ________________________

Date: ________________________

Getting started: Log into a Bloomberg terminal on campus. Press HELP twice at any time for Bloomberg customer support. Use GO (green key) to execute commands.

Part 1: Finding Beta & Computing Expected Returns

1Look up beta for three stocks.

Type each ticker followed by Equity then BETA GO.

For example: AAPL Equity BETA

Use 2-year weekly returns against the S&P 500 (default settings).

StockTickerBeta (β)R² (%)
AppleAAPL
JPMorgan ChaseJPM
Johnson & JohnsonJNJ

2Find the current risk-free rate.

Type GT10 Govt GO to see the 10-year Treasury yield. Record the current yield.

rf =

For the market risk premium, use the historical average: E(rM) − rf ≈ 8%

3Compute CAPM expected returns.

Use the formula: E(ri) = rf + βi × 8%

StockBetaE(r) CalculationE(r) %
AAPL
JPM
JNJ

Part 2: Estimating Alpha

4Find actual 1-year returns.

For each stock, type AAPL Equity TRA GO (Total Return Analysis). Set the period to 1 year.

StockActual 1Y ReturnCAPM ExpectedAlpha (α)Over/Under/Fair?
AAPL
JPM
JNJ

5Interpret your findings.

Which stock had the highest alpha? Does positive alpha mean the stock is a guaranteed "buy"? What are the limitations of this analysis?

Part 3: Fama-French Factors & Anomalies

6Compare size and value characteristics.

For each stock, type AAPL Equity FA GO (Financial Analysis). Find:

StockMarket Cap ($B)Book Value/SharePrice/Book RatioSize: Large/Small?Value or Growth?
AAPL
JPM
JNJ
Value vs. Growth: High Price/Book (P/B > 3) → Growth stock. Low P/B (< 2) → Value stock. Fama-French predicts value stocks earn higher returns over time.

7Check recent factor performance.

Type FAMA GO or search "Fama French" on Bloomberg. Alternatively, type EQS GO and create screens for small-cap value vs. large-cap growth stocks.

Based on recent data, are the size and value premiums still positive?

Part 4: Market Efficiency Test

8Event study: Earnings announcement reaction.

Pick any stock. Type AAPL Equity ERN GO to see recent earnings announcements.

Find the most recent earnings surprise (actual vs. estimate). Then type GP GO and zoom in to the announcement date.

FieldYour Finding
Stock ticker
Earnings date
EPS estimate vs. actual
Stock price change on announcement day
Price change over next 5 days

9Assess market efficiency.

Based on your event study:

Reminder: One data point does not prove or disprove EMH. Professional research uses hundreds of events and statistical tests. This exercise is designed to familiarize you with the data and the logic, not to reach definitive conclusions.

Bloomberg Quick Reference

CommandFunctionExample
BETABeta analysis (regression)AAPL Equity BETA
TRATotal Return AnalysisAAPL Equity TRA
FAFinancial AnalysisAAPL Equity FA
GPGraph/Price ChartAAPL Equity GP
ERNEarnings AnalysisAAPL Equity ERN
GT10 Govt10-Year TreasuryGT10 Govt GO
EQSEquity ScreeningEQS GO