Bonds A Step by Step Analysis with Excel (Chapter 1, Pricing and Return; Chapter 2, Bond Price Volatility: Duration and Convexity) by Dumrauf Guillermo L

Author:Dumrauf, Guillermo L. [Dumrauf, Guillermo L.]
Language: eng
Format: epub
Publisher: Guillermo L. Dumrauf
Published: 2013-11-29T16:00:00+00:00

Figure 1.8 XIRR function or IRR for non-periodic cash flows

You have noticed that there is a column C named “PVCF” that contains the present value of each cash flow, which was calculated using the yield as a discount rate. The total of column C appears in cell C28 and it is equal to the bond price. This result is obvious, but it is not only a sanity check for our calculations; it will be useful when we will have to calculate the duration and convexity in the chapter “Bonds, Duration and Convexity”.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.