Use Excel functions whenever possible. Refer to cells rather than input numerical values. If the output (answers) does not change when the relevant inputs change it is incorrect! You should not have anything in cells other than the shaded ones (i.e., no intermediate computations are needed).

E3 F G * Called on date in cell B8. *Put on the date in cell B10 *Actual (not estimated by dur-n) TB co Inputs Output 2 Settlement 9/30/2019 Yield to maturity 3 Maturity 9/30/2031 Yield to first call 4 Annual Coupon rate 7.00% Yield to put 5 Maturity value, % of par 100 Macaulay Duration 6 Current price, % of par 103.25 Modified Duration 7 Call price, % of par 105 New Price if YTM changes by amount in B13 8 First callable on 9/30/2022 % Price Change if YTM changes by % in B13 9 Put price, % of par 95 10 Putable on 9/30/2024 11 Coupons per year 12 Basis 13 Yield change (for E7) 0.65% 14 15 Information to compute total return Total return computation 16 Number of reinvested coupons FV of reinvested coupons, % of par 17 Annual coupon reinvest.rate 4.60% Total accumulated, % of par 18 Selling price, % of par 102.50 Annualized total return 19 E3 F G * Called on date in cell B8. *Put on the date in cell B10 *Actual (not estimated by dur-n) TB co Inputs Output 2 Settlement 9/30/2019 Yield to maturity 3 Maturity 9/30/2031 Yield to first call 4 Annual Coupon rate 7.00% Yield to put 5 Maturity value, % of par 100 Macaulay Duration 6 Current price, % of par 103.25 Modified Duration 7 Call price, % of par 105 New Price if YTM changes by amount in B13 8 First callable on 9/30/2022 % Price Change if YTM changes by % in B13 9 Put price, % of par 95 10 Putable on 9/30/2024 11 Coupons per year 12 Basis 13 Yield change (for E7) 0.65% 14 15 Information to compute total return Total return computation 16 Number of reinvested coupons FV of reinvested coupons, % of par 17 Annual coupon reinvest.rate 4.60% Total accumulated, % of par 18 Selling price, % of par 102.50 Annualized total return 19