Closed-from (analytical) bond price formula
We can solve for the price of a bond by recognizing that a coupon-bearing bond is equal to three positions: long perpetuity (coupon) + short forward start perpetuity (coupon) + long zero-coupon bond (face value). You can get a copy of the spreadsheet on the website.
Length:
06:10