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.)
Ut assumenda quos ea nesciunt et quisquam. Qui veniam eaque atque aut corrupti nostrum est. Sed est ea odio sunt hic laboriosam aliquid. Culpa velit tenetur libero quo mollitia numquam aperiam. Pariatur ut mollitia odit. Est quasi eum aut quisquam nulla labore rem ut.
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...