Digital currency such as Bitcoin has attracted many investors’ attentions given its rapid growth of value very recently. Its superior return rate has also put pressure on many fund managers who are required to provide competitive return rates from their managed portfolios. Some fund managers have started to seriously consider including digital currency as part of their investment portfolios. However, they also know that such an investment decision can be highly risky since the price of digital currency is highly unstable. Janet Lopez is one of the fund managers who have done extensive research on digital currency. She estimates that the rate-of-return of digital currency is about 50%, i.e. 100 dollars of investment on digital currency can generate 50 dollars of profit, the coming year, whereas the rate-of-return of her current portfolio is 8%. She further estimates that the most she can lose in the next year in digital currency is 40%, i.e. 40% of any amount invested, whereas the most she could lose in her current portfolio is 10%. Janet is managing a $720,000 fund and needs to figure out how much to invest in digital currency and how much to invest in the existing portfolio so as to maximize the total profit. For risk management purpose, she has to limit the investment in digital currency to be no more than 25% of the total investment and also limit the potential loss of the total investment to be no more than $100,000.
(a) Develop a Linear programming model for the above problem.
(b) Draw the feasible region for the Linear Programming (LP) model.
(c) Find the optimal solution(s) and optimal value for the LP model. Justify why the solution is optimal. Describe also verbally how the manager should invest.
(d) (Solution using Excel). The real-estate in Ottawa region has also increased recently in value. The rate-of-return is reported to be around 20%. Janet estimates that the most she can lose in real estate is 20%. Given the same budget and risk management requirement as stated above, how much should Janet invest in Digital currency, existing portfolio, and real-estate so as to maximize the total profit? Develop a Linear Programming model for the problem. Solve it using Excel. You should provide the Excel spreadsheet formulation, the answer report, and describe verbally how the manager should invest.