Problems

1. Add a spin button for the car NPV example that allows the tax rate to vary between 30 percent and 50 percent.

2. Add a spin button for the car NPV example that allows the interest rate to vary between 5 percent and 20 percent.

3. The Format Control dialog box allows a minimum value of 0. Despite this limitation, can you figure out a way to use a spin button to vary sales growth between –10 percent and 20 percent?

4. Using our lemonade example in Chapter 15, “Sensitivity Analysis with Data Tables,” create spin buttons that allow our inputs to vary within the following ranges:

   Open table as spreadsheet

   Input	Low value	High value
   Price	$2.00	$5.00
   Unit cost	$0.20	$1.00
   Fixed cost	$20,000.00	$100,000.00

5. Using the mortgage payment example in Chapter 15, create spin buttons that allow our inputs to vary within the following ranges:

   Open table as spreadsheet

   Input	Low value	High value
   Amount borrowed	$250,000	$800,000
   Number of months of payments	120	360
   Annual interest rate	4%	10%

6. For the weekend example used in Chapter 22, “Conditional Formatting,” set up a check box that will turn conditional formatting on or off.

7. In the financial formulas described in Chapter 9, “More Excel Financial Functions,” we use a last argument of 1 to indicate end of month cash flows and and 0 to indicate beginning of month cash flows. Excel recognizes a TRUE as equivalent to a 1 and a FALSE as equivalent to 0. Set up a worksheet where a user can enter the number of months in a loan, principal, and annual interest rate to find the monthly payment. Then use a check box to select whether the payments are at the beginning or end of the month.

8. The file Quarterly.xlsx contains quarterly sales at different department stores. Use option buttons to select the quarter and a list box to select the product. Your worksheet should then compute sales at a specified store during a specific quarter.