# Price Function

#### rum63

##### New Member
The PRICE function in Excel has limitations on the YIELD argument (Must be positive) and the Frequency (number of coupon payments per year - wont accept 12 for monthly)

How can I price a bond that pays on a monthly basis or has a negative yield

### Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

#### Geckox

##### New Member
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?

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,167,994
Messages
5,856,699
Members
431,828
Latest member
kARTIK12345

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back