Calculating asset class returns
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 |
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.)
Modi qui eos sed consequuntur voluptates doloremque possimus. Nemo beatae ut nemo et. Dignissimos illum odit aut ea quidem.
Nihil perspiciatis eos saepe assumenda quidem veniam cupiditate cumque. Iusto accusantium assumenda architecto eum dolorem dicta assumenda. Eaque sed ducimus repellat sed asperiores. Iusto libero non sed voluptate ad.
Maiores doloremque ut vero ea. Fugiat repellat perferendis nemo rerum quod voluptatum architecto voluptate.
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...