| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to calculate bond value and current yield
A bond has a $1,000 par value, 12% coupon rate, interest on the bond is paid
annually, the current yield to maturity on the bond is 6%, and the maturity of the bond is 10 years. I'm having problems with the formula to compute the following: 1. What is the value of the bond? 2. What is the current yield on the bond? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does anyone know how to calculate Yield to Maturity using Exel? | Excel Worksheet Functions | |||
| yield on bond priced over 100 | Excel Worksheet Functions | |||
| How do I calculate yield for multiple coupon resets? | Excel Discussion (Misc queries) | |||
| how do you calculate "dividend yield using Excel? | Excel Discussion (Misc queries) | |||
| Bond Yield Template with Payment schecule and chart (Excel) | Excel Discussion (Misc queries) | |||
Threaded Mode
