Tutorials by Brand:
Calculate Accrued Interest on a Bond in Excel – 3 Ways
Typically, in finance textbooks, bond valuation is discussed with a hidden assumption: that you are valuing the bond on a coupon payment date. If that is the case, then you can use the PV function to find the price (though there is another hidden assumption in there: that the yield curve is flat). The problem with this is that usually…