Question: Just need help finding the excel functions for the highlighted total return computation. The answers are there, just not sure how to get them through

Just need help finding the excel functions for the highlighted total returnJust need help finding the excel functions for the highlighted total return computation. The answers are there, just not sure how to get them through excel.

Inputs Settlement Maturity Annual Coupon rate Maturity value, % of par Current price, % of par Call price, % of par First callable on Put price, % of par Putable on Coupons per year Basis Yield change (for E7) 9/30/2019 9/30/2031 7.00% 100 103.25 105 9/30/2022 Output Yield to maturity Yield to first call Yield to put Macaulay Duration Modified Duration New Price if YTM changes by amount in B13 % Price Change if YTM changes by % in B13 6.60% 7.30% *Called on date in cell B8. 5.37% *Put on the date in cell B10 8.38 8.11 97.99 -5.09% *Actual (not estimated by dur-n) 95 9/30/2024 0.65% Information to compute total return Number of reinvested coupons Annual coupon reinvest.rate Selling price, % of par 7 4.60% 102.50 Total return computation FV of reinvested coupons, % of par Total accumulated, % of par Annualized total return 26.26 128.76 6.41% Use Excel functions whenever possible. Refer to cells rather than input numerical values! I grade procedures, not answers; you will lose points if your output (answers) does not change when the relevant inputs change. You should not have anything in cells other than the shaded ones (i.e., no intermediate computations are needed)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!