[Solved] Pricing a bond

Narg

New member
I have a bond with a floating coupon off sofr. I did to discount the cash flows using a BBB muni curve and a liquidity premium. Since each cash flow is different, I don’t know how to do it. Can any of you help me with the formulae’s or an excel template ? Thanks
 
I have a bond with a floating coupon off sofr. I did to discount the cash flows using a BBB muni curve and a liquidity premium. Since each cash flow is different, I don’t know how to do it. Can any of you help me with the formulae’s or an excel template ? Thanks
The bond matures in 2037 and is callable
 
I have a bond with a floating coupon off sofr. I did to discount the cash flows using a BBB muni curve and a liquidity premium. Since each cash flow is different, I don’t know how to do it. Can any of you help me with the formulae’s or an excel template ? Thanks
Dear Narg

Thanks for reaching out and sharing your problem. We have reviewed your requirements. Hopefully, we will develop some helpful formulas; if possible, we will try to provide you with templates.

When we are done, we will let you know. Good luck.

Regards
Lutfor Rahman Shimanto
ExcelDemy
 
I have a bond with a floating coupon off sofr. I did to discount the cash flows using a BBB muni curve and a liquidity premium. Since each cash flow is different, I don’t know how to do it. Can any of you help me with the formulae’s or an excel template ? Thanks
Dear Narg

Thanks for your patience! The following Excel file provides a concise overview of the steps needed to use the bond pricing template.

Pricing A Bond.png

To use the bond pricing template effectively, follow the steps below:
  1. Input bond details: face value, coupon rate, and maturity date.
  2. Enter SOFR rate, BBmunicurve rate, and liquidity premium.
  3. The calculation will automatically be calculated to get the bond price.
  4. Review results and adjust inputs if needed.

I hope this guide helps you navigate and utilize the bond pricing template effectively. Feel free to reach out if you have any further questions or need additional assistance with your analysis.

Regards
ExcelDemy
 

Attachments

  • Pricing_A_Bond.xlsx
    11.2 KB · Views: 0

Online statistics

Members online
0
Guests online
67
Total visitors
67

Forum statistics

Threads
337
Messages
1,470
Members
624
Latest member
duytoi
Top