Model B D E F G H 3 M A 1 02. Madinah's Million 2 3 DATA 4 5 Rate of Return 6 Maturity 7 Rating 8 9 Crystal Ball 4.88% Awesome OSCM 6.12% Short 3 1. Excellent Bayday Exploration 5.50% Long 4 2. Very Good Movie Theatre 5.64% Galaxy Gas 5.28% Short 3 4 - Fair Supply Chain 6.03% Short 1 1 Toll House 5.77% Long 1 Live Theatre 5.22% Long 2 3-Good $285,000 $305,000 Cost to Purchase $ to invest Purchase Business? TUTA RETURN Total Available 10 DECISION 11 Investment Decision: 12 13 Annual Return 14 15 CONSTRAINTS 16 17 18 19 20 21 22 23 24 25 28 27 28 29 Statement QUESTION 2 - MADINAH'S MILLION [5 MARKS] Excel File: BUS2501 Q2 Investment TEMPLATE.XLS Madinah bought a ticket with her colleagues at work and just won a share of the Lotto Max Millions and is deciding how to invest part of her share ($1,000,000). She is looking at 6 different corporate bonds. She has some stipulations and concerns about the risks associated with each investment. You have been asked to determine the best investment decision to maximize her annual return on the investment within the constraints given. See the Excel template for the return rate (%), 2 Page years to maturity and rating of risk assigned to each of the investment possibilities available for her. * Years to Maturity is the length of time over which the bonds will be payable. ** Rating indicates independent underwriter's assessment of the quality or risk associated with each issue. Madinah has some stipulations about how she wants to invest the money: She wants to invest the entire amount She wants to invest in part ownership in either the Movie Theatre or Live Theatre but not both. No more than $180,000 should be invested in any one type of corporate bond investment (excludes the ownership investment). At least $100,000 should be in Supply Chain. At least $500,000 of the total investment should be in bonds that mature in the Long Term. No more than 35% of the total money invested in the corporate bonds should be invested in bonds that are rated either a 3 (Good) or 4 (Fair). Create an Excel Solver spreadsheet that models Madinah's situation. Use the Solver to find the best portfolio that satisfies Madinah's constraints. What is the "best" portfolio to invest and its expected return? The solution statement must be a complete sentence Use the template provided to help formulate your problem. Note that not every cell in every row needs to be filled in. Do not insert or delete any rows