raft-0.3.7.2: Miscellaneous Haskell utilities for data structures and data manipulation.

Safe HaskellSafe
LanguageHaskell2010

Data.Function.Excel

Contents

Description

Several Microsoft Excel functions, adapted from https://gist.github.com/econ-r/dcd503815bbb271484ff.

Synopsis

Finance functions

pmt Source #

Arguments

:: Double

Interest rate per period.

-> Int

Total number of periods.

-> Double

Present value.

-> Maybe Double

Future value.

-> Maybe Bool

Whether payments are due at the beginning of each perioed.

-> Double

Payment per period.

Compute payments.

ipmt Source #

Arguments

:: Double

Interest rate per period.

-> Int

Period for which interest is to be computed.

-> Int

Total number of periods.

-> Double

Present value.

-> Maybe Double

Future value.

-> Maybe Bool

Whether payments are due at the beginning of each period.

-> Double

Interest payment.

Compute interest payment.

ppmt Source #

Arguments

:: Double

Interest rate per period.

-> Int

Period for which interest is to be computed.

-> Int

Total number of periods.

-> Double

Present value.

-> Maybe Double

Future value.

-> Maybe Bool

Whether payments are due at the beginning of each period.

-> Double

Interest payment.

Compute principle payment.

nper Source #

Arguments

:: Double

Interest rate per period.

-> Double

Payment per period.

-> Double

Present value.

-> Maybe Double

Future value.

-> Maybe Bool

Whether payments are due at the beginning of each period.

-> Double

Number of periods.

Number of periods for an investment.

pv Source #

Arguments

:: Double

Interest rate per period.

-> Int

Total number of periods.

-> Double

Payment per period.

-> Maybe Double

Future value.

-> Maybe Bool

Whether payments are due at the beginning of each period.

-> Double

Present value.

Compute prevent value.

fv Source #

Arguments

:: Double

Interest rate per period.

-> Int

Total number of periods.

-> Double

Payment per period.

-> Maybe Double

Present value.

-> Maybe Bool

Whether payments are due at the beginning of each period.

-> Double

Future value.

Compute future value.