APIdia Launch Partner

Top Fields Constructors Methods

io.github.spannm.jackcess.impl.expr

public Class DefaultFinancialFunctions

Class Inheritance

extends Object

java.lang.Object
io.github.spannm.jackcess.impl.expr.DefaultFinancialFunctions

Annotations

@SuppressWarnings:checkstyle.HideUtilityClassConstructor

Static Imports

io.github.spannm.jackcess.impl.expr.DefaultFunctions.registerFunc, .FunctionSupport.getOptionalDoubleParam

Field Summary

Modifier and Type	Field and Description
public static final Function	DDB
public static final Function	FV
public static final Function	IPMT
private static final int	MAX_RATE_ITERATIONS
public static final Function	NPER
public static final Function	PMT
private static final int	PMT_BEG_MNTH 1 - payment start of month
private static final int	PMT_END_MNTH 0 - payment end of month (default)
public static final Function	PPMT
public static final Function	PV
public static final Function	RATE
private static final double	RATE_PRECISION
public static final Function	SLN
public static final Function	SYD

Constructor Summary

Access	Constructor and Description
pack-priv	DefaultFinancialFunctions()

Method Summary

Modifier and Type	Method and Description
public static double	calculateDoubleDecliningBalance(double cost, double salvage, double life, double period, double factor)
private static double	calculateFutureValue(double rate, double nper, double pmt, double pv, int pmtType)
private static double	calculateInterestPayment(double rate, double per, double nper, double pv, double fv, int pmtType)
private static double	calculateLoanPayment(double rate, double nper, double pv, double fv, int pmtType)
private static double	calculateLoanPaymentPeriods(double rate, double pmt, double pv, double fv, int pmtType)
private static double	calculatePresentValue(double rate, double nper, double pmt, double fv, int pmtType)
private static double	calculatePrincipalPayment(double rate, double per, double nper, double pv, double fv, int pmtType)
public static double	calculateRate(double nper, double pmt, double pv, double fv, int pmtType, double guess)
private static double	calculateStraightLineDepreciation(double cost, double salvage, double life)
private static double	calculateSumOfYearsDepreciation(double cost, double salvage, double life, double period)
private static double	getFV(EvalContext ctx, Value[] params, int idx)
private static int	getPaymentType(EvalContext ctx, Value[] params, int idx)

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

DDB	back to summary
public static final Function DDB

FV	back to summary
public static final Function FV

IPMT	back to summary
public static final Function IPMT

MAX_RATE_ITERATIONS	back to summary
private static final int MAX_RATE_ITERATIONS

NPER	back to summary
public static final Function NPER

PMT	back to summary
public static final Function PMT

PMT_BEG_MNTH	back to summary
private static final int PMT_BEG_MNTH 1 - payment start of month

PMT_END_MNTH	back to summary
private static final int PMT_END_MNTH 0 - payment end of month (default)

PPMT	back to summary
public static final Function PPMT

PV	back to summary
public static final Function PV

RATE	back to summary
public static final Function RATE

RATE_PRECISION	back to summary
private static final double RATE_PRECISION

SLN	back to summary
public static final Function SLN

SYD	back to summary
public static final Function SYD

Constructor Detail

DefaultFinancialFunctions	back to summary
pack-priv DefaultFinancialFunctions()

Method Detail

calculateDoubleDecliningBalance	back to summary
public static double calculateDoubleDecliningBalance(double cost, double salvage, double life, double period, double factor)

calculateFutureValue	back to summary
private static double calculateFutureValue(double rate, double nper, double pmt, double pv, int pmtType)

calculateInterestPayment	back to summary
private static double calculateInterestPayment(double rate, double per, double nper, double pv, double fv, int pmtType)

calculateLoanPayment	back to summary
private static double calculateLoanPayment(double rate, double nper, double pv, double fv, int pmtType)

calculateLoanPaymentPeriods	back to summary
private static double calculateLoanPaymentPeriods(double rate, double pmt, double pv, double fv, int pmtType)

calculatePresentValue	back to summary
private static double calculatePresentValue(double rate, double nper, double pmt, double fv, int pmtType)

calculatePrincipalPayment	back to summary
private static double calculatePrincipalPayment(double rate, double per, double nper, double pv, double fv, int pmtType)

calculateRate	back to summary
public static double calculateRate(double nper, double pmt, double pv, double fv, int pmtType, double guess)

calculateStraightLineDepreciation	back to summary
private static double calculateStraightLineDepreciation(double cost, double salvage, double life)

calculateSumOfYearsDepreciation	back to summary
private static double calculateSumOfYearsDepreciation(double cost, double salvage, double life, double period)

getFV	back to summary
private static double getFV(EvalContext ctx, Value[] params, int idx)

getPaymentType	back to summary
private static int getPaymentType(EvalContext ctx, Value[] params, int idx)