Microsoft Office Tutorials and References
In Depth Information
One More Example—If You Have a Ready Model
FIGURE 15.2 Creating a Name in Excel
FIGURE 15.3 Functions and Formulas with Names
part of Excel
s requirements for the Payment function (otherwise, it will result in a
What you really want to see are functions or formulas that convey the infor-
mation to the analyst or to any other potential audience. The way to make the
models meaningful is to change the names of the cells in column B to be meaningful
names. This will make the model very clear and transparent to any reader.
To change the names of the cells in column B, simply apply the following
Select the two columns with the model A1:B9 on the sheet Car Loan.
Under the Formulas ribbon, click Create from Selection in the Name Manager
See Figure 15.2 for the way it is done.
Once you create the names and enter the formulas and functions, your model
will make much more sense. See Figure 15.3.
ONE MORE EXAMPLE—IF YOU HAVE A READY MODEL
In the following example, I received a ready-made Projections Statement where the
formulas were already created. See the sheet BEP Example no names in the Chapter