Calculating asset returns by portfolio weights
I have a securities portfolio (Fixed Income) and corresponding information regarding the single issues weights (in %) in the portfolio, sector identifiers (i.e. Industrial, Retail) and Total Return quotes %) on a month-to-date basis (MTD). It looks something like this
* * *
Sid____________Sector__________Weight_____Total Return MTD XS121452838____Industrial______0.0012_____1.25 XS121452816____Retail__________0.0012_____2.25 XS121452822____Retail__________0.0012_____3.25 XS121452811____Utilities_______0.0012_____4.25 XS121452812____Healthcare______0.0012_____-2.21
## ...
How do I calculate sector Total Return? i.e. the total return of all utilities companies in the portfolio (taking their respective weights in this sub-segment into consideration - Portfolio Utilities holdings).
I have added an illustration to aid Ross's Answer for clarity.
Hope the image is legible.![enter image description here](