If the period is say one month, and you wish to calculate using a competitive return known over one year, you might choose a discount rate of a twelfth of the competitive return - but be aware that this is not absolutely accurate. The discount rate chosen is assumed to compound each period.NPV(8.75% 1000 2000 3000) where the discount rate 8.75% is the assumed competitive return over one year, and 1000 is to be paid at the end of yat the end of year at the end of year 3, returns 4943.21 as currency. , pronunat /.pn fs dt org/, utilizând fonetismul limbii române u-pn a-fis dat org (abreviat uneori ca OOo sau OO.o) este o suit de software birotic liber (Open source).Proiectul se bazeaz pe codul surs al unei versiuni precedente a StarOffice, de la Sun Microsystems.

NPV calculates the net present value using the formula: It is assumed to be constant for all periods. The payments may be both positive and negative, for income and outgoing.ĭiscountrate is the discount rate (expressed as a fraction of 1) which you consider applies to one single period. Apache OpenOffice is a free open source office suite that includes six applications: Writer (word processor), Calc (spreadsheets), Impress (presentations), Draw (diagramming and graphics), Base (database), and Math (formulas). payment30) payment1 to payment30 are up to 30 numbers or ranges containing numbers, representing payments made at the end of each of a series of fixed length periods. Returns the net present value of an investment with regular cash payments.

Openoffice