Goal Seek

Goal seek allows you to solve for an unknown value in your spreadsheet such that it causes some other cell to take on a specific value. We introduced this for break-even analysis, and then used it to calculate internal rate of return.