Silver Price Forecast Game — Student IDs Only (click to expand)
Target date: 4/15/26. Guess the silver spot price ($/oz) on that date.
The closest guess earns +5 extra points. Posted as Student ID only (no names).
If there is a tie, all tied students receive the extra points.
Match units: if the rate is monthly, then n is months and cash flows are monthly.
2) Single cash flow formulas
FV:FV = PV(1+r)^n
PV:PV = FV/(1+r)^n
n:n = ln(FV/PV)/ln(1+r)
r:r = (FV/PV)^(1/n) − 1
3) Annuities (equal payments)
Ordinary annuity (payments at end): Excel type=0
Annuity due (payments at beginning): Excel type=1
Key Excel:PMT, PV, FV, NPER, RATE
4) Excel TVM functions (ABS if you want positive answers)
Goal
Excel
Typical inputs
Future value
=ABS(FV(rate,nper,pmt,pv,[type]))
rate, nper, pmt, pv
Present value
=ABS(PV(rate,nper,pmt,fv,[type]))
rate, nper, pmt, fv
Payment
=ABS(PMT(rate,nper,pv,fv,[type]))
rate, nper, pv, fv
Rate
=RATE(nper,pmt,pv,fv,[type])
nper, pmt, pv, fv
Number of periods
=NPER(rate,pmt,pv,fv,[type])
rate, pmt, pv, fv
Sign rule: Excel treats money you pay out as negative and money you receive as positive.
If your answer shows up negative, your signs are probably inconsistent (or use ABS() for presentation).
5) APR vs EAR
APR is nominal annual rate. Monthly periodic rate is APR/12.
EAR includes compounding: EAR = (1+APR/m)^m − 1.
Excel:=EFFECT(APR,m) and =NOMINAL(EAR,m)
6) NPV / NFV quick rule
NPV() assumes the first cash flow is at t=1. If there is a time-0 cash flow, add it separately.
Example:=-100 + NPV(0.10,40,40,40)
NFV: compute PV first, then compound: FV(rate,n,0,-PV,0)
Common mistakes:
(1) Using APR as the periodic rate,
(2) mixing months/years,
(3) forgetting type=1 for annuity due,
(4) putting time-0 cash flow inside NPV().
Ch 3–4 Lab • Financial Statements + Ratios (One Lab for Both Chapters)
This lab combines Chapter 3 (IS/BS/CF) + Chapter 4 (ratio analysis). Bring your calculator and be ready to build the statements first, then compute ratios.
Suppose you already own Apple and want to add another stock.
If Apple and Walmart have a relatively low correlation (assume about 0.11), combining them can reduce portfolio volatility more than combining Apple with another stock that moves very similarly to Apple.
Why Walmart? Different business model / demand drivers can help reduce co-movement.
That does not guarantee higher return, but it can improve the portfolio’s risk-return tradeoff.
Practical idea: Start with the stock you already have (e.g., Apple), then look for a second stock with solid fundamentals and lower correlation rather than just chasing another high-return stock.
7) Systematic vs. unsystematic risk
Unsystematic risk (firm-specific risk): company events (lawsuits, management issues, product failures). This risk can be reduced by diversification.
Systematic risk (market risk): economy-wide risk (interest rates, recessions, inflation, market shocks). This risk cannot be diversified away.
CAPM focuses on systematic risk.
8) Beta (β): the CAPM risk measure
Beta measures systematic (market) risk, not total risk.
β = 1.0: same market sensitivity as the market.
β > 1.0: more sensitive than the market (higher systematic risk).
β < 1.0: less sensitive than the market (lower systematic risk).
β = 0: no market sensitivity (theoretical benchmark).
β < 0: moves opposite the market (rare, but possible for hedging-type assets).
9) CAPM formula (required return)
CAPM:R̂ = Rf + β ( Rm − Rf )
Rf = risk-free rate
Rm = expected market return
(Rm − Rf) = market risk premium (MRP)
R̂ = required return (or cost of equity estimate in many applications)
Interpretation: A higher beta means a larger risk premium above the risk-free rate, so CAPM gives a higher required return.
10) Security Market Line (SML)
The SML is the graph of CAPM required return versus beta.
Y-axis: required return
X-axis: beta
Intercept:Rf
Slope:(Rm − Rf) (market risk premium)
Change
What happens to SML?
Risk-free rate increases (MRP unchanged)
SML shifts upward in parallel (same slope)
Market risk premium increases
SML gets steeper (larger slope)
11) Using the Chapter 6 calculators (JUFinance)
One-Stock Return/Risk Calculator: use for expected return, variance, and SD of a single stock.
Two-Stock Portfolio Calculator: test different weights and correlation assumptions to see diversification effects.
CAPM Calculator: compute required return using risk-free rate, beta, and market return (or market risk premium).
12) Common mistakes (watch these on quizzes/exams)
Using % values incorrectly (e.g., entering 12 instead of 0.12 in formulas/calculators).
Confusing expected return with standard deviation.
Assuming portfolio SD is a simple weighted average.
Forgetting correlation/covariance in two-stock portfolio risk.