47 Articles in this category

DarkLight
financial
47 Articles in this category

DarkLight
Currency_functional
Given a decimal number and a fractional unit, returns a number in the decimal fraction format.
Function signature
CURRENCY_FRACTIONAL(decimalprice: Number, unit: Number) => Number
Examples
Updated on : 19 May 2022
Effect
Calculates annual effective interest rate when provided with the nominal rate and the number of compounding periods per year.
Function signature
EFFECT(nominalrate: Number, periodsperyear: Number) => Number
Examples
Updated on : 19 May 2022
Net_present_value
Calculates an investment's net present value using discount rate and a series of periodic cash flows.
Function signature
NET_PRESENT_VALUE(discountrate: Number, cashflows: Array) => Number
Examples
Updated on : 19 May 2022
Nominal
Calculates the annual nominal interest using the number of compounding periods per year and the effective rate.
Function signature
NOMINAL(effectiverate: Number, periodsperyear: Number) => Number
Examples
Updated on : 19 May 2022
RRI
Given a number of periods and target value, calculates the interest rate an investment needs to reach that value.
Function signature
RRI(periods: Number, presentvalue: Number, futurevalue: Number) => Number
Examples
Updated on : 19 May 2022
SLN
Calculates an asset's depreceiation over one period using the straighline method.
Function signature
SLN(cost: Number, salvage: Number, life: Number) => Number
Examples
Updated on : 19 May 2022
SYD
Calculates an asset's depreciation using the sum of years digits method for a specified period.
Function signature
SYD(cost: Number, salvage: Number, life: Number, period: Number) => Number
Examples
Updated on : 19 May 2022
TBillprice
Returns a US Treasury Bill's price based on discount rate.
Function signature
TBILLPRICE(settlement: String, maturity: String, discount: Number) => Number
Examples
Updated on : 19 May 2022
TBillyield
Returns a US Treasury Bill's yield based on price.
Function signature
TBILLYIELD(settlement: String, maturity: String, price: Number) => Number
Examples
Updated on : 19 May 2022