-
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
Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
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
