Skip to content
Ti
← All Projects

APPLIED FINANCE LAB / 02

Investment Portfolio & Risk Analysis

Risk-return and diversification analysis across a sample five-asset portfolio.

Risk & ReturnDiversificationSharpe Ratio

SNAPSHOT — AS OF SEPTEMBER 2026

10.53%

Sample Portfolio Return

14.48%

Simplified Weighted Risk Estimate

0.45

Simplified Risk-Adjusted Return Estimate

Question / Objective

Compare the historical risk and return profile of five common asset classes, then evaluate how a sample diversified portfolio built from them would have performed on a risk-adjusted basis — a foundational exercise in modern portfolio theory.

Course-Concept Connection

  • Investment Principles
  • FIN 3033 — Principles of Investment
  • FIN 4423 — Investment Portfolio Management

Data Sources

Methodology

  1. 1.Collected 5-year annualized return and standard deviation for four ETFs representing distinct asset classes: SPY (U.S. large-cap equity), QQQ (U.S. tech-heavy equity), VXUS (international equity), and GLD (gold).
  2. 2.Sourced AGG (U.S. investment-grade bonds) risk/return data from its official issuer fact sheet, using the 5-year annualized NAV return and the 3-year standard deviation (AGG's 5-year standard deviation was not available from the same source as the other four assets — see Limitations).
  3. 3.Calculated each asset's Sharpe ratio using the current 3-month Treasury bill rate as the risk-free rate proxy.
  4. 4.Built a sample diversified portfolio (40% SPY / 15% QQQ / 15% VXUS / 20% AGG / 10% GLD) and computed its weighted-average return and a naive weighted-average risk figure.
  5. 5.Compared the sample portfolio's risk-adjusted return against a single-asset (SPY-only) benchmark.

Assumptions

  • The sample 40/15/15/20/10 portfolio weighting is illustrative, chosen to represent a moderate-growth allocation — it is not a personalized or optimized allocation for any individual investor.
  • Because asset correlation data wasn't available from these sources, the portfolio's risk is shown as a weighted average of individual asset standard deviations. This is a simplification: true portfolio volatility is normally lower than this figure, since diversification benefits (imperfect correlation between assets) reduce combined risk below a simple weighted average.
  • AGG's return (5-year window) and standard deviation (3-year window) come from slightly different measurement periods, which affects comparability with the other four assets.

Analysis

Risk vs. Return, 5-Year Annualized

X-axis: standard deviation (risk). Y-axis: annualized return. *AGG's standard deviation is a 3-year figure (see limitations).

Standard Deviation (%)Annualized Return (%)SPYQQQVXUSGLDAGG*
Risk vs. Return, 5-Year Annualized — data table
AssetStandard Deviation (%)Annualized Return (%)
SPY15.74%12.70%
QQQ20.91%14.22%
VXUS15.09%9.16%
GLD16.78%19.20%
AGG*5.51%0.09%

Sharpe Ratios (Risk-Free Rate: 3.97%, 3-mo T-bill)

Asset5Y ReturnStd DevSharpe Ratio
SPY12.70%15.74%0.58
QQQ14.22%20.91%0.51
VXUS9.16%15.09%0.37
GLD19.20%16.78%0.93
AGG*0.09%5.51%n/a

Sample Diversified Portfolio

40% SPY · 15% QQQ · 15% VXUS · 20% AGG · 10% GLD

WEIGHTED RETURN

10.53%

SIMPLIFIED WEIGHTED RISK ESTIMATE

14.48%

SIMPLIFIED RISK-ADJUSTED RETURN ESTIMATE

0.45

This “simplified” risk figure is a weighted average of individual asset standard deviations, not a true correlation-adjusted portfolio standard deviation — real diversification would likely lower actual portfolio risk below this estimate. See Limitations.

Key Findings

  • Gold (GLD) posted the strongest 5-year risk-adjusted return of the group (Sharpe ≈0.93), reflecting a strong five-year run; GLD also carried a standard deviation in the same range as U.S. equities.
  • Bonds (AGG) delivered a strikingly low 5-year annualized return (0.09%) — a direct result of the 2022 rate-driven bond selloff (AGG fell 13.06% that calendar year per its fact sheet), illustrating interest rate risk in fixed income even for high-quality, investment-grade holdings.
  • The sample diversified portfolio's naive weighted-average return was about 10.5% with a naive weighted-average risk of about 14.5% (Sharpe ≈0.45) — lower than SPY alone on this simplified basis, which is expected: true diversification would likely improve this figure, since the naive calculation ignores the risk-reducing effect of imperfect correlation between asset classes.
  • QQQ delivered the highest raw return (14.2%) among the four ETF-sourced assets but also the highest standard deviation (20.9%), consistent with its concentrated, growth-heavy composition.

Limitations

  • Risk/return figures are drawn from third-party ETF data providers, not computed from raw daily price data, and cover slightly different exact date ranges across sources.
  • The portfolio risk calculation is a simplified weighted average, not a true covariance-based portfolio standard deviation — it should be read as a rough upper bound on risk, not a precise figure.
  • This is an educational analysis only. It is not investment advice, and the sample portfolio is not a recommendation to buy, sell, or hold any security.
Tools used: Risk-return analysis, Sharpe ratio, Portfolio weightingLast updated: September 2026

This independent analysis was developed for portfolio demonstration using concepts from Tazreen Islam's Finance education at UTSA. It is not an original course submission and is not investment advice or a recommendation to buy or sell any security.

AI-assisted workflow: AI tools were used to support research, model development, coding, and validation. Source data, assumptions, calculations, and conclusions were reviewed against underlying sources before publication.