Please answer these questions in excel, showing the formulas used. Thank you in advance!

B5 xx Assume you have $100,000 to invest and have 8 investment alternatives, see below. Rates of Return are interpreted as follows: if you invest $100 in Texas Oil, you expect to get a return of $9 after 1 year (100*0.09=9). B D E F G H J L M A N 4 Assume you have $100,000 to invest and have 8 investment alternatives, see below. Rates of Return are interpreted as follows: if you invest $100 in Texas Oil, you expect to get a return of $9 after 1 year (100*0.09=9). How much would you invest in each of the 8 investment alternatives in order to maximize total return after 1 year? The Oil and IT industries offer higher returns but also involve higher risks. To reduce risk, comply with the following guidelines: -Guideline 1: Invest no more than 30% of total funds in Oil -Guideline 2: Invest no more than 40% of total funds in IT -Guideline 3: Invest at least 10% of total funds in Retail -Guideline 4: Invest at least 15% of total funds in Textiles -Guideline 5: Your investment in Oil has to be at least as much as your investment in IT Investment Industry Rate of Return Texas Oil Oil 0.09 Green Oil Oil 0.11 NY Textiles Textiles 0.06 Cotton Textiles Textiles 0.07 IT Touch IT 0.13 IT IT Land IT 0.15 l-Mart Retail 0.04 AllStores Retail Retail 0.05 5 6 7 8 9 10 11 12 13 15 14 15 16 17 18 19 20 21 22 Retail 0.5 points