HomeОбразованиеRelated VideosMore From: TeachExcel

Bond Pricing, Valuation, Formulas, and Functions in Excel

336 ratings | 176075 views
Premium Course: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt Excel Tutorials: https://www.teachexcel.com/src=yt This tutorial will show you how to calculate bond pricing and valuation in excel. This teaches you how to do so through using the NPER() PMT() FV() RATE() and PV() functions and formulas in excel. To follow along with this tutorial and download the spreadsheet used and or to get free excel macros, keyboard shortcuts, and forums, go to: http://www.TeachMsOffice.com
Html code for embedding videos on your blog
Text Comments (26)
BHAVIK PATEL (4 months ago)
Super simply awesome thanks
BHAVIK PATEL (6 months ago)
You made it very simple thank you boss
Annmarie Clarke (11 months ago)
Absolute life saver, honest
Siddharth jain (2 years ago)
sir, what can i do if coupon interest rate is semiannually.
David Wu (2 years ago)
You just take everything in half terms. So if the coupon interest rate is 1% in semiannual terms, you can assume a 2% annual interest rate and vice versa. The only thing that will change from this is the number of periods you use. So in annual terms, ten years will have ten periods. On the other hand, semi-annual terms will have 20 years. Hope that helps
Rajesh Charania (2 years ago)
Simply Amazing !!!
John (2 years ago)
does this formula disregard discounting? - no mention of the interest rates in the formula
giovanni cherico (3 years ago)
Thank you very much. Your tutorial was incredibly helpful. Your instructions were clear and easily understood. This will save me time when I don't have my financial calculator with me.
Renjith R (4 years ago)
Great class .. All in one
Erica Torres (4 years ago)
Wow!!! Thank you, this was super helpful, you are amazing!!!
av8r49a (4 years ago)
Jfyi, the coupon pmt (cell b5) changes at 9:30 and when a change was made in cell b4 (the coupon rate) yet no formula, link, etc. between these cells was ever shown in the video…
Cody Felton (4 years ago)
A savings bond is a zero coupon bond. It has no coupons. 
Xiomara Ortiz (4 years ago)
what is a zero-coupon bond ?
giovanni cherico (3 years ago)
+Section82 Discount Bonds are bonds that don't make regular payments and pay the Face Value (FV) of the bond at maturity. I haven't heard of a zero bond but it seems to make sense.
Section82 (4 years ago)
A zero coupon bond is simply that - a bond that does not give out semi-annual coupon payments like a typical bond. It only pays back it's face value once it reaches maturity.
Stefan Smith (4 years ago)
I believe it's a bond that pays no interest.
HayhatMinaZila (4 years ago)
hello246n (4 years ago)
hi great video, how would you calculate expected yield of a bond?
M. Bumedien (5 years ago)
Did you visit drstock.org ?
dabuddha669 (6 years ago)
super helpful, now i can hand in my assignment on time, you rock!!!
Funtoosh4202 (6 years ago)
The narration is a bit boring. Still thanks for teaching
Sebastian Wendling (7 years ago)
@ExcelisHell Is there a fixed YTM function in excel or do we have to look it up online on stock exchange websites?
TeachExcel (8 years ago)
@EcoTZ1 have to go to teachmsoffice. com for that.
TeachExcel (8 years ago)
@tiger496 There is a yield to maturity function that I used to get it.
TeachExcel (9 years ago)
The first argument is for the "rate." For the formula you typed, that would be cell B7. The present value depends on the rate b/c that is going to be what you use to discount the future value and vice verse.
Ge Atherton (9 years ago)
Thank a lot, you juts made understand what my professor could not do in months, she was too fast. Jimmy

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.