Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Yield to Maturity
I am perplexed why does the Yield to Maturity function need to be fed an
"issue date" as a parameter? If I invest in a bond today with maturity of 2/1/2013 and the bond sell for 80% of par and has a 5% coupon, why would I care about an issue date? The formula is: YIELDMAT(settlement,maturity,issue,rate,pr,basis) -- W |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Current Yield vs. Yield to Maturity at low prices | Excel Worksheet Functions | |||
How to calculate the maturity value | Excel Worksheet Functions | |||
Does anyone know how to calculate Yield to Maturity using Exel? | Excel Worksheet Functions | |||
How do I make a template for Yield to Maturity? | Excel Worksheet Functions |