Goal Seek is a great feature in Excel to find a target value. You can find Goal Seek within the Data Tab under the what-if button. In this example, I will share with you how to answer how much new revenue much we achieve to produce $10,000 in profit.

goal seek profit

Goal Seek options setup

goal seek setup

Goal Seek Results: The value is $8,050 in new product revenue will yield a profit of 10K.

goal seek results