Microsoft Office Tutorials and References
In Depth Information
Playing What-If with Goal Seeking
Figures 8-5 and 8-6 illustrate how you can use the Goal Seek feature to find
out how much sales must increase to realize first quarter net income of
$225,000 (given certain growth, cost of goods sold, and expense
assumptions) in a sales forecast table.
Figure 8-5:
Use goal
seeking
to find out
how much
sales must
increase to
reach a
target income.
Figure 8-6:
Forecast
spreadsheet
showing
goalseeking
solution.
Search JabSto ::




Custom Search