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
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
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.