Bond Pricing, Valuation, Formulas, and Functions in Excel
Loading...
Loading...
27,788
Link to this comment:
Share to:
Uploader Comments (ExcelisHell)
see all
All Comments (12)
-
@ExcelisHell Is there a fixed YTM function in excel or do we have to look it up online on stock exchange websites?
-
This is very helpful and thank you!!!
-
@tiger496 There is a yield to maturity function that I used to get it.
-
exciting
Loading...
- 6:58Copy Formulas and Functions to New Cells in Excelby ExcelisHell1,157 views
- 5:12Combine Multiple Functions into the Same Formul...by ExcelisHell1,162 views
- 9:07Double Vlookup in Excel - Use Multiple Vlookups...by ExcelisHell743 views
- 5:33Hide Vlookup Souce Data in Excelby ExcelisHell293 views
- 6:43How to Use an Excel Data Table for "What-if" An...by DannyRocksExcels18,074 views
- 3:07Introduction to Bondsby kanjohvideo6,820 views
- 10:05Crash Course in Bonds Part 1 - Yield to Maturityby kd0imh3,458 views
- 4:42Exam Preparation - Bond Valuation Usual Exam Qu...by MBAbullshitDotCom2,044 views
- 13:33Relationship between bond prices and interest r...by khanacademy39,257 views
- 10:01CFA Exam Prep: Level 1 Debt (fixed income ) Inv...by AllenResources16,838 views
- 11:21The basics of bondsby moneycontent14,129 views
- 9:53GFM07 - The meaning of net present value. (Part 1)by campbellharvey3,850 views
- 4:46Finding Bond Price and YTM on a Financial Calcu...by csbhatnagar10,549 views
- 2:07Yield Curve analysisby lordbinder21,018 views
- 9:17Understanding Fixed Income by 7city.comby 7citytube3,201 views
- 9:01The Basics of Bonds Valuationby jcbagneris2,950 views
- 8:44The Index and Match Spreadsheet Function in Excelby FinancialFluency816 views
- 8:24Forecast volatility with GARCH(1,1)by bionicturtledotcom29,643 views
- 7:38Bond Valuationby csbhatnagar4,959 views
how do I save this in my computer?
EcoTZ1 1 year ago
@EcoTZ1 have to go to teachmsoffice. com for that.
ExcelisHell 1 year ago
=PV(B7,B3,B5,B6,0)
Doesn't depend on "Coupon Rate", so why when you change it, it changes the Present Value?
Because whenever I change that value the PV doesn't update.
WMX010 2 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.
ExcelisHell 2 years ago