Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started