Answered step by step
Verified Expert Solution
Link Copied!

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.image text in transcribed

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

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

Intermediate Financial Management

Authors: Eugene F Brigham, Phillip R Daves

9th Edition

032431986X, 9780324319866

More Books

Students also viewed these Finance questions

Question

Where is the position?

Answered: 1 week ago

Question

Why are employees considering union representation?

Answered: 1 week ago

Question

What is the total annual turnover rate?

Answered: 1 week ago