Hi Karen

Welcome to the forum. I, for one, would not complete somebody's homework assignment but if you have a particular problem with Excel then I would offer assistance to point you in the right direction if I could.

Do you have a workbook that you can post?

You surely have an idea about discounted cash flow analysis and I have found at least one place through searching the web that may be able to give you what you want. Perhaps that could be your next point of call.

Good luck.