Price formula for Bond Valuation

PHPOffice / PhpSpreadsheet

A pure PHP library for reading and writing spreadsheet files

https://phpspreadsheet.readthedocs.io

MIT License

13.34k stars 3.46k forks source link

Price formula for Bond Valuation #4175

Open AshikurRahmanTusar opened 1 month ago

AshikurRahmanTusar commented 1 month ago

The price formula does not provide the correct value in two scenarios:

When the settlement date falls between the last coupon dates. In a leap year, the price is inaccurate for semi-annual coupons when the settlement date is after the second coupon date.

oleibman commented 1 month ago

Please provide some examples where the calculated value does not meet your expectations.