Future and Preset Values

Расчет будущей и приведенной стоимости Excel

Calculate Net present value and Internal rate of return using formulas MS 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.

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.

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.

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.

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.