Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started