Microsoft Office Tutorials and References

In Depth Information

**Data Tables—One More Example**

FIGURE 17.10
Enter the Rate for the Column and the Number of Years for the Row

FIGURE 17.11
The Original Output Is Identical to the Original Model

Below the Payment value in E20, I listed the desired interest rates. To the right of

the Payment, I listed the number of years. This time when I use the data table, I

will input entries in both cells of the dialog box: the row input cell and the column

input cell.

For the row input cell, click on the cell containing the number of years in

the original model (cell B6) and for the column input cell, click on the cell with the

original interest rate (cell B5). See Figure 17.10.

Figure 17.11 shows the resulting output. Note that the original Payment value in

the cell corresponds to the intersection of three years and 8 percent interest. It is the

same as the Payment value of the original model. This is a good way to verify that

the table was correctly set up and that the parameters were accurately filled.

DATA TABLES—ONE MORE EXAMPLE

Let

s now illustrate the use of the data table for the Projections Statement example

used in the last two chapters. See Figure 17.12. In this example, the break-even point

was either 59,333 units or a selling price of $22.80. I used Goal Seek to figure this out

in Chapter 16.

’