Calculating Prices of Bonds with Semi-Annual Coupon Payments (Using Excel)

In this video you'll learn how to determine the price of a bond that makes semi-annual 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.

• #education
• #bond_price
• #coupon_payment
• #coupon_rate
• #pv_of_annuity
• #ytm
• #yield_to_maturity
• #pv
• #price
• #excel
• #semi_annual
• #corporate_bonds
• #semiannual_coupon
• #semiannual_yield
• #settlement_date
• #maturity_date
• #rwjj
• #ross
• #westerfield
• #jaffe
• #jordan
• #corporate_finance
• #pv
• #price