| 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to calculate bond value and current yield
look in the help index for
FINANCIAL FUNCTIONS One you will find is PV -- Don Guillett Microsoft MVP Excel SalesAid Software "Gary" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to calculate bond value and current yield
In addition, have a look at the the functions available through Analysis
Toolpak, an Excel add-in. -- http://www.wimgielis.be = Excel/VBA, soccer and music "Don Guillett" wrote: look in the help index for FINANCIAL FUNCTIONS One you will find is PV -- Don Guillett Microsoft MVP Excel SalesAid Software "Gary" wrote in message ... 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? |
| Reply |
| 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) | |||
Hybrid Mode
