Excel File Edit View Insert Format Tools Data Window Help 82% Fri 8:38 PM Tony Laaksonen AutoSave OFF 5 PS#3Data(FIN3520) Home Insert Draw Page Layout Formulas Data Review View Share Verdana (Body) 12 A A Paste B I U General $ % 9 .00 0 Conditional Format Cell Formatting as Table Styles Insert Delete Format X M Z Sort & Filter Find & Select J19 fx A B C D E F G H I J K L M N 1 Today is 5/15/2018 2 Table 3.3 Treasury Bond 3 Maturity Coupon 4 5/15/21 4.25 Bid 102.5585 Asked 5 11/15/39 6.50 102.8077 137.4301 137.7822 Chg -0.21 Ask Yield 3.26 0.12 3.95 6 Table 3.4 7 68 Excel Duration Function DURATION(settlement, maturity, coupons, yld, frequemcy, [basis]) Before you write the formula identify all inputs Settlement: enter today's date as serial date number 9 10 Maturity: enter maturity date as serial date number 11 Coupons: enter annual coupon rate 12 13 14 yld: enter the bond's current annual YTM Frequency: # times interest is paid per year = Basis: Counting Convention # = 15 Table 3.5 Convexity Template 16 1 2 3 4 5 PVCF 17 Date t CFt Time- Weight CF 222222222 18 (1+i)* (t+t)*CF 19 11/15/18 20 5/15/19 21 11/15/19 5/15/20 23 11/15/20 24 5/15/21 25 26 Performance Duration Money Market + APR 10 6 PV of TWCF (4) * (5) W X P TR PNG Comments 4 Ideas P 82%