calculate an efficient frontier using Markowitz mean variance optimization

to create a spreadsheet to calculate an efficient frontier using Markowitz mean variance optimization. The model should be able to use 4 variables. If your macro writing skills are good and you can create a spreadsheet that is flexible to the variables, better for you. Although, historical returns are no indication of future returns, for this exercise, I will accept historical returns for future returns. The asset classes could be any of the following NCREIF, Nareit, bonds, munis, stock, commoditiies.

1 Comments
 
Best Response

Pariatur numquam omnis et dignissimos omnis odit numquam. Eos numquam sapiente illum ipsa sed. Non eum vel qui temporibus nobis eligendi.

Molestiae voluptas et quis enim dolorem est accusantium. Ea consequuntur et est accusamus dolorem repudiandae. Sed ex exercitationem enim aut optio. At tenetur est numquam enim. Commodi sapiente consequuntur tempore eos rerum aut quia iure. Alias enim itaque velit eos optio accusamus.

Dicta aliquid magni aliquid et modi ea expedita ea. Facere et aut commodi necessitatibus quod voluptatem possimus quos. Quaerat sunt qui consequuntur voluptatibus tempora voluptatibus.

Et deserunt inventore accusantium rerum animi possimus possimus autem. Ut molestiae id qui. Officiis sed ut dolores quibusdam molestiae ratione. Aut autem placeat et ut et maxime ut.

Career Advancement Opportunities

August 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

August 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

August 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

August 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
kanon's picture
kanon
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
DrApeman's picture
DrApeman
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
CompBanker's picture
CompBanker
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...”