Crypt-Me-Not Investments, Inc. is a new investment firm that deals exclusively with cryptocurrency investments. An investor wants to invest $100,000 in cryptocurrency next year and approaches them...


Q6b. Pls solve in Excel.


Thank you


Crypt-Me-Not Investments, Inc. is a new investment firm that deals exclusively with cryptocurrency investments.<br>An investor wants to invest $100,000 in cryptocurrency next year and approaches them about investing in Solana<br>(SOL) and Dogecoin (DOGE) which are currently selling at $175 and $1.00, respectively. The expected annual<br>return on each unit of SOL is $180 and on each unit of DOGE is $100 and like everyone else, the investor wants<br>to maximize their returns. The risk index associated with each unit of SOL is 1.6 and with each unit of DOGE is 1.8.<br>Crypt-Me-Not recommends not crossing a total risk value of 5000 with the client's investments. Moreover, since<br>DOGE is substantially cheaper and less risky than SOL, the investor insists that a minimum of 1,000 units of DOGE<br>in the portfolio is necessary. Based on these constraints, formulate a Linear Program and answer the following<br>questions after solving it using Solver in Excel (Round up to the next whole number for first three answers).<br>3. Looking at the sensitivity report, the shadow price for Funds Available is<br>_(Round two decimal places)<br>and for Risk Index is<br>(Round two decimal places).<br>

Extracted text: Crypt-Me-Not Investments, Inc. is a new investment firm that deals exclusively with cryptocurrency investments. An investor wants to invest $100,000 in cryptocurrency next year and approaches them about investing in Solana (SOL) and Dogecoin (DOGE) which are currently selling at $175 and $1.00, respectively. The expected annual return on each unit of SOL is $180 and on each unit of DOGE is $100 and like everyone else, the investor wants to maximize their returns. The risk index associated with each unit of SOL is 1.6 and with each unit of DOGE is 1.8. Crypt-Me-Not recommends not crossing a total risk value of 5000 with the client's investments. Moreover, since DOGE is substantially cheaper and less risky than SOL, the investor insists that a minimum of 1,000 units of DOGE in the portfolio is necessary. Based on these constraints, formulate a Linear Program and answer the following questions after solving it using Solver in Excel (Round up to the next whole number for first three answers). 3. Looking at the sensitivity report, the shadow price for Funds Available is _(Round two decimal places) and for Risk Index is (Round two decimal places).

Jun 05, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here