I need the final part of my project to be completed. The last section to be completed is hedging. The information in part 3 of my project has some wrong answers so it should also be corrected.The project part 1 hedging section should look similar to the template.Heres is a video that can help you.https://www.youtube.com/watch?v=szFSNJny8jo&feature=youtu.be
Index This file is the template to use for the class project for FINC 6367 - International Finance INDEX Source data for DC1 I. Initial data DC1 Source data for DC2 II. Final data DC2 III. Trading profits IV. One year forecast V. Hedging Team membersJohn Sally Sue Currency studiedAAA/BBB Semester/yearFall 20xx Source data for DC1 Forward RatesInterest ratesFuturesOptionsForecast Forex RatesUSD Interest rates http://www.investing.com/rates-bonds/forward-ratesJapanese Yen Futures Settlementshttp://www.cmegroup.com/trading/fx/g10/japanese-yen_quotes_settlements_options.htmlhttp://www.investing.com/currencies/streaming-forex-rates-majors http://www.global-rates.com/interest-rates/libor/libor.aspxhttp://www.cmegroup.com/trading/fx/g10/japanese-yen_quotes_settlements_futures.htmlhttp://www.cmegroup.com/trading/fx/g10/japanese-yen_quotes_settlements_options.html#tradeDate=05/26/2017http://www.fxstreet.com/rates-charts/usdjpy/forecasthttp://www.global-rates.com/interest-rates/libor/american-dollar/american-dollar.aspx http://www.global-rates.com/interest-rates/libor/japanese-yen/japanese-yen.aspxhttp://www.cmegroup.com/trading/fx/g10/japanese-yen_quotes_settlements_futures.html#tradeDate=05/26/2017 NameBidAskHighLowChgTimeJPY5/26/175/25/175/24/175/23/175/22/17Japanese Yen Option (American) SettlementsBidAskOpenHighLowChgChg %TimeUSD5/26/175/25/175/24/175/23/175/22/17 USDJPY TN FWD-0.39-0.33-0.35-0.330.05514:56:00 JPY LIBOR - overnight-0.0106%-0.00914 %-0.00914 %-0.00700 %-0.01200 %Trade Date:EUR/USD1.11811.11821.1211.12351.1161-0.0029-0.26%26/05 USD LIBOR - overnight0.93000%0.93000 %0.93056 %0.93056 %0.92889 % USDJPY SN FWD-0.42-0.31-0.35-0.35-0.02915:02:00 JPY LIBOR - 1 week-0.0069%-0.00536 %-0.00536 %-0.00464 %-0.00429 %All market data contained within the CME Group website should be considered as a reference only and should not be used as validation against, nor as a complement to, real-time market data feeds.Type:USD/JPY111.34111.36111.83111.86110.88-0.48-0.43%26/05 USD LIBOR - 1 week0.94922%0.94967 %0.94967 %0.94944 %0.94833 % USDJPY SW FWD-2.72-2.48-2.67-2.58-0.0215:02:00 JPY LIBOR - 2 weeks-----MonthOpenHighLowLastChangeSettleEstimated VolumePrior Day Open InterestExpiration:GBP/USD1.27981.27991.29421.29461.2776-0.0143-1.10%26/05 USD LIBOR - 2 weeks----- USDJPY 2W FWD-5.35-5.15-5.35-5.15-0.0514:56:00 JPY LIBOR - 1 month-0.01629 %-0.01457 %-0.01600 %-0.01171 %-0.01236 %Last Updated: Friday, 26 May 2017 06:00 PMTrade Date:USD/CHF0.97460.97480.97250.97610.96970.00220.23%26/05 USD LIBOR - 1 month1.04467 %1.04383 %1.03272 %1.02356 %1.02939 % USDJPY 3W FWD-8.45-8.09-8.36-8.09-0.135:30:00 JPY LIBOR - 2 months-0.01371 %-0.01086 %-0.01229 %-0.01264 %-0.00979 %About This ReportUSD/CAD1.34421.34441.34841.34981.3433-0.0041-0.30%26/05 USD LIBOR - 2 months1.12083 %1.12028 %1.11056 %1.10139 %1.09889 % USDJPY 1M FWD-13.2-12.6-12.94-12.75-0.2817:11:00 JPY LIBOR - 3 months-0.01529 %-0.01386 %-0.01386 %-0.01279 %-0.01279 %StrikeTypeOpenHighLowLastChangeSettleEstimated VolumePrior Day Open InterestEUR/JPY124.45124.47125.35125.43124.17-0.89-0.71%26/05 USD LIBOR - 3 months1.20178 %1.20039 %1.19761 %1.18867 %1.19200 % USDJPY 2M FWD-31.45-30.8-30.95-30.90.1815:02:00 JPY LIBOR - 4 months-----17-Jun8949090255894708988535589870126,499208,427Last Updated: Friday, 20 May 2016 06:00 PMAUD/USD0.74460.74470.74550.74610.7422-0.0008-0.11%26/05 USD LIBOR - 4 months----- USDJPY 3M FWD-46.22-45.12-45.89-45.5-0.2915:02:00 JPY LIBOR - 5 months-----JLY 178967090380B89610A90030A36090005303291About This ReportNZD/USD0.7060.70620.70230.70770.70070.00380.54%26/05 USD LIBOR - 5 months----- USDJPY 4M FWD-60.95-60.15-60.95-60.360.1514:58:00 JPY LIBOR - 6 months0.02300 %0.02300 %0.02329 %0.02329 %0.02329 %17-Aug8978090490B89725A90160B36090110198946500Call----0.3524.8700 USD LIBOR - 6 months1.41378 %1.41794 %1.41739 %1.41350 %1.41933 % USDJPY 5M FWD-79.85-78.85-79.8-78.85-0.114:57:00 JPY LIBOR - 7 months-----17-Sep89855906358984590285B360902558987,1086550Call----0.3524.3700 USD LIBOR - 7 months----- USDJPY 6M FWD-96.2-95-96-95.2-0.5516:00:00 JPY LIBOR - 8 months-----17-Oct----36590385006600Call----0.3523.8700 USD LIBOR - 8 months----- USDJPY 7M FWD-112.03-110.53-111.45-110.53-0.2316:00:00 JPY LIBOR - 9 months-----17-Dec90225910359022590700A3609067072786650Call----0.3523.3700 USD LIBOR - 9 months----- USDJPY 8M FWD-134.35-132.75-134.15-132.95-0.714:56:00 JPY LIBOR - 10 months-----18-Mar-91380B-91145A370911250706700Call----0.3522.8700 USD LIBOR - 10 months----- USDJPY 9M FWD-151.55-147.55-150.29-149.36-0.317:11:00 JPY LIBOR - 11 months-----18-Jun-91735B-91655A375916000286750Call----0.3522.3700 USD LIBOR - 11 months----- USDJPY 10M FWD-167.5-165.5-167.42-165.50.214:56:00 JPY LIBOR - 12 months0.12500 %0.12571 %0.12643 %0.12571 %0.12643 %18-Sep-92020B-92020B38592130046800Call----0.3521.8700 USD LIBOR - 12 months1.72122 %1.72289 %1.72567 %1.71956 %1.72650 % USDJPY 11M FWD-186.3-184.1-186.18-184.18-0.4514:56:0018-Dec----39092665006850Call----0.3521.3700 USDJPY 1Y FWD-206.33-202.57-205.48-205.3-1.1215:02:00CAD NZD and AUD Libor rates are no longer available. MXN doesn't have Libor rates19-Mar----40093210006900Call----0.3520.8700 USDJPY 15M FWD-265.86-260.86-265.86-260.86-2.115:30:0019-Jun----40593775006950Call----0.3520.3700 USDJPY 21M FWD-393-381-391-389.094.117:03:00For CAD Please use 3M rate (Cidor) from this source19-Sep----40594420007000Call----0.3519.8700 USDJPY 2Y FWD-459.5-454.500226/05http://www.tradingeconomics.com/canada/interbank-rate19-Dec----41095075007050Call----0.3519.3700 USDJPY 3Y FWD-742-72200-126/0520-Mar----41595735007100Call----0.3518.8700 USDJPY 4Y FWD-1046.7-1016.7-1046.7-1016.75.95:30:00For AUD, please use the 3M rate from this source20-Jun----41596405007150Call----0.3518.3700 USDJPY 5Y FWD-1354.9-1314.9-1354.9-1314.95.85:30:00http://www.tradingeconomics.com/australia/interbank-rate20-Sep----42097090007200Call----0.3517.8700 USDJPY 6Y FWD-1652-159200326/0520-Dec----42597780007250Call----0.3517.3700 USDJPY 7Y FWD-1948-187700326/05For NZD please use 3M rate from this source21-Mar----42598480007300Call----0.3516.8700 USDJPY 8Y FWD-2234-215400226/05https://tradingeconomics.com/new-zealand/interbank-rate21-Jun----43099190007350Call----0.3516.3700 USDJPY 9Y FWD-2506-241600126/0521-Sep----43099910007400Call----0.3515.8700 USDJPY 10Y FWD-2763-266200-226/05For MXN, please use the 28 days interbank rate from this source21-Dec----435100645007450Call----0.3515.3700 USDJPY 12Y FWD-3611-348600024/05https://tradingeconomics.com/mexico/interbank-rate22-Mar----440101385007500Call----0.3514.8700 USDJPY 15Y FWD-4196-405600024/05Total127,905216,3007550Call----0.3514.3700 USDJPY 20Y FWD-4942-479200024/057600Call----0.3513.8700 USDJPY 30Y FWD-5683.8101-5559.45020002-Jan7650Call----0.3513.3700 7700Call----0.3512.8707 7750Call----0.3512.3700 7800Call----0.3511.8700 7850Call----0.3511.3700 7900Call----0.3510.8707 7950Call----0.3510.3703 8000Call----0.359.87019 8050Call----0.359.3701 8100Call----0.358.8705 8150Call----0.358.3702 8200Call----0.357.8701 8250Call----0.357.3701 8300Call----0.356.8700 8350Call----0.356.3706 8400Call----0.355.87043 8450Call----0.355.37020 8500Call----0.354.87035 8550Call----0.354.37011 8600Call----0.353.870481 8650Call----0.363.380657 8700Call----0.352.8801,028 8750Call----0.342.390961 8800Call-2.250B--0.321.9101,047 8850Call1.581.581.58-0.291.4711,056 itm8900Call-1.360B--0.241.0802,599 8950Call0.861.020B.570A-0.190.77211,546 atm9000Call0.5.740B.380A-0.140.531472,765 9050Call0.29.520B.250A-0.10.362822,411 out9100Call0.22.360B0.22-0.070.243211,667 9150Call0.16.250B0.16-0.060.171602,291 9200Call0.1.170B0.1-0.040.111272,015 9250Call0.1.120B0.08-0.030.0831,509 9300Call0.07.080B0.05-0.0250.06361,292 9350Call-.060B--0.0150.04502,207 9400Call0.04.045B.035A-0.0150.0358846 9450Call-.030B--0.0050.02501,313 9500Call-.025B--0.0050.0201,174 9550Call-.020B--0.0050.0150897 9600Call-.015B--0.0050.0150686 9650Call----UNCH0.010406 9700Call-.010B--0.0050.010365 9750Call----UNCH0.0050644 9800Call----0.0050.00501,493 9850Call0.010.010.01-0.0050.0051298 9900Call----UNCHCAB0833 9950Call----UNCHCAB0463 10000Call----UNCHCAB0606 10050Call----UNCHCAB0246 10100Call----UNCHCAB0656 10150Call----UNCHCAB0227 10200Call----UNCHCAB0222 10250Call----UNCHCAB0193 10300Call----UNCHCAB0207 10350Call----UNCHCAB08 10400Call----UNCHCAB0126 10450Call----UNCHCAB039 10500Call----UNCHCAB059 10550Call----UNCHCAB041 10600Call----UNCHCAB0108 10650Call----UNCHCAB031 10700Call----UNCHCAB0128 10750Call----UNCHCAB035 10800Call----UNCHCAB09 10850Call----UNCHCAB040 10900Call----UNCHCAB085 10950Call----UNCHCAB037 11000Call----UNCHCAB00 11050Call----UNCHCAB039 11100Call----UNCHCAB020 11150Call----UNCHCAB021 11200Call----UNCHCAB0225 11250Call----UNCHCAB05 11300Call----UNCHCAB010 11350Call----UNCHCAB010 11400Call----UNCHCAB020 11450Call----UNCHCAB0123 11500Call----UNCHCAB05 11550Call----UNCHCAB014 11600Call----UNCHCAB027 11650Call----UNCHCAB0103 6500Put----UNCHCAB032 6550Put----UNCHCAB00 6600Put----UNCHCAB025 6650Put----UNCHCAB00 6700Put----UNCHCAB00 6750Put----UNCHCAB00 6800Put----UNCHCAB01 6850Put----UNCHCAB02 6900Put----UNCHCAB00 6950Put----UNCHCAB01 7000Put----UNCHCAB00 7050Put----UNCHCAB00 7100Put----UNCHCAB021 7150Put----UNCHCAB00 7200Put----UNCHCAB00 7250Put----UNCHCAB0147 7300Put----UNCHCAB041 7350Put----UNCHCAB030 7400Put----UNCHCAB028 7450Put----UNCHCAB020 7500Put----UNCHCAB0295 7550Put----UNCHCAB062 7600Put----UNCHCAB021 7650Put----UNCHCAB083 7700Put----UNCHCAB079 7750Put----UNCHCAB0185 7800Put----UNCHCAB0866 7850Put----UNCHCAB015 7900Put----UNCHCAB078 7950Put----UNCHCAB0251 8000Put----UNCHCAB0541 8050Put----UNCHCAB0325 8100Put----UNCHCAB01,472 8150Put----UNCHCAB0716 8200Put----UNCHCAB01,071 8250Put----UNCHCAB0542 8300Put----UNCHCAB0678 8350Put----UNCHCAB0915 8400Put----UNCHCAB01,045 8450Put----UNCHCAB0510 8500Put----UNCH0.00501,202 8550Put----UNCH0.0050650 8600Put----UNCH0.00501,135 8650Put-----0.0050.00501,749 8700Put--.015A--0.010.0112,541 8750Put0.015.025B0.015--0.0150.02103,072 8800Put0.0450.0450.04--0.0350.045412,605 8850Put0.120.120.09--0.070.1511,558 8900Put0.30.3.160A--0.120.211715,670 8950Put0.31.410B0.30.37-0.160.41441,323 9000Put0.65.680B.510A--0.210.662153,435 9050Put--.780A--0.250.994658 9100Put--1.150A--0.281.3712,423 9150Put--1.550A--0.31.790394 9200Put--1.970A--0.322.2401,791 9250Put-----0.322.710117 9300Put-----0.333.19090 9350Put-----0.343.670285 9400Put-----0.354.16037 9450Put-----0.354.65047 9500Put-----0.355.150280 9550Put-----0.365.640133 9600Put-----0.356.14021 9650Put-----0.356.64028 9700Put-----0.357.14014 9750Put-----0.367.63015 9800Put-----0.368.13058 9850Put-----0.368.63045 9900Put-----0.369.13030 9950Put-----0.369.63038 10000Put-----0.3610.130209 10050Put-----0.3610.63014 10100Put-----0.3611.13045 10150Put-----0.3611.63082 10200Put-----0.3612.130182 10250Put-----0.3612.63025 10300Put-----0.3613.13038 10350Put-----0.3613.63024 10400Put-----0.3614.13080 10450Put-----0.3614.630104 10500Put-----0.3615.130619 10550Put-----0.3615.6300 10600Put-----0.3616.1303 10650Put-----0.3616.6300 10700Put-----0.3617.1303 10750Put-----0.3617.6303 10800Put-----0.3618.1303 10850Put-----0.3618.6307 10900Put-----0.3619.1303 10950Put-----0.3619.6304 11000Put-----0.3620.1304 11050Put-----0.3620.6307 11100Put-----0.3621.1308 11150Put-----0.3621.6304 11200Put-----0.3622.1303 11250Put-----0.3622.6300 11300Put-----0.3623.1304 11350Put-----0.3623.6304 11400Put-----0.3624.1304 11450Put-----0.3624.6308 11500Put-----0.3625.1308 11550Put-----0.3625.63014 11600Put-----0.3626.13020 11650Put-----0.3626.63014 Total1,74581,928 http://www.investing.com/rates-bonds/forward-rateshttp://www.tradingeconomics.com/canada/interbank-ratehttp://www.cmegroup.com/trading/about-settlements.htmlhttps://www.investing.com/currencies/eur-usdhttps://www.investing.com/currencies/usd-jpyhttps://www.investing.com/currencies/gbp-usdhttps://www.investing.com/currencies/usd-chfhttps://www.investing.com/currencies/usd-cadhttps://www.investing.com/currencies/eur-jpyhttps://www.investing.com/currencies/aud-usdhttps://www.investing.com/currencies/nzd-usdhttp://www.global-rates.com/interest-rates/libor/japanese-yen/japanese-yen.aspxhttp://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-overnight.aspxhttp://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-1-week.aspxhttp://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-2-weeks.aspxhttp://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-1-month.aspxhttp://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-2-months.aspxhttp://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-3-months.aspxhttp://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-4-months.aspxhttp://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-5-months.aspxhttp://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-6-months.aspxhttp://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-7-months.aspxhttp://www.cmegroup.com/trading/fx/g10/japanese-yen_quotes_settlements_futures.htmlhttp://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-8-months.aspxhttp://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-9-months.aspxhttp://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-10-months.aspxhttp://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-11-months.aspxhttp://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-12-months.aspxhttp://www.global-rates.com/interest-rates/libor/libor.aspxhttp://www.global-rates.com/interest-rates/libor/japanese-yen/jpy-libor-interest-rate-overnight.aspxhttp://www.global-rates.com/interest-rates/libor/japanese-yen/jpy-libor-interest-rate-1-week.aspxhttp://www.global-rates.com/interest-rates/libor/japanese-yen/jpy-libor-interest-rate-2-weeks.aspxhttp://www.global-rates.com/interest-rates/libor/japanese-yen/jpy-libor-interest-rate-1-month.aspxhttp://www.cmegroup.com/trading/fx/g10/japanese-yen_quotes_settlements_options.htmlhttp://www.global-rates.com/interest-rates/libor/japanese-yen/jpy-libor-interest-rate-2-months.aspxhttp://www.global-rates.com/interest-rates/libor/japanese-yen/jpy-libor-interest-rate-3-months.aspxhttp://www.global-rates.com/interest-rates/libor/japanese-yen/jpy-libor-interest-rate-4-months.aspxhttp://www.global-rates.com/interest-rates/libor/japanese-yen/jpy-libor-interest-rate-5-months.aspxhttp://www.global-rates.com/interest-rates/libor/japanese-yen/jpy-libor-interest-rate-6-months.aspxhttp://www.global-rates.com/interest-rates/libor/japanese-yen/jpy-libor-interest-rate-7-months.aspxhttp://www.global-rates.com/interest-rates/libor/japanese-yen/jpy-libor-interest-rate-8-months.aspxhttp://www.global-rates.com/interest-rates/libor/japanese-yen/jpy-libor-interest-rate-9-months.aspxhttp://www.global-rates.com/interest-rates/libor/japanese-yen/jpy-libor-interest-rate-10-months.aspxhttp://www.global-rates.com/interest-rates/libor/japanese-yen/jpy-libor-interest-rate-11-months.aspxhttp://www.cmegroup.com/trading/about-settlements.htmlhttp://www.global-rates.com/interest-rates/libor/japanese-yen/jpy-libor-interest-rate-12-months.aspxhttp://www.investing.com/currencies/streaming-forex-rates-majorshttp://www.global-rates.com/interest-rates/libor/american-dollar/american-dollar.aspxhttp://www.fxstreet.com/rates-charts/usdjpy/forecasthttp://www.tradingeconomics.com/australia/interbank-rate I. Initial data DC1 Template for Part 1 of project Date when hedge is initiated Students' namesYour names hereFriday, May 26, 2017 Garza-Gomez, Xavier: Must be a Friday (or Thursday if Friday was a holiday) 1. Currency to hedgeJapanese Yen 1a Currency pair formed with the US dollar (as seen in OANDA, FXCM)USD/JPY 1b Date when hedge (trading) will be closed and all the calculations doneFriday, June 02, 2017 GarzaX: Students must state the date when they will "close" the hedges/trades in this theoretical exercise. Hint: it is the Friday (or Thursday if Friday is a holiday) after the initial date 1c Is this a direct quote in the spot market? (Y/N)N 2. Exchange rate of the currency as typically quoted in FX markets. Use the SPOT price from the Investing.com siteBIDASK 111.34111.36Any cell in this color must be updated by students, Using links is strongly recommended (instead of typing the values) 2a Express the price as a direct quote (value of one unit of that currency in dollars)0.0089799 garzax: Calculated cell If direct quote, then it's same as 2. If indirect, then must calculate the inverse.0.0089815 3. Three or six-month future rate as of this date (use whatever period covers the second data collection period) Report the settlement price reported on the CME Group website89870 Expiration month of future contractJune-17 . Specify the size of the future (option) contracts 12500000 GarzaX: Look in Contract Specifications 4. Forward points observed on this date. Use the Investing.com website for information. Select data for 1W (summer) or the period specified for the exercise. Students doing USDJPY must use an appropriate factor to convert pips.BIDASK -2.72-2.48 Horizon for Fwd quotes 1 week 5. Use the CME group website to obtain option price data. Week 2 Jun 2017 Garza-Gomez, Xavier: Must indicate week/month/year of the option used Garza-Gomez, Xavier: Must be a Friday (or Thursday if Friday was a holiday) Specify the expiration week,month and year on the CME options that will cover the period you are interested in hedging Strike Garza-Gomez, Xavier: The distance between strike prices must be at least 100 pips Premium 5a. Choose a call option that is in the money and obtain its premium89001.08 garzax: Normally quoted as cents. With exception of EURUSD which is quoted in dollars and the JPY which is quoted as 100ths of a cent. 5b. Find the call option that is at the money and obtain its premium Garza-Gomez, Xavier: ATM strike price is determined using the futures contract price that is linked to the option garzax: Normally quoted as cents. With exception of EURUSD which is quoted in dollars and the JPY which is quoted as 100ths of a cent. GarzaX: Students must state the date when they will "close" the hedges/trades in this theoretical exercise. Hint: it is the Friday (or Thursday if Friday is a holiday) after the initial date garzax: Calculated cell If direct quote, then it's same as 2. If indirect, then must calculate the inverse.90000.53 5c. Choose a call option that is out the money and obtain its premium91000.24 6. Use the CME group website to obtain put option price data. Use the same expiration month you chose for call optionsStrikePremium 6a. Choose a put option that is in the money and obtain its premium91001.37 garzax: Normally quoted as cents. With exception of EURUSD which is quoted in dollars and the JPY which is quoted as 100ths of a cent. 6b. Find the put option that is at the money and obtain its premium90000.66 6c. Choose a put option that is out the money and obtain its premium89000.21 7. Use the Global Rates website to identify the LIBOR ratesLIBOR rates Garza-Gomez, Xavier: Don't forget to