Can I modify the YIELD formula to use a monthly frequency?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,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,
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Yield Function with Monthly Frequency 2
Problem with Yield() function 5
Current Yield vs. Yield to Maturity at low prices 1
How to calculate Yield using Yield Function by C# 0
How to write a formula to show the "last date" of a month 2
Loan Principal Payments 1
Frequency of Billing 2
Conditional Counting of Duplicated Names 4

Back
Top