So I have excess returns, all the coefficients needed (hi, bi, si), as well as the risk free rate, SMB number, and HML number. I have 39 companies (and I have their returns and standard deviations). These 39 need to be in a portfolio, and I'm supposed to find out how the portfolio weight of each company. Also Its factor sensitivity to HML is at least 0.48. Its factor sensitivity to SMB is at least 0.02. Its factor sensitivity to the broad market is equal to 1. It is risk-efficient, that is, it has minimal risk coming from firm-specific events How the hell do I do this????? I've been googling around forever. It seems like I actually don't need to do any of the regressions because I already have all the information that I need from them. ANY help would be amazing
Trending Content - Investment Banking Forum
| +166 | Investment Banks Ranked By Your Divorced Blue Collared Uncle | 17 | 54m |
| +156 | Think Twice before Recruiting for HOUSTON IB!! | 65 | 2d |
| +136 | UBS Exits 2026 | 37 | 7h |
| +57 | Congrats on the ROs. I Still Don’t Know Which One You Were | 8 | 5h |
| +40 | Mid-Level UBS Departure for another BB (Grass Isn’t Greener…) | 31 | 3d |
| +39 | Did not get a return offer due to headcount, but happy to move on. | 8 | 16h |
| +37 | IB RO Discussion | 6 | 3d |
| +32 | GS - Low Bonus | 23 | 22h |
| +29 | Lied about bonus to future employer | 16 | 4h |
| +28 | Early VP promo timeline | 15 | 1d |
Career Resources
help please :(
Did you get a response by chance?
Yes, my groupmate figured it out. Basically you just use excel solver, with the assumptions I have above written in. Then you minimize for risk / maximize for return, and bam! solver outputs your portfolio weights
Do you think you can help me out? I think we're doing the same assignment, I'm still unsure how to input all of the data in solver
I haven't taken OM in university so I have no idea how to use solver yet. I just observed what my group mate did. I suggest youtubing how to use excel solver, it didn't seem too hard.
Okay thank you. Did you happen to have to derive the risk free rate? for each security? or just from the market risk premium that was given?
Factor models will not give you weightings. This is something you will need to come up with yourself.
For example, you can simply choose to equally weight your portfolio, or value-weight your portfolio (e.g. market cap of stock 1 / sum of all your portfolio stocks market caps).
Quaerat maxime magni exercitationem tenetur autem repudiandae vero. Et et numquam non corporis facilis quibusdam. Autem aut odit ut ut eum nostrum quibusdam.
Sint facilis non quia nihil non fugiat illo. Minus sapiente pariatur alias nihil magni. Corporis et aspernatur et aut autem qui. Qui non omnis nulla nobis qui. Aliquid provident est rerum dolore veritatis. Distinctio suscipit mollitia sunt repellendus dolores molestiae numquam nihil.
Sunt labore consequatur nihil voluptatum. Repudiandae quis sed provident ratione distinctio eum expedita. Impedit suscipit consequatur expedita ut a rerum et. Id deleniti est soluta. Praesentium vitae veritatis amet vel voluptatum enim. Magni est aut molestiae.
Qui nihil rerum optio doloribus sint. Totam dolorem voluptatem recusandae culpa. Soluta vel inventore maiores omnis pariatur. Quis culpa voluptatum id consectetur aut. Quod quo odio officia enim distinctio et. Exercitationem inventore in aut blanditiis nihil ab facilis. Dolore tempore aliquam ipsa.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...