Class RateImpl¶

Namespace: OfficeOpenXml.FormulaParsing.Excel.Functions.Finance.Implementations
Assembly: EPPlus.dll

Rate implementation

public static class RateImpl

Inheritance¶

object ← RateImpl

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Methods¶

LEvalRate(double, double, double, double, double, PmtDue)¶

LEvalRate

public static double LEvalRate(double Rate, double NPer, double Pmt, double PV, double dFv, PmtDue Due)

Parameters¶

Rate double

NPer double

Pmt double

PV double

dFv double

Due PmtDue

Returns¶

double

Rate(double, double, double, double, PmtDue, double)¶

Rate

public static FinanceCalcResult<double> Rate(double NPer, double Pmt, double PV, double FV = 0, PmtDue Due = PmtDue.EndOfPeriod, double Guess = 0.1)

Parameters¶

NPer double

Pmt double

PV double

FV double

Due PmtDue

Guess double

Returns¶

FinanceCalcResult<double>

Exceptions¶

ArgumentException