| Date and Time Calculations Category | | Date Information Family | What It Does |
|---|
| DYear (TheDate) | Determine the decimal year for a date | | DMonth (TheDate) | Determine the Decimal Month of a date | | DateYMD (Yr, Mnth, Day) | Determine a Date Number given Years,Months,Days | | DateSeqNum (TheDate) | Convert a Date to an Annual Sequence Number | | IsSeqDate (TheDate, AnnualDateSeq) | Determines if TheDate is one of the specified annual sequence dates | | | DayName (TheDate) | Name of the Day of the Week | | MonthName (TheDate) | Name of the Month | | IsLeap (TheDate) | Determine if the year is a leap year | | DaysInMonth (TheDate) | How many Days in the Month | | IsAnniversary (Date1, Date2) | Determine if one date is an anniversary of the other | | | WeekNumber (TheDate, StartOfWeek, [StartOfWeek1]) | Week Number | | WeekNumberToDate (WeekNum, StartOfWeek, [StartOfWeek1], Yr) | Convert a Week Number to a date | | | MonthStart (TheDate) | MonthStart | | MonthEnd (TheDate) | MonthEnd | | NumPers (Periods) | Number of periods per year in an annual sequence | | | MostRecent (TheDate, Dates, [Dates2], [Dates3], [Dates4], [RoundDown], [DefaultDate]) | Get the most imminent of some range(s) of dates relative to a current date | | MostImminent (TheDate, Dates, [Dates2], [Dates3], [Dates4], [RoundDown], [DefaultDate]) | Get the most recent of some range(s) of dates relative to a current date | | TimeBaseLengths (Timebase, [DayCount], [Periods]) | Returns the length of each period in the timebase as an array, in months | | | AnnSeq (AnnSeqNum, NumPmtsPerYr, [EOMRule]) | Generate an annual date sequence | | CreateTimeBase (Start, [Periods], [AbFin], [NumOfPrds]) | Create a timebase | | Date Difference Family | What It Does |
|---|
| DiffY (Date1, Date2, [DayCount], [Periods]) | Difference in Years | | DiffM (Date1, Date2, [DayCount], [Periods]) | Difference in Months | | DiffD (Date1, Date2, [DayCount], [Periods]) | Difference in Days | | DiffP (FromDate, ToDate, AnnDateSeq) | Number of periods between two dates | | Date Increment Family | What It Does |
|---|
| | DpY (TheDate, Yrs, [DayCount], [Periods]) | Date Plus Years | | DpM (TheDate, Months, [DayCount], [Periods]) | Date Plus Months | | DpD (TheDate, Days, [DayCount], [Periods]) | Date Plus Days | | DpP (TheDate, NPer, [Periods]) | Date plus a number of periods | | | PrevDateSeq (TheDate, AnnDateSeq, [SpecificDates]) | Determine the Previous Date in an annual sequence | | NextDateSeq (TheDate, AnnDateSeq, [SpecificDates]) | Next Date in the Sequence | | | PrevDateList (TheDate, [SpecificDates]) | Return the previous date from the list | | NextDateList (TheDate, [SpecificDates]) | Return the next date in the list | | NextDateCombine (TheDate, [AnnDateSeq1], [SpecificDates1], [AnnDateSeq2], [SpecificDates2], [AnnDateSeq3], [SpecificDates3], [AnnDateSeq4], [SpecificDates4]) | Calculates the next date using up to 4 or more possible date streams | | DatePer (WhichOne, FirstPmtDate, Periodicity) | Choose a date from a ...Per... series of dates | | EDateBF (TheDate, Months) | BF"s version of EDATE | | | DateSeq (FromDate, ToDate, AnnDateSeq, [SpecificDates]) | Build a Date Sequence | | DateSeqCombine (FromDate, ToDate, [AnnDateSeq1], [SpecificDates1], [AnnDateSeq2], [SpecificDates2], [AnnDateSeq3], [SpecificDates3], [AnnDateSeq4], [SpecificDates4]) | Combines up to 4 lists of dates | | Time Period Family | What It Does |
|---|
| TpY (Time, Base, [DayCount], [Periods]) | Years in Timeperiod | | TpM (Time, Base, [DayCount], [Periods]) | Months in timeperiod | | TpD (Time, Base, [DayCount], [Periods]) | Days in timeperiod | | | Occurs (Time, Base, EventDates) | Determine if an event occurs in a time period | Special Dates Category | | Business Days Family | What It Does |
|---|
| DpYBD (TheDate, Yrs, [BusDaySwitch], [AnnHols], [HolDates], [DayCount], [Periods]) | Date plus years ensuring the date determined is a Business Day | | DpMBD (TheDate, Months, [BusDaySwitch], [AnnHols], [HolDates], [DayCount], [Periods]) | Date plus Months (Business Days) | | DpDBD (TheDate, Days, [BusDaySwitch], [AnnHols], [HolDates], [DayCount], [Periods], [BDOption]) | Date plus days allowing for Business Days | | | NextBD (TheDate, [BusDaySwitch], [AnnHols], [HolDates]) | Determines the date of the next Business Day | | PrevBD (TheDate, [BusDaySwitch], [AnnHols], [HolDates]) | Previous Business Day | | NextDateSeqBD (TheDate, AnnDateSeq, [SpecificDates], [BusDaySwitch], [AnnHols], [HolDates]) | Determine the next date in an annual sequence, slipped to the next Business Day | | PrevDateSeqBD (TheDate, AnnDateSeq, [SpecificDates], [BusDaySwitch], [AnnHols], [HolDates]) | Determine the previous date in an annual sequence, slipped to the next Business Day | | | IsBD (TheDate, [BusDaySwitch], [AnnHols], [HolDates]) | Determines if the date is a Business Day | | | NetWorkDaysBF (FromDate, ToDate, [WeekendDays], [AnnHols], [HolDates], [BusDaySwitch]) | Days Elapsed, not counting holidays including the two end dates | | NextDateListBD (TheDate, [SpecificDates], [BusDaySwitch]) | Next date in list, taking into account Business Days | | PrevDateListBD (TheDate, [SpecificDates], [BusDaySwitch]) | Return the previous date from the list, taking into account Business Days | | Holidays Family | What It Does |
|---|
| Holiday (HolNum, YearOrDate) | Date of the Holiday in question | | DescribeHol (HolNum) | Describes the holiday in question | | WhatHol (TheDate, [BusDaySwitch]) | What the name of the holiday is on the date in question | | | IsHol (TheDate, [BusDaySwitch]) | Whether TheDate is a holiday or not | | IsWE (TheDate, [WeekendDays]) | IsWeekend | | WesternEaster (YearOrDate) | Western Easter | | CreateDate (YearOrDate, [MonthInYearOpt], [DayInMonthOpt], [OccurrenceNo], [DayinWeekOpt], [Relativity], [FirstYear], [RecurringYrs], [MoveWeekend], [AfterDate], [DaysRelative]) | Creates a date using specified assumptions and constraints | Discrete Amount Projections Category | | Payments Family | What It Does |
|---|
| MkPmtsSeq (TheDate, PmtDates, Pmts, SeqRelStart, SeqRelFinish, AnnualDateSeq) | Make payments between dates defined on an annual sequence | | MkPmts (Time, Base, PmtDates, Pmts) | Make several Payments | | MkPmtsGrow (Time, Base, PmtDates, Pmts, GrowthDates, GrowthRates) | Make one or more Payments that Grow | | MkPmtsFcst (Time, Base, PmtDates, FcstVals, StartFcst, FcstBase) | Make one or more Payments according to a forecast | | MkPmtsSF (Time, Base, Start, Finish, PmtDates, Pmts) | Make Payments within Start and Finish | | MkPmtsLim (Time, Base, PmtDates, Pmts, CumLimit) | Make Payments up to a maximum Limit of cumulative Payments | | | MkPmtsLag (Time, Base, [LagMonths], PmtDates, Pmts, [DayCount], [Periods], [AbStart], [AbFin]) | Make Payments Lagged | | MkPmtsLagProf (Time, Base, MonthsLag, Proportions, PmtDates, Pmts, [DayCount], [Periods], [AbStart], [AbFin]) | Make Payments lagged according to a profile | | | RePhasePmts (Time, Base, FromPmtDates, ToPmtDates, Pmts) | RePhase Payments | | | TotPmts (PmtDates, Pmts) | The Total of all the Payments | | TotPmtsSF (Start, Finish, PmtDates, Pmts) | Total or average of payments Start and Finish | | | SumBetween (FromDate, ToDate, PmtDates, Pmts, [InclusiveOpt]) | Sum of Payments between two dates | | DoBetween (FromDate, ToDate, PmtDates, Pmts, [InclusiveOpt], [RangeOperation]) | Sum, average or count of Payments between two dates | | MatchPmts (TheDate, PmtDates, Pmts) | Make Payments if the payment dates match the date in question | | CarryNeg (Amounts) | CarryNeg | | CarryPos (Amounts) | Carry forward positive balances | | MkPmtsX (Time, Base, PmtDates, Pmts, [Pmts2], [Pmts3], [Pmts4], [Pmts5], [Pmts6], [Pmts7], [Pmts8], [Pmts9], [Pmts10]) | Make several Payments, extended version | | MkPmtsLagX (Time, Base, [LagMonths], PmtDates, Pmts, [Pmts2], [Pmts3], [Pmts4], [Pmts5], [Pmts6], [Pmts7], [Pmts8], [Pmts9], [Pmts10], [DayCount], [Periods]) | Make Payments Lagged, extended version | | MkPmtsIdx (Time, Base, PmtDates, Pmts, IdxFcstVals, IdxStartFcst, IdxFcstBase, [BaseDateOrIdx]) | Make several Payments, growing by an an Index | | MkPmtsCats (Time, Base, PmtDates, Pmts, Categories, [ChosenCategories], [Categories2], [ChosenCategories2], [Options], [AbStart], [AbFin], [CatMin], [CatMax], [CatMin2], [CatMax2]) | Make Payments depending on categories | | MkPmtsGroup (Time, Base, [LagMonths], PmtDates, Pmts, [DayCount], [Periods], [PrdsGroup], [AbStart], [AbFin]) | Make Payments and Group together | | Payments Periodic Family | What It Does |
|---|
| MkPmtsPer (Time, Base, AbsFinish, PmtDates, Pmts, Periodicity) | Make a sequence of Payments Periodically | | | MkPmtsPerGrow (Time, Base, AbsFinish, PmtDates, Pmts, GrowthDates, GrowthRates, Periodicity) | Make a sequence of payments periodically with growth | | MkPmtsPerFcst (Time, Base, AbsFinish, PmtDates, FcstVals, StartFcst, FcstBase, Periodicity) | Make a sequence of payments according to a forecast | | MkPmtsIdxPer (Time, Base, AbsFinish, PmtDates, Pmts, IdxFcstVals, IdxStartFcst, IdxFcstBase, [BaseDateOrIdx], Periodicity) | Make a sequence of Payments Periodically, where the payments are grown by an Index | | Payments Market Family | What It Does |
|---|
| | MkPmtsGrowMkt (Time, Base, MktValue, PmtDates, Pmts, GrowthDates, GrowthRates) | Make payments that are grown with reference to a market forecast | | MkPmtsFcstMkt (Time, Base, PmtDates, Pmts, FcstVals, StartFcst, FcstBase) | Make payments that are read off a market forecast | | MkPmtsPerGrowMkt (Time, Base, Finish, MktValue, PmtDates, Pmts, GrowthDates, GrowthRates, Periodicity) | Make payments periodically that are grown with reference to a market forecast | | MkPmtsPerFcstMkt (Time, Base, Finish, PmtDates, Pmts, FcstVals, StartFcst, FcstBase, Periodicity) | Make payments periodically that are read off a market forecast | Distributed Amount Projections Category | | Time Spread Family | What It Does |
|---|
| GSpread (Time, Base, Start, Total, [CompletionDate], [CurveModel], [Shape], [DayCount], [Periods], [ProjMode]) | General Spread Function | | UniSpread (Time, Base, Start, Finish, Total, [DayCount], [Periods], [ProjMode]) | Spread an amount Uniformly over time | | UniSpreadGrow (Time, Base, Start, Finish, Total, GrowthDates, GrowthRates, [DayCount], [Periods], [ProjMode]) | Spread an amount Uniformly over time, with Growth | | | SCurve (Time, Base, Start, Finish, Total, [Skew], [Peakness], [DayCount], [Periods], [ProjMode]) | Distribute an amount over time according to an S-Curve | | SCurveGrow (Time, Base, Start, Finish, Total, [Skew], [Peakness], GrowthDates, GrowthRates, [DayCount], [Periods], [ProjMode]) | Distribute an amount over time according to an S-Curve, but grow it first | | | DistSpread (Time, Base, Start, MidPoint, Finish, Total, DistType, [DayCount], [Periods], [ProjMode]) | Distribute an amount over time according to a specified distribution type | | FStepSpread (Time, Base, Total, FromDates, AnnualRates, [DayCount], [Periods], [ProjMode]) | Stepped Rate where there is a Total to be spread, using From Dates | | TStepSpread (Time, Base, Total, ToDates, AnnualRates, [DayCount], [Periods], [ProjMode]) | Stepped Rate where there is a Total to be spread, using To Dates | | MkPmtsWeighted (Time, Base, Total, PmtDates, Weights) | Make Payments that are weighted to add to a Total | | SCumCurve (Time, Base, Start, Finish, Total, CumTime, CumAmt, [InterpType], [Tension], [Bias], [DayCount], [Periods], [ProjMode]) | S Curve from a cumulative curve | | Time Spread Periodic Family | What It Does |
|---|
| UniSpreadPer (Time, Base, Start, Finish, AbsFinish, Totals, Periodicity, [DayCount], [Periods], [ProjMode]) | UniSpread applied periodically (...Per... feature) | | SCurvePer (Time, Base, Start, Finish, AbsFinish, Totals, [Skew], [Peakness], Periodicity, [DayCount], [Periods], [ProjMode]) | SCurve applied periodically (...Per... feature) | | | SCurveGrowPer (Time, Base, Start, Finish, AbsFinish, Totals, [Skew], [Peakness], GrowthDates, GrowthRates, Periodicity, [DayCount], [Periods], [ProjMode]) | SCurve applied periodically (...Per... feature) and with Growth | | UniSpreadGrowPer (Time, Base, Start, Finish, AbsFinish, Totals, GrowthDates, GrowthRates, Periodicity, [DayCount], [Periods], [ProjMode]) | UniSpread applied periodically (...Per... feature) and with Growth | | Time Spread Weighted Family | What It Does |
|---|
| UniSpreadS (Time, Base, Start, Finish, Total, [SeasonFactors], [SeasonSeq], [DayCount], [Periods], [ProjMode]) | Spread an amount Uniformly over time, but allow for seasonality | | WeightSpread (Time, Base, Start, Finish, Total, Weights, [DayCount], [Periods], [ProjMode]) | Spreads an amount through time using a series of weights | | FWeightSpread (Time, Base, Finish, Total, FromDates, Weights, [DayCount], [Periods], [ProjMode]) | Distribute an amount over time according to specific weighting factors and FromDates | | TWeightSpread (Time, Base, Start, Total, ToDates, Weights, [DayCount], [Periods], [ProjMode]) | Distribute an amount over time according to specific weighting factors and ToDates | | Time Spread History Family | What It Does |
|---|
| UniSpreadH (Time, Base, Start, Finish, Total, [DatesHistory], [PmtsHistory], [DayCount], [Periods], [ProjMode]) | UniSpread that uses historical data | | SCurveH (Time, Base, Start, Finish, Total, [Skew], [Peakness], [DatesHistory], [PmtsHistory], [DayCount], [Periods], [ProjMode]) | SCurve that uses historical data | | WeightSpreadH (Time, Base, Start, Finish, Total, Weights, [DatesHistory], [PmtsHistory], [DayCount], [Periods], [ProjMode]) | WeightSpread that uses historical data | | FWeightSpreadH (Time, Base, Finish, Total, FromDates, Weights, [DatesHistory], [PmtsHistory], [DayCount], [Periods], [ProjMode]) | FWeightSpread that uses historical data | | TWeightSpreadH (Time, Base, Start, Total, ToDates, Weights, [DatesHistory], [PmtsHistory], [DayCount], [Periods], [ProjMode]) | WeightSpread that uses historical data | | DistSpreadH (Time, Base, Start, MidPoint, Finish, Total, DistType, [DatesHistory], [PmtsHistory], [DayCount], [Periods], [ProjMode]) | DistSpread that uses historical data | | GSpreadH (Time, Base, Start, Total, [CompletionDate], [CurveModel], [Shape], [DatesHistory], [PmtsHistory], [DayCount], [Periods], [ProjMode]) | GSpread that uses historical data | | | UniSpreadAdj (Time, Base, Start, Finish, Total, [ActualsToDate], [DayCount], [Periods], [ProjMode]) | UniSpread that uses an ActualsToDate figure to continually reforecast so that the overall budget stays at Total. | | SCurveAdj (Time, Base, Start, Finish, Total, [Skew], [Peakness], [ActualsToDate], [DayCount], [Periods], [ProjMode]) | SCurve that uses an ActualsToDate figure to continually reforecast so that the overall budget stays at Total. | | WeightSpreadAdj (Time, Base, Start, Finish, Total, Weights, [ActualsToDate], [DayCount], [Periods], [ProjMode]) | WeightSpread that uses an ActualsToDate figure to continually reforecast so that the overall budget stays at Total. | | FWeightSpreadAdj (Time, Base, Finish, Total, FromDates, Weights, [ActualsToDate], [DayCount], [Periods], [ProjMode]) | FWeightSpread that uses an ActualsToDate figure to continually reforecast so that the overall budget stays at Total. | | TWeightSpreadAdj (Time, Base, Start, Total, ToDates, Weights, [ActualsToDate], [DayCount], [Periods], [ProjMode]) | TWeightSpread that uses an ActualsToDate figure to continually reforecast so that the overall budget stays at Total. | | DistSpreadAdj (Time, Base, Start, MidPoint, Finish, Total, DistType, [ActualsToDate], [DayCount], [Periods], [ProjMode]) | DistSpread that uses an ActualsToDate figure to continually reforecast so that the overall budget stays at Total. | | GSpreadAdj (Time, Base, Start, Total, [CompletionDate], [CurveModel], [Shape], [ActualsToDate], [DayCount], [Periods], [ProjMode]) | GSpread that uses an ActualsToDate figure to continually reforecast so that the overall budget stays at Total. | Constant Rate Projections Category | | Constant Rate Family | What It Does |
|---|
| Con (Time, Base, Start, Finish, AnnualRate, [DayCount], [Periods], [ProjMode]) | Constant rate | | | ConGrow (Time, Base, Start, Finish, AnnualRate, GrowthDates, GrowthRates, [RevMonthsOpt], [DayCount], [Periods], [ProjMode]) | Even rate that is continuously growing | | AnnGrow (Time, Base, Start, Finish, AnnualRate, GrowthDates, GrowthRates, [DayCount], [Periods], [ProjMode]) | Constant rate that grows at annual intervals | | | RePhaseCon (Time, Base, FromStart, FromFinish, ToStart, ToFinish, AnnualRate, [DayCount], [Periods], [ProjMode]) | RePhase an amount according to a constant rate | | LinGrow (Time, Base, Start, Finish, AnnualRate, GrowthDates, GrowthRates, [RevMonthsOpt], [DayCount], [Periods], [ProjMode]) | Project a constant rate that grows (or declines) linearly over time | | ConS (Time, Base, Start, Finish, AnnualRate, [SeasonFactors], [SeasonSeq], [DayCount], [Periods], [ProjMode]) | Project an constant rate, but allow for seasonality | | AnnRate (Time, Base, Start, Finish, AmountDisbursed, [DayCount], [Periods], [ProjMode]) | Annual Rate given an amount and a time difference | | ConSF (Time, Base, Start, Finish, AnnualRate, OverallStartDate, OverallFinishDate, [DayCount], [Periods], [ProjMode]) | A version of Con that also has overall Start and Finish dates | | | ConIdx (Time, Base, Start, Finish, InitialAnnRate, IdxFcstVals, IdxStartFcst, IdxFcstBase, [IdxReg], [BaseDateOrIdx], [FirstIdxDate], [DayCount], [Periods], [ProjMode]) | Constant Rate Index | | ConEvent (Time, Base, Start, Finish) | Constant Rate Event | | Constant Rate Periodic Family | What It Does |
|---|
| ConPer (Time, Base, Start, Finish, AbsFinish, AnnualRates, Periodicity, [DayCount], [Periods], [ProjMode]) | Con applied periodically (...Per... feature) | | AnnGrowPer (Time, Base, Start, Finish, AbsFinish, AnnualRates, GrowthDates, GrowthRates, Periodicity, [DayCount], [Periods], [ProjMode]) | AnnGrow applied periodically (...Per... feature) | | ConGrowPer (Time, Base, Start, Finish, AbsFinish, AnnualRates, GrowthDates, GrowthRates, [RevMos], Periodicity, [DayCount], [Periods], [ProjMode]) | ConGrow applied periodically (...Per... feature) | | Constant Rate Market Family | What It Does |
|---|
| ConGrowMkt (Time, Base, Start, Finish, FirstRev, MktAnnRate, InitialAnnRate, GrowthDates, GrowthRates, [RevMonthsOpt], [DayCount], [Periods], [ProjMode]) | Project a constant rate that periodically reviews to a market rate prevailing at the time | | | ConFcstMkt (Time, Base, Start, Finish, FirstRev, InitialAnnRate, FcstVals, StartFcst, FcstBase, [RevMonthsOpt], [DayCount], [Periods], [ProjMode]) | Project a constant rate that periodically reviews to a forecast prevailing at the time | | | ConFcstGrowMkt (Time, Base, Start, Finish, FirstRev, InitialAnnRate, FcstVals, StartFcst, FcstBase, GrowthDates, GrowthRates, [RevMos], [DayCount], [Periods], [ProjMode]) | Project a constant rate that periodically reviews to a forecast prevailing at the time, and also apply growth | | Constant Rate Revenue Family | What It Does |
|---|
| ConRevGrow2 (Time, Base, Start, Finish, MktPrice, FirstRev, AnnualRate, GrowthDates, GrowthRates, GrowthDatesAnnRate, GrowthAnnRate, [RevMonthsOpt], [RevMonthsAnnRateOpt], [DayCount], [Periods], [ProjMode]) | Expanded version of ConRevGrow | | ConRev (Time, Base, Start, Finish, MktPrice, AnnualRate, [DayCount], [Periods], [ProjMode]) | TBA | | | ConRevGrow (Time, Base, Start, Finish, MktPrice, FirstRev, AnnualRate, GrowthDates, GrowthRates, [RevMonthsOpt], [DayCount], [Periods], [ProjMode]) | Constant Rate Revenue with optional Growth | | ConRevFcst (Time, Base, Start, Finish, FirstRev, AnnualRate, FcstVals, StartFcst, FcstBase, [RevMonthsOpt], [DayCount], [Periods], [ProjMode]) | Constant Rate Revenue according to a price forecast | Stepped Rate Projections Category | | Stepped Rate From Family | What It Does |
|---|
| FStep (Time, Base, Finish, FromDates, AnnualRates, [DayCount], [Periods], [ProjMode]) | Stepped rate using a series of "from" dates and rates. | | FStepGrow (Time, Base, Finish, InitialAnnRate, FromDates, GrowthDates, GrowthRates, [DayCount], [Periods], [ProjMode]) | Stepped rate from a series of dates where the rates are derived from an initial rate with growth applied | | FStepGrowX (Time, Base, Finish, FromDates, AnnualRates, GrowthDates, GrowthRates, [RevMonthsOpt], [DayCount], [Periods], [ProjMode]) | Stepped Rate with Growth applied | | FStepThenGrow (Time, Base, Finish, FromDates, AnnualRates, GrowthDates, GrowthRates, [RevMonthsOpt], [DayCount], [Periods], [ProjMode]) | Stepped Rate using From Dates then constantly Grow after that | | FStepFcst (Time, Base, Finish, FromDates, FcstVals, StartFcst, FcstBase, [DayCount], [Periods], [ProjMode]) | Project a stepped continuous rate from a series of dates where the rates are read off a supplied forecast | | FStepGrown (Time, Base, Finish, FromDates, AnnualRates, GrowthDates, GrowthRates, [DayCount], [Periods], [ProjMode]) | FStep that is grown according to growth rates | | FStepSF (Time, Base, Start, Finish, FromDates, AnnualRates, [DayCount], [Periods], [ProjMode]) | FStep incorporating a Start date as well as a Finish date | | FStepS (Time, Base, Finish, FromDates, AnnualRates, [SeasonFactors], [SeasonSeq], [DayCount], [Periods], [ProjMode]) | The same as FStep but with the Seasonality facility | | FStepCombine (Time, Base, CombineSwitch, Finish, FromDates, AnnualRates, [FromDates2], [AnnualRates2], [FromDates3], [AnnualRates3], [FromDates4], [AnnualRates4], [DayCount], [Periods], [ProjMode]) | Combines up to 4 streams of annual rates and calculates the amount due in the period. | | | MultiFStep (Time, Base, Finish, FromDates, AnnualRates, [Finish2], [FromDates2], [AnnualRates2], [Finish3], [FromDates3], [AnnualRates3], [DayCount], [Periods], [ProjMode]) | TBA | | Stepped Rate To Family | What It Does |
|---|
| TStep (Time, Base, Start, ToDates, AnnualRates, [DayCount], [Periods], [ProjMode]) | Stepped rate using a series of "to" dates and rates. | | TStepGrow (Time, Base, Start, InitialAnnRate, ToDates, GrowthDates, GrowthRates, [DayCount], [Periods], [ProjMode]) | Project a stepped continuous rate up to a series of dates where the rates are derived from an initial rate with growth applied | | TStepGrowX (Time, Base, Start, ToDates, AnnualRates, GrowthDates, GrowthRates, [RevMonthsOpt], [DayCount], [Periods], [ProjMode]) | Stepped Rate with Growth applied | | TStepThenGrow (Time, Base, Start, Finish, ToDates, AnnualRates, GrowthDates, GrowthRates, [RevMonthsOpt], [DayCount], [Periods], [ProjMode]) | Stepped Rate using ToDates then constantly Grow after that | | TStepFcst (Time, Base, Start, ToDates, FcstVals, StartFcst, FcstBase, [DayCount], [Periods], [ProjMode]) | Project a stepped continuous rate up to a series of dates where the rates are read off a supplied forecast | | TStepGrown (Time, Base, Start, ToDates, AnnualRates, GrowthDates, GrowthRates, [DayCount], [Periods], [ProjMode]) | TStep that is grown according to growth rates | | TStepSF (Time, Base, Start, Finish, ToDates, AnnualRates, [DayCount], [Periods], [ProjMode]) | TStep incorporating a Finish date as well as a Start date | | TStepS (Time, Base, Start, ToDates, AnnualRates, [SeasonFactors], [SeasonSeq], [DayCount], [Periods], [ProjMode]) | The same as TStep but with the Seasonality facility | | TStepCombine (Time, Base, CombineSwitch, Start, ToDates, AnnualRates, [ToDates2], [AnnualRates2], [ToDates3], [AnnualRates3], [ToDates4], [AnnualRates4], [DayCount], [Periods], [ProjMode]) | Combines up to 4 streams of annual rates and calculates the amount due in the period. | | | MultiTStep (Time, Base, Start, ToDates, AnnualRates, [Start2], [ToDates2], [AnnualRates2], [Start3], [ToDates3], [AnnualRates3], [DayCount], [Periods], [ProjMode]) | TBA | | Stepped Rate Market Family | What It Does |
|---|
| FStepGrowMkt (Time, Base, Finish, MktAnnRate, FromDates, AnnualRates, GrowthDates, GrowthRates, [DayCount], [Periods], [ProjMode]) | Project a stepped continuous rate using a series of "from" dates and rates, where any gaps (zeros) in the rates are derived using a market rate and growth rates | | FStepFcstMkt (Time, Base, Finish, FromDates, AnnualRates, FcstVals, StartFcst, FcstBase, [DayCount], [Periods], [ProjMode]) | Project a stepped continuous rate using a series of "from" dates and rates, where any gaps (zeros) in the rates are read off a supplied forecast | | | TStepGrowMkt (Time, Base, Start, MktAnnRate, ToDates, AnnualRates, GrowthDates, GrowthRates, [DayCount], [Periods], [ProjMode]) | Project a stepped continuous rate using a series of "to" dates and rates, where any gaps (zeros) in the rates are derived using a market rate and growth rates | | TStepFcstMkt (Time, Base, Start, ToDates, AnnualRates, FcstVals, StartFcst, FcstBase, [DayCount], [Periods], [ProjMode]) | Project a stepped continuous rate using a series of "to" dates and rates, where any gaps (zeros) in the rates are read off a supplied forecast | | Stepped Rate Revenue Family | What It Does |
|---|
| FStepRev (Time, Base, Finish, MktPriceFromDates, MktPrices, FromDates, AnnualRates, [DayCount], [Periods], [ProjMode]) | Stepped Rate Revenue using From Dates | | TStepRev (Time, Base, Start, MktPriceToDates, MktPrices, ToDates, AnnualRates, [DayCount], [Periods], [ProjMode]) | Stepped Rate Revenue using To Dates | | | FStepRevGrow (Time, Base, Finish, MktPrice, FirstRev, FromDates, AnnualRates, GrowthDates, GrowthRates, [RevMonthsOpt], [DayCount], [Periods], [ProjMode]) | Stepped Rate Revenue with Growth using From Dates | | FStepRevFcst (Time, Base, Finish, FirstRev, FromDates, AnnualRates, FcstVals, StartFcst, FcstBase, [RevMonthsOpt], [DayCount], [Periods], [ProjMode]) | Stepped Rate Revenue according to a forecast, using From Dates | | | TStepRevGrow (Time, Base, Start, MktPrice, FirstRev, ToDates, AnnualRates, GrowthDates, GrowthRates, [RevMonthsOpt], [DayCount], [Periods], [ProjMode]) | Stepped Rate Revenue with Growth using To Dates | | TStepRevFcst (Time, Base, Start, FirstRev, ToDates, AnnualRates, FcstVals, StartFcst, FcstBase, [RevMonthsOpt], [DayCount], [Periods], [ProjMode]) | Stepped Rate Revenue according to a forecast, using To Dates | | | FStepThenGrowRev (Time, Base, Finish, MktPrice, FromDates, AnnualRates, GrowthDates, GrowthRates, GrowthDatesAnnRate, GrowthAnnRate, [RevMonthsOpt], [RevMonthsAnnRateOpt], [DayCount], [Periods], [ProjMode]) | Do a FStepRev and then grow after that. | | TStepThenGrowRev (Time, Base, Start, Finish, MktPrice, ToDates, AnnualRates, GrowthDates, GrowthRates, GrowthDatesAnnRate, GrowthAnnRate, [RevMonthsOpt], [RevMonthsAnnRateOpt], [DayCount], [Periods], [ProjMode]) | Do a TStepRev and then grow after that. | Interpolated and Curve-Fitted Projections Category | | Interpolated and Curve-Fitted Rates Family | What It Does |
|---|
| InterpedRate (Time, Base, Dates, AnnualRates, [InterpType], [Tension], [Bias], [DayCount], [Periods], [ProjMode]) | Interpolated Annual Rate | | FittedRate (Time, Base, Dates, AnnualRates, [PolyOrder], [DayCount], [Periods], [ProjMode]) | Fitted Rate | | | Ramp (Time, Base, Dates, AnnualRates, [PolyOrder], [DayCount], [Periods], [ProjMode]) | Ramped Rate | | Interpolated and Curve-Fitted Levels Family | What It Does |
|---|
| InterpedLevel (TheDate, Dates, Levels, [InterpType], [Tension], [Bias], [DayCount], [Periods]) | Interpolated Level | | FittedLevel (TheDate, Dates, Levels, [PolyOrder], [DayCount], [Periods]) | Fitted Level | Instantaneous Level Projections Category | | Levels Family | What It Does |
|---|
| Bal (TheDate, AdvanceDates, NetAdvances) | Balance | | Level (TheDate, Start, Finish, Level) | Level with a Start and Finish date | | | FLevels (TheDate, Finish, FromDates, Levels) | Series of levels using "from" dates and levels | | TLevels (TheDate, Start, ToDates, Levels) | Series of levels to corresponding dates | | | FLevelsGrow (TheDate, Finish, InitialLevel, FromDates, GrowthDates, GrowthRates) | Series of levels from specific dates the level is determined by an initial level and a growth forecast | | TLevelsGrow (TheDate, Start, InitialLevel, ToDates, GrowthDates, GrowthRates) | Series of levels to specific dates the level is determined by an initial level and a growth forecast | | | FLevelsFcst (TheDate, Finish, FromDates, FcstVals, StartFcst, FcstBase) | Series of levels from specific dates the level is determined by a forecast | | TLevelsFcst (TheDate, Start, ToDates, FcstVals, StartFcst, FcstBase) | Series of levels to specific dates the level is determined by a forecast | | FLevelsCombine (TheDate, CombineSwitch, Finish, FromDates, Levels, [FromDates2], [Levels2], [FromDates3], [Levels3], [FromDates4], [Levels4]) | Combine multiple sets of levels | | | FLevelsThenGrow (TheDate, Finish, FromDates, Levels, GrowthDates, GrowthRates, [RevMonthsOpt]) | Do an FLevels and thereafter grow | | TLevelsThenGrow (TheDate, Start, Finish, ToDates, Levels, GrowthDates, GrowthRates, [RevMonthsOpt]) | Do a TLevels and thereafter grow | | Levels Market Family | What It Does |
|---|
| FLevelsGrowMkt (TheDate, Finish, MktLevel, FromDates, Levels, GrowthDates, GrowthRates) | Series of levels from corresponding dates where any gaps are determined by an initial level and a growth forecast | | TLevelsGrowMkt (TheDate, Start, MktLevel, ToDates, Levels, GrowthDates, GrowthRates) | Series of levels to corresponding dates where any gaps are determined by an initial level and a growth forecast | | | FLevelsFcstMkt (TheDate, Finish, FromDates, Levels, FcstVals, StartFcst, FcstBase) | Series of levels from corresponding dates where any gaps are determined by a forecast | | TLevelsFcstMkt (TheDate, Start, ToDates, Levels, FcstVals, StartFcst, FcstBase) | Series of levels to corresponding dates where any gaps are determined by a forecast | | Growth Family | What It Does |
|---|
| Grow (TheDate, StartingValue, GrowthDates, GrowthRates, [RevMonthsOpt]) | Grow an amount from one date to another using GrowthRates | | GrowFromTo (Date1, Date2, StartingValue, GrowthDates, GrowthRates, [GrowthType], [RevMonthsOpt], [DayCount], [Periods]) | Grow an amount from one date to another | | | FGrowStep (TheDate, Finish, StartingValue, FromDates, GrowthDates, GrowthRates) | Grow an amount in steps using FromDates | | TGrowStep (TheDate, Start, StartingValue, ToDates, GrowthDates, GrowthRates) | Grow an amount in steps using ToDates | | | FGrowStepMkt (TheDate, Finish, MktAnnRate, FromDates, AnnualRates, GrowthDates, GrowthRates) | Grow in steps with reference to a Market | | TGrowStepMkt (TheDate, Start, MktAnnRate, ToDates, AnnualRates, GrowthDates, GrowthRates) | Grow in steps with reference to a Market | | GrowMkt (TheDate, StartingValue, GrowthDates, GrowthRates, [RevMos], [RevDisc], [UOTog]) | Grow an amount as if it were reviewing to market | | GrowLin (TheDate, StartingValue, GrowthDates, GrowthRates, [RevMonthsOpt]) | Grow an amount linearly | | Forecast Family | What It Does |
|---|
| Fcst (TheDate, FcstVals, StartFcst, FcstBase, [FcstSwitchOpt], [FcstDef_Pre], [FcstDef_Post]) | Read a value off an evenly spaced forecast | | | FcstGrow (TheDate, FcstVals, StartFcst, FcstBase, GrowthDates, GrowthRates, [RevMonthsOpt], [FcstSwitchOpt]) | Read a value off an evenly spaced forecast and then grow it | | FcstCollar (TheDate, Minimum, Maximum, FcstVals, StartFcst, FcstBase, [FcstSwitchOpt]) | Read a value off an evenly spaced forecast, with a maximum and minimum | | SumFcst (Date1, Date2, FcstVals, StartFcst, FcstBase, [DayCount], [Periods]) | Sum of the values of an even forecast between two dates | | | FFcstStep (TheDate, Finish, FromDates, FcstVals, StartFcst, FcstBase, [FcstSwitchOpt]) | Read a value off an evenly spaced forecast, but at specific stepped intervals described by FromDates | | TFcstStep (TheDate, Start, ToDates, FcstVals, StartFcst, FcstBase, [FcstSwitchOpt]) | Read a value off an evenly spaced forecast, but at specific stepped intervals described by ToDates | | IdxFromTo (BaseDateOrIdx, TheDate, IdxFcstVals, IdxStartFcst, IdxFcstBase) | Change in value dependent on the growth in an index | | Forecast Specific Times Family | What It Does |
|---|
| FcstT (TheDate, FcstFromDates, FcstValues, [FcstSwitchOpt]) | Get a Forecast from a general range of times and values | | FcstGrowT (TheDate, FcstFromDates, FcstValues, GrowthDates, GrowthRates, [RevMonthsOpt], [FcstSwitchOpt]) | General Forecast Grow | | TFcstT (TheDate, FcstToDates, FcstValues, [FcstSwitchOpt]) | FcstT but with ToDates instead of FromDates | Levels Over Time Projections Category | | Levels Average Family | What It Does |
|---|
| ALevel (Time, Base, StartLevels, FinishLevels, Level, [LevelSwitchOpt], [DayCount], [Periods]) | Simple level with a Start and Finish date averaged over a timeperiod | | | FALevels (Time, Base, FinishLevels, FromDates, Levels, [LevelSwitchOpt], [DayCount], [Periods]) | Series of levels from corresponding dates averaged over a timeperiod | | TALevels (Time, Base, StartLevels, ToDates, Levels, [LevelSwitchOpt], [DayCount], [Periods]) | Series of levels to corresponding dates averaged over a timeperiod | | FALevelsGrow (Time, Base, FinishLevels, InitialLevel, FromDates, GrowthDates, GrowthRates, [LevelSwitchOpt], [DayCount], [Periods]) | Series of levels from specific dates where the level is determined by an initial level and GrowthRates averaged over a timeperiod | | TALevelsGrow (Time, Base, StartLevels, InitialLevel, ToDates, GrowthDates, GrowthRates, [LevelSwitchOpt], [DayCount], [Periods]) | Series of levels to corresponding dates the level is determined by an initial level and GrowthRates averaged over a timeperiod | | | FALevelsFcst (Time, Base, FinishLevels, FromDates, FcstVals, StartFcst, FcstBase, [LevelSwitchOpt], [DayCount], [Periods]) | Series of levels from corresponding dates the level is determined by a forecast averaged over a timeperiod | | TALevelsFcst (Time, Base, StartLevels, ToDates, FcstVals, StartFcst, FcstBase, [LevelSwitchOpt], [DayCount], [Periods]) | Series of levels to corresponding dates the level is determined by a forecast averaged over a timeperiod | | | FALevelsThenGrow (Time, Base, FinishLevels, FromDates, Levels, GrowthDates, GrowthRates, [LevelSwitchOpt], [RevMonthsOpt], [DayCount], [Periods]) | Do an FALevels and thereafter grow at GrowthRates | | TALevelsThenGrow (Time, Base, StartLevels, FinishLevels, ToDates, Levels, GrowthDates, GrowthRates, [LevelSwitchOpt], [RevMonthsOpt], [DayCount], [Periods]) | Do a TALevels and thereafter grow at GrowthRates | | | ALevelGrow (Time, Base, StartLevels, FinishLevels, InitialLevel, GrowthDates, GrowthRates, [LevelSwitchOpt], [RevMonthsOpt], [DayCount], [Periods]) | Grow a single level in an average kind of way using GrowthRates | | Levels Average Market Family | What It Does |
|---|
| FALevelsGrowMkt (Time, Base, FinishLevels, MktLevel, FromDates, Levels, GrowthDates, GrowthRates, [LevelSwitchOpt], [DayCount], [Periods]) | Series of levels from corresponding dates where any gaps are determined by an initial level and a growth forecast averaged over a timeperiod | | TALevelsGrowMkt (Time, Base, StartLevels, MktLevel, ToDates, Levels, GrowthDates, GrowthRates, [LevelSwitchOpt], [DayCount], [Periods]) | Series of levels to corresponding dates where any gaps are determined by an initial level and a growth forecast averaged over a timeperiod | | | FALevelsFcstMkt (Time, Base, FinishLevels, FromDates, Levels, FcstVals, StartFcst, FcstBase, [LevelSwitchOpt], [DayCount], [Periods]) | Series of levels from corresponding dates where any gaps are determined by a forecast averaged over a timeperiod | | TALevelsFcstMkt (Time, Base, StartLevels, ToDates, Levels, FcstVals, StartFcst, FcstBase, [LevelSwitchOpt], [DayCount], [Periods]) | Series of levels to corresponding dates where any gaps are determined by a forecast averaged over a timeperiod | | Forecast Average Family | What It Does |
|---|
| AFcst (Time, Base, FcstVals, StartFcst, FcstBase, [LevelSwitchOpt], [FcstSwitchOpt]) | AFcst | | Growth Average Family | What It Does |
|---|
| AGrow (Time, Base, StartingValue, GrowthDates, GrowthRates, [LevelSwitchOpt], [RevMonthsOpt], [DayCount], [Periods]) | Average Grow | Projections NPV Category | | NPV Constant Rate Family | What It Does |
|---|
| PVCon (NPVDate, DisAER, Start, Finish, AnnualRate, [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc]) | Present Value of a Con Function | | PVAnnGrow (NPVDate, DisAER, Start, Finish, AnnualRate, GrowthDates, GrowthRates, [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF]) | Present Value of an AnnGrow function | | PVConGrow (NPVDate, DisAER, Start, Finish, AnnualRate, GrowthDates, GrowthRates, [RevMonthsOpt], [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF]) | Present Value of a ConGrow function | | PVConQ (NPVDate, DisAER, Start, Finish, AnnualRate, [PmtsPerYearOpt]) | Present Value of a Constant Rate (Quick Version) | | NPV Stepped Rate Family | What It Does |
|---|
| PVTStep (NPVDate, DisAER, Start, ToDates, AnnualRates, [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF]) | Present Value of a TStep function | | PVTStepQ (NPVDate, DisAER, Start, ToDates, AnnualRates, [PmtsPerYearOpt]) | PVTStep, quick version | | | PVTStepIC (NPVDate, DisAER, Start, ToDates, AnnualRates, [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [InvDate], [InvAmt], [CapRateAER]) | Present Value of a TStep function | | PVTStepICQ (NPVDate, DisAER, Start, ToDates, AnnualRates, [InvDate], [InvAmt], [CapRateAER], [PmtsPerYearOpt]) | PVTStepIC, quick version | | | PVFStep (NPVDate, DisAER, Finish, FromDates, AnnualRates, [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF]) | Present Value of an FStep function | | PVFStepIC (NPVDate, DisAER, Finish, FromDates, AnnualRates, [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [InvDate], [InvAmt], [CapRateAER]) | Present Value of an FStep function | | | PVFStepQ (NPVDate, DisAER, Finish, FromDates, AnnualRates, [PmtsPerYearOpt]) | PVFStep, quick version | | PVFStepICQ (NPVDate, DisAER, Finish, FromDates, AnnualRates, [InvDate], [InvAmt], [CapRateAER], [PmtsPerYearOpt]) | PVFStepIC, quick version | | NPV Payments Family | What It Does |
|---|
| PVMkPmtsSF (NPVDate, DisAER, Start, Finish, PmtDates, Pmts, [DayCountDisc], [PrdsDisc]) | NPV of a MkPmtsSF function | | PVMkPmts (NPVDate, DisAER, PmtDates, Pmts, [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF]) | NPV of a MkPmts function | | NPV Time Spread Family | What It Does |
|---|
| PVGSpread (NPVDate, DisAER, Start, Total, [CompletionDate], [CurveModel], [Shape], [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF]) | Present Value of a GSpread | | PVUniSpread (NPVDate, DisAER, Start, Finish, Total, [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF]) | Present Value of a UniSpread | | PVSCurve (NPVDate, DisAER, Start, Finish, Total, [Skew], [Peakness], [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF]) | Present Value of a SCurve | | PVSCurveGrow (NPVDate, DisAER, Start, Finish, Total, [Skew], [Peakness], GrowthDates, GrowthRates, [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF]) | Present Value of a SCurveGrow | | PVDistSpread (NPVDate, DisAER, Start, MidPoint, Finish, Total, DistType, [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF]) | Present Value of a DistSpread | | PVFStepSpread (NPVDate, DisAER, Total, FromDates, AnnualRates, [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF]) | Present Value of a FStepSpread | | PVTStepSpread (NPVDate, DisAER, Total, ToDates, AnnualRates, [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF]) | Present Value of a TStepSpread | | PVMkPmtsWeighted (NPVDate, DisAER, Total, PmtDates, Weights, [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF]) | Present Value of a MkPmtsWeighted | | PVSCumCurve (NPVDate, DisAER, Start, Finish, Total, CumTime, CumAmt, [InterpType], [Tension], [Bias], [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF]) | Present Value of a SCumCurve | Time Value Of Money Analysis Category | | Basic Interest Rate Conversions Family | What It Does |
|---|
| SimpleToSimple (InterestSimple, PmtsPerYrSrce, PmtsPerYrTarg) | Converts a simple interest from one PmtsPerYear basis to another | | SimpleToAER (InterestSimple, PmtsPerYear) | Convert a simple interest rate to an AER (annual equivalent rate) | | SimpleToCont (InterestSimple, PmtsPerYear) | Convert a simple interest rate to a Continuous Interest Rate | | SimpleToDF (InterestSimple, PmtsPerYear, FromDate, ToDate, [DayCount], [Periods]) | Convert a simple interest rate to a discount factor | | | AERToSimple (InterestAER, PmtsPerYear) | Convert an AER (annual equivalent rate) to a simple interest rate | | AERToCont (InterestAER) | Convert an AER (annual equivalent rate) to a Continuous Interest Rate | | AERToDF (InterestAER, FromDate, ToDate, [DayCount], [Periods]) | Convert an AER (annual equivalent rate) to a discount factor | | | ContToSimple (InterestCont, PmtsPerYear) | Convert a continuous interest rate to a simple interest rate | | ContToAER (InterestCont) | Convert a Continuous Interest Rate to an AER (annual equivalent rate) | | ContToDF (InterestCont, FromDate, ToDate, [DayCount], [Periods]) | Convert a continuous interest rate to a discount factor | | | DFToSimple (DiscountFactor, PmtsPerYear, FromDate, ToDate, [DayCount], [Periods]) | Convert a discount factor to a simple interest rate | | DFToAER (DiscountFactor, FromDate, ToDate, [DayCount], [Periods]) | Convert a discount factor to an AER (annual equivalent rate) | | DFToCont (DiscountFactor, FromDate, ToDate, [DayCount], [Periods]) | Convert a discount factor to a continuous interest rate | | Advanced Interest Rate Conversions Family | What It Does |
|---|
| SimpleToSimpleX (FromDatesInt, IntSimple, FromDate, ToDate, [DayCountSource], [DayCountTarget], PrdsSource, PrdsTarget) | Convert an interest rate from one basis of daycount and periods to another. | | SimpleToAERX (FromDatesInt, IntSimple, FromDate, ToDate, [DayCountDisc], [PrdsDisc]) | Convert an interest rate from simple to an annual effective rate. | | SimpleToContX (FromDatesInt, IntSimple, FromDate, ToDate, [DayCountDisc], [PrdsDisc]) | Convert an interest rate from simple to continuous | | SimpleToDFX (FromDatesInt, IntSimple, FromDate, ToDate, [DayCountDisc], [PrdsDisc]) | Convert an interest rate from simple to a discount factor. | | | AERToSimpleX (InterestAER, FromDate, ToDate, [DayCountDisc], [PrdsDisc]) | Convert an AER (annual equivalent rate) to a simple interest rate. | | | ContToSimpleX (InterestCont, FromDate, ToDate, [DayCountDisc], [PrdsDisc]) | Convert a continuous interest rate to a simple one. | | | DFToSimpleX (DiscountFactor, FromDate, ToDate, [DayCountDisc], [PrdsDisc]) | Convert a discount factor to a simple interest rate. | | | RateConvert (FromDatesInt, IntSimple, FromDate, ToDate, [DayCountSource], [DayCountTarget], PrdsSource, PrdsTarget, [MarginOpt]) | Generic Rate Convert | | Annuity Family | What It Does |
|---|
| FVM (AnnPmt, PresentValue, InterestAER, TermYrs, PmtsPerYear) | Future Value of an annuity allowing for different periodicity of payments per year | | PVM (AnnPmt, InterestAER, TermYrs, PmtsPerYear, [FVOpt]) | Present Value of an Annuity allowing for different periodicity of payments per year | | PmtM (PresentValue, InterestAER, TermYrs, PmtsPerYear, [FVOpt]) | Annual Payment of an annuity allowing for different periodicity of payments per year | | TermM (AnnPmt, PresentValue, InterestAER, PmtsPerYear, [FVOpt]) | Length of the Term of an annuity allowing for different periodicity of payments per year | | IntRateM (AnnPmt, PresentValue, TermYrs, PmtsPerYear, [FVOpt]) | Interest Rate (AER-annual equivalent rate) of an annuity allowing for different periodicity of payments per year | | | PVEGAnn (DisAER, TermYrs, AnnGrowthRate) | Present Value of an Exponentially Growing Annuity | | PVEGAnnM (DisAER, TermYrs, PmtsPerYear, AnnGrowthRate, [GrowRevsPerYrOpt]) | Present Value of an Exponentially Growing Annuity | | PVEGPerAnn (DisAER, TermYrs, AnnGrowthRate, PmtIntervalYrs) | Present Value of an Exponentially Growing PERIODIC Annuity | | | PVEGPerp (DisAER, AnnGrowthRate) | Present Value of an Exponentially Growing Perpetuity | | PVEGPerpM (DisAER, PmtsPerYear, AnnGrowthRate, [GrowRevsPerYrOpt]) | Present Value of a Perpetuity | | PVEGPerPerp (DisAER, AnnGrowthRate, PmtIntervalYrs) | Present Value of an Exponentially Growing PERIODIC Perpetuity | | | PVLGAnn (DisAER, TermYrs, AnnGrowthRate) | Present Value of a linearly growing annuity | | PVLGAnnM (DisAER, TermYrs, PmtsPerYear, AnnGrowthRate, [GrowRevsPerYrOpt]) | Present Value of a linearly growing annuity, where there is more than one payment made per year | | PVLGPerp (TermYrs, AnnGrowthRate) | Present Value of a linearly growing perpetuity | | PVLGPerpM (TermYrs, PmtsPerYear, AnnGrowthRate, [GrowRevsPerYrOpt]) | Present Value of a linearly growing perpetuity, where there is more than one payment made per year | | | SumEGAnn (TermYrs, AnnGrowthRate) | Sum of an exponentially growing annuity (growth annually in arrear). | | SumEGAnnM (TermYrs, AnnGrowthRate, [GrowRevsPerYrOpt]) | Sum of an exponentially growing annuity (growth applied with specified frequency). | | SumEGAnnCont (TermYrs, AnnGrowthRate) | Sum of an exponentially growing annuity (growth annually in arrear). | | | SumLGAnn (TermYrs, AnnGrowthRate) | The sum of a linearly growing annuity (growth annually in arrear) | | SumLGAnnM (TermYrs, AnnGrowthRate, [GrowRevsPerYrOpt]) | The sum of a linearly growing annuity, taking into account the number of changes in rate per year. | | SumLGAnnCont (TermYrs, AnnGrowthRate) | The sum of a linearly growing annuity assuming constant continuous growth | | Annuity Extended Family | What It Does |
|---|
| PVBF (DrawDate, NumPmts, InterestSimple, Pmt, [FVOpt], [DayCount], [PrdsInt]) | Present Value of an annuity using industry values for interest daycount and period frequency. | | FVBF (PresentValue, DrawDate, NumPmts, InterestSimple, Pmt, [DayCount], [PrdsInt]) | Future Value | | PMTBF (PresentValue, DrawDate, NumPmts, InterestSimple, [FVOpt], [DayCount], [PrdsInt]) | Annuity Payment using industry values for interest daycount and period frequency. | | RateBF (PresentValue, DrawDate, NumPmts, Pmt, [FVOpt], [DayCount], [PrdsInt]) | Annual interest rate (simple) of an annuity using industry values for interest daycount and period frequency. | | NPerBF (PresentValue, DrawDate, InterestSimple, Pmt, [FVOpt], [DayCount], [PrdsInt]) | Repayment Date | | | PVBFX (FromDatesInt, IntSimple, DrawDate, NumPmts, Pmt, [FVOpt], [DayCount], [PrdsInt], [StartDCF], [FinishDCF]) | PV of an annuity | | US APR Family | What It Does |
|---|
| APRToQuoted (LoanAmount, Fees, USAPR, TermYrs, PmtsPerYear) | Convert a US style APR to a quoted interest rate | |
|