Hi,

you were working on this assignment but I had to cancel because the deadline was not correct. can you finish it by tomorrow at 10am?

Thanks

solve this problem by formulating a Linear Programming (LP) model, and like Task 1

you should provide all details about the model and your Excel results. (22 points)

In addition, the team leader has the following questions for you, and you should provide

your answers based on the Excel sensitivity reports.

a) The team leader suspects that the interest rate for the money borrowed on Friday may

fluctuate between 0.3% and 0.7%. How would this fluctuation affect the investment

plan? Provide detailed answers and analysis. (2 points)

b) The team leader argues with the regulators that the requirement of the debt-to-equity

ratio has a direct impact on their investment plan. Based on the Excel report, can you

verify if the optimal investment plan is affected or not by the requirement? (2points)

c) Suppose that the team leader wants to keep some money (any value but zero) in the

account by the end of Friday. For this decision to be part of the optimal investment

plan, the interest rate for the account on Friday, which is 1% right now, has to be

attractive enough (so that the money left in the account accrues good enough interest).

Is the current interest rate attractive enough? If not, how much higher should it be so

that the leader?s decision on keeping some (non-zero) money in the account on Friday

can be part of an optimal investment plan? (2 points)

ADM2302 M, N, P and Q Assignment # 2 Assignment # 2 Linear Programing Formulation and Sensitivity Analysis ADM2302 students are reminded that submitted assignments must be neat, readable, and well-organized. Assignment marks will be adjusted for sloppiness, poor grammar and spelling, as well as for technical errors. This assignment can be done in a group of one, two, or three students. Plagiarism on assignments will not be accepted, each student must sign the statement of integrity. Solutions to the Case Study are to be prepared using the Report to Management format provided in the ADM2302 Course Outline. This assignment can NOT be hand written. The assignment is to be submitted electronically as a single PDF file via blackboard learn by Sunday February 28th prior to 23:59. Front page of the PDF document has to include title of the assignment, course code and section, student name and student number. Second page is the statement of integrity that must be signed. CASE STUDY (70 points) Report to Management Format (16 points) Professional traders can find investment opportunities from day-to-day financial markets. Very often an investment strategy is required that determines how the investment should be planned across different days so that it can eventually lead to some profits. After months of study on the daily stock market, the traders of the international firm QuantTradeX have identified which stocks they should invest so that they can receive almost-predictable returns. In particular, by investing in these stocks they have the following proprietary trading strategy. At the start of every day of the week (Monday through Friday), they can decide how much to invest on that day, say, X dollars. If in the next day they are able to match that initial investment (the X dollars) with another investment of half of that amount, i.e. X/2 dollars, then they can expect to receive a total return on the third day that doubles the initial amount of the investment, i.e. a total return of 2X dollars. For example, if the trader invests X dollars on Monday and another X/2 dollars on Tuesday, which in total is 1.5X dollars, they can expect to receive 2X dollars on Wednesday, which gives them a gain of 0.5X dollars in two days. However, any initial investment that is not matched on the subsequent day will lose its whole value. Thus, considering any investment without a subsequent fund to match might not be meaningful. Besides the stock market, Foreign Exchange (FX) market is another popular financial market that daily traders actively participate. Although the firm QuantTradeX used to invest mostly in the stock market, they cannot let go any good investment opportunity even if it is in the FX market. The firm has recently noticed that whenever the number of travelers increases during the weekend, the FX rate tends to increase also in the following few days and go back to normal by the end of the week. They believe that in this case if they are able to invest Y dollars in the FX market on the Monday that follows right after the weekend, they can receive its doubled amount, i.e. 2Y dollars next day (Tuesday). If the investment is made on Tuesday, they can receive 1.5Y dollars next day (Wednesday). Winter 2016 Page 1 ADM2302 M, N, P and Q Assignment # 2 However, if the investment is made on Wednesday, they only receive 1.2Y dollars in two days, i.e. Friday. No investment in FX markets will be considered for the days after Wednesday. On any given day of a week, the traders of the firm can re-invest any return they receive from the previous investments made in the same week. If there is any amount in the firm's account that is not invested in any of the financial markets, that amount can accrue 1% of daily interest through money markets. Every Sunday night, the traders of the firm need to determine an investment plan for the following weekdays, i.e. how money in their account should be invested in each day. The plan is considered successful if it maximizes the amount of money they can have in their account by the end of the coming Saturday. It is assumed that on Saturday they can still receive returns from earlier investments in the same week. Today is another Sunday that the firm needs to make the investment plan, and it has been just confirmed that the number of travelers has increased significantly this weekend. The firm currently has 1 million in their account. Task 1 You are hired fairly recently and assigned to help the traders determine a successful investment plan for the coming week. Report how you solve this problem by formulating a Linear Programming (LP) model. Besides following the \"report to management\" format, you should provide all the details, which includes but are not limited to the LP model, i.e. decision variables, constraints, and objective function, with detailed explanations, the Excel sheets including your LP model, and answer and sensitivity reports. (20 points) Moreover, your manager has the following questions for you, and you should provide your answers based on the Excel sensitivity report. a) If the firm can borrow some more money today (so that more cash for the following week's investment), and for each dollar they borrow they have to return by the coming Saturday its doubled amount, i.e. return 2Z dollars for Z dollars borrowed, would you recommend the firm to borrow the money or not? (2 points) b) The firm suspects that the daily interest rate may rise around the end of Friday (so that any dollar carried over from Friday to Saturday will accrue a higher interest). Should they plan to save some more money throughout the week so that they can have more saving in their account by the end of Friday? Provide detailed answers and analysis for any possible rise of the interest rate. (2 points) c) The manager foresees that there is some possibility the firm may need to transfer out some money from the account for some non-investment purposes on Wednesday. He wonders how this would impact the performance of the investment plan. Provide detailed answers and analysis based on the sensitivity report for any possible amount of transfer. (2 points) Winter 2016 Page 2 ADM2302 M, N, P and Q Assignment # 2 Task 2: (Discard any consideration in Task1) Suppose that you are hired to join a team of traders specialized in leveraged investments. What this means is that on each day of trading, the traders can go borrow money also from the money markets to make investments. The current daily interest rate for borrowed money is 0.5%. However, for risk management purpose, the amount of money borrowed on each day has to be regulated. In particular, it is said in the regulation that the debt-to-equity ratio on each day, which is calculated by the amount of money borrowed in the begining of each day the amount of money left in the account by the end of the previous day with no interest accrued cannot exceed 100%. Your job now is to take into account the possibility of leveraged investments and help the traders determine the optimal investment plan for the coming week. Report how you solve this problem by formulating a Linear Programming (LP) model, and like Task 1 you should provide all details about the model and your Excel results. (22 points) In addition, the team leader has the following questions for you, and you should provide your answers based on the Excel sensitivity reports. a) The team leader suspects that the interest rate for the money borrowed on Friday may fluctuate between 0.3% and 0.7%. How would this fluctuation affect the investment plan? Provide detailed answers and analysis. (2 points) b) The team leader argues with the regulators that the requirement of the debt-to-equity ratio has a direct impact on their investment plan. Based on the Excel report, can you verify if the optimal investment plan is affected or not by the requirement? (2points) c) Suppose that the team leader wants to keep some money (any value but zero) in the account by the end of Friday. For this decision to be part of the optimal investment plan, the interest rate for the account on Friday, which is 1% right now, has to be attractive enough (so that the money left in the account accrues good enough interest). Is the current interest rate attractive enough? If not, how much higher should it be so that the leader's decision on keeping some (non-zero) money in the account on Friday can be part of an optimal investment plan? (2 points) Winter 2016 Page 3