8. Excel For Finance Tips - What is Yield ?
What is Yield ?
Remember IRR ?... well, simply put, it's another name for that.
It's the return you get from a series of cash flows, but applies mostly to Bonds. Lets prove that using Excel functions.
Here, we have a 5 year Zero Coupon Bond that trades at 75. This means that you pay 75 for it today, and get back 100 in 5 years time.
I have entered 2 calculations:
- IRR
- Yield
- Note: The results are both the same.. 5.92%
Lets see what it looks like for a 5 year 5% coupon bond. A 5% coupon bond is a bond that pays 5 every year for 5 years, then pays another 100 at year 5.
- Note: IRR and YIELD both return the same.. 11.92%
IRR and YIELD are not always the same.. YIELD is a more complicated version of IRR, but if we assume annual cash flows, we can make the functions return the same result.
Download Spreadsheet to look at YIELD and IRR in Excel
Training Video on: What is Yield ?
Attachment | Size |
---|---|
YIELD-IRR-Excel.xls | 19.5 KB |
- Nick's blog
- Login or register to post comments
- 8055 reads
Recent comments
5 years 44 weeks ago
6 years 30 weeks ago
6 years 42 weeks ago
6 years 44 weeks ago
6 years 45 weeks ago
6 years 51 weeks ago
7 years 7 weeks ago
7 years 7 weeks ago
7 years 7 weeks ago
7 years 7 weeks ago