Question: How do I make a graph like this in excel? I have the data for mine but this is the model and I can not

How do I make a graph like this in excel? I have the data for mine but this is the model and I can not figure how to do the negative and positives on the right side of the graph and get the lines the way I need it.How do I make a graph like this in excel? I have

100 80 60 Actual price change 200 Figure A 40 150 Percentage change in bond price 20 Duration approximation 100 B Percentage change in bond price + + -4 -3 -2 -1 0 1 2 3 4 5 50 -20 0 4 -3 -2 -1 0 3 4 5 -40 Initial Bond Coupon Maturity YTM 12% 5 years 10% B 12% 30 years 10% 3% 30 years 10% D 3% 6% cava -50 30 years -60 Change in yield to maturity (percentage points) Change in yield to maturity (percentage points) 100 80 60 Actual price change 200 Figure A 40 150 Percentage change in bond price 20 Duration approximation 100 B Percentage change in bond price + + -4 -3 -2 -1 0 1 2 3 4 5 50 -20 0 4 -3 -2 -1 0 3 4 5 -40 Initial Bond Coupon Maturity YTM 12% 5 years 10% B 12% 30 years 10% 3% 30 years 10% D 3% 6% cava -50 30 years -60 Change in yield to maturity (percentage points) Change in yield to maturity (percentage points)

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!