software

I want to use the YIELD function for payments received monthly. Is there a
way to include 12 in the frequency?


YIELD(settlement,maturity,rate,pr,redemption,frequ ency,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,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot;DDRquot; wrote:

gt; I want to use the YIELD function for payments received monthly. Is there a
gt; way to include 12 in the frequency?

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.

--
Regards,
Fredquot;Gary L Brownquot; gt; wrote in message
...
gt;
gt; YIELD(settlement,maturity,rate,pr,redemption,frequ ency,basis)
gt;
gt; Frequency is the number of coupon payments per year. For annual payments,
gt; frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4;
gt; for monthly, frequency = 12 .
gt;
gt;
gt; HTH,
gt; --
gt; Gary Brown
gt;
gt; If this post was helpful, please click the ''Yes'' button next to ''Was this
gt; Post Helpfull to you?''.
gt;
gt;
gt; quot;DDRquot; wrote:
gt;
gt;gt; I want to use the YIELD function for payments received monthly. Is there a
gt;gt; way to include 12 in the frequency?