Added “Par Cpn” and “Strip B/E Par Cpn” columns, where Strip B/E Par Cpn uses “Strip B/E SP Px” as the principal price instead of the market price. Also available in USD Bond sheet
The new column leverages the Par Coupon to calculate the Strip Breakeven in lieu of the bond’s market price.
Strip B/E Par Coupon = (100-SP B/E Px) / (whole bond px - SP B/E px) * whole bond coupon
Par Coupon = (100 - SP Bond px) / (whole bond px - SP bond px) * whole bond coupon
