Financial module

  • DDB - depreciation of an asset via the Double-Declining Balance method
  • FV - future value of an investment with constant deposits and interest
  • Pmt - payment for a loan with constant payments and interest
  • IPmt - interest payment for a loan with constant payments and interest
  • PPmt - principal payment for a loan with constant payments and interest
  • SYD - sum-of-years’ digits depreciation of an asset
  • SLN - straight-line depreciation of an asset in one period
  • PV - present value of investment
  • IRR - internal rate of return for a series of cash flows
  • MIRR - modified internal rate of return for a series of cash flow
  • Rate - interest rate per period of an annuity
  • NPV - net present value of an investment
  • NPer - number of periods for an investment with constant deposits and interest

Warning

Work in Progress Below

DDB

FV

PMT

IPmt

PPmt

SYD

SLN

PV

IRR

MIRR

Rate

NPV

NPer