New to Telerik Document Processing? Start a free 30-day trial

Pmt

Class

Calculates the periodic payment for a loan or annuity with constant payments and a constant interest rate.

Definition

Namespace:Telerik.Documents.Spreadsheet.Expressions.Functions

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public class Pmt : NumbersInFunction

Inheritance: objectFunctionBaseFunctionWithArgumentsFunctionWithSameTypeArguments<double>NumbersInFunctionPmt...

Inherited Members NumbersInFunction.ArgumentConversionRulesFunctionWithSameTypeArguments<double>.EvaluateOverride(FunctionEvaluationContext<object>)FunctionWithArguments.EvaluateOverride(FunctionEvaluationContext<RadExpression>)FunctionWithArguments.EvaluateLiftedElement(FunctionEvaluationContext<RadExpression>, RadExpression[], int, int)FunctionBase.IsSpillingArgument(int, RadExpression)FunctionBase.Evaluate(FunctionEvaluationContext<RadExpression>)FunctionBase.IsArgumentNumberValid(int)FunctionBase.LiftsOverArrays...

Constructors

Pmt()

Initializes a new PMT function instance for calculating loan or annuity payments.

public Pmt()

Fields

FunctionName

string

The name of the function.

public static readonly string FunctionName

Properties

FunctionInfo

Metadata describing this function's signature, category, and arguments.

public override FunctionInfo FunctionInfo { get; }

Property Value:

The function info as FunctionInfo.

Overrides: FunctionBase.FunctionInfo

Name

string

The function name used in formulas.

public override string Name { get; }

Property Value:

The name as String.

Overrides: FunctionBase.Name

Methods

EvaluateOverride(FunctionEvaluationContext<double>)

Evaluates the payment amount using rate, number of periods, present value, and optional future value and payment type, returning the result or an error expression.

protected override RadExpression EvaluateOverride(FunctionEvaluationContext<double> context)

Parameters:contextFunctionEvaluationContext<double>

The context.

Returns:

RadExpression

Functions result as RadExpression.

Overrides: FunctionWithSameTypeArguments<double>.EvaluateOverride(FunctionEvaluationContext<double>)