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. Using ...
One way to improve your spreadsheet is to present data in chart form, and Excel is a great program for doing just this.