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 options setup
Goal Seek Results: The value is $8,050 in new product revenue will yield a profit of 10K.