Looking for help in calculating Sharpe

Hi all, I'm an intern at a fund and I'm trying to calculate the sharpe ratio for a hypothetical portfolio consisting of 3 different ETFs. I'm using excel and coming up with a sharpe of 0.06, which seems extremely low - most likely due to incorrect calculations or using wrong numbers. Would anyone be able to help me with this?

Thanks in advance!

Here is how I did it (formulas) - I am unable to post links. 1. Cumulative return of ETF: =(latest price (July 2020)- initial price (Jan 2015))/initial price (Jan 2015) 2. Annualized return of one ETF: =(1 + cumulative return)^(12/61)-1 [61 is the # months of data used] 3. Overall portfolio annualized return - I first found the weighted annualized return: =weight x annualized return then I sum it together to find portfolio return: =sum(weighted annualized return) 4. Standard deviation, using daily return (=(today's price - yesterday's price)/yesterday's price), then to find monthly returns: =STDEVA(returns column) 5. Correlation: =CORREL(price column of ETF A, price column of ETF B) 6. I found the formula for a three-asset portfolio standard deviation online, which consists of 2 parts: First part: Sum of weights squared multiplied by standard deviations of each ETF squared Second part: Sum of 2 x (weight of A) x (weight of B) x (correlation between A and B) x (Std dev of A) x (Std dev of B) Taking the square root of the sum of both parts gives the standard deviation. 7. Sharpe Ratio: (annualized return - risk free rate (0.13))/annualized standard deviation

1 Comments
 
Most Helpful

Cum quibusdam vel ab. Optio necessitatibus id voluptatem repellendus. Facere illo commodi maxime iusto amet deserunt.

Career Advancement Opportunities

September 2026 Hedge Fund

  • Point72 99.0%
  • D.E. Shaw 98.0%
  • Citadel Investment Group 97.0%
  • AQR Capital Management 96.0%
  • Magnetar Capital 95.0%

Overall Employee Satisfaction

September 2026 Hedge Fund

  • Magnetar Capital 99.0%
  • D.E. Shaw 98.0%
  • Blackstone Group 97.0%
  • Citadel Investment Group 96.0%
  • Two Sigma Investments 94.9%

Professional Growth Opportunities

September 2026 Hedge Fund

  • AQR Capital Management 99.0%
  • Point72 98.0%
  • D.E. Shaw 97.1%
  • Citadel Investment Group 96.1%
  • Magnetar Capital 95.1%

Total Avg Compensation

September 2026 Hedge Fund

  • Portfolio Manager (9) $1,648
  • Vice President (27) $464
  • Director/MD (11) $372
  • NA (9) $320
  • Engineer/Quant (83) $287
  • 3rd+ Year Associate (26) $284
  • Manager (4) $282
  • 2nd Year Associate (32) $253
  • 1st Year Associate (76) $193
  • Analysts (234) $178
  • Intern/Summer Associate (29) $145
  • Junior Trader (5) $102
  • Intern/Summer Analyst (276) $95
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
DrApeman's picture
DrApeman
98.9
6
dosk17's picture
dosk17
98.9
7
CompBanker's picture
CompBanker
98.9
8
GameTheory's picture
GameTheory
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
bolo up's picture
bolo up
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”