|
|
|
Exhibit 1
|
|
|
The one-variable data table can give the cash flow picture automatically.
|
|
|
|
Exhibit 2
|
|
|
Set up the one-variable data table directly below the original data to speed the solution.
|
|
|
|
Exhibit 3
|
|
|
Tell the spreadsheet where to find the needed data—in a row or a column.
|
|
|
|
Exhibit 4
|
|
|
This what-if feature provides instant documentation of the substitution process.
|
|
|
|
Exhibit 5
|
|
|
The spreadsheet program also can handle a two-variable data table.
|
|