Использование OpenOffice.org Calc для решения экстремальных задач в экономике. Еременко А.В. - 4 стр.

                                                                                           4
11 Функции для расчета по способу уменьшаемого остатка.................................................................43
    11.1 Функция DB....................................................................................................................................................................43
    11.2 Функция VDB.................................................................................................................................................................45

12 Функции наращения и дисконтирования доходов и затрат...............................................................49
    12.1 Функция FV....................................................................................................................................................................49
    12.2 Функция FVSCHEDULE................................................................................................................................................52
    12.3 Функция PV....................................................................................................................................................................53
    12.4 Функция NPER...............................................................................................................................................................55
    12.5 Функция RATE................................................................................................................................................................57
    12.6 Функция INTRATE.........................................................................................................................................................59
    12.7 Функция EFFECTIVE....................................................................................................................................................60
    12.8 Функция EFFECT_ADD................................................................................................................................................61

13 Функции различных видов платежей в заданном платежном периоде...........................................62
    13.1 Функция PMT.................................................................................................................................................................62
    13.2 Функция IPMT................................................................................................................................................................64
    13.3 Функция PPMT...............................................................................................................................................................65
    13.4 Функция CUMPRINC_ADD..........................................................................................................................................68
    13.5 Функция CUMIPMT_ADD............................................................................................................................................69

14 Функции оценки эффективности капиталовложений.......................................................................70
    14.1 Функция NPV..................................................................................................................................................................70
    14.2 Функция IRR...................................................................................................................................................................72
    14.3 Функция MIRR...............................................................................................................................................................73
    14.4 Функция XNPV...............................................................................................................................................................74
    14.5 Функция XIRR................................................................................................................................................................75

15 Другие функции....................................................................................................................................77
    15.1 Функция YIELDDISC.....................................................................................................................................................77
    15.2 Функция DISC................................................................................................................................................................78
    15.3 Функция RECEIVED......................................................................................................................................................79
    15.4 Функция PRICEDISC.....................................................................................................................................................81
    15.5 Функция ISPMT..............................................................................................................................................................82
    15.6 Функция CUMPRINC.....................................................................................................................................................84
    15.7 Функция CUMIPMT.......................................................................................................................................................85