G Guest Apr 5, 2006 #1 I want to use the YIELD function for payments received monthly. Is there a way to include 12 in the frequency?
I want to use the YIELD function for payments received monthly. Is there a way to include 12 in the frequency?
G Guest Apr 5, 2006 #2 YIELD(settlement,maturity,rate,pr,redemption,frequency,basis) Frequency is the number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4; for monthly, frequency = 12 . HTH,
YIELD(settlement,maturity,rate,pr,redemption,frequency,basis) Frequency is the number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4; for monthly, frequency = 12 . HTH,
F Fred Smith Apr 6, 2006 #3 While this would make eminent sense, unfortunately, Yield does not support monthly payments. A frequency of 12 gets you a #Num error. Many people have requested this enhancement. Hopefully Microsoft will support this in the next release.
While this would make eminent sense, unfortunately, Yield does not support monthly payments. A frequency of 12 gets you a #Num error. Many people have requested this enhancement. Hopefully Microsoft will support this in the next release.
