What are the formulas behind the YIELDDISC function?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CPodd - 07 Feb 2007 15:04 GMT

The YIELDDISC Function in EXCEL gives me my expected results. It is a great
ADD-IN Function. However, I have been asked to describe the Mathematical
Formulas behind this Function and YIELDDISC is a black box on this issue.

I know that it is based on IRR, but does anyone have a desciption (or a link
to a description) that would be more "Textbook"?

Thanks.

Reply to this Message

Dave F - 07 Feb 2007 15:08 GMT

There's a lot of information on the function at this link, however, I don't
see any information on the math behind it:
http://www.google.com/search?hl=en&q=YIELDDISC+function+excel

Dave

Signature

A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

> The YIELDDISC Function in EXCEL gives me my expected results. It is a great
> ADD-IN Function. However, I have been asked to describe the Mathematical
[quoted text clipped - 4 lines]
>
> Thanks.

Reply to this Message

CPodd - 07 Feb 2007 17:10 GMT

Thanks for the tip.

I found that the following document was the most helpful:

http://stuff.mit.edu/afs/athena/project/hose/www/formula1/Functionref.pdf

Regards, CPodd

> There's a lot of information on the function at this link, however, I don't
> see any information on the math behind it:
[quoted text clipped - 10 lines]
> >
> > Thanks.

Reply to this Message