I need this project please. Please me know if you will be able to complete it Thanks

FIN 5545 Project: Currency Hedge, The sample period for this project is from 3/15/2016 to 4/15/2016. At the start of the sample period, your company receives 2,500,000 Euros, which you plan to convert into US dollars at the end of sample period for tax reasons. Since EUR/USD exchange rate fluctuates every day, the US dollar value of your 2.5 mil Euros next month is uncertain, which is called exchange rate risk. Your objective is to lower this exchange rate risk. You decide to hedge against this risk using EUR/USD (=Euro FX) futures contract expiring in June 2016. 10 Questions (each is worth 1 point): 1. What is the difference between Euro FX futures and Eurodollar futures? 2. You are converting the currency in April but asked to use June expiring futures. Why can't we use April expiring futures and match the months? And what is the contract size of the Euro FX futures contract? 3. How many Euro FX futures contract do you buy or short to hedge the risk? Specify explicitly whether you are taking a long or short position of the Euro FX futures. 4. For every trading day (no weekends/holidays) during the sample period, collect the daily EUR/USD exchange rate and EUR/USD futures price. If you do not want to collect these prices every day, see hint #2 below. Create a spreadsheet and enter (1) date, (2) exchange rate, and (3) futures price. 5. Calculate the Euro FX futures daily gains, and cumulative gains for each day using the position you answered in Q3. 6. Assume the initial margin requirement is $5,000 per contract. Calculate the margin account balance each trading day. Is there a margin call, when the maintenance margin requirement is $3,500 per contract? If yes, add the required cash to the margin account to restore initial margin account requirement. 7. For each day, calculate the value of your unhedged position (= converting 2.5 mil Euros into USD), 8. For each day, calculate the values of your hedged position (= unhedged value in Q7 + futures cumulative gain in Q5). 9. Plot the unhedged values in Q7 and hedged values in Q8 over time. In addition, calculate the standard deviations of the unhedged values and that of the hedged values. Discuss both the graph and the standard deviations. 10. Using your Q9 answers, confirm that you successfully lowered the exchange rate risk or not. Hints: 1. Your spreadsheet must include at least the following columns for each trading day: 1) Date, 2) EUR/USD exchange rate, 3) EUR/USD futures price, 4) Futures daily gain, 5) Cumulative gain, 6) Margin account balance, 7) Unhedged value and 8) Hedged value (= unhedged value + cumulative gain). 2. Use http://www.cmegroup.com/ (where EUR/USD futures contracts are traded) to locate the EUR/USD futures and collect the futures prices. The screenshot below shows that the EUR/USD futures price on 12/22/2014 was 1.2239. Video tutorial: https://www.youtube.com/watch?v=qBPkVOjOvDA 3. To collect EUR/USD exchange rate, you can use any resource such as Bloomberg, Google or Yahoo. In the past, Bloomberg gave the best results because it provides exchange rate upto 4 decimal points. 4. As of 10/26/2015, 2.5 mil Euros is worth $2,776,737.50. If your unhedged values differ more than $500,000 from this number, check your data and re-calculate. 5. How to calculate futures daily gains, cumulative gains is explained in page 26-27 or review Week 1 files. 6. If you get lost, ask for help in Hangouts. You can even share the data and discuss results with your colleagues. But do not copy the answers. 7. In week 1, we already learned all the tools for this project. The only missing part is the data collection. As you collect the data, I strongly recommend start working on this project. In the past, students had trouble doing it later because they forgot the tools learned in week 1. \f\f\f\f