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

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... show more 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 function?? I don't even know where to find it on the menu or anything. Thanks!!!
2 answers 2