In: Finance
Common Stock Column i |
Amount invested in $ Column ii |
Weight Column iii |
Expected Return on stock Column iv |
Expected return on portfolio Column V=Column iii*Column iv |
A | 6,000.00 | 0.1000 | 0.14 | 0.0140 |
B | 11,000.00 | 0.1833 | 0.16 | 0.0293 |
C | 9,000.00 | 0.1500 | 0.17 | 0.0255 |
D | 7,000.00 | 0.1167 | 0.13 | 0.0152 |
E | 5,000.00 | 0.0833 | 0.20 | 0.0167 |
F | 13,000.00 | 0.2167 | 0.15 | 0.0325 |
G | 9,000.00 | 0.1500 | 0.18 | 0.0270 |
60,000.00 | 1.00 | 0.1602 |
Common stock name, amount invested in $ and Expected return for each common stock are taken from question.
Total amount invested = 6,000+11,000+9,000+7,000+5,000+13,000+9,000 = 60,000
Expected return on portfolio is 16.02%.
Formulae used:
1. For weight calculation Column iv
For stock A = Amount invested in stock A/Total amount invested*100 = 6,000/60,000*100=0.10 or 10.00%
For stock B = Amount invested in stock A/Total amount invested*100 = 11,000/60,000*100=0.1833 or 18.33%
For stock C = Amount invested in stock A/Total amount invested*100 = 9,000/60,000*100=0.15 or 15.00%
For stock D = Amount invested in stock A/Total amount invested*100 = 7,000/60,000*100=0.1167 or 11.67%
For stock E = Amount invested in stock A/Total amount invested*100 = 5,000/60,000*100=0.0833 or 8.33%
For stock F = Amount invested in stock A/Total amount invested*100 = 13,000/60,000*100=0.2167 or 21.67%
For stock G = Amount invested in stock A/Total amount invested*100 = 9,000/60,000*100=0.15 or 15.00%
Expected return on portfolio = Total of Column v = 0.1602 or 16.02%