Asset Cash Flow Generation 41
value that is greater than or equal to the lookup value. Using 1 or−1 requires the
array or list to be placed in order, so try to use 0 if possible.
MOD
The MOD function is a mathematical function that returns the remainder after a
number has been divided by a divisor. There are only two parameters for MOD, the
number that is to be divided and the divisor.
PMT
A useful function for finance is the PMT function. This function takes a rate, a term,
and a principal amount and returns the payment necessary to amortize the principal
amount within the term given. The specific parameters include:
=PMT(rate, term, principal balance)
Always be certain that the rate corresponds to the term. For example, if the term
is on a monthly basis the rate needs to be adjusted so that it is a monthly rate. Also,
the PMT function’s default setting is to return the payment as a negative value, so
either a negative needs to be put in front of the formula or other formulas have
to work with a negative payment value. Project Model Builder assumes all positive
values and requires the negative to be in front of the function.
