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’s 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 Excel enables you to compute a value for a spreadsheet input that makes the value of a given formula match the goal you specify. For example, in our lemonade store example from Chapter 15, suppose we charge $3.00 a glass. We want to know how many glasses we need to sell to break even. We can use Goal Seek to ...