How to use goal seek in excel (windows vista) to find YTM to make NPV zero?

Question

I am trying to do an assignment in Excel for my financing class, and I don't know how to use the Excel function. I am looking for YTM guesses to make the NPV equal zero. The assignment tells me to use the "goal seek" function and it will automatically find the right input. Could anyone tell me how to use this...

Answer 1

Select the NPV formula cell

The NPV formula should have YTM as one of its factors within the formula.

From the Excel menu bar, click on Data
Locate the Data Tools panel and the What if Analysis item. From the What if Analysis menu, select Goal Seek.

Set Cell: should be the cell that calculates NPV
To Value: 0
By changing cell: cell that has YTM

Answer 2

http://www.teachexcel.com/tutorials/dataanalysis/goalseek.php

check that out on how to use the goal seek function. also, they have their own forum if you have any trouble