Say you have a quarterly Profit Statement and your Sales for Q1 and Q2 have been reasonably well but in Q3 they dropped dramatically. Â You are left with one quarter toÂ meet your Net Profit goal of \$200,000.

You can use ExcelÂ´s Goal Seek feature (under What If Analysis) to find out what Sales you need to achieve in Q4 in order to meet your Net Profit goal of \$200,000.

DOWNLOAD EXCEL WORKBOOK

STEP 1: Select the cell that you want to achieve your goal of \$200,000 which isÂ theÂ Total Net Profit in cell F7, which isÂ a Sum formula (Important: This cell must be a formula for the Goal Seek to work)

STEP 2: Go to Data > What If Analysis > Goal Seek

STEP 3:Â SET CELL:Â This is theÂ cell that contains theÂ goal we want to achieve, F7, and is selected automatically

STEP 4:Â TO VALUE: Type the goal value that you want to achieve. Â In our example, it will be 200,000

STEP 5:Â BY CHANGING CELL: Enter the reference for the cell that contains the input value that you want to adjust. Â In our example it is the Q4 Sales forecast in cell E5

STEP 6:Â Press OK and Goal Seek will run and produce a result. Â Press OK to keep the results or Cancel to discard

With Goal Seek we need to achieve Q4 Sales of \$437,730 in order to achieve our Net Profit goal of \$200,000. Â Over to the Sales team then to make it happen!

### HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

If you like this Excel tip, please share it

email

Pinterest

Facebook

Twitter

Linkedin