| The Projections NPV category calculates the Present
Values of some of the Projections functions.
Conventionally, when using Business Functions to do DCF,
you first or all prepare a full cash flow using projections
functions such as FStep, Con, or AnnGrow and calculate the Net
Present Value of the result. If you are confident of your
input data, there is of course no need to do this - the
function has sufficient information to calculate the NPV
directly. This category of functions takes the same input
data as you might use in the corresponding projections
function, and prepares a full cash flow internally within
Business Functions, which it then discounts. The effect is
exactly the same as doing the full cashflow in your
spreadsheet, but only using one cell and one function call,
instead of a whole cash flow of calculations. |