1-FIND THE WEIGHT OF EACH INVESTMENT.

2-FIND THE OVERALL RETURN OF YOUR PORTFOLIO INVESTMENT.

KINDLY SHOW ALL THE CALCULATIONS AND WORK.

Merge & Center - $ - % 8.08 .00 5.0 Clipboard Font Conditional Format as Formatting Table Styles Alignment Number A241 : fo B E G H 1 J K 239 240 L 241 242 Q: Suppose you have Rs.500,000 that you decided to invest in three different proejcts as follows: 243 244 Project Investment Return weight 245 A 200,000 20% 0.4 0.08 246 B 100,000 -25% 0.2 -0.05 247C 200,000 15% 0.4 0.06 248 500,000 1 0.09 9% portfolio return 249 Find weight of each investment 250 Find overall return of your portfolio investment 251 252 253 254 Th 255 Quick Analysis (Ctrl+Q) Use the Quick Analysis tool quickly and easily analyze y with some of Excel's most u tools such as charts color- and formulas 256 157 258 259 280