Hedging-Currency-Risks-at-AIFS表格推荐下载.xlsx
- 文档编号:413026
- 上传时间:2023-04-28
- 格式:XLSX
- 页数:19
- 大小:65.62KB
Hedging-Currency-Risks-at-AIFS表格推荐下载.xlsx
《Hedging-Currency-Risks-at-AIFS表格推荐下载.xlsx》由会员分享,可在线阅读,更多相关《Hedging-Currency-Risks-at-AIFS表格推荐下载.xlsx(19页珍藏版)》请在冰点文库上搜索。
Exhibit9TemplateforCurrencyRateandSalesVolumeImpactonCompanyBottomLineExp25000Optionsfee0.05Final25000Benefit(+)/Loss(-)inUSDUSDExchangeRate(USD/EUR)%CoverContractsOptionsOptionscost1.011.221.48STD100%0%100%1525.003725.00(1525.00)(1525.00)2474.87100%25%75%1143.752793.75(1143.75)(1143.75)1856.16100%50%50%762.501862.50(762.50)(762.50)1237.44100%75%25%381.25931.25(381.25)(381.25)618.72100%100%0%0.000.000.000.000.0075%0%100%1143.754106.25(1143.75)(2768.75)2933.8875%25%75%857.813407.81(857.81)(2482.81)2484.0775%50%50%571.882709.38(571.88)(2196.88)2040.6675%75%25%285.942010.94(285.94)(1910.94)1608.9175%100%0%0.001312.500.00(1625.00)1201.4950%0%100%762.504487.50(762.50)(4012.50)3501.9850%25%75%571.884021.88(571.88)(3821.88)3217.8250%50%50%381.253556.25(381.25)(3631.25)2938.7650%75%25%190.633090.63(190.63)(3440.63)2666.3850%100%0%0.002625.000.00(3250.00)2402.9825%0%100%381.254868.75(381.25)(5256.25)4134.4625%25%75%285.944635.94(285.94)(5160.94)3999.5725%50%50%190.634403.13(190.63)(5065.63)3866.1725%75%25%95.314170.31(95.31)(4970.31)3734.4125%100%0%0.003937.500.00(4875.00)3604.470%0%100%0.005250.000.00(6500.00)4805.960%25%75%0.005250.000.00(6500.00)4805.960%50%50%0.005250.000.00(6500.00)4805.960%75%25%0.005250.000.00(6500.00)4805.960%100%0%0.005250.000.00(6500.00)4805.96BestStrategy%CoverContractsOptionsOptionscost1.011.221.48STD100.00%100.00%0.00%00000.00Source:
@#@AdaptedbycasewritersfromAIFS.Numbersandlevelshavebeendisguisedforconfidentiality.(8000.00)(6000.00)(4000.00)(2000.00)0.002000.004000.006000.001.011.221.48(8000.00)(6000.00)(4000.00)(2000.00)0.002000.004000.006000.001.011.221.48%CoverContractsOptions1.011.221.48100%0%100%575.00(1525.00)2375.0025%75%(356.25)(1143.75)2756.2550%50%(1287.50)(762.50)3137.5075%25%(2218.75)(381.25)3518.75100%0%(3150.00)0.003900.0075%0%100%956.25(1143.75)1131.2525%75%257.81(857.81)1417.1950%50%(440.63)(571.88)1703.1375%25%(1139.06)(285.94)1989.06100%0%(1837.50)0.002275.0050%0%100%1337.50(762.50)(112.50)25%75%871.88(571.88)78.1350%50%406.25(381.25)268.7575%25%(59.38)(190.63)459.38100%0%(525.00)0.00650.0025%0%100%1718.75(381.25)(1356.25)25%75%1485.94(285.94)(1260.94)50%50%1253.13(190.63)(1165.63)75%25%1020.31(95.31)(1070.31)100%0%787.500.00(975.00)0%0%100%2100.000.00(2600.00)25%75%2100.000.00(2600.00)50%50%2100.000.00(2600.00)75%25%2100.000.00(2600.00)100%0%2100.000.00(2600.00)%CoverContractsOptions1.011.221.48100%0%100%3725.00(1525.00)(1525.00)25%75%2793.75(1143.75)(1143.75)50%50%1862.50(762.50)(762.50)75%25%931.25(381.25)(381.25)100%0%0.000.000.0075%0%100%4106.25(1143.75)(2768.75)25%75%3407.81(857.81)(2482.81)50%50%2709.38(571.88)(2196.88)75%25%2010.94(285.94)(1910.94)100%0%1312.500.00(1625.00)50%0%100%4487.50(762.50)(4012.50)25%75%4021.88(571.88)(3821.88)50%50%3556.25(381.25)(3631.25)75%25%3090.63(190.63)(3440.63)100%0%2625.000.00(3250.00)Finalvolume:
@#@10000Benefit(+)/Loss(-)inUSD100%75%50%25%0%-4000-3000-2000-10000100020003000400050001.011.221.48Finalvolume:
@#@25000Benefit(+)/Loss(-)inUSD100%75%50%25%0%-7000-5000-3000-100010003000500070001.011.221.4825%0%100%4868.75(381.25)(5256.25)25%75%4635.94(285.94)(5160.94)50%50%4403.13(190.63)(5065.63)75%25%4170.31(95.31)(4970.31)100%0%3937.500.00(4875.00)0%0%100%5250.000.00(6500.00)25%75%5250.000.00(6500.00)50%50%5250.000.00(6500.00)75%25%5250.000.00(6500.00)100%0%5250.000.00(6500.00)%CoverContractsOptions1.011.221.48100%0%100%4775.00(1525.00)(2825.00)25%75%3843.75(1143.75)(2443.75)50%50%2912.50(762.50)(2062.50)75%25%1981.25(381.25)(1681.25)100%0%1050.000.00(1300.00)75%0%100%5156.25(1143.75)(4068.75)25%75%4457.81(857.81)(3782.81)50%50%3759.38(571.88)(3496.88)75%25%3060.94(285.94)(3210.94)100%0%2362.500.00(2925.00)50%0%100%5537.50(762.50)(5312.50)25%75%5071.88(571.88)(5121.88)50%50%4606.25(381.25)(4931.25)75%25%4140.63(190.63)(4740.63)100%0%3675.000.00(4550.00)25%0%100%5918.75(381.25)(6556.25)25%75%5685.94(285.94)(6460.94)50%50%5453.13(190.63)(6365.63)75%25%5220.31(95.31)(6270.31)100%0%4987.500.00(6175.00)0%0%100%6300.000.00(7800.00)25%75%6300.000.00(7800.00)50%50%6300.000.00(7800.00)75%25%6300.000.00(7800.00)100%0%6300.000.00(7800.00)Finalvolume:
@#@30000Benefit(+)/Loss(-)inUSD100%75%50%25%0%-8000-6000-4000-200002000400060001.011.221.48Finalvolume:
@#@25000Benefit(+)/Loss(-)inUSD100%75%50%25%0%-7000-5000-3000-100010003000500070001.011.221.48Finalvolume:
@#@10000Benefit(+)/Loss(-)inUSD100%75%50%25%0%-4000-3000-2000-10000100020003000400050001.011.221.48Finalvolume:
@#@25000Benefit(+)/Loss(-)inUSD100%75%50%25%0%-7000-5000-3000-100010003000500070001.011.221.48Finalvolume:
@#@25000Benefit(+)/Loss(-)inUSD100%75%50%25%0%-7000-5000-3000-100010003000500070001.011.221.48Finalvolume:
@#@30000Benefit(+)/Loss(-)inUSD100%75%50%25%0%-8000-6000-4000-200002000400060001.011.221.48Finalvolume:
@#@10000Benefit(+)/Loss(-)inUSD100%75%50%25%0%-4000-3000-2000-10000100020003000400050001.011.221.48Finalvolume:
@#@25000Benefit(+)/Loss(-)inUSD100%75%50%25%0%-7000-5000-3000-100010003000500070001.011.221.48Finalvolume:
@#@25000Benefit(+)/Loss(-)inUSD100%75%50%25%0%-7000-5000-3000-100010003000500070001.011.221.48Finalvolume:
@#@30000Benefit(+)/Loss(-)inUSD100%75%50%25%0%-8000-6000-4000-200002000400060001.011.221.48Exp25000Optionsfee0.05Final25000Benefit(+)/Loss(-)inUSDUSDExchangeRate(USD/EUR)%CoverContractsOptionsOptionscost1.011.221.48100%0%100%1525.003725.00(1525.00)(1525.00)100%25%75%1143.752793.75(1143.75)(1143.75)100%50%50%762.501862.50(762.50)(762.50)100%75%25%381.25931.25(381.25)(381.25)100%100%0%0.000.000.000.0075%0%100%1143.754106.25(1143.75)(2768.75)75%25%75%857.813407.81(857.81)(2482.81)75%50%50%571.882709.38(571.88)(2196.88)75%75%25%285.942010.94(285.94)(1910.94)75%100%0%0.001312.500.00(1625.00)50%0%100%762.504487.50(762.50)(4012.50)50%25%75%571.884021.88(571.88)(3821.88)50%50%50%381.253556.25(381.25)(3631.25)50%75%25%190.633090.63(190.63)(3440.63)50%100%0%0.002625.000.00(3250.00)25%0%100%381.254868.75(381.25)(5256.25)25%25%75%285.944635.94(285.94)(5160.94)25%50%50%190.634403.13(190.63)(5065.63)25%75%25%95.314170.31(95.31)(4970.31)25%100%0%0.003937.500.00(4875.00)0%0%100%0.005250.000.00(6500.00)0%25%75%0.005250.000.00(6500.00)0%50%50%0.005250.000.00(6500.00)0%75%25%0.005250.000.00(6500.00)0%100%0%0.005250.000.00(6500.00)BestStrategy%CoverContractsOptionsOptionscost1.011.221.48100.00%100.00%0.00%0000FinalvolumeBestStrategy%CoverContractsOptionsSTD100.00%100.00%0.00%0.005250.0011.041.081.121.16100002,200.001,800.001,400.001,000.00600.00105002,310.001,890.001,470.001,050.00630.00110002,420.001,980.001,540.001,100.00660.00115002,530.002,070.001,610.001,150.00690.00120002,640.002,160.001,680.001,200.00720.00125002,750.002,250.001,750.001,250.00750.00130002,860.002,340.001,820.001,300.00780.00135002,970.002,430.001,890.001,350.00810.00140003,080.002,520.001,960.001,400.00840.00145003,190.002,610.002,030.001,450.00870.00150003,300.002,700.002,100.001,500.00900.00155003,410.002,790.002,170.001,550.00930.00160003,520.002,880.002,240.001,600.00960.00165003,630.002,970.002,310.001,650.00990.00170003,740.003,060.002,380.001,700.001,020.00175003,850.003,150.002,450.001,750.001,050.00180003,960.003,240.002,520.001,800.001,080.00185004,070.003,330.002,590.001,850.001,110.00190004,180.003,420.002,660.001,900.001,140.00195004,290.003,510.002,730.001,950.001,170.00200004,400.003,600.002,800.002,000.001,200.00205004,510.003,690.002,870.002,050.001,230.00210004,620.003,780.002,940.002,100.001,260.00215004,730.003,870.003,010.002,150.001,290.00220004,840.003,960.003,080.002,200.001,320.00225004,950.004,050.003,150.002,250.001,350.00230005,060.004,140.003,220.002,300.001,380.00235005,170.004,230.003,290.002,350.001,410.00240005,280.004,320.003,360.002,400.001,440.00245005,390.004,410.003,430.002,450.001,470.00250005,500.004,500.003,500.002,500.001,500.00255005,610.004,590.003,570.002,550.001,530.00260005,720.004,680.003,640.002,600.001,560.00265005,830.004,770.003,710.002,650.001,590.00270005,940.004,860.003,780.002,700.001,620.00275006,050.004,950.003,850.002,750.001,650.00280006,160.005,040.003,920.002,800.001,680.00285006,270.005,130.003,990.002,850.001,710.00290006,380.005,220.004,060.002,900.001,740.00295006,490.005,310.004,130.002,950.001,770.00300006,600.005,400.004,200.003,000.001,800.00(1525.00)(5250.00)1.01(1525.00)(5250.00)1.02(1525.00)(5000.00)1.03(1525.00)(4750.00)1.04(1525.00)(4500.00)1.05(1525.00)(4250.00)1.06(1525.00)(4000.00)1.07(1525.00)(3750.00)1.08(1525.00)(3500.00)1.09(1525.00)(3250.00)1.1(1525.00)(3000.00)1.11(1525.00)(2750.00)1.12(1525.00)(2500.00)1.13(1525.00)(2250.00)1.14(1525.00)(2000.00)1.15(1525.00)(1750.00)Options,4975.00Forwards,6500.00ForwardsvsOptions1.011.061.111.161.211.261.311.361.411.46(6000.00)(4000.00)(2000.00)0.002000.004000.006000.008000.001.16(1525.00)(1500.00)1.17(1525.00)(1250.00)1.18(1525.00)(1000.00)1.19(1525.00)(750.00)1.2(1525.00)(500.00)1.21(1525.00)(250.00)1.22(1525.00)0.001.23(1275.00)250.001.24(1025.00)500.001.25(775.00)750.001.26(525.00)1000.001.27(275.00)1250.001.28(25.00)1500.001.29225.001750.001.3475.002000.001.31725.002250.001.32975.002500.001.331225.002750.001.341475.003000.001.351725.003250.001.361975.003500.001.372225.003750.001.382475.004000.001.392725.004250.001.42975.004500.001.413225.004750.001.423475.005000.001.433725.005250.001.443975.005500.001.454225.005750.001.464475.006000.001.474725.006250.001.484975.006500.00Options,4975.00Forwards,6500.00ForwardsvsOptions1.011.061.111.161.211.261.311.361.411.46(6000.00)(4000.00)(2000.00)0.002000.004000.006000.008000.00100.00%100.00%0.00%1000050.00%37.50%12.50%1050050.00%37.50%12.50%1100050.00%37.50%12.50%1150050.00%37.50%12.50%STD1200050.00%50.00%0.00%2474.871250050.00%50.00%0.00%1856.161300050.00%50.00%0.00%1237.441350050.00%50.00%0.00%618.721400050.00%50.00%0.00%0.001450050.00%50.00%0.00%1500075.00%56.25%18.75%2933.881550075.00%56.25%18.75%2484.071600075.00%56.25%18.75%2040.661650075.00%56.25%18.75%1608.911700075.00%56.25%18.75%1201.491750075.00%75.00%0.00%1800075.00%75.00%0.00%3501.981850075.00%75.00%0.00%3217.821900075.00%75.00%0.00%29
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Hedging Currency Risks at AIFS