Chad,

If you want to check if your calculation of payback periods is correct there
is an interesting table
(figure 7-2)on page 114 of the book called "Wall Street On Sale" by Timothy
P. Vick that shows the payback periods for stocks.

I have always wanted to know how that table was calculated. So
your question and the answers to it is particularly interesting to me.

Thanks for asking it.

If PBP = PV/PMT it should be relatively easy to calculate since Excel has
a PV and a PMT functions. I'll give it a try.

Cheers. BobB


"Chad" wrote in message
...
Hey all,

Does anyone have a macro for calculating payback period??
I need some help thanks