"LaWhore Mama" wrote:
Just about an hour ago my CFO called me to come over to his offices.
[....]
This is what he had to say
"If an investment does not have a payback period then there is no
return from the investment. And an IRR and payback period have a
one to one relationship whereby an IRR occurs at the payback period."

So is there any way to find the payback period on this investment?

That is utter nonsense!

And you do not provide sufficient information to calculate either a payback
or discounted payback period.

Google "irr payback period" without quotes. You will find numerous sites
that explain that payback, IRR, average return, MIRR, NPV, etc are all
__different__ methods for making financial decisions.

To keep your job, you need to give your CFO what he wants -- whatever that
is. Frankly, I no longer know what that is.

But do take some time to educate yourself. Here are some interesting sites
to look at.

http://www.investopedia.com/walkthro...back-rule.aspx
http://www.investopedia.com/walkthro...te-return.aspx
http://www.investopedia.com/walkthro...ng-return.aspx

Note the additional links to related "chapters" and "sections" at the top of
the page.

Of course, the internet is not a reliable source of information. (That
might be "news" to some people.) But if you look at some other sites that
Google turns up, you will see a "common theme".

This will be my last response on the subject, since this is a financial
management issue, not an Excel question. Good luck!