NPV on a Quaterly Basis
 

Is there a formula for calcing Net Present Value on a quaterly basis?

NPV on a Quaterly Basis
 

NPV will do it for you. The input value must be spaced quarterly. See Excel
Help below

NPV(rate,value1,value2, ...)

Rate is the rate of discount over the length of one period.

Value1, value2, ... are 1 to 29 arguments representing the payments and
income.

Value1, value2, ... must be equally spaced in time and occur at the end of
each period.
NPV uses the order of value1, value2, ... to interpret the order of cash
flows. Be sure to enter your payment and income values in the correct
sequence.
Arguments that are numbers, empty cells, logical values, or text
representations of numbers are counted; arguments that are error values or
text that cannot be translated into numbers are ignored.
If an argument is an array or reference, only numbers in that array or
reference are counted. Empty cells, logical values, text, or error values in
the array or reference are ignored.


"Vick" wrote:

Is there a formula for calcing Net Present Value on a quaterly basis?