# Future and Preset Values ### NPV and IRR in EXCEL

Calculate Net present value and Internal rate of return using formulas MS EXCEL.

### Depreciation in Excel

Consider the methods to calculate the depreciation using MS EXCEL. In this article, we are going to start not from the features of APL (SLN), SYD (SYD), USF (DB), DOB (DDB), puo (VDB), AMOROUS (AMORLINC), AMORUM (AMORDEGRC), and the methods of depreciation adopted in Russia.

### Future value and FV Function in EXCEL

Calculate the Future value of an investment for different ways of calculating interest: according to the formula of simple interest, compound interest and annuity formula.

### Annuity in EXCEL. Calculating the future value

Determine the Future value of an investment in the case of an annuity. An investment will understand how regular contributions and initial payment. For this, we use the function BS(). Also derive an alternative formula for calculating Future value.

### Annuity in EXCEL. Calculating the Present value

Define Given (current) value of future incomes (or costs) in the case of an annuity. For this, we use the function PS(). Also derive an alternative formula for the calculation of fair value.

### Present value and PV Function in EXCEL

Calculate Given (to current moment) value investments at various ways of calculation of interest: according to the formula of simple interest, compound interest, annuity, and in the case of payments of arbitrary size.