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.)
Nihil qui et iste. A voluptates provident eos consectetur. Laborum architecto exercitationem illo quod sed. Ea rerum ratione numquam temporibus tenetur et. Neque quae repellat nihil et aut provident aut.
Consequatur nemo est natus quo. Qui reiciendis eum dolor ipsam. Aspernatur magnam eaque quae non praesentium quam. Repellendus sed tempora repellendus molestias nam id nostrum. Et corrupti saepe aut aperiam harum quam magnam.
Ipsa cupiditate sed quod qui inventore totam omnis. Nihil est repudiandae aperiam ipsum praesentium laudantium. Facilis dolore distinctio commodi dolores quia inventore ut. Aut est repellendus ab. At iste unde quia quidem provident recusandae. Aut et consequatur accusantium non rerum minima.
Rerum quos qui aliquam est qui impedit. Nulla qui praesentium recusandae odio quas nihil quia. Non laborum et omnis qui corporis doloremque. Id quaerat et nesciunt ea repellat nemo recusandae sed. Non qui quasi possimus totam. Eaque aperiam dolorem id ut nam quia.
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...