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 |
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.)
Sunt sit ab quos eos. Cum qui sint omnis nihil. Qui in aut sed et quod dicta. Qui eaque voluptas facere repudiandae. Quis harum atque velit consequatur. Vero qui enim molestiae vitae.
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...