-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Excel Facts
Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
I have also come across the challenge of trying to calculate the Price for a bond with a negative yield.
For example, the price for the current German 5-year government bond was 97,782 with a yield of 0,45%.
=PRICE(DATE(2022,4,18),DATE(2027,4,16),0,0.0045,100,1,1)
Now I would like to calculate the price if the yield where to drop by 50 basis points:
=PRICE(DATE(2022,4,18),DATE(2027,4,16),0,-0.0005,100,1,1)
As expected I get an error (#NUM!).
Any ideas on how to get the price?
For example, the price for the current German 5-year government bond was 97,782 with a yield of 0,45%.
=PRICE(DATE(2022,4,18),DATE(2027,4,16),0,0.0045,100,1,1)
Now I would like to calculate the price if the yield where to drop by 50 basis points:
=PRICE(DATE(2022,4,18),DATE(2027,4,16),0,-0.0005,100,1,1)
As expected I get an error (#NUM!).
Any ideas on how to get the price?
Upvote
0
Similar threads
- Replies
- 9
- Views
- 548
- Replies
- 1
- Views
- 329
- Replies
- 7
- Views
- 399
