Chapter 18. The Goal Seek Command
Questions answered in this chapter:
For a given price, how many glasses of lemonade does a lemonade store need to sell per year to break even?
We want to pay off our mortgage in 15 years. The annual interest rate is 6 percent. The bank told us we can afford monthly payments of $2,000. How much can we borrow?
I always had trouble with “story problems” in high school algebra. Can Excel make solving story problems easier?
The Goal Seek feature in Microsoft Excel 2010 enables you to compute a value for a worksheet input that makes the value of a given formula match the goal you specify. For example, in the lemonade store example in Chapter 17, suppose you have fixed overhead costs, fixed per-unit costs, and a fixed sales ...