Документ взят из кэша поисковой машины. Адрес оригинального документа : http://uneex.lorien.cs.msu.su/static/GnumericDoc_ru/r4323.html
Дата изменения: Mon Sep 26 12:35:55 2011
Дата индексирования: Tue Oct 2 07:30:47 2012
Кодировка: UTF-8
FVSCHEDULE

FVSCHEDULE

Name

FVSCHEDULE -- 

Synopsis

FVSCHEDULE(principal,schedule)

Description

FVSCHEDULE returns the future value of given initial value after applying a series of compound periodic interest rates. The argument @principal is the present value; @schedule is an array of interest rates to apply. The @schedule argument must be a range of cells.

Examples

Let us assume that the cells A1, A2, ..., A5 contain interest rates 0.11, 0.13, 0.09, 0.17, and 0.03. Then

FVSCHEDULE(3000,A1:A5) equals 4942.7911611.

See also

PV, FV.