If you manage a portfolio worth $100,000,000 and you choose to invest in only stock 1, 2, and 3.
Table 1. Average Return and Beta								What is the minimum beta for a portfolio with return equal to 13%?
Stock	1	2	3	4	5			No short sales allowed.
Average annual return	15%	8%	12%	50%	80%			Report the answer with 2 numbers after decimal place, say 1.51
Beta	1	1.2	2.5	3	3.5			(Remember to run Solver 3 times)
Table 2. Portfolio A information
Stock	1	2	3
Investment (million USD)