Excel can solve for unknown variables, either for a single cell with Goal Seek or multiple cells with Solver.

Excel's Goal Seek feature helps with reverse calculations in financial planning, like CVP analysis. Goal Seek can assist in NPV analysis by determining selling prices to reach certain targets.

Use the PMT function to calculate the Monthly Payment Now, we will use Goal Seek. On the Data tab, click the What-if Analysis button in the Forecast group and select Goal Seek from its menu.

This month’s column shows how to use Excel’s Goal Seek for data analysis.

Goal seeking is finding the correct input when only the output is known. This is often done using the goal seek function in Microsoft Excel or what-if analysis via computer programs. Goal-seek ...