Hi! I asked in class test many time before.This time is that I have an exam on next Saturday, which is on November 7. Subject is Advanced Investment Finance.But, the thing is that the exam will be in class exam during 2 hours. Can the expert be ready on coming the exam date? (Nov7, 9AM, U.S New York time)One more thing is that exam will be on Excel test. (Surely, I will provide review class, Zoom lecture class)
Sheet1 Problem 13-2a-13.2b Use the table below to complete the spreadsheets below CALLPUT Exercise PriceMarchAprilMayMarchAprilMay (X) 15020.0021.5023.003.003.504.45 15515.5016.2517.754.104.905.90 16012.5012.8513.505.306.006.80 1658.109.0010.657.008.009.20 1705.206.308.509.4010.7512.45 1753.254.255.7513.0014.3014.20 1802.503.404.4515.0016.1017.75 INPUTOUTPUT aActionDateOptionExercise PriceStock PricePremium (Pay)/RecPayoffProfit /LossBE (Stock)HPR % BuyMarchCall150175 BuyAprilCall165165 BuyMayPut170160 Buy MarchPut180162 SellMayPut165125 SellAprilPut175165 SellMayCall155180BE2 (Stock) SellAprilCall150165 SellMayStraddle175200 BuyMarchStraddle180185 INPUTOUTPUT bActionDateOptionExercise Price 1Exercise Price 2Stock PricePremium (Pay)/RecTotal PayoffTotal Profit/Loss BuyMarchBull Call Spread150160170 BuyAprilBull Put Spread160180162 BuyMayBear Put Spread170180150 BuyAprilBear Call Spread160170170 BuyMarchButterfly Call Spread150160165 SellMayButterfly Call Spread170180200 Sheet1 Problem 13-1 Please Complete the Output section given the information below INPUTOUTPUT ActionOptionExercise PricePremiumStock PricePayoff Profit /LossBE Stock BuyCall1409165 BuyCall62559 BuyPut46538 Buy Put66966 SellPut13211126 SellPut1279128 SellCall1566152 SellCall1438145BE Stock 2 SellStraddle12021135 BuyStraddle9513125 Problem 11-9 Chapter 11 - Probem 11-9 I N P U TTrading DateMonday, May 15, 2017 Settlement Date (T+3 Business Days)Thursday, May 18, 2017 Market Price96.50 Coupon Rate8.250%=PRICE(M4,M5,M6,M7,M8,M9) Coupon Dates M&S (Mar 31 and Sep 30)=COUPDAYBS(M4,M5,2,1) Semi-Annual Coupon Payment$41.25 Face Value$1,000=COUPDAYS(M4,M5,2,1) Accrued Basis360Days=(M12/M13)*M6*100/2 =+M11+M14 OUTPUTMarket Price Paid $965.00 $96.50 x 10 Accrued Expenses$11.00 41.25 x (48 / 180) = 11.00 Invoice Price$976.00 Total Days48 DRAW THE DATES 5/18 $41.25$41.25 3/314/305/316/307/318/319/30 DAYS =3018 T + 3 business Days 48 Days Problem 11-10 Chapter 11 - Probem 11-10 I N P U TTrading DateThursday, July 22, 2010 Settlement Date (T+3 Business Days)Tuesday, July 27, 2010 Market Price101.25 Coupon Rate6.750%=PRICE(M4,M5,M6,M7,M8,M9) Coupon Dates M&N (May 31 and Nov 30)=COUPDAYBS(M4,M5,2,1) Semi-Annual Coupon Payment$33.75 Face Value$1,000=COUPDAYS(M4,M5,2,1) Accrued Basis360Days=(M12/M13)*M6*100/2 =+M11+M14 OUTPUTMarket Price Paid $1,012.50 $101.25 x 10 Accrued Expenses$10.69 33.75 x (57 / 180) = 10.68 Invoice Price$1,023.19 Total Days57 DRAW THE DATES 7/27 $33.75$33.75 5/316/307/318/319/3010/3111/30 DAYS =3027 T + 3 business Days 57 Days Problem 11-14 Chapter 11 - Probem 11-14 CALCULATING THE YTM Settlement Date (SD) =2/15/20 Maturity Date (MD) =6/30/25 Coupon Rate (CR) =7.500% Market Price (MP) = 98.750 Redemption value % (R) =100 Coupon Pmts per year (Frequency (F) =2 Yield to Maturity (YTM) =7.79% =YIELD(D6,D7,D8,D9,D10,D11) = YIELD (SD,MD,CR,MP,R,F) Problems 11-15 Chapter 11 - Probem 11-14 Face Value1,000 Coupon Rate7.75% Life in Years4 Yield8.25% Frequency2 Bond Price$983.25=-PV(E9/E10,E8*E10,E7*E6/E10,E6) Macaulay Duration3.51 Modified Duration3.4%=+E13/(1+E9/E8)/100 Convexity12.881.31%=+E17/E11 PeriodCash FlowPV Cash FlowWeightedDuration CalcFactor yearsConvexity Calc 0($983.25) 138.7537.213.785%0.037852.00074.43 238.7535.743.635%0.072706.000214.44 338.7534.323.491%0.1047312.000411.90 438.7532.963.353%0.1341120.000659.30 538.7531.663.220%0.1609930.000949.77 638.7530.403.092%0.1855442.0001,277.00 738.7529.202.970%0.2078856.0001,635.21 81,038.75751.7576.455%6.1163972.00054,125.69 100.000%7.02018=SUM(G21:G30)59,347.74 DURATION AND CONVEXITY FORMULAS PRICE983.25 DURATION3.51=+G31/2CONVEXITY12.88