PhpSpreadsheet
PhpSpreadsheet copied to clipboard
Price formula for Bond Valuation
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.
Please provide some examples where the calculated value does not meet your expectations.
Closing, no update in over 3 months, insufficient information to keep ticket open.