Hi guys, I've attached a simple Excel file. Within it, there are two pages, one which contains calculations for asset class weights, total returns and portfolio returns and the other contains the data I made up. My question is simply, how does one appropriately calculate the total return of each asset class? Cheers
| Attachment | Size |
|---|---|
| Question for WS Oasis.xls 24 KB | 24 KB |
| +38 | Strategy to asset allocation | 10 | 1w |
| +28 | Q&A | Research Associate, Long-Only | (0 years in DCM/IB/consulting) | 6 | 2d |
| +9 | Working for Endowment? | 5 | 1d |
| +9 | WAMCO - Ken Leech | 2 | 3w |
| +9 | Rising sophomore trying to pivot to finance | 2 | 2w |
| +9 | Best/Worst Experience in the Industry | 1 | 4w |
| +8 | Bridgepoint Acq Kayne Anderson RE | 2 | 6d |
| +6 | Goldman Sachs Operations? | 1 | 6d |
| +6 | MBB to Banking Career | 1 | 1w |
| +6 | Family office - analyst role test | 3 | 3w |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
weighted average, multiply each asset class's weight by its respective return & sum.
That would calculate the portfolio's return correct? I'm after the total return of each asset class (ie. Real Estate, Infrastructure, etc.)
Et quas est asperiores voluptatem velit adipisci. Accusantium quis autem et asperiores harum numquam ipsum. Voluptas doloremque repellat quisquam ut ipsum doloribus dolorem.
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...