|
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 | | QuotedToAPR (LoanAmount, Fees, TermYrs, QuotedRate, PmtsPerYear) | Convert a quoted simple annual interest rate to a US style APR | Discounted Cash Flow Category | | DCF One-Off Family | What It Does |
|---|
| PVOne (TheDate, NPVDate, DisAER, [DayCountDisc], [PrdsDisc]) | Determine the NPV of a future single payment of 1 dollar (ie a factor) | | FPVOne (TheDate, NPVDate, DiscRatesAER, FromDates, [DayCountDisc], [PrdsDisc]) | PV of a single payment using a discount rate that changes over time according to FromDates | | TPVOne (TheDate, NPVDate, DiscRatesAER, ToDates, [DayCountDisc], [PrdsDisc]) | PV of a single payment using a discount rate that changes over time according to ToDates | | PVOneQ (TheDate, NPVDate, DisAER) | Determine the NPV of a future single payment of 1 dollar (Quick Version) | | DCF Annual Family | What It Does |
|---|
| PVA (NPVDate, DisAER, AnnualCashFlows, StartAnnDate, [DCountDisc], [StartDCF], [FinishDCF]) | Present Value of an annual stream of cashflows | | IRRA (AnnualCashFlows, [IRRMinOpt], [IRRMaxOpt], [IRRAccOpt]) | Internal Rate of Return of an annual stream of cashflows | | PayBackA (AnnualCashFlows, StartAnnDate, [MinPayBack], [Interpolate], [DCount], [PayBackOptions]) | Payback date for Annual cash flows | | PayBackDiscA (DisAER, AnnualCashFlows, StartAnnDate, [MinPayBack], [Interpolate], [DCountDisc], [PayBackOptions]) | Discounted Payback Date for Annual DCF | | EACF (DisAER, AnnualCashFlows, [DCountDisc]) | Equivalent Annual Cash Flow | | DurationA (NPVDate, DisAER, AnnualCashFlows, StartAnnDate, [DCountDisc]) | Macaulay Duration | | AvLifeA (Start, AnnualCashFlows, StartAnnDate, [DCountDisc]) | Average Life | | DCF Even Intervals Family | What It Does |
|---|
| PVE (NPVDate, DisAER, EvenCashFlows, EvenTimeStart, EvenTimeInterval, [StartDCF], [FinishDCF]) | NPV for an evenly spaced (not necessarily annual) series of cashflows | | IRRE (EvenCashFlows, EvenTimeInterval, [IRRMinOpt], [IRRMaxOpt], [IRRAccOpt]) | IRR for an evenly spaced (not necessarily annual) series of cashflows | | PaybackE (EvenCashFlows, EvenTimeStart, EvenTimeInterval, [MinPayBack], [Interpolate], [PayBackOptions]) | Payback Date | | PayBackDiscE (DisAER, EvenCashFlows, EvenTimeStart, EvenTimeInterval, [MinPayBack], [Interpolate], [PayBackOptions]) | Discounted Payback Date | | EECF (DisAER, EvenCashFlows, EvenTimeInterval) | Equivalent Even Cash Flow | | DurationE (NPVDate, DisAER, EvenCashFlows, EvenTimeStart, EvenTimeInterval) | Macaulay Duration | | AvLifeE (Start, EvenCashFlows, EvenTimeStart, EvenTimeInterval) | Average Life | | DCF Specific Times Family | What It Does |
|---|
| PVT (NPVDate, DisAER, Dates, Cashflows, [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF], [PVTOptions]) | Present Value of cashflows at specific Dates | | IRRT (Dates, Cashflows, [IRRMinOpt], [IRRMaxOpt], [IRRAccOpt], [DayCountDisc], [PrdsDisc], [PVTOptions]) | Internal Rate of Return of cashflows at specific times | | PayBackT (Dates, Cashflows, [MinPayBack], [Interpolate], [DayCount], [Periods], [PayBackOptions]) | Payback Date | | PayBackDiscT (DisAER, Dates, Cashflows, [MinPayBack], [Interpolate], [DayCountDisc], [PrdsDisc], [PayBackOptions]) | Discounted Payback Date | | EACFT (Dates, Cashflows, [DayCountDisc], [PrdsDisc]) | Equivalent Annual Cash Flow | | DurationT (NPVDate, DisAER, Dates, Cashflows, [DayCountDisc], [PrdsDisc]) | Macaulay Duration | | AvLifeT (Start, Dates, Cashflows, [DayCountDisc], [PrdsDisc]) | Average Life | | | PVTIC (NPVDate, DisAER, Dates, Cashflows, [DayCountDisc], [PrdsDisc], [InvDate], [InvAmt], [CapRateAER], [StartDCF], [FinishDCF], [CapOption], [PVTOptions]) | PVT with Investment and Capitalisation | | IRRTIC (Dates, Cashflows, [IRRMinOpt], [IRRMaxOpt], [IRRAccOpt], [DayCountDisc], [PrdsDisc], [InvDate], [InvAmt], [CapRateAER], [StartDCF], [FinishDCF], [CapOption], [PVTOptions]) | Internal Rate of Return of cashflows at specific times | | | PVTX (NPVDate, DisAER, Dates, Cashflows, [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF], [PVTOptions], [Dates2], [Cashflows2], [Dates3], [Cashflows3], [Dates4], [Cashflows4]) | PVT Extended | | IRRTX (Dates, Cashflows, [IRRMinOpt], [IRRMaxOpt], [IRRAccOpt], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF], [PVTOptions], [Dates2], [Cashflows2], [Dates3], [Cashflows3], [Dates4], [Cashflows4]) | Internal Rate of Return of cashflows at specific times, extended version | | | PVTCX (NPVDate, DisAER, Dates, Cashflows, [IRRMinOpt], [IRRMaxOpt], [IRRAccOpt], [DayCountDisc], [PrdsDisc], [CapRateAER], [StartDCF], [FinishDCF], [CapOption], [PVTOptions], [Dates2], [Cashflows2], [Dates3], [Cashflows3], [Dates4], [Cashflows4]) | PVT Extended with capitalisation | | IRRTCX (Dates, Cashflows, [IRRMinOpt], [IRRMaxOpt], [IRRAccOpt], [DayCountDisc], [PrdsDisc], [CapRateAER], [StartDCF], [FinishDCF], [CapOption], [PVTOptions], [Dates2], [Cashflows2], [Dates3], [Cashflows3], [Dates4], [Cashflows4]) | Internal Rate of Return of cashflows at specific times | | DCF Dispersed Annual Family | What It Does |
|---|
| | NPVM (NPVDate, DisAER, AnnualCashFlows, StartAnnDate, PmtsPerYear) | Present Value of annual cash flows that are annually specified that are assumed to take place at intervals over the year | | PVSFM (NPVDate, DisAER, Start, AnnualCashFlows, StartAnnDate, Finish, PmtsPerYear) | Present Value of annually dispersed cashflows, with a start and finish date | | IRRM (AnnualCashFlows, PmtsPerYear, [IRRMinOpt], [IRRMaxOpt], [IRRAccOpt]) | IRR for cash flows that are annually specified that are assumed to take place at intervals over the year | | | CorrectionM (DisAER, PmtsPerYear) | Correction Factor to multiply an NPV for annually spaced cashflows to convert to cashflows spaced over the year | | CorrectionCont (DisAER) | Correction Factor to multiply an NPV for annually spaced cashflows to convert to cashflows spaced continuously throughout the year | | CorrectionDC (NPVDate, DisAER, [DayCount], [CashBasis]) | NPV Correction Factor for DayCount | | EACFM (DisAER, AnnualCashFlows, PmtsPerYear) | Equivalent Annual Cash Flow | | DurationM (NPVDate, DisAER, AnnualCashFlows, StartAnnDate, PmtsPerYear) | Macaulay Duration | | AvLifeM (Start, AnnualCashFlows, StartAnnDate, PmtsPerYear) | Average Life | | EffTimeM (DisAER, PmtsPerYear) | Effective Time when cashflow is dispersed over the year | Accounting And Tax Category | | Accounting Family | What It Does |
|---|
| Depreciate (Time, Base, StartDep, LifeOrDecRate, DepType, InitialValue, [FinalValue], [DayCount], [Periods], [ProjMode]) | Depreciate | | DepreciatedValue (TheDate, InitialDate, StartDep, LifeOrDecRate, DepType, InitialValue, [FinalValue], [DayCount], [Periods], [ProjMode]) | Calculate the Depreciated Value | | | DepPoolWIP (Time, Base, FromDatesInt, IntSimple, AdditionDates, Additions, ISDates, LifeOrDecRate, DepType, [FinalValue], [DepSwitch], [DayCount], [Periods], [DayCountDisc], [PrdsDisc]) | Operate a Depreciation Pool using the WIP method | | DepPoolRatio (Time, Base, FromDatesInt, IntSimple, AdditionDates, Additions, ISDates, ISPortions, LifeOrDecRate, DepType, [FinalValue], [DepSwitch], [DayCount], [Periods], [DayCountDisc], [PrdsDisc]) | Operate a Depreciation Pool using the Ratio method | | DepPool (Time, Base, FromDatesInt, IntSimple, AdditionDates, Additions, ISDates, ISPortions, LifeOrDecRate, DepType, [FinalValue], [DepSwitch], [DayCount], [Periods], [DayCountDisc], [PrdsDisc]) | Operate a Depreciation Pool using either the WIP or the Ratio method | | | DepreciatePer (Time, Base, AbsFinish, StartDep, LifeOrDecRate, DepType, InitialValue, [FinalValue], Periodicity, [DayCount], [Periods], [ProjMode]) | Depreciate Periodic | | DepreciateGrowPer (Time, Base, AbsFinish, StartDep, LifeOrDecRate, DepType, InitialValue, [FinalValue], GrowthDates, GrowthRates, Periodicity, [DayCount], [Periods], [ProjMode]) | Depreciate Periodic | | DepreciateFcstPer (Time, Base, AbsFinish, StartDep, LifeOrDecRate, DepType, InitialValue, [FinalValue], FcstVals, StartFcst, FcstBase, Periodicity, [DayCount], [Periods], [ProjMode]) | Depreciate Periodic | | DepreciateIdxPer (Time, Base, AbsFinish, StartDep, LifeOrDecRate, DepType, InitialValue, [FinalValue], IdxFcstVals, IdxStartFcst, IdxFcstBase, [BaseDateOrIdx], Periodicity, [DayCount], [Periods], [ProjMode]) | Depreciate Periodic | | | LIFOPrice (Disposal, Additions, Prices) | Calculate the average price of a stock movement using LIFO (last in first out) | | LIFOCalc (AdditionDates, Additions, Prices, OutputSwitch) | Does a full LIFO calculation to output all the columns of results | | Tax Family | What It Does |
|---|
| FAvRate (Amount, MargRates, FromThresholds) | Calculates the average tax rate given a series of marginal tax rates effective FROM, or ABOVE certain thresholds | | TAvRate (Amount, MargRates, ToThresholds) | Calculates the average tax rate given a series of marginal tax rates effective UP TO certain thresholds | | | FAvRateTD (Amount, MargRates, FromThresholds, FromDatesTh, InputDateValue) | Average Rate (Time Dependent). Calculates the average tax rate given a series of marginal tax rates effective FROM certain dates and FROM, or ABOVE certain thresholds | | TAvRateTD (Amount, MargRates, ToThresholds, ToDates, InputDateValue) | Average Rate (Time Dependent). Calculates the average tax rate given a series of marginal tax rates effective UP TO certain dates and UP TO certain thresholds. | Mathematical Calculations Category | | Statistics Family | What It Does |
|---|
| | LinReg (LRSwitch, YValues, XValues) | Linear Regression | | BestPoly (YValues, XValues, [MaxDegPoly]) | Find the best degree for regressing a polynomial | | SignChanges (YValues, [SignChangeType], [Tolerance]) | Number of Sign Changes | | RSqrdPoly (Coefficients, YValues, XValues) | R Squared For a Polynomial | | PolyEqn (Coefficients) | Show the polynomial equation as text | | CalcPoly (x, Coefficients) | Calculates a result of a polynomial equation based on the coefficients in a range | | PolyRoot (Degree, YValues, XValues, [MinRSqrdOpt]) | Fit a polynomial and then find its root (x value at y=0). Will detect the best order of polynomial if required (if Degree=0). | | PolyReg (Degree, YValues, XValues, [MinRSqrdOpt], [MaxDegPoly]) | Polynomial Regression. Fit a polynomial to a set of data. Will detect the best order of polynomial if required (if Degree=0). | Range Operations Category | | Range Lookup Family | What It Does |
|---|
| LookupNum (InputRange, OutputRange, InputValue, [LookupSwitch], [LookupTol], [OnErrorN]) | Do a general Lookup using numbers | | LookupN (InputVal, InputRange, OutputRange, [LookupSwitch], [LookupTol], [OnErrorN]) | Do a general Lookup using numbers | | SeekNum (InputRange, OutputRange, InputValue) | Seek a number in a list of numbers and look up a corresponding number in another list | | | PickNum (WhichOne, OutputRange) | Pick an numeric item from a list of numeric items | | SortPick (WhichOne, Values, [Direction]) | Pick a number from a list of numbers after sorting the list first | | | LookUpNum2D (OutputMatrix, AxisRangeX, AxisRangeY, InputValueX, InputValueY, [LookupSwitch]) | Lookup2D | | PickMatrix (OutputMatrix, i, j) | PickMatrix | | | LookupNIndex (InputVal, InputRange, [LookupSwitch], [LookupTol], [OnErrorN]) | Like LookupN but instead of a returning a valoue it tells you the index number of the source range | | Seek (InputRangePoly, OutputRangePoly, InputPoly_s, [DefaultPoly]) | Seek a item (number, date or text) in a list of numbers and look up a corresponding item in another list | | SeekList (InputRangePoly, OutputMatrixPoly, InputPoly) | Lookup a list and return a one-D list of items from a 2D matrix | | SortNum (Values, [Direction]) | Sort a range of numbers | | | FindIf (InpList, OutList, Criteria, [FindSwitch], [CritOpts]) | Find one or more values in a list, depending on criteria | | Range Sum Family | What It Does |
|---|
| DoBetweenX (XMin, XMax, XValues, YValues, [IncOpt], [RangeOperation]) | Do operations on a the Y values of an X-Y data range | | SumCat (Values, Categories, ChosenCategory) | Sum a range by Category number | | SumCats (Values, Categories, [ChosenCategories], [Options], [CatMin], [CatMax]) | Sum by more than one Category number | | | SumPos (Values) | Sums the positive numbers in a range | | SumNeg (Values) | Sums the negative values in a range | | SumDiv (Values1, [Values2]) | Sum of one range divided by another | | SumBounds (Minimum, Maximum, Values) | Sum within Bounds | | | SumSubRange (Values, iStart, iFinish) | Sum a subrange within a range | | SumCombine (CombineSwitch, Values1, [Values2], [Values3], [Values4]) | BF version of SumProduct | | | DoIf (Operation, ListIn, [ListOut], Criteria, [CritOpts], [DefValOnErr]) | Do an operation, such as SUMIF, across several sheets | | SelCats (Values, Categories, [ChosenCategories], [Options], [CatMin], [CatMax]) | Select values and create a range based on categories | | Range Reference Family | What It Does |
|---|
| Coordinates (RangeRef) | Get the cell co-ordinates given a reference to a cell | | WorkSheetName (RangeRef) | Get the sheet name given a reference to a cell | | RefPlus (RangeRef, Rows, Cols) | Take a cell reference and return a text reference plus rows and columns | | GetRef (RangeRef) | Get a Cell Reference as text, given a reference to a cell | | Range Calcs Family | What It Does |
|---|
| MinBetween (Minimum, Maximum, Values, [Values2], [Values3], [Values4]) | Determine the minimum value providing that value is within a certain minimum and a maximum | | MaxBetween (Minimum, Maximum, Values, [Values2], [Values3], [Values4]) | Determine the maximum value providing that value is within a certain minimum and a maximum | | | MeanNZ (Values) | Determine the Mean of all non zero items | | | WeightAv (Values, Weights) | Weighted Average | | Range Information Family | What It Does |
|---|
| RangeDir (Values) | Tells you the Range Direction (ascending, descending) | | Range Manipulation Family | What It Does |
|---|
| CRC_fl (InputRange) | TBA | | OneD (Input) | Turn a range into a one dimensional, BF-style range | | MatchList (InpList, InpVal_s) | TBA | | SortText (Textstrings, [Direction]) | Sort an array of text (strings) | | SubList (List, IncludeTrueFalse) | Create sub list based on true/false criteria | | ApplyToList (Number, ArithSwitch, Values) | Apply a number to a list eg multiply. add etc | | PickEveryNth (List, PickEvery, [StartingAt], [TrimSwitch]) | Pick every Nth value from a list | | CombineLists (CombineSwitch, Values1, [Values2], [Values3], [Values4]) | Combine 2 lists of numerical values | | TransposeNum (Values) | Transpose a number array | | CreateList (TrimSwitch, [Item1], [Item2], [Item3], [Item4], [Item5], [Item6], [Item7], [Item8], [Item9], [Item10], [Item11], [Item12], [Item13], [Item14], [Item15], [Item16], [Item17], [Item18], [Item19], [Item20], [Item21], [Item22], [Item23], [Item24], [Item25], [Item26], [Item27], [Item28]) | Creat a list (range) of numbers or text from a series of cell references | | TrimList (List, [TrimSwitch]) | Trim a list (1 dimensional range) | | JoinLists (TrimSwitch, List1, [List2], [List3], [List4]) | Join 1 or more lists (1 dimensional ranges) | | Unique (PolyList) | Extract unique values from list | | Interpolation Family | What It Does |
|---|
| Interp (InputRange, OutputRange, InputValue, [InterpType], [Tension], [Bias]) | Interpolate | | Interpolate (InputRange, OutputRange, InputValue, [Extrap], [MinimumOpt], [MaximumOpt], [InterpType], [Tension], [Bias]) | Do a lookup that interpolates between values | | InterpDate (InputDateRange, OutputRange, InputDateValue, [InterpType], [Tension], [Bias], [DayCount], [Periods]) | Interpolate for Date inputs. | | InterpolateDate (InputDateRange, OutputData, InputDateValue, [Extrap], [MinimumOpt], [MaximumOpt], [InterpType], [Tension], [Bias], [DayCount], [Periods]) | Do a lookup that interpolates between date values | | | Intersection (YValues, XValues, YValues2, XValues2) | Find the intersection of 2 lines | Simulation Modelling Category | | Monte Carlo Family | What It Does |
|---|
| Distribution (DistMin, DistMid, DistMax, DistType, [RandOpt]) | Generate a value from a probability distribution | | PartialDependency (AxisRangeX, InputValueX, InputValuesMin, InputValuesMid, InputValuesMax, DistType, [RandOpt]) | Generate a value from a probability distribution where there is a graphical partial dependency | | DistCumulative (CumProbs, Values, [CumSwitch], [RandOpt]) | Generate a value from a specified cumulative probability distribution | | | DistUniform (DistMin, DistMax, [RandOpt]) | Generate a value from a uniform probability distribution | | DistTriangular (DistMin, DistMid, DistMax, [RandOpt]) | Generate a value from a triangular probability distribution | | DistDoubleTri (DistMin, DistMid, DistMax, [RandOpt]) | Generate a value from a double triangular distribution | | DistNormal (StanDev, Mean, [RandOpt]) | Generate a value from a normal probability distribution | | DistLogNormal (StanDev, Mean, [RandOpt]) | Generate a value from a log-normal probability distribution | | | RandNum () | Compute a semi random number | | NRandom () | Number of Random Number in Sequence | | PickRandom (WhichOne) | Pick a specific random number from a set of random numbers | | DescribeDistType (DistType) | Describes the value used for DistType | | CumProb (Deviate, DistMin, DistMid, DistMax, DistType, [ClipTailLevel]) | Find the cumulative probability level for a given deviate value from a distribution | | Shuffle (Values) | TBA | Real Estate Category | | Rent Family | What It Does |
|---|
| RentGrow (Time, Base, RentStart, BrksOrExp, FirstRev, MktRent, InitRent, GrowthDates, GrowthRates, [RevMos], [RevDisc], [DayCount], [Periods], [ProjMode], [UOTog], [Brk]) | Rent with Growth | | | RentFcst (Time, Base, RentStart, BrksOrExp, FirstRev, InitRent, FcstVals, StartFcst, FcstBase, [RevMos], [RevDisc], [DayCount], [Periods], [ProjMode], [UOTog], [Brk]) | Rent using a rental forecast at reviews | | | RentLevelGrow (TheDate, RentStart, BrksOrExp, FirstRev, MktRent, InitRent, GrowthDates, GrowthRates, [RevMos], [RevDisc], [UOTog], [Brk]) | Calculates the absolute rental level given a set of GrowthRates | | RentLevelFcst (TheDate, RentStart, BrksOrExp, FirstRev, InitRent, FcstVals, StartFcst, FcstBase, [RevMos], [RevDisc], [UOTog], [Brk]) | Calculated the absolute Rent Level from a forecast | | Rent From Family | What It Does |
|---|
| FStepRent (Time, Base, BrksOrExp, FromDates, AnnRents, [DayCount], [Periods], [ProjMode], [Brk]) | Stepped Rent using review dates that specify when rents change, where the dates are FromDates rather than "up until" dates | | | FStepRentGrow (Time, Base, BrksOrExp, MktRent, FromDates, AnnRents, GrowthDates, GrowthRates, [RevToMkt], [RevMos], [RevDisc], [DayCount], [Periods], [ProjMode], [UOTog], [Brk]) | Stepped Rent using review dates that specify when rents change, where the dates are FromDates rather than "up until" dates | | FStepRentFcst (Time, Base, BrksOrExp, FromDates, AnnRents, FcstVals, StartFcst, FcstBase, [RevToMkt], [RevMos], [RevDisc], [DayCount], [Periods], [ProjMode], [UOTog], [Brk]) | Stepped Rent using a supplied forecast, using FromDates | | | FStepRentFcstCollar (Time, Base, BrksOrExp, FromDates, AnnRents, FcstVals, StartFcst, FcstBase, AnnRentCaps, AnnRentFloors, [RevToMkt], [RevMos], [RevDisc], [DayCount], [Periods], [ProjMode], [UOTog], [Brk]) | Stepped Rent using a supplied forecast, using FromDates where the rent is "collared" between caps and floors | | FStepRentGrowCollar (Time, Base, BrksOrExp, MktRent, FromDates, AnnRents, AnnRentCaps, AnnRentFloors, GrowthDates, GrowthRates, [RevToMkt], [RevMos], [RevDisc], [DayCount], [Periods], [ProjMode], [UOTog], [Brk]) | Stepped Rent using a forecast for rental growth at reviews, keeping the rental level within a collar | | Rent To Family | What It Does |
|---|
| TStepRent (Time, Base, RentStart, ReviewDates, AnnRents, [DayCount], [Periods], [ProjMode]) | Stepped Rent using review dates that specify when rents change | | | TStepRentGrow (Time, Base, RentStart, BrksOrExp, MktRent, ReviewDates, AnnRents, GrowthDates, GrowthRates, [RevMos], [RevDisc], [DayCount], [Periods], [ProjMode], [UOTog], [Brk]) | Stepped Rent, using a forecast for rental growth at reviews | | TStepRentFcst (Time, Base, RentStart, BrksOrExp, ReviewDates, AnnRents, FcstVals, StartFcst, FcstBase, [RevMos], [RevDisc], [DayCount], [Periods], [ProjMode], [UOTog], [Brk]) | Stepped Rent using a rental forecast at reviews | | | TStepRentGrowCollar (Time, Base, RentStart, BrksOrExp, MktRent, ReviewDates, AnnRents, AnnRentCaps, AnnRentFloors, GrowthDates, GrowthRates, [RevMos], [RevDisc], [DayCount], [Periods], [ProjMode], [UOTog], [Brk]) | Stepped Rent using a forecast for rental growth at reviews, keeping the rental level within a collar | | TStepRentFcstCollar (Time, Base, RentStart, BrksOrExp, ReviewDates, AnnRents, FcstVals, StartFcst, FcstBase, AnnRentCaps, AnnRentFloors, [RevMos], [RevDisc], [DayCount], [Periods], [ProjMode], [UOTog], [Brk]) | Stepped Rent using a rental forecast at reviews, keeping the rental level within a collar | | Rent Reletting Family | What It Does |
|---|
| RentFcstR (Time, Base, RentStart, BrksOrExp, FirstRev, InitRent, FcstVals, StartFcst, FcstBase, [RevMos], [RevDisc], [RelVoid_s], [RelRF_s], [RelTerm_s], [DayCount], [Periods], [ProjMode], [AbFin], [UOTog], [ROpts], [Brk]) | RentFcst with reletting | | RentGrowR (Time, Base, RentStart, BrksOrExp, FirstRev, MktRent_s, InitRent, GrowthDates, GrowthRates, [RevMos], [RevDisc], [RelVoid_s], [RelRF_s], [RelTerm_s], [DayCount], [Periods], [ProjMode], [AbFin], [UOTog], [ROpts], [Brk]) | Rent Grow with Reletting | | | FStepRentGrowR (Time, Base, BrksOrExp, MktRent_s, FromDates, AnnRents, GrowthDates, GrowthRates, [RevToMkt], [RevMos], [RevDisc], [RelVoid_s], [RelRF_s], [RelTerm_s], [DayCount], [Periods], [ProjMode], [AbFin], [UOTog], [ROpts], [Brk]) | Stepped Rent using "from" dates and growth rates with reletting | | FStepRentFcstR (Time, Base, BrksOrExp, FromDates, AnnRents, FcstVals, StartFcst, FcstBase, [RevToMkt], [RevMos], [RevDisc], [RelVoid_s], [RelRF_s], [RelTerm_s], [DayCount], [Periods], [ProjMode], [AbFin], [UOTog], [ROpts], [Brk]) | Stepped Rent using "from" dates and a market forecast with reletting | | | TStepRentGrowR (Time, Base, RentStart, BrksOrExp, MktRent_s, ReviewDates, AnnRents, GrowthDates, GrowthRates, [RevMos], [RevDisc], [RelVoid_s], [RelRF_s], [RelTerm_s], [DayCount], [Periods], [ProjMode], [AbFin], [UOTog], [ROpts], [Brk]) | Stepped Rent using "to" dates and a market forecast with reletting | | TStepRentFcstR (Time, Base, RentStart, BrksOrExp, ReviewDates, AnnRents, FcstVals, StartFcst, FcstBase, [RevMos], [RevDisc], [RelVoid_s], [RelRF_s], [RelTerm_s], [DayCount], [Periods], [ProjMode], [AbFin], [UOTog], [ROpts], [Brk]) | TStepRentFcst with reletting | | | TStepRentGrowSFR (Time, Base, AbsStart, RentStart, AbsFinish, BrksOrExp, MktRent_s, ReviewDates, AnnRents, GrowthDates, GrowthRates, [RevMos], [RevDisc], [RelVoid_s], [RelRF_s], [RelTerm_s], [DayCount], [Periods], [ProjMode], [UOTog], [ROpts], [Brk]) | TStepRentGrowR with an overriding Start and Finish Date | | FStepRentGrowSFR (Time, Base, AbsStart, AbsFinish, BrksOrExp, MktRent_s, FromDates, AnnRents, GrowthDates, GrowthRates, [RevToMkt], [RevMos], [RevDisc], [RelVoid_s], [RelRF_s], [RelTerm_s], [DayCount], [Periods], [ProjMode], [UOTog], [ROpts], [Brk]) | FStepRentGrowR with an overriding Start and Finish Date | | TStepRentFcstSFR (Time, Base, AbsStart, RentStart, AbsFinish, BrksOrExp, ReviewDates, AnnRents, FcstVals, StartFcst, FcstBase, [RevMos], [RevDisc], [RelVoid_s], [RelRF_s], [RelTerm_s], [DayCount], [Periods], [ProjMode], [UOTog], [ROpts], [Brk]) | TStepRentFcstR with an overriding Start and Finish Date | | FStepRentFcstSFR (Time, Base, AbsStart, AbsFinish, BrksOrExp, FromDates, AnnRents, FcstVals, StartFcst, FcstBase, [RevToMkt], [RevMos], [RevDisc], [RelVoid_s], [RelRF_s], [RelTerm_s], [DayCount], [Periods], [ProjMode], [UOTog], [ROpts], [Brk]) | FStepRentFcstR with an overriding Start and Finish Date | | UK Valuation Family | What It Does |
|---|
| CapValueTStepRentFcstR (ValuationDate, Yield, DisAER, RentStart, BrksOrExp, ReviewDates, AnnRents, FcstVals, StartFcst, FcstBase, [RevMos], [RevDisc], [RelVoid_s], [RelRF_s], [RelTerm_s], [CostsPerc], [DayCount], [CashBasis], [CapOptions], [UOTog], [ROpts], [Brk]) | TBA | | CapValueTStepRentGrowR (ValuationDate, Yield, DisAER, RentStart, BrksOrExp, MktRent_s, ReviewDates, AnnRents, GrowthDates, GrowthRates, [RevMos], [RevDisc], [RelVoid_s], [RelRF_s], [RelTerm_s], [CostsPerc], [DayCount], [CashBasis], [CapOptions], [UOTog], [ROpts], [Brk]) | TBA | | CapValue (Yield, MktRent, PassingAnnRent, MonthsNextRev, [RentFreeMonths], [CostsPerc], [PmtsPerYearOpt], [YieldTypeOpt]) | Cap Value (UK Real Estate Conventional Math) | | EqYield (Valuation, MktRent, PassingAnnRent, MonthsNextRev, [RentFreeMonths], [CostsPerc], [PmtsPerYearOpt], [YieldTypeOpt]) | Equivalent Yield (UK Real Estate Conventional Math) | | CapValueG (Yield, AnnRents, DeferralMonths, [CostsPerc], [PmtsPerYearOpt], [YieldTypeOpt]) | Cap Value (UK Real Estate Conventional Math), extended version | | EqYieldG (Valuation, AnnRents, DeferralMonths, [CostsPerc], [PmtsPerYearOpt], [YieldTypeOpt]) | Equivalent Yield (UK Real Estate Conventional Math) | | CapValueGD (ValuationDate, Yield, FromDates, AnnRents, [CostsPerc], [PmtsPerYearOpt], [CapOptions]) | Cap Value (UK Real Estate Conventional Math), extended version, extended version | | EqYieldGD (ValuationDate, Valuation, FromDates, AnnRents, [CostsPerc], [PmtsPerYearOpt], [CapOptions]) | Equivalent Yield (UK Real Estate Conventional Math), extended version, extended version | | | NomToTrue (NomYield, PmtsPerYear) | Convert a Nominal (Simple) Yield to a True (APR) Yield | | TrueToNom (TrueYield, PmtsPerYear) | Convert a True (APR) Yield to a Nominal (Simple) Yield | | YPPDef (Yield, [MonthsDeferred], [PmtsPerYearOpt], [YieldTypeOpt]) | Years Purchase of a Perpetuity | | | CapValueGrowGD (ValuationDate, Yield, MktRent, FromDates, AnnRents, [GrowthDatesOpt], [GrowthRatesOpt], [RevToMkt], [CostsPerc], [PmtsPerYearOpt], [CapOptions]) | CapValueGD with reversion to market | | CapValueFcstGD (ValuationDate, Yield, FromDates, AnnRents, FcstVals, StartFcst, FcstBase, [RevToMkt], [CostsPerc], [PmtsPerYearOpt], [CapOptions]) | CapValueGD with reversion to market | | EqYieldGrowGD (ValuationDate, Valuation, MktRent, FromDates, AnnRents, [GrowthDatesOpt], [GrowthRatesOpt], [RevToMkt], [CostsPerc], [PmtsPerYearOpt], [CapOptions]) | Inverse of CapValueGrowGD | | EqYieldFcstGD (ValuationDate, Valuation, FromDates, AnnRents, FcstVals, StartFcst, FcstBase, [RevToMkt], [CostsPerc], [PmtsPerYearOpt], [CapOptions]) | Inverse of CapValueFcstGD | | UK Valuation DCF Family | What It Does |
|---|
| CapValueDCF (Yield, DisAER, PmtsPerYear, MktRent, PassingAnnRent, [RevMos], MonthsNextRev, [RentFreeMonths], [CostsPerc], [YieldTypeOpt]) | Cap Value (DCF Math) | | EqYieldDCF (Valuation, DisAER, PmtsPerYear, MktRent, PassingAnnRent, [RevMos], MonthsNextRev, [RentFreeMonths], [CostsPerc], [YieldTypeOpt]) | Equivalent Yield (DCF Math) | | CapValueDCFG (Yield, DisAER, PmtsPerYear, AnnRents, DeferralMonths, [RevMos], [CostsPerc], [YieldTypeOpt]) | Cap Value (DCF Math) | | EqYieldDCFG (Valuation, DisAER, PmtsPerYear, AnnRents, DeferralMonths, [RevMos], [CostsPerc], [YieldTypeOpt]) | Equivalent Yield (DCF Math) | | CapValueDCFGD (ValuationDate, Yield, DisAER, PmtsPerYear, FromDates, AnnRents, [RevMos], [CostsPerc], [CapOptions]) | Cap Value (DCF Math) | | EqYieldDCFGD (ValuationDate, Valuation, DisAER, PmtsPerYear, FromDates, AnnRents, [RevMos], [CostsPerc], [CapOptions]) | Equivalent Yield (DCF Math) | | | NomToTrueDCF (NomYield, PmtsPerYear, DiscAER) | Convert a Nominal (Simple) Yield to a True (APR) Yield, DCF Math | | TrueToNomDCF (TrueYield, PmtsPerYear, DiscAER) | Convert a True (APR) Yield to a Nominal (Simple) Yield, DCF Math | | YPADefDCF (DisAER, [MonthsDeferred], AnnuityEndMonths, [PmtsPerYearOpt]) | Years Purchase of a Annuity (using DCF Math) | | YPPDefDCF (Yield, DisAER, [MonthsDeferred], [RevMonths], [PmtsPerYearOpt], [YieldTypeOpt]) | Years Purchase of a Perpetuity (using DCF Math) | | TheorYield (DisAER, GrowthRatePA, [RevMonths], [PmtsPerYearOpt], [YieldTypeOpt]) | Theoretical Yield | | ImpGrowth (Yield, DisAER, [RevMonths], [PmtsPerYearOpt], [YieldTypeOpt]) | Growth implied by a yield and a discount rate | | ImpDiscRate (Yield, GrowthRatePA, [RevMonths], [PmtsPerYearOpt], [YieldTypeOpt]) | Implied Discount Rate APR pa | | PVRent (DisAER, GrowthRatePA, [RevMonths], [PmtsPerYearOpt]) | PV of $1 per year in rent (exponentially growing perpetuity with periodic reviews) | | | CapValueGrowDCFGD (Yield, DisAER, PmtsPerYear, MktRent, AnnRents, DeferralMonths, [GrowthDatesOpt], [GrowthRatesOpt], [RevToMkt], [RevMos], [CostsPerc], [YieldTypeOpt]) | TBA | | CapValueFcstDCFGD (Yield, DisAER, PmtsPerYear, AnnRents, FcstVals, StartFcst, FcstBase, DeferralMonths, [RevToMkt], [RevMos], [CostsPerc], [YieldTypeOpt]) | TBA | | TWRR (FromDate_s, ToDate_s, Dates, CapVals, [NetIncomes], [CapExps], [CapRecs], [TWRRSwitch], [TWRROptions]) | Time-Weighted Rate of Return | | NPV Rent Projections Family | What It Does |
|---|
| PVRentGrow (NPVDate, DisAER, RentStart, BrksOrExp, FirstRev, MktRent, InitRent, GrowthDates, GrowthRates, [RevMos], [RevDisc], [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF], [UOTog], [Brk]) | Present Value of the RentGrow function | | PVRentFcst (NPVDate, DisAER, RentStart, BrksOrExp, FirstRev, InitRent, FcstVals, StartFcst, FcstBase, [RevMos], [RevDisc], [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF], [UOTog], [Brk]) | Present Value of the RentFcst function | | | PVTStepRent (NPVDate, DisAER, RentStart, ReviewDates, AnnRents, [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF]) | Present Value of the TStepRent function | | PVTStepRentGrow (NPVDate, DisAER, RentStart, BrksOrExp, MktRent, ReviewDates, AnnRents, GrowthDates, GrowthRates, [RevMos], [RevDisc], [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF], [UOTog], [Brk]) | Present Value of the TStepRentGrow function | | PVTStepRentFcst (NPVDate, DisAER, RentStart, BrksOrExp, ReviewDates, AnnRents, FcstVals, StartFcst, FcstBase, [RevMos], [RevDisc], [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF], [UOTog], [Brk]) | Present Value of the TStepRentFcst function | | PVTStepRentGrowR (NPVDate, DisAER, RentStart, Finish, BrksOrExp, MktRent_s, ReviewDates, AnnRents, GrowthDates, GrowthRates, [RevMos], [RevDisc], [RelVoid_s], [RelRF_s], [RelTerm_s], [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF], [UOTog], [ROpts], [Brk]) | Present Value of the TStepRentGrowR function | | PVTStepRentFcstR (NPVDate, DisAER, RentStart, Finish, BrksOrExp, ReviewDates, AnnRents, FcstVals, StartFcst, FcstBase, [RevMos], [RevDisc], [RelVoid_s], [RelRF_s], [RelTerm_s], [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF], [UOTog], [ROpts], [Brk]) | Present Value of a PVTStepRentFcstR | | PVTStepRentGrowIC (NPVDate, DisAER, RentStart, BrksOrExp, MktRent, ReviewDates, AnnRents, GrowthDates, GrowthRates, [RevMos], [RevDisc], [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [InvDate], [InvAmt], [CapRateAER], [UOTog], [Brk]) | Present Value of the TStepRentGrow function, with capitalisation. | | PVTStepRentGrowRIC (NPVDate, DisAER, RentStart, CapDate, BrksOrExp, MktRent_s, ReviewDates, AnnRents, GrowthDates, GrowthRates, [RevMos], [RevDisc], [RelVoid_s], [RelRF_s], [RelTerm_s], [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [InvDate], [InvAmt], [CapRateAER], [UOTog], [ROpts], [Brk]) | Present Value of the TStepRentGrowR function, with capitalisation. | | | PVFStepRent (NPVDate, DisAER, BrksOrExp, FromDates, AnnRents, [DayCount], [Periods], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF], [Brk]) | Present Value of the FStepRent function | | PVFStepRentGrow (NPVDate, DisAER, BrksOrExp, MktRent, FromDates, AnnRents, GrowthDates, GrowthRates, [RevToMkt], [RevMos], [RevDisc], [DayCount], [Periods], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF], [UOTog], [Brk]) | Present Value of the FStepRentGrow function | | PVFStepRentFcst (NPVDate, DisAER, BrksOrExp, FromDates, AnnRents, FcstVals, StartFcst, FcstBase, [RevToMkt], [RevMos], [RevDisc], [DayCount], [Periods], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF], [UOTog], [Brk]) | Present Value of the FStepRentFcst function | | PVFStepRentGrowR (NPVDate, DisAER, BrksOrExp, MktRent_s, FromDates, AnnRents, GrowthDates, GrowthRates, [RevToMkt], [RevMos], [RevDisc], [RelVoid_s], [RelRF_s], [RelTerm_s], [DayCount], [Periods], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF], [UOTog], [ROpts], [Brk]) | Present Value of the FStepRentGrowR function | | PVFStepRentGrowIC (NPVDate, DisAER, BrksOrExp, MktRent, FromDates, AnnRents, GrowthDates, GrowthRates, [RevToMkt], [RevMos], [RevDisc], [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [InvDate], [InvAmt], [CapRateAER], [UOTog], [Brk]) | Present Value of the ?FStepRentGrowIC? function | | PVFStepRentGrowRIC (NPVDate, DisAER, CapDate, BrksOrExp, MktRent_s, FromDates, AnnRents, GrowthDates, GrowthRates, [RevToMkt], [RevMos], [RevDisc], [RelVoid_s], [RelRF_s], [RelTerm_s], [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [InvDate], [InvAmt], [CapRateAER], [UOTog], [ROpts], [Brk]) | Present Value of the ?FStepRentGrowRIC? function | | | PVTStepIdxRentGrowR (NPVDate, DisAER, RentStart, BrksOrExp, MktRent_s, ReviewDates, AnnRents, GrowthDates, GrowthRates, IdxGrowDates, IdxGrowRates, IdxReg_s, IdxBaseDate_s, [FirstIdxDate_s], [RevDis], [RelVoid_s], [RelRF_s], [RelTerm_s], [RevMonths], [DayCount], [CashBasis], [AbStart], [AbFin], [StartDCF], [FinishDCF], [UOTog], [ROpts], [Brk], [IdxLag_s]) | Present Value of a TStepIdxRentGrowR | | PVTStepIdxRentFcstR (NPVDate, DisAER, RentStart, BrksOrExp, ReviewDates, AnnRents, FcstVals, StartFcst, FcstBase, IdxFcstVals, IdxStartFcst, IdxFcstBase, IdxReg_s, BaseDateOrIdx_s, [FirstIdxDate_s], [RevDis], [RelVoid_s], [RelRF_s], [RelTerm_s], [RevMonths], [DayCount], [CashBasis], [AbStart], [AbFin], [StartDCF], [UOTog], [ROpts], [Brk], [IdxLag_s]) | Present Value of a TStepIdxRentFcstR | | Retail Rent Family | What It Does |
|---|
| TStepGTurnRentGrow (Time, Base, RentStart, BrksOrExp, MargRates, FromThresholds, FromDatesTh, GrowDatesTh, GrowRatesTh, ToDates, Turnovers, GrowthDates, GrowthRates, [GrowEvery], [TurnSwitch], [DayCount], [Periods], [ProjMode], [Brk]) | Stepped Gross Turnover Rent | | TStepGTurnRentGrowR (Time, Base, RentStart, BrksOrExp, MargRates, FromThresholds, FromDatesTh, GrowDatesTh, GrowRatesTh, ToDates, Turnovers, GrowthDates, GrowthRates, [GrowEvery], [RelVoid], [RelRF], [RelTerm], [TurnSwitch], [DayCount], [Periods], [ProjMode], [AbFin], [Brk]) | Stepped Gross Turnover Rent with reletting | | Index Rent Family | What It Does |
|---|
| IdxRentGrowR (Time, Base, RentStart, BrksOrExp, MktRent_s, AnnRent, GrowthDates, GrowthRates, IdxGrowDates, IdxGrowRates, IdxReg_s, IdxBaseDate_s, [FirstIdxDate_s], [RelVoid_s], [RelRF_s], [RelTerm_s], [DayCount], [Periods], [ProjMode], [AbFin], [ROpts], [Brk], [IdxLag_s]) | Rent growing off of an Initial Rent with indexation and reletting | | IdxRentFcstR (Time, Base, RentStart, BrksOrExp, AnnRent, FcstVals, StartFcst, FcstBase, IdxFcstVals, IdxStartFcst, IdxFcstBase, IdxReg_s, BaseDateOrIdx_s, [FirstIdxDate_s], [RelVoid_s], [RelRF_s], [RelTerm_s], [DayCount], [Periods], [ProjMode], [AbFin], [ROpts], [Brk], [IdxLag_s]) | Rent growing off of an Initial Rent with indexation and reletting (forecast basis) | | | IdxRentGrowMktR (Time, Base, RentStart, BrksOrExp, FirstRev, MktRent_s, InitRent, GrowthDates, GrowthRates, IdxGrowDates, IdxGrowRates, IdxReg_s, IdxBaseDate_s, [FirstIdxDate_s], [RevDis], [RelVoid_s], [RelRF_s], [RelTerm_s], [RevMonths], [DayCount], [Periods], [ProjMode], [AbFin], [UOTog], [ROpts], [Brk], [IdxLag_s]) | Rent reviewing to market with the option to grow with indexation inbetween reviews (with reletting - growth basis) | | IdxRentFcstMktR (Time, Base, RentStart, BrksOrExp, FirstRev, InitRent, FcstVals, StartFcst, FcstBase, IdxFcstVals, IdxStartFcst, IdxFcstBase, IdxReg_s, BaseDateOrIdx_s, [FirstIdxDate_s], [RevDis], [RelVoid_s], [RelRF_s], [RelTerm_s], [RevMonths], [DayCount], [Periods], [ProjMode], [AbFin], [UOTog], [ROpts], [Brk], [IdxLag_s]) | Rent reviewing to market with the option to grow with indexation inbetween reviews (with reletting - forecast basis) | | | TStepIdxRentGrowR (Time, Base, RentStart, BrksOrExp, MktRent_s, ReviewDates, AnnRents, GrowthDates, GrowthRates, IdxGrowDates, IdxGrowRates, IdxReg_s, IdxBaseDate_s, [FirstIdxDate_s], [RevDis], [RelVoid_s], [RelRF_s], [RelTerm_s], [RevMonths], [DayCount], [Periods], [ProjMode], [AbStart], [AbFin], [UOTog], [ROpts], [Brk], [IdxLag_s]) | Stepped Rent growing with indexation and reletting | | TStepIdxRentFcstR (Time, Base, RentStart, BrksOrExp, ReviewDates, AnnRents, FcstVals, StartFcst, FcstBase, IdxFcstVals, IdxStartFcst, IdxFcstBase, IdxReg_s, BaseDateOrIdx_s, [FirstIdxDate_s], [RevDis], [RelVoid_s], [RelRF_s], [RelTerm_s], [RevMonths], [DayCount], [Periods], [ProjMode], [AbStart], [AbFin], [UOTog], [ROpts], [Brk], [IdxLag_s]) | Stepped Rent growing with indexation and reletting (forecast basis) | | Real Estate Costs Family | What It Does |
|---|
| LetCostR (Time, Base, LeaseStartDate, BrksOrExp, [PmtDatesOpt], [PmtsOpt], [GrowthDatesOpt], [GrowthRatesOpt], [ExpCost_s], [ExpDur_s], [ExpCurve_s], [ExpShape_s], [RelCost_s], [RelDur_s], [RelCurve_s], [RelShape_s], [RelVoid_s], [RelTerm_s], [Options], [DayCount], [Periods], [ProjMode], [AbFin], [ROpts], [Brk]) | Letting Costs, Fitout, fees etc | | LetCostRQ (Time, Base, LeaseStartDate, BrksOrExp, [PmtDatesOpt], [PmtsOpt], [GrowthDatesOpt], [GrowthRatesOpt], [ExpCost_s], [RelCost_s], [RelVoid_s], [RelTerm_s], [Options], [AbFin], [Brk]) | Letting Costs, Fitout, fees etc | | LeasingFeeGrowR (Time, Base, FeePerc_s, LeaseStartDate, BrksOrExp, MktRent_s, InitRent, GrowthDates, GrowthRates, [RelVoid_s], [RelTerm_s], [AbFin], [Brk]) | Leasing Fee | | FServChargeR (Time, Base, SCStartDate, BrksOrExp, FromDates, ServChargeAnnRates, SCFromDates, SCPercentages, [RelVoid_s], [RelTerm_s], [DayCount], [Periods], [ProjMode], [AbFin], [ROpts], [Brk]) | Service Charge (FromDates basis) | | ServChargeGrowR (Time, Base, SCStartDate, BrksOrExp, FirstSCRevDate, ServChargeTotal, GrowthDates, GrowthRates, SCRevMonths, SCFromDates, SCPercentages, [RelVoid_s], [RelTerm_s], [DayCount], [Periods], [ProjMode], [AbFin], [ROpts], [Brk]) | Service Charge (Grow basis) | | ServChargeFcstR (Time, Base, SCStartDate, BrksOrExp, FirstSCRevDate, SCFcstTotalServCharge, SCStartFcst, SCFcstBase, SCRevMonths, SCFromDates, SCPercentages, [RelVoid_s], [RelTerm_s], [DayCount], [Periods], [ProjMode], [AbFin], [ROpts], [Brk]) | Service Charge (Fcst basis) | | FServChargeGrowR (Time, Base, SCStartDate, BrksOrExp, FromDates, ServChargeAnnRates, GrowthDates, GrowthRates, SCRevMonths, SCFromDates, SCPercentages, [RelVoid_s], [RelTerm_s], [DayCount], [Periods], [ProjMode], [AbFin], [ROpts], [Brk]) | TBA | | | FVacServChargeR (Time, Base, StartCost, StartLease, BrksOrExp, FromDates, ServChargeAnnRates, SCFromDates, SCPercentages, [RelVoid_s], [RelTerm_s], [DayCount], [Periods], [DayCountRec], [PeriodsRec], [ProjMode], [AbFin], [ROpts], [Brk]) | Vacant Service Charge (FromDates basis) | | VacServChargeGrowR (Time, Base, StartCost, StartLease, BrksOrExp, FirstSCRevDate, ServChargeTotal, GrowthDates, GrowthRates, SCRevMonths, SCFromDates, SCPercentages, [RelVoid_s], [RelTerm_s], [DayCount], [Periods], [DayCountRec], [PeriodsRec], [ProjMode], [AbFin], [ROpts], [Brk]) | Vacant Service Charge (Grow basis) | | VacServChargeFcstR (Time, Base, StartCost, StartLease, BrksOrExp, FirstSCRevDate, SCFcstTotalServCharge, SCStartFcst, SCFcstBase, SCRevMonths, SCFromDates, SCPercentages, [RelVoid_s], [RelTerm_s], [DayCount], [Periods], [DayCountRec], [PeriodsRec], [ProjMode], [AbFin], [ROpts], [Brk]) | Vacant Service Charge (Fcst basis) | | LeasingFeeFcstR (Time, Base, FeePerc_s, LeaseStartDate, BrksOrExp, InitRent, FcstVals, StartFcst, FcstBase, [RelVoid_s], [RelTerm_s], [AbFin], [Brk]) | Leasing Fee | | Real Estate Costs UK Family | What It Does |
|---|
| UKRatesGrow (Time, Base, Start, Finish, RatesMultiplier, RateableValue, GrowthDates, GrowthRates, InflationRates, InflationDates, [DCRates], [PrdsRates], [ProjMode]) | UK Business Rates (Grow Basis) | | UKRatesFcst (Time, Base, Start, Finish, RatesMultiplier, StartFcst, FcstBase, FcstRateableValues, InflationRates, InflationDates, [DCRates], [PrdsRates], [ProjMode]) | UK Business Rates (Forecast Basis) | | | UKRatesGrowR (Time, Base, Start, BrksOrExp, RatesMultiplier, [RateableValue_s], GrowthDates, GrowthRates, InflationRates, InflationDates, [RelVoid_s], [RelTerm_s], [DCRates], [PrdsRates], [ProjMode], [AbFin], [ROpts], [Brk]) | UK Rates with reletting (Forecast Basis) | | UKRatesFcstR (Time, Base, Start, BrksOrExp, RatesMultiplier, StartFcst, FcstBase, FcstRateableValues, InflationRates, InflationDates, [RelVoid_s], [RelTerm_s], [DCRates], [PrdsRates], [ProjMode], [AbFin], [ROpts], [Brk]) | UK Rates with reletting (Forecast Basis) | | | UKEmptyRatesFcstR (Time, Base, StartCost, StartLease, BrksOrExp, RatesMultiplier, StartFcst, FcstBase, FcstRateableValues, InflationRates, InflationDates, [RatesHol_s], [RelVoid_s], [RelTerm_s], [EmptyRatesFrac], [DCRates], [PrdsRates], [ProjMode], [AbFin], [ROpts], [Brk]) | UK Empty Rates with reletting (Forecast Basis) | | UKEmptyRatesGrowR (Time, Base, StartCost, StartLease, BrksOrExp, RatesMultiplier, [RateableValue_s], GrowthDates, GrowthRates, InflationRates, InflationDates, [RatesHol_s], [RelVoid_s], [RelTerm_s], [EmptyRatesFrac], [DCRates], [PrdsRates], [ProjMode], [AbFin], [ROpts], [Brk]) | UK Empty Rates with reletting (Forecast Basis) | | Lease Information Family | What It Does |
|---|
| LeaseEnd (BrksOrExp, [Brk]) | Determine lease termination | | ReletOccurs (Time, Base, BrksOrExp, [RelVoid_s], [RelRF_s], [RelTerm_s], [Brk]) | Determine whether a relet occurs | | RentDateInfo (TheDate, LeaseStartDate, RentStart, BrksOrExp, Reviews, [RevMos], RentDateSwitch, [RelVoid_s], [RelRF_s], [RelTerm_s], [RoundDown], [Brk]) | Rent Review Information | | RentEventOccurs (Time, Base, LeaseStartDate, RentStart, BrksOrExp, Reviews, [RevMos], RentEventType, [RelVoid_s], [RelRF_s], [RelTerm_s], [Brk]) | Determine whether a rental date occurs | | RentEvent (Time, Base, LeaseStartDate, RentStart, BrksOrExp, Reviews, [RevMos], [RelVoid_s], [RelRF_s], [RelTerm_s], [Brk]) | Tells you what (if any) rent event occurred in that period. | | | LastReview (TheDate, FirstRev, [RevMos], [RoundDown]) | Determine the date of the last rent review | | NextReview (TheDate, FirstRev, [RevMos], [RoundDown]) | Determine the date of the next rent review | | LastReviewR (TheDate, BrksOrExp, FirstRev, [RevMos], [RelVoid_s], [RelTerm_s], [RoundDown], [Brk]) | Like LastReview but with reletting | | NextReviewR (TheDate, BrksOrExp, FirstRev, [RevMos], [RelVoid_s], [RelTerm_s], [RoundDown], [Brk]) | Like NextReview but with reletting | | | LeaseInfo (LeaseStartOpt, [RentFreeMonths], [RentStartDate], [ReviewsOpt], [BreaksOpt], [LeaseExpiryDate], [TermYrsOpt], [LeaseInfoSwitch], [LIOptions], [DayCount], [Periods]) | Gives you date information about a lease | | Occupancy (Time, Base, LeaseStartDate, BrksOrExp, [RelVoid_s], [RelTerm_s], [DayCount], [Periods], [AbFin], [Brk]) | Calculates average occupancy, expressed as a fraction | | LeaseDates (RentStart, BrksOrExp, [RevMos], [RelVoid_s], [RelRF_s], [RelTerm_s], [ReviewsOpt], [AbStart], [AbFin], [LDateOptions], [Brk]) | Return a list of all the lease dates of a certain type(s) | Banking Category | | Interest Family | What It Does |
|---|
| Interest (Time, Base, Start, Finish, InterestSimple, Balance, [DayCount], [PrdsInt], [ProjMode]) | Calculate Interest for a timeperiod for a Balance that has Start and Finish dates. | | | FInterest (Time, Base, FromDatesInt, IntSimple, Finish, FromDates, Balances, [DayCount], [PrdsInt], [ProjMode]) | Calculate Interest using "From" Dates | | | TInterest (Time, Base, FromDatesInt, IntSimple, Start, ToDates, Balances, [DayCount], [PrdsInt], [ProjMode]) | Calculate Interest using "To" dates | | | TotInterestSF (Start, Finish, InterestSimple, Balance, [DayCount], [PrdsInt]) | The total interest accrued between two dates | | InterestX (Time, Base, FromDatesInt, IntSimple, Start, Finish, Balance, [DayCount], [PrdsInt], [ProjMode]) | Calculate Interest for a timeperiod for a Balance that has Start and Finish dates., extended version | | | PVFInterest (NPVDate, FromDatesInt, IntSimple, Finish, FromDates, Balances, [DayCount], [PrdsInt]) | PV of FInterest | | PVInterestX (NPVDate, FromDatesInt, IntSimple, Start, Finish, Balance, [DayCount], [PrdsInt]) | PV of InterestX | | PVInterest (NPVDate, Start, Finish, InterestSimple, Balance, [DayCount], [PrdsInt]) | PV of Interest | | Yield Curve Family | What It Does |
|---|
| ZeroCoupon (CalculationDate, ParBaseDate, ParDates, ParYields, ParCoupFreqs, CurrentPrices, [RateType], [DCount], [BusDaySwitch]) | Determines the Zero Coupon Discount factor using the Bootstrap method | | | FutureToSpot (FromDate, ToDate, BaseDate, ToDates, FutureRatesAER, [RateType], [DCount]) | Calculate a Spot Rate given a series of Future Rates | | SpotToSpot (FromDate, ToDate, BaseDate, ToDates, SpotRatesAER, [RateType], [DCount]) | Calculate a FutureRate given a series of SpotRates. | | ZeroCouponCurve (CalculationDates, ParBaseDate, ParDates, ParYields, ParCoupFreqs, CurrentPrices, [RateType], [DCount], [BusDaySwitch]) | Determines Zero Coupon Discount factors or rates using the Bootstrap method | | Loan Family | What It Does |
|---|
| Loan (Time, Base, FromDatesInt, IntSimple, AdvanceDates, NetAdvances, RepaymentDate, [LoanOutput], [DayCount], [PrdsInt], [ProjMode]) | Calculate a loan (interest, principal and balance) | | LoanX (Time, Base, FromDatesInt, IntSimple, AdvanceDates, NetAdvances, RepaymentDate, [RollTo], [LoanOutput], [DayCount], [PrdsInt], [ProjMode]) | Calculate a loan (interest, principal and balance) for a loan where the interest can roll up | | | LoanLin (Time, Base, FromDatesInt, IntSimple, AdvanceDates, NetAdvances, StartRepayments, RepaymentDate, [LoanOutput], [DayCountInt], [PrdsInt], [DayCountPrin], [PrdsPrin], [ProjMode]) | Calculate a loan (interest, principal and balance) with a linear repayment schedule | | LoanLinX (Time, Base, FromDatesInt, IntSimple, AdvanceDates, NetAdvances, StartRepayments, RepaymentDate, [RollTo], [LoanOutput], [DayCountInt], [PrdsInt], [DayCountPrin], [PrdsPrin], [ProjMode]) | Loan with a linear repayment schedule | | | Mortgage (Time, Base, FromDatesInt, IntSimple, FinishRates, FromDates, AnnDebtServiceRates, AdvanceDates, NetAdvances, [LongStopRepDate], [LoanOutput], [DayCount], [DayCountInt], [Periods], [PrdsInt], [ProjMode]) | Mortgage | | MortgageQ (Time, Base, InterestSimple, AdvanceDate, NetAdvance, RepaymentDate, [EarlyRepDate], [LoanOutput], [DayCount], [PrdsInt], [ProjMode]) | Mortgage | | LoanRep (Time, Base, FromDatesInt, IntSimple, AdvanceDates, NetAdvances, StartRepayments, RepaymentDate, [RepType], [RollTo], [LoanOutput], [DayCount], [PrdsRep], [PrdsInt], [ProjMode]) | Calculate a loan (interest, principal and balance), for a loan with a specific type of repayment method | | LoanPool (Time, Base, FromDatesInt, IntSimple, AdvanceDates, NetAdvances, Term_s, PmtsPerYr_s, [StartingSeqNum_s], [AddMargin_s], [Options], [LoanOutput], [DayCount], [ProjMode]) | Operate a Loan Pool | | | IdxBondGrow (Time, Base, CouponRateFromDates, CouponRatespa, SettlementDate, SettlementPrice, MaturityDate, [IdxReg], IdxGrowDates, IdxGrowRates, IdxBaseDate, [FirstIdxDate], [IdxLag], [BondOutput], [DayCountInt], [PrdsInt], [ProjMode]) | Index linked bond, Growth Basis | | IdxBondFcst (Time, Base, CouponRateFromDates, CouponRatespa, SettlementDate, SettlementPrice, MaturityDate, IdxFcstVals, IdxStartFcst, IdxFcstBase, [IdxReg], [BaseDateOrIdx], [FirstIdxDate], [IdxLag], [BondOutput], [DayCountInt], [PrdsInt], [ProjMode]) | Index linked bond, Fcst Basis | | Residual Cash Family | What It Does |
|---|
| Overdraft (Time, Base, BFBalance, CashFlow, IntAERDebt, PmtsPerYear, [AcctOutput]) | Calculates the interest, principal etc for an overdraft | | CashAcct (Time, Base, BFBalance, CashFlow, IntAERCash, PmtsPerYear, [AcctOutput]) | Calculates the interest, principal etc for a cash surplus | | FlexAcct (Time, Base, BFBalance, CashFlow, InterestAER, PmtsPerYear, [AcctOutput]) | Calculates the interest, principal etc for both an overdraft and a cash surplus, where the interest on cash is the same as the interest in debt | | CurrentAcct (Time, Base, BFBalance, CashFlow, IntAERDebt, IntAERCash, PmtsPerYear, [AcctOutput]) | Calculates the interest, principal etc for both an overdraft and a cash surplus, where there are different interest rates for debt and cash surplus | | STDAcct (Timebase, FromDatesInt, IntCash, IntSTD, CFTimes, Cashflows, [OBCash], [OBSTD], [Options], [LAOutput], [DCCash], [DCSTD], [PrdsCash], [PrdsSTD], [ProjMode]) | Short Term Debt Account | | | LoanAcct (Timebase, Threshold, Tranche, FromDatesInt, IntLoan, IntCash, IntSTD, CFTimes, Cashflows, LoanTerm, [OBCash], [OBSTD], [Options], [LAOutput], [DCLoan], [DCCash], [DCSTD], [PrdsLoan], [PrdsCash], [PrdsSTD], [ProjMode]) | Given a set of cashflows, inserts long term Loans and calculates interest and balance on short term cash and debt (overdraft) | | LoanAcctEM (Timebase, Threshold, Tranche, FromDatesInt, IntLoan, IntCash, IntSTD, CFTimes, Cashflows, LoanTerm, [FromDEM], [IntEM], [OBCash], [OBSTD], [Options], [LAOutput], [DCLoan], [DCCash], [DCSTD], [DCEM], [PrdsLoan], [PrdsCash], [PrdsSTD], [PrdsEM], [ProjMode]) | Given a set of cashflows, inserts long term Loans and calculates interest and balance on short term cash and debt (overdraft) | | Equity Trading Family | What It Does |
|---|
| BetaIndex (Values, [IndexValues]) | Beta of a stock, given Index data | | BetaReturns (Returns, IndexReturns) | The Beta value of a Stock, given data in the form of periodic returns | | DescribeReturn (ReturnSwitch) | Describe the Return Switch in the TotalReturn function | | TotalReturnQ (HistoryPeriod, CalculationDate, Dates, Values, [Cash_Flows], [CashFlowTiming], [ReturnSwitch]) | TotalReturn (quick version) | | TotalReturn (HistoryPeriod, CalculationDate, Dates, Values, [CashFlowDates], [Cash_Flows], [ReturnSwitch], [IndexValues], [IndexCashDates], [IndexCashFlows], [ExchangeRates]) | Total return Analysis | | Options Family | What It Does |
|---|
| HistoricVol (HistoryPeriod, CalculationDate, Dates, StockPrices) | Estimate historical volatility from stock prices | | ImpliedVolBS (ValuationDate, OptionExpiry, RiskFreeRateAER, CostOfCarryAER, StockPrice, StrikePrice, OptionValue, [OptionType], [DayCount], [Periods]) | Implied Volatility (Black/Scholes) | | OptionBS (ValuationDate, OptionExpiry, RiskFreeRateAER, CostOfCarryAER, StockPrice, StrikePrice, Volatility, [OptionType], [OptionOutput], [DayCount], [Periods]) | Option Value (Black/Scholes) | | SwaptionBS () | Swaption Value (Black/Scholes) | | CapBS (CappedRateAER, CalculationDate, ParBaseDate, Volatility, ParDates, ParYields, ParCoupFreqs, CurrentPrices, [DayCount], [CashBasis]) | Value of a Cap (using Black/Scholes) | | | OptionBinom (ValuationDate, OptionExpiry, RiskFreeRateAER, CostOfCarryAER, StockPrice, StrikePrice, Volatility, [TimeSteps], [OptionType], [OptionStyle], [DayCount], [Periods]) | Price an option using the Binomial nethod | | OptionMonte (ValuationDate, OptionExpiry, RiskFreeRateAER, CostOfCarryAER, StockPrice, StrikePrice, Volatility, [TimeSteps], [OptionType], [NSim], [DayCount], [Periods]) | Price an option usingthe Monte Carlo method | | Swaps Family | What It Does |
|---|
| Swap (DayCount, [Periods]) | Value of an Interest Swap | Petroleum Economics Category | | Petroleum Engineering Family | What It Does |
|---|
| ProdProfWF (Time, Base, ResvsOrDcRate, FromDates, AnnualRates, DeclinePoint, AbandonRate, [DayCount], [Periods], [ProjMode], [PPSwitch]) | Production Profile for Waterflooding | | STOIIP (Swc, Porosity, Boi, NetRockVolume) | TBA | | OilReserves () | Calculate underground oil reserves | | Decline Curve Family | What It Does |
|---|
| Decline (Yrs, ResvsOrDcRate, PlateauRate, AbandonRate, [DeclineParam], [DeclineSwitch]) | Production in decline up to, or at, a certain time | | DeclineRate (ReservesDec, PlateauRate, AbandonRate, [DeclineParam]) | Calculate the Annual Decline Rate | | DescribeDecline (DeclineParam) | Describe in a text string the DeclineParam setting | | | ProdProf (Time, Base, ResvsOrDcRate, FromDates, AnnualRates, DeclinePoint, AbandonRate, [DeclineParam], [DayCount], [Periods], [ProjMode], [PPSwitch]) | Generate an oil production profile based on pre-determined production rates and a decline curve | | AbandonDate (ResvsOrDcRate, FromDates, AnnualRates, DeclinePoint, AbandonRate, [DeclineParam], [DayCount], [Periods]) | Calculate the Abandonment Date given an oil production profile based on pre-determined production rates and a decline curve | | StartDecline (Reserves, FromDates, AnnualRates, DeclinePoint, [DayCount], [Periods]) | Start of Decline Period | Text Category | | Numbers To Text Family | What It Does |
|---|
| MoneyText (Amount, [Currency], [Language]) | Describe a monetary value as text | | Text String Family | What It Does |
|---|
| GetToken (Textstring, TokenNo, [Delimiter], [OptionLetters]) | Get A Token from a string | | GetTokens (Textstring, FirstTokenToFind, NumberOfTokens, [Delimiter], [OptionLetters]) | Get Tokens | | InString (Textstring, LetterSequence) | In String | | ExInt (InputPoly_s) | Extract an Integer from a String | | ExFl (InputPoly_s) | Extract a floating point number from a string | | ExNumRange (Textstring, [Delimiter]) | Extract a number range | | Regular Expressions Family | What It Does |
|---|
| RegSMatch (Textstring, RegSought, [CaseInSensitive]) | Return the first substring if any) matched by the regular expression | | RegMatchWhole (Textstring, RegSought, [CaseInSensitive]) | Whether the whole string matches the RegEx | | RegNMatches (Textstring, RegSought, [CaseInSensitive]) | Returns the number of matches | | RegReplace (Textstring, RegSought, Replacement, [CaseInSensitive]) | Do a search and replace | | RegSMatches (Textstring, RegSought, [CaseInSensitive]) | Return all substrings that match the Regular Expression | | RegSplit (Textstring, RegSought, [SplitMode], [CaseInSensitive]) | Split the input string into a number of substrings | Miscellaneous Category | | Special Arithmetic Family | What It Does |
|---|
| GV (VarNo) | Get the value of a local (formula) variable | | SV (VarVal, [VarNo]) | Set the value of a local (formula) variable | | StdEq (VarReq, [StdEquation], [p], [q], [r]) | Solve a variable from a standard 3 variable equation | | DiffGaps (Value, Value2, GapStarts, GapEnds) | Difference taking into account gaps | | AddGaps (Value, Increment, GapStarts, GapEnds) | Add two numbers allowing for gaps in the addition | | Rounding Family | What It Does |
|---|
| SRound (Value, Nearest, [StartingFromOpt]) | Special Round | | SFloor (Value, Nearest, [StartingFromOpt]) | Special Floor | | SCeiling (Value, Nearest, [StartingFromOpt]) | Special Ceiling | | | RoundWeekDay (TheDate, DayInWeek, [RoundMethod]) | Round to nearest Weekday | | RoundMonthDay (TheDate, DayInMonth, [RoundMethod]) | Round to nearest day of month | | RoundMD (TheDate, MonthInYear, DayInMonth, [RoundMethod]) | Round to nearest month and day in month | | RoundDateSeq (TheDate, AnnDateSeq, [RoundMethod]) | Round Date Sequence | | DateRound (TheDate, AnnDateSeq, [RoundMethod]) | Round a date | | DateFloor (TheDate, AnnDateSeq) | Rounds a date to a floor | | DateCeiling (TheDate, AnnDateSeq) | Rounds a date to a ceiling | | Disperse (Tot, iStart, iFinish) | Disperse an integer amount as equally as possible throughout an array | | RoundList (Values, Nearest, [StartingFromOpt], [RoundMethod], [AdjPos]) | Round an array of numbers and adjust so that the total adds up. | | Library Information Family | What It Does |
|---|
| BFVer () | Business Functions Version Number | | DescribeLoanAcctOutput (LAOutput) | Describes a value of a LAOutput variable (and similar variables) | | Describe (VarName, [VarValue]) | Describe what a variable or the value of a variable is | | | DescribeCombineSwitch (CombineSwitch) | Describe CombineSwitch | | DescribePmtsPerYear (PmtsPerYearOpt) | Describe the PmtsPerYear setting | | DescribeLevelSwitch (LevelSwitch) | Describe in a text string the LevelSwitch setting | | DescribeBD (BusDaySwitch, [AnnHols], [HolDates]) | Describe Business Day convention | | DescribeDayCount (DayCount) | Describe DayCount Method | | DescribePeriods (Periods) | Describe Periods used in Daycount Calculation | | DescribeLookup (LookupSwitch) | Describe in a text string the LookupSwitch setting | | DescribeAS (AnnDateSeq) | Describe Annual Sequence | | DescribeRounding (RoundMethod) | Describe the rounding method used | | DescribeLoanOutput (LoanOutput) | Describes the value of a LoanOutput variable (also LAOutput) | | DescribeShape (Shape) | Describes the value of Shape variable. | | ArgValues (ArgNo) | TBA | | Flow Of Control Family | What It Does |
|---|
| Switch (SwitchVar, Default, Case1, Res1, [Case2], [Res2], [Case3], [Res3], [Case4], [Res4], [Case5], [Res5], [Case6], [Res6], [Case7], [Res7], [Case8], [Res8], [Case9], [Res9], [Case10], [Res10], [Case11], [Res11], [Case12], [Res12]) | Switch (Select Case) | | SwitchR (SwitchVar, Default, Cases, Results) | Switch with Ranges | | SwitchT (SwitchVar, DefaultText, Case1, ResText1, [Case2], [ResText2], [Case3], [ResText3], [Case4], [ResText4], [Case5], [ResText5], [Case6], [ResText6], [Case7], [ResText7], [Case8], [ResText8], [Case9], [ResText9], [Case10], [ResText10]) | Switch (Select Case) for Text | | SwitchRT (SwitchVar, DefaultTxt, Cases, ResultsText) | Switch (Select Case) for Text Ranges | | | IfElse (Default, Cond1, Res1, [Cond2], [Res2], [Cond3], [Res3], [Cond4], [Res4], [Cond5], [Res5], [Cond6], [Res6], [Cond7], [Res7], [Cond8], [Res8], [Cond9], [Res9], [Cond10], [Res10], [Cond11], [Res11], [Cond12], [Res12]) | If...ElseIf...Else | | IfElseR (Default, Conds, Results) | If...ElseIf...Else with Ranges | | IfElseT (DefaultText, Cond1, ResText1, [Cond2], [ResText2], [Cond3], [ResText3], [Cond4], [ResText4], [Cond5], [ResText5], [Cond6], [ResText6], [Cond7], [ResText7], [Cond8], [ResText8], [Cond9], [ResText9], [Cond10], [ResText10]) | If...ElseIf...Else for Text | | IfElseRT (DefaultTxt, Conds, ResultsText) | If...ElseIf...Else with Ranges for text | | GoalSeek (TargetCell, TargetValue, ChangingCell, [Order]) | Set up the parameters for an embedded GoalSeek to be carried out by CalculateFull | | Def (Input, [DefaultValue], [Options]) | Get the value or its Default value | | | SwitchX (SwitchVar, Case1, [Result1], [Case2], [Result2], [Case3], [Result3], [Case4], [Result4], [Case5], [Result5], [Case6], [Result6], [Case7], [Result7], [Case8], [Result8], [Case9], [Result9], [Case10], [Result10], [Case11], [Result11], [Case12], [Result12], [DefaultValue]) | Extended Switch for returning any data type, including ranges | | Comparisons Family | What It Does |
|---|
| Tranche (Amounts, Value, Values) | Tranche an amount | | CollarDate (TheDate, Date1, Date2) | Collar Date | | InBetween (Amt, Minimum, Maximum, [CompareOpt]) | Is a value Inbetween | | Collar (Amt, Minimum, Maximum) | Collars a number | | Excel Information Family | What It Does |
|---|
| Ev (Textstring_s, [DefaultValue], [Options]) | BF Indirect function equivalent | | Errors Family | What It Does |
|---|
| CountErrors (TheRange, [ErrorType]) | Counts the number of errors in a range | | Safe (Input_s, [OnErr_s], [OnNum_s], [OnNA_s], [OnName_s], [OnRef_s], [OnValue_s], [OnDiv0_s], [OnNull_s], [ReturnBehaviour]) | Safely handle Calculations that may generate errors | | UnAllocated Family | What It Does |
|---|
| CreateFcst (FcstVals, StartFcst, FcstBase) | TBA |
|