Week 6 — Chapter 13: Risk & Return

Compute expected return, variance/standard deviation, covariance/correlation, portfolio risk, CAPM expected return, and holding period return. Includes mini-calculators and course exercises.

Theme: MBA • FIN509

Intro

We model returns with probabilities (states) or time series. Key objects:

  • E[R] = Σ piRi
  • Var(R) = Σ pi(Ri−E[R])²; σ = √Var
  • Cov(R1,R2) = Σ pi(R1i−E[R1])(R2i−E[R2])
  • ρ = Cov / (σ₁σ₂)
  • Portfolio: E[Rp] = w₁E[R₁]+w₂E[R₂]; Var(Rp) = w₁²σ₁² + w₂²σ₂² + 2w₁w₂Cov
  • CAPM: E[Ri] = Rf + βi(E[Rm]−Rf)

Single Stock — Expected Return & Standard Deviation

Enter states as CSV. Example probs: 0.1,0.2,0.4,0.2,0.1; returns (%): -30,-2,10,18,40
E[R]:
Var:
σ:

Two-Stock Portfolio — E[R], σ, Covariance & Correlation

Enter the same state probabilities; returns (%) for Stock 1 and 2; choose weights w₁, w₂ (w₂ auto = 1−w₁).
0.50
E[R₁], σ₁:
E[R₂], σ₂:
Cov(1,2):
ρ(1,2):
E[Rp]:
σp:

CAPM — Expected Return

E[R] (CAPM):
Formula: E[R]=Rf + β (E[Rm] − Rf)

Holding Period Return (HPR)

HPR:
Formula: HPR = (P₁ − P₀ + D) / P₀

Exercises — Preload Buttons

Stock A (states)

E[R] ≈ 8.2%, σ ≈ 16.98%.

Stocks A & B

Cov ≈ −0.54% (−0.0054), ρ ≈ −0.93 with the given inputs.

For data pulls in Sheets: =GOOGLEFINANCE("NVDA","close",DATE(2020,7,31),DATE(2025,7,31)) then month-end filter. Market proxy: "INDEXSP:.INX".

Homework (Due with Final) — Quick Helpers

Q1 — Discrete States (Answer: 9%)

Probs: 0.25, 0.50, 0.25; Returns (%): 30, 12, −18

Q2 — CAPM (Answer: 12%)

Rf=7, MRP=5, β=1 ⇒ set E[Rm]=12.

Q3 — Portfolio β (Answer: 0.988)

Use value weights × betas; sum.

Q4 — Target Return via β (Answer: 1.76)

Solve for βnew given mix and target E[R].

Q5 — Stock A (states)

E[R]=8.2%, Var≈0.02884, σ≈16.98%.

Q6 — Market Risk Premium (Answer: 11%)

MRP = E[Rm] − Rf.

Q7, Q9–Q12

Weighted averages of returns or betas as specified.

Quick Quiz

Click to check answers.

Resources

Note: Classroom calculators are for instruction; verify key numbers in Excel or approved tools when grading.