In this video you'll learn how to determine the price of a bond that makes semiannual coupon payments (as most corporate bonds in the US do). Additionally, you'll see how you can easily calculate the price of a bond in Excel using =pv() and =price() function.

Students will particularly find this video useful in understanding parts of Chapter 8 (Interest Rates and Bond Valuation) of Corporate Finance (13th Edition) by Ross, Westerfield, Jaffe and Jordan.