CFLib.org – Common Function Library Project

FinancialLib

Last updated January 07, 2015 / 13 Released UDF(s)
Periods

Calculate the number of payments for a loan. | Requires: CF5

Payment

Calculate payment on loan. | Requires: CF5

FutureValue

Calculate the future value of investment with regular deposits. | Requires: CF5

TranslateFuture

Translates a Cryptic Futures symbol into a descriptive structure. | Requires: CF5

TranslateFutureMonth

Handles commodity month translation tasks. | Requires: CF5

CompoundInterest

Calculate the compound interest after n years. | Requires: CF5

DiscountingInterest

Calculate the actual value of an amount by discounting the interest over n years. | Requires: CF5

BlackScholes

Computes the theoretical price of an equity option. | Requires: CF5

IsCodFisc

Check if a string is a well formed italian Fiscal Code. | Requires: CF5

getDepreciatedValue

This function outputs the current value of an item based on straight line depreciation. | Requires: CF6

excelRate

Returns the interest rate per period of an annuity. | Requires: CF6

calcIRR

Calculate IRR. | Requires: CF6

validateIBAN

Validates an IBAN number. | Requires: CF10

Search CFLib.org


Latest Additions

Raymond Camden added
QueryDeleteRows
November 04, 2017

Leigh added
nullPad
May 11, 2016

Raymond Camden added
stripHTML
May 10, 2016

Kevin Cotton added
date2ExcelDate
May 05, 2016

Raymond Camden added
CapFirst
April 25, 2016

Created by Raymond Camden / Design by Justin Johnson