Q2-SYNI (an investment fund management company formerly known as Save Your Nickels Investments) has acquired a new client that has authorized SYNI to invest up to $1.2 million in either a stock fund (5) or a money market fund (M). SYNI has an internal risk index, where the higher the number the riskier the investment, and the stock fund has a value of 8 and the money market fund has a value of 3. Each unit in the stock fund costs $50 and earns 10% per year and each unit of the money market fund costs $100 and earns 4% per year. The client has indicated that the yearly earnings from invested funds must be a least $60,000 and that at least $300,000 must be invested in the money market fund. Note for each unit of the stock fund purchased for $50 the 10% earning means $5 will be earned (and a similar story holds for the money market fund. SYNI explains to the client the goal is to meet client requirements but minimize the risk. Use Excel to solve the problem and include your Excel file with at least an answer and sensitivity report. Also answer the following: a-how many units of each fund should be purchased? b-how much of the $1.2 million is invested? c-how much is added to the overall risk exposure of the client if $80,000 is the minimum in yearly earnings required? Q2-SYNI (an investment fund management company formerly known as Save Your Nickels Investments) has acquired a new client that has authorized SYNI to invest up to $1.2 million in either a stock fund (5) or a money market fund (M). SYNI has an internal risk index, where the higher the number the riskier the investment, and the stock fund has a value of 8 and the money market fund has a value of 3. Each unit in the stock fund costs $50 and earns 10% per year and each unit of the money market fund costs $100 and earns 4% per year. The client has indicated that the yearly earnings from invested funds must be a least $60,000 and that at least $300,000 must be invested in the money market fund. Note for each unit of the stock fund purchased for $50 the 10% earning means $5 will be earned (and a similar story holds for the money market fund. SYNI explains to the client the goal is to meet client requirements but minimize the risk. Use Excel to solve the problem and include your Excel file with at least an answer and sensitivity report. Also answer the following: a-how many units of each fund should be purchased? b-how much of the $1.2 million is invested? c-how much is added to the overall risk exposure of the client if $80,000 is the minimum in yearly earnings required