Please don't post to more than one newsgroup. See answer in other newsgroup

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Brad" wrote in message
...
How can I build a function that will calculate an effective yield rate
given
that an individual can put in a lump sum at issue, have a different
premium
contribution between year 1 and renewal year?