Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What excel functions are used to get the outlined 3 (modified duration, new price, and % change). Those are the answers, just not sure how

image text in transcribedWhat excel functions are used to get the outlined 3 (modified duration, new price, and % change). Those are the answers, just not sure how to get them.

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 2 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions

Question

What is the cerebrum?

Answered: 1 week ago