| aa | An integer number |
| AbandonRate | Abandonment rate, an amount (eg bbl) per year. |
| AbFin | Absolute finish of the cashflow or projection. |
| AbsFinish | The absolute finish date until which calculations run. |
| AbsStart | Absolute Start of the projection (overrides other start dates) |
| AbStart | Absolute start of the cashflow |
| AcctOutput | Switch that sets what parameters are output from a residual cash account function |
| ActualsToDate | Actuals up to the start of this timeperiod |
| AdditionDates | The date of each of the Additions to the pool |
| Additions | The net values of any Additions to the pool (+ve, or -ve for withdrawals from pool) |
| AddMargin | Additional margin to be charged over and above ?IntRatesSimple? |
| AddMargin_s | Additional margin to be charged over and above IntSimple |
| AdjPos | Adjustment Position: Where the rounding adjustment is to be placed so that the total is correct |
| AdjustmentFactor | Adjustment Factor |
| AdvanceDate | Dates on which corresponding NetAdvances are made |
| AdvanceDates | Dates on which corresponding NetAdvances are made |
| AfterDate | Makes sure that the calculated date is after AfterDate. Useful for "chaining" dates (like ensuring the Boxing Day Holiday is after the Xmas day Holiday). |
| Alphas | The Alpha parameter of the distribution |
| Amortisation | The proportion of the principal amortised at the time of repayment |
| Amount | An amount (usually money) |
| AmountDisbursed | |
| Amounts | The amounts (usually money) to be projected. |
| Amt | Amount |
| AnnDateSeq | Either omitted, or an option number related to the number of rounding periods in the year, or a range of floats describing an annual sequence of dates in the format mm.dd. |
| AnnDateSeq1 | Either omitted, or an option number related to the number of rounding periods in the year, or a range of floats describing an annual sequence of dates in the format mm.dd. |
| AnnDateSeq2 | Either omitted, or an option number related to the number of rounding periods in the year, or a range of floats describing an annual sequence of dates in the format mm.dd. |
| AnnDateSeq3 | Either omitted, or an option number related to the number of rounding periods in the year, or a range of floats describing an annual sequence of dates in the format mm.dd. |
| AnnDateSeq4 | Either omitted, or an option number related to the number of rounding periods in the year, or a range of floats describing an annual sequence of dates in the format mm.dd. |
| AnnDebtServiceRates | Annual rates of debt service (interest + principal). In other words, all cashflow from these annual rates goes to interest and principal. |
| AnnGrowthRate | Annual Growth Rate, eg 5% p.a., expressed as a fraction, eg 0.05. |
| AnnHols | List of annual holidays in Date Sequence format (1.01,4.01 mm.dd etc), that recur every year. |
| AnnPmt | Annual Payment |
| AnnProdRate | Annual production rate |
| AnnRent | The annual passing rent prevailing |
| AnnRentCaps | List of annual rent caps. A value of blank or zero signifies no cap. |
| AnnRentFloors | List of annual rent floors. A value of blank or zero signifies no floor. |
| AnnRents | List of annual rents specified as annual rates |
| AnnRepRates | Repayment rates per year. Repayments +ve, further drawdowns -ve. Note, these are annual rates of payment, not one-offs. |
| AnnSeqNum | A annual date sequence number on the form mm.dd |
| AnnSwitch | Which annuity variable to solve for. |
| AnnualCashFlows | Annual cash flows, evenly spaced one year apart, the first one starting on StartAnnDate |
| AnnualDateSeq | Annual DateSequence |
| AnnualRate | The annual rate at which a stream of cashflow occurs. |
| AnnualRates | Either a single AnnualRate or a range of annual rates. |
| AnnualRates2 | A range of annual rates. |
| AnnualRates3 | A range of annual rates. |
| AnnualRates4 | A range of annual rates. |
| AnnuityEndMonths | When the annuity ends (how long in months from valuation date to when the annuity stops) |
| ArgNo | |
| ArgValues | |
| ArithSwitch | The arithmetic operator to use eg 0 = multiply |
| AxisRangeX | Values that represent the X Axis of a graphical relationship |
| AxisRangeY | Values that represent the Y Axis of a graphical relationship |
| Balance | The balance for which you want to do interest calculations (where you owe money, its a +ve balance) |
| Balances | The balances for which you want to do interest and loan calculations (where you owe money, its a +ve balance (following Excel"s convention)). |
| Base | Either the length of a Time Period, expressed in exact months, or as a date, in which case it is the date of the end of the time period. |
| BaseDate | The Base Date (or reference date) for a parameters that end at some time in the future |
| BaseDateOrIdx | Indexing Base Date or the value of the index itself. The date where the index is consulted to establish the base point for subsequent growth. |
| BaseDateOrIdx_s | Indexing Base Date or the value of the index itself. The date where the index is consulted to establish the base point for subsequent growth. |
| BaseYrs | Either the length of a Time Period, expressed as a fraction of a year, or the date of the end of a Time Period, expressed as a date number or a decimal year. |
| BDOption | Business Day Calculation Option: 0=Add and skiup to next BD, 1=add not counting BD"s |
| Beta | Beta |
| Betas | The Beta parameter in a distribution |
| BFBalance | Brought forward balance ie balance at beginning of timeperiod (where you owe money, its a +ve balance) |
| Bias | A parameter indicating Bias in an Interpolation (only required for Hermite Interpolation) |
| Boi | Oil Formation Volume Factor |
| BondOutput | Switch that sets what parameters are output from a Bond function |
| BreaksOpt | |
| Brk | Which break number to break the (original lease) on. If omitted, break on first break. |
| BrksOrExp | Breaks and ultimate expiry, or just the expiry by itself. ( See also Brk, for some functions) |
| BusDaySwitch | Basis of Business Days. See List of Holidays for detail. |
| CalcdAmt | The amount calculated for the time period |
| CalcdBal | Balance |
| CalcdLevel | The calculated Level |
| CalcdPmt | The relevant payment made in the specified timeperiod |
| CalcdPmts | The payments made |
| CalculationDate | Date for which calculations are to be performed |
| CalculationDates | Dates for which calculations are to be performed |
| CapDate | Capitalisation Date, when the projection ceases and the value is capitalised |
| CapExps | Capital Expenditures AS A POSITIVE NUMBER (don"t make expenditure negativ) |
| CapOption | Capitalisation Option in the form optionval.nn where nn is a number of cashflows (eg "last nn cashflows) |
| CapOptions | One or options (additive) for use in capitalising a property income stream |
| CappedRateAER | Capped Interest Rate expressed as an AER (annual effective rate) |
| CapRateAER | Cap Rate (Annual Equivalent Rate) |
| CapRecs | Capital Receipts |
| CapVals | Capital Values |
| Case1 | A case value. |
| Case10 | A case value. |
| Case11 | A case value. |
| Case12 | A case value. |
| Case2 | A case value. |
| Case3 | A case value. |
| Case4 | A case value. |
| Case5 | A case value. |
| Case6 | A case value. |
| Case7 | A case value. |
| Case8 | A case value. |
| Case9 | A case value. |
| CaseInSensitive | Whether you want the evaluation to be case insensitive (default: case sensitive). This will simply convert Textstring and RegSought to lower case before evaluating. |
| Cases | Integer list of cases for the Select Case statement |
| CashBasis | Timing of payments, either omitted, or an option number, or a range of floats describing an annual sequence of payment dates in the format mm.dd for payments in advance or -mm.dd for payments in arrears. |
| CashFlow | A single cashflow representing to total positive (+ve) or negative (-ve) cashflow for the period |
| CashFlowDate | |
| CashFlowDates | The corresponding date of each cash flow |
| Cashflows | A range of cash flows. |
| Cashflows2 | A range of cash flows. |
| Cashflows3 | A range of cash flows. |
| Cashflows4 | A range of cash flows. |
| CashFlowTiming | |
| Cash_Flows | A range of cash flows. |
| Categories | An integer list of categories into which you have classified your Values |
| Categories2 | An integer list of categories into which you have classified your Values |
| CatMax | Maximum Category No |
| CatMax2 | Maximum Category No (second set of categories) |
| CatMin | Minimum Category No |
| CatMin2 | Minimum Category No (second set of categories) |
| CFTimes | A range of cash flows. |
| ChangingCell | Reference to a cell that you want to have change its value so that TargetCell=TargetValue |
| ChartChar | The character used for the graph (defaults to a vertical line) |
| ChartWid | The width (in terms of characters) of the mini bar |
| ChosenCategories | An integer list of the categories you want to select or include in calculations. |
| ChosenCategories2 | A list of the categories you want to sum over. |
| ChosenCategory | The category you want to sum over. |
| ClipTailLevel | An optional parameter for clipping the infinite tail distributions (normal, lognormal etc) so that probability levels in the clipped area round to 0 or 1 as appropriate. eg ClipTailLev=.01 means that a probability of .995 is rounded to 1. |
| Coefficients | List of coefficients |
| Cols | A number of columns |
| CombineSwitch | A switch defining how 2 or more lists or cashflow streams are to be combined |
| CompareOpt | Type of comparison |
| CompletionDate | When the project completes |
| ComponentPart | Whether this call of a projections function is part of as larger projection. |
| Cond1 | A boolean (aka logical ) condition eg A1>=B2 |
| Cond10 | A boolean (aka logical ) condition eg A1>=B2 |
| Cond11 | A boolean (aka logical ) condition eg A1>=B2 |
| Cond12 | A boolean (aka logical ) condition eg A1>=B2 |
| Cond2 | A boolean (aka logical ) condition eg A1>=B2 |
| Cond3 | A boolean (aka logical ) condition eg A1>=B2 |
| Cond4 | A boolean (aka logical ) condition eg A1>=B2 |
| Cond5 | A boolean (aka logical ) condition eg A1>=B2 |
| Cond6 | A boolean (aka logical ) condition eg A1>=B2 |
| Cond7 | A boolean (aka logical ) condition eg A1>=B2 |
| Cond8 | A boolean (aka logical ) condition eg A1>=B2 |
| Cond9 | A boolean (aka logical ) condition eg A1>=B2 |
| Conds | Boolean list of conditions for the If/Then/Else statement |
| CoordinateString | Cell coordinates |
| CostOfCarryAER | Cost of Carry as an Annual Effective Rate (annually compounded rate) |
| CostsPerc | Selling Costs Percentage |
| CouponRateFromDates | A range of dates from which the coupon rates apply |
| CouponRatespa | One or more annual interest rates where the rates are simple interest, not AER ie interest paid=fraction of year x simple interest rate |
| Criteria | One or more criteria written in the BF style of writing criteria. |
| CritOpts | One or more Search Options (additive) |
| CumAmt | Cumulative amount as a fraction between 0 and 1 |
| CumLimit | Cumulative Limit |
| CumProbs | List of cumulative probabilities (0-1) that correspond to Values |
| CumSwitch | An integer switch to tell the function how to deal with inbetween probability values - whether to interpolate, round up or down. See Values in the function detail. |
| CumTime | Cumulative time as a fraction between 0 and 1 |
| Currency | A number indicating which currency |
| CurrentPrices | Current Prices of the fixed income financial instruments, expressed as a decimal fraction of the par price |
| CurtailOption | Criteria (additive options) for curtailing the range. |
| CurveModel | This variable is included for future use, it is not in use yet. |
| Date1 | One of 2 or more dates, and the lowest or earliest date |
| Date2 | One of 2 or more dates |
| DateResult | The result of the function expressed as a date. |
| DateResults | List of dates |
| Dates | A range of dates. |
| Dates2 | A range of dates. |
| Dates3 | A range of dates. |
| Dates4 | A range of dates. |
| DateSeqNumber | Annual Date Sequence number in the format mm.dd, as used in AnnDateSeq, Periods and CashBasis |
| DatesHistory | A list of dates that correspond to PmtsHistory, and represent the timing of historic payments. |
| DateSwitch | How the date is to be returned. 0 = Decimal Year, 1 = Date. |
| Day | Day in the month, expressed as a whole number |
| DayCount | Either a single number denoting the DayCount method, or a number in the form ww.ss where ww is the daycount of whole periods and ss applies to stub periods. See Using Daycount. |
| DayCountDisc | For use in discounting or compounding. Either a single number denoting the DayCount method, or a number in the form ww.ss where ww is the daycount of whole periods and ss applies to stub periods. See Using Daycount. |
| DayCountInt | Daycount for interest calculations and payments. Either a single number denoting the DayCount method, or a number in the form ww.ss where ww is the daycount of whole periods and ss applies to stub periods. See Using Daycount. |
| DayCountPrin | Daycount for principal calculations and payments.Either a single number denoting the DayCount method, or a number in the form ww.ss where ww is the daycount of whole periods and ss applies to stub periods. See Using Daycount. |
| DayCountRec | Daycount for receipts. Either a single number denoting the DayCount method, or a number in the form ww.ss where ww is the daycount of whole periods and ss applies to stub periods. See Using Daycount. |
| DayCountSource | The Daycount basis of the interest rate you want to convert FROM. Either a single number denoting the DayCount method, or a number in the form ww.ss where ww is the daycount of whole periods and ss applies to stub periods. See Using Daycount. |
| DayCountTarget | The DayCount basis of the interest rate you want to convert TO. Either a single number denoting the DayCount method, or a number in the form ww.ss where ww is the daycount of whole periods and ss applies to stub periods. See Using Daycount. |
| DayInMonth | The day in the month (1-31) |
| DayInMonthOpt | A day number (1-31) |
| DayInWeek | The day in the week (1=Sunday, 2=Tuesday etc) |
| DayinWeekOpt | A date of the week number (1-7, Sunday=1) |
| Dayname | The name of the day |
| Days | A number of days. |
| DaysRelative | Days to be shifted relative to the Relativity date. |
| DCArray | Series of Daycount options. See Function Narrative. Either a single number denoting the DayCount method, or a number in the form ww.ss where ww is the daycount of whole periods and ss applies to stub periods. See Using Daycount. |
| DCCash | Either a single number denoting the DayCount method, or a number in the form ww.ss where ww is the daycount of whole periods and ss applies to stub periods. See Using Daycount. |
| DCEM | External Margin: Either a single number denoting the DayCount method, or a number in the form ww.ss where ww is the daycount of whole periods and ss applies to stub periods. See Using Daycount. |
| DCLoan | Loan: Either a single number denoting the DayCount method, or a number in the form ww.ss where ww is the daycount of whole periods and ss applies to stub periods. See Using Daycount. |
| DCount | A single integer denoting the DayCount method used for determining time differences. See Using Daycount. |
| DCountDisc | A single integer denoting the DayCount method used for determining time differences for discounting purposes. See Using Daycount. |
| DCRates | Either a single number denoting the DayCount method, or a number in the form ww.ss where ww is the daycount of whole periods and ss applies to stub periods. See Using Daycount. |
| DCSTD | Short Term Debt: Either a single number denoting the DayCount method, or a number in the form ww.ss where ww is the daycount of whole periods and ss applies to stub periods. See Using Daycount. |
| DeclineParam | Also know as the parameter "b": Either 0 or omitted for Exponential Decline, 1 for Harmonic decline, or any other number as the decline exponent in a Hyperbolic Decline |
| DeclinePoint | The proportion of reserves depleted when the reservoir goes into decline |
| DeclineSwitch | Switch indicating what output is required (0=Cumulative Production, 1=Instantaneous Rate) |
| DecMonth | Decimal Month |
| DecPlaces | Number of decimal places when showing a number |
| DecRate | Annual rate of decline (also known as "ai") |
| DecYear | Date expressed as a decimal year |
| Default | The value that is return if none of the Cases or Conditions are met |
| DefaultDate | If the function does not find a date that meets the criteria, it returns the default date |
| DefaultPoly | If function fails to find what its looking for. If No default is specified and it fails to find, an error will result. If you don"t want this to happen, use a default value. |
| DefaultText | The default text value in a function if no case or condition is matched. |
| DefaultTxt | The default text value in a function if no case or condition is matched. |
| DefaultValue | What the function should default to |
| DeferralMonths | Months until review (up until which the corresponding AnnRent runs) |
| DefValOnErr | Default Value on error |
| Degree | Degree of polynomial required. 1 is for polynomials like a+bx, 2 for those like a+bx+cx^2 etc. 0=function will find best match amongst degrees 1 to 20. Maximum=20. |
| Delimiter | The single character that is used to delimit the string (eg a space, or comma) |
| DepSwitch | Output type required (0=Depreciation in period, etc) |
| DepType | The type of depreciation ( 0=Straight Line, 1= Declining Balance, 2=Double Declining,3=Sum of Years Digits) |
| Deviate | A value belonging to the distribution |
| Direction | Direction of search, sort or whatever. 0 for ascending, 1 for descending. |
| DisAER | The discount rate expressed as an AER (Annual Equivalent Rate). See Annual Equivalent Rates. |
| DiscAER | Discount Rate EAR (Annual Effective Rate), See Annual Equivalent Rates |
| DiscountFactor | Discount Factor (Present Value/Future Value) |
| DiscRatesAER | A range of Discount Rates expressed as AER"s eg {.1,.11..115}. See Annual Equivalent Rates |
| Disposal | The amount disposed of, expressed as a +ve number. |
| DistMax | Maximum Point of a Distribution (either p=1 or as defined for the distribution type DistType) |
| DistMid | Mid Point of a Distribution (either p=0.5 or as defined for the distribution type DistType) |
| DistMin | Minimum Point of a Distribution (either p=0 or as defined for the distribution type DistType) |
| DistType | Distribution type(1=uniform, etc - see variable detail for values) |
| DoMax | |
| DownRev | Input a value of 1 to allow for downward reviews in a lease |
| DrawDate | Initial Drawdown date of a loan or annuity |
| DueRent | The rent due in that time period |
| DurationYrs | Duration in Years |
| EarlyRepDate | The optional early repayment date of the loan, which overrides any other repayment date |
| EmptyRatesFrac | Empty Rates fraction (usually 50%) |
| EndPos | Ending Position |
| EOMRule | End of Month rule in effect (true/false) |
| ErrorType | Which type of error |
| EvenCashFlows | Evenly space cashflows, eg quarterly, annually |
| EventDate | The date of an event |
| EventDates | Either a single event dates, or a list of event dates |
| EvenTimeInterval | Time interval in months |
| EvenTimeStart | Starting point of even cash flows ie the date of the first cashflow |
| EventType | Type of Event |
| ExchangeRates | Exchange Rates |
| ExpCost_s | |
| ExpCurve_s | See CurveModel |
| ExpDur_s | Duration in months |
| Exponents | |
| ExpShape_s | A parameter indicating Skewness and Peakedness in a time spread functions. 0.00=symmetrical, evenly distributed; -100=backloaded;+100 frontloaded; 0.50 symmetrical, moderately peaked; 50.90, skewed to front ent, highly peaked. |
| Extrap | Indicates whether you would like to extrapolate or flag an error if input value outside range (0 or omitted) or extrapolate if outside range (1), or collar (restrict) the input value to the endpoints of the range (2) |
| FcstAnnRates | The values of a forecast specified by FcstBase and StartFcst |
| FcstBase | The base (ie the length in exact months of the individual time periods) of a forecast specified by FcstVals and StartFcst |
| FcstDef_Post | The default value after the start of the forecast, if the date falls outside the bounds of the forecast. |
| FcstDef_Pre | The default value before the start of the forecast, if the date falls outside the bounds of the forecast. |
| FcstFromDates | Forecast times |
| FcstRateableValues | The values of a forecast specified by FcstBase and StartFcst |
| FcstRatesBase | The base (ie the length in exact months of the individual time periods) of a forecast specified by FcstVals and StartFcst |
| FcstResult | Value output from a forecast function |
| FcstSum | Sum of a forecast |
| FcstSwitchOpt | Type of forecast. Zero or omitted = instantaneous, 1 = interpolated average |
| FcstToDates | A range of dates that determine the dates up until corresponding FcstVals run. |
| FcstVals | The values of a forecast specified by FcstBase and StartFcst |
| FcstValues | Values of the forecast at times specified by FcstTimes |
| FeePerc_s | One or more fee percentages |
| Fees | Fees |
| FinalValue | The final value of something (for depreciation, the salvage value at the end of the assets life). Zero if omitted. |
| FindSwitch | What you want returned (0=value(s),1=position of found item(s) in input list) |
| Finish | The finish date until which calculations run. |
| Finish2 | The finish date until which calculations run. |
| Finish3 | The finish date until which calculations run. |
| FinishDCF | Optional Finish Date for cashflows to be included in the DCF (PV or IRR) calculation. If omitted, all cashflows are included. Over-rides other Finish dates in the function. |
| Finishes | Either one Finish date or a list of Finish dates |
| FinishLevels | When the level(s) finish |
| FinishRates | The date where the annual rates of cashflow finish |
| FirstIdxDate | First Indexation Date. The first date when indexation occurs. |
| FirstIdxDate_s | First Indexation Date. First date when the rent reviews to indexation. |
| FirstPmtDate | The date of the first payment |
| FirstRev | First review date. |
| FirstSCRevDate | First service charge review date, where the GrowthRates are applied. |
| FirstTokenToFind | |
| FirstYear | The first year where this type of date occurs (blank will be returned if prior) |
| FromDate | The date from which a period of time starts |
| FromDates | A range of dates from which a level, rate or threshold applies |
| FromDates2 | A range of dates from which a level or rate applies |
| FromDates3 | A range of dates from which a level or rate applies |
| FromDates4 | A range of dates from which a level or rate applies |
| FromDatesInt | The dates from which the interest rates are effective. |
| FromDatesTh | Threshold from dates: dates from which the threshold applies |
| FromDate_s | One date or a range of dates from which you want a calculations to run |
| FromDEM | From dates for EM interest rates |
| FromFinish | The Finish date of the payment stream before it is rephased |
| FromPmtDate | The PmtDate before it is rephased |
| FromPmtDates | The PmtDates before they are rephased |
| FromStart | The Start date of the payment stream before it is rephased |
| FromThresholds | Levels (eg of Turnover, Income etc) from which certain rates apply |
| FutureMultiplier | The rates multiplier to be used from 2005. |
| FutureRatesAER | A an implied AER (Annual Equivalent Rate) interest rate relating to a period in the future (usually used with ToDates to define this period. See Annual Equivalent Rates |
| FV | The future value. FV is the cash balance you would want to attain on the last payment. Because of endemic confusion over the sign of FV (we use the same convention as Microsoft), take special care when inputting this variable. |
| FVOpt | The future value (optional). FV is the cash balance you would want to attain on the last payment. because of endemic confusion over the sign of FV (we use the same convention as Microsoft), we recommend it is omitted or zero. |
| GapEnds | One or more numbers indicating where a gap ends |
| GapStarts | One or more numbers indicating where a gap starts |
| GrowDatesTh | Dates from which GrowRatesTh apply |
| GrowEvery | The length of time (months) inbetween when the GrowthRates are applied. |
| GrowFrom | Date from which GrowthRatePA applies |
| GrowPriceEvery | The length of time (months) inbetween when the GrowthRates are applied. |
| GrowRatesTh | Annual rate of growth of the Thresholds, % per year, expressed as an AER (Annual Equivalent Rate) and as a fraction eg 0.10 = 10% |
| GrowRevsPerYrOpt | The number of growth periods during the year where growth is applied, expressed in the same units as Pmts Per Year |
| GrowthAnnRate | Annual growth rates, % per year, expressed as an AER (Annual Equivalent Rate) and as a fraction eg 0.10 = 10% |
| GrowthBaseDate | Start Growth |
| GrowthDates | Dates from which GrowthRates apply |
| GrowthDatesAnnRate | Dates from which GrowthRates apply |
| GrowthDatesLevels | Dates from which GrowthRates apply |
| GrowthDatesOpt | Dates from which GrowthRates apply |
| GrowthLag | Lag between when growth occurs and where growth is calculated to |
| GrowthLevels | Annual growth rates, % per year, expressed as an AER (Annual Equivalent Rate) and as a fraction eg 0.10 = 10% |
| GrowthRatePA | Growth rate per annum |
| GrowthRates | Annual growth rates, % per year, expressed as an AER (Annual Equivalent Rate) and as a fraction eg 0.10 = 10% |
| GrowthRatesOpt | Annual growth rates, % per year, expressed as an AER (Annual Equivalent Rate) and as a fraction eg 0.10 = 10% |
| GrowthType | Type of Growth (0 or omitted=exponential, 1=Linear) |
| Guess | An initial guess at a solution, which the function will use as a starting point. |
| HistoryPeriod | Number of months preceding CalculationDate for which you want the total return analysed. |
| HolDates | List of Dates of specific one off holidays. Note that these dates are one-off, not annually recurring. |
| HolNum | The number (from the index of holidays) of the holiday you want. See List of Holidays for detail. |
| i | The i (horizontal) position of the value you want to pick out of a matrix, starting from the left at 1. |
| IdxBaseDate | Indexing Base Date. The date where the index is consulted to establish the base point for subsequent growth. |
| IdxBaseDate_s | Indexing Base Date. The date where the index is consulted to establish the base point for subsequent growth. |
| IdxFcstBase | The base (ie the length in exact months of the individual time periods) of a forecast specified by IdxFcstVals and IdxStartFcst |
| IdxFcstVals | The values of a forecast specified by IdxFcstBase and IdxStartFcst |
| IdxGrowDates | Dates from which IdxGrowRates apply |
| IdxGrowRates | Annual growth rates of the Index, % per year, expressed as an AER (Annual Equivalent Rate) and as a fraction eg 0.10 = 10% |
| IdxLag | Lag between using (applying) the index and looking it up off the forecasts or growth schedule. Often the index some months previous is used. |
| IdxLag_s | Lag between the indexation date, when the rent changes, and the date where the indexation is looked up |
| IdxReg | The general length of time in months between reviews in line with the index. (0=continuous application, large number eg 999 for no indexing at all) |
| IdxReg_s | The length of time for each step period, in months, between application of indexation (0=continuous application, large number eg 999 for no indexing at all) |
| IdxStartFcst | Start of the forecast specified by IdxFcstBase and IdxFcstVals |
| iFinish | The entry number of the last item in the range or subrange |
| IncludeTrueFalse | A list of true/false values |
| InclusiveOpt | How you want items at either limits of the period to be treated |
| IncOpt | How you want items at either limits of the XMin-Xmax range to be treated |
| Increment | |
| IndexCashDates | The corresponding date of each Index cash flow |
| IndexCashFlows | A range of cashflows for the Index |
| IndexReturns | The Returns on the Index in each Period |
| IndexValues | A range of values for the Index |
| InflationDates | Dates from which InflationRates apply |
| InflationRates | Annual growth rates, % per year, expressed as an AER (Annual Equivalent Rate) and as a fraction eg 0.10 = 10% |
| InitialAnnRate | Initial Annual Rate |
| InitialDate | The initial date (for depreciation, the purchase date) ie the date when the asset comes into being for the purposes of the accounts. |
| InitialLevel | The initial starting level before growth is applied. |
| InitialValue | The initial value of something (for depreciation, the purchase cost) |
| InitRent | The first value of the passing rent, prior to the first rent review |
| InpList | The range in a Lookup that the InputValue refers to when it does its lookup. |
| Input | The input value |
| InputDateRange | A list of dates which are looked up against to determine the looked up value. |
| InputDateValue | The date value which is compared against the InputDateRange |
| InputPoly | A single polymorphic input (string, date or number). |
| InputPoly_s | One or more polymorphics input (string, date or number). |
| InputRange | The range in a Lookup that the InputValue refers to when it does its lookup. |
| InputRangePoly | The range in a Lookup that the InputPoly refers to when it does its lookup. |
| InputVal | The input value to a lookup |
| InputValue | The input value to a lookup |
| InputValuesMax | A list of values that describe upper line of the partial dependency relationship |
| InputValuesMid | A list of values that describe the mid line of the partial dependency relationship |
| InputValuesMin | A list of values that describe lower line of the partial dependency relationship |
| InputValueX | A value which is compared against AxisRangeX to perform the lookup |
| InputValueY | A value which is compared against AxisRangeY to perform the lookup |
| Input_s | One or more input values |
| InpVal_s | A polymorphic input (string, date or number) |
| IntAERCash | Interest per annum on cash, expressed as an AER. See Annual Equivalent Rates |
| IntAERDebt | Interest per annum on debt, expressed as an AER. See Annual Equivalent Rates |
| IntCash | One or more annual interest rates where the rates are simple interest, not AER ie interest paid=fraction of year x simple interest rate |
| IntEM | One or more annual interest/margin rates where the rates are simple interest, not AER ie interest paid=fraction of year x simple interest rate |
| InterestAER | Interest Rate expressed as an AER, Annual Equivalent Rate. See Annual Equivalent Rates |
| InterestCont | Interest Rate expressed as a continuous discount rate |
| InterestSimple | Interest Rate expressed as simple interest, per annum |
| Interpolate | Indicates whether you would like the result interpolated (0=No, 1=Yes) |
| InterpType | Interpolation Type (default 0=linear) |
| IntLoan | One or more annual interest rates where the rates are simple interest, not AER ie interest paid=fraction of year x simple interest rate |
| IntOverRide | |
| IntOverRideDates | |
| IntPmt | Interest Due |
| IntResult | Integer Result from a function |
| IntSF | *Sinking Fund interest rates (simple interest) |
| IntSimple | One or more annual interest rates where the rates are simple interest, not AER ie interest paid=fraction of year x simple interest rate |
| IntSTD | Shot Term Debt: One or more annual interest rates where the rates are simple interest, not AER ie interest paid=fraction of year x simple interest rate |
| InvAmt | Investment Amount, the amount paid, as a positive number (capital expenditure=+ve) |
| InvDate | Investment date, when the purchase is made |
| InvestmentAmt | Investment amount (expenditure=+ve number) |
| InvestmentDate | Date when investment amount are paid |
| IRRAccOpt | Accuracy to which the IRR should be determined |
| IRRAER | The IRR (internal rate of return) expressed as an AER (Annual Equivalent Rate). |
| IRRMaxOpt | A maximum acceptable IRR |
| IRRMinOpt | A maximum acceptable IRR |
| ISDates | In-Service Dates: When each asset or part of an asset comes into use and depreciation commences. |
| ISPortions | Fractional portions of the total cost transferred to the depreciation pool on each ISDate |
| iStart | The entry number of the first item in the range or subrange |
| Item1 | Number, text, cell reference or range |
| Item10 | Number, text, cell reference or range |
| Item11 | Number, text, cell reference or range |
| Item12 | Number, text, cell reference or range |
| Item13 | Number, text, cell reference or range |
| Item14 | Number, text, cell reference or range |
| Item15 | Number, text, cell reference or range |
| Item16 | Number, text, cell reference or range |
| Item17 | Number, text, cell reference or range |
| Item18 | Number, text, cell reference or range |
| Item19 | Number, text, cell reference or range |
| Item2 | Number, text, cell reference or range |
| Item20 | Number, text, cell reference or range |
| Item21 | Number, text, cell reference or range |
| Item22 | Number, text, cell reference or range |
| Item23 | Number, text, cell reference or range |
| Item24 | Number, text, cell reference or range |
| Item25 | Number, text, cell reference or range |
| Item26 | Number, text, cell reference or range |
| Item27 | Number, text, cell reference or range |
| Item28 | Number, text, cell reference or range |
| Item3 | Number, text, cell reference or range |
| Item4 | Number, text, cell reference or range |
| Item5 | Number, text, cell reference or range |
| Item6 | Number, text, cell reference or range |
| Item7 | Number, text, cell reference or range |
| Item8 | Number, text, cell reference or range |
| Item9 | Number, text, cell reference or range |
| j | The j (vertical) position of the value you want to pick out of a matrix, starting from the top at 1. |
| KeyDate | Either the Start or Finish date |
| LagMonths | Number of months lagged. Either a single number if applied to all Pmts, or a range, in which it is applied to corresponding Pmts. |
| Lambda | |
| LAMHOutput | |
| Language | A number indicating which language |
| LAOutput | Switch that sets what parameters are output from a Loan function |
| LDateOptions | What type of lease date is required (additive) |
| LeaseExpiry | The date of the expiry of the lease |
| LeaseExpiryDate | |
| LeaseInfoSwitch | An option indicating what item of information you require |
| LeaseStartDate | The date when the lease commences |
| LeaseStartOpt | |
| LetterSequence | |
| Level | Absolute level of something |
| Levels | A range of Levels. |
| Levels2 | |
| Levels3 | |
| Levels4 | |
| LevelSwitch | A switch describing how the level is averaged over a timeperiod |
| LevelSwitchOpt | A switch describing how the level is averaged over a timeperiod |
| LicenseCode | 10 Digit BF License Code |
| LifeOrDecRate | Either the life in years of the asset (eg 10 years) OR an annual rate of decline eg (0.25 per year) |
| LIOptions | Lease Info Options (additive, can be combined) |
| List | A 1 dimensional range, or single value |
| List1 | First 1 dimensional range, or single value |
| List2 | Second 1 dimensional Range, or single value |
| List3 | Third 1 dimensional Range, or single value |
| List4 | Fourth 1 dimensional Range, or single value |
| ListIn | A 1 dimensional range. It can span several sheets eg Sheet1:Sheet2!A1. This is the input range against which the tests are run. |
| ListOut | A 1 dimensional range. It can span several sheets eg Sheet1:Sheet2!A1. This is the range that goes into the calculations or is the output range (analogous to Excel"s "sum_range"). If missing, the input range is used instead. |
| LoanAmount | Loan amount advanced |
| LoanFee | Fee, as a fraction of the principal |
| LoanOutput | Switch that sets what parameters are output from a Loan function |
| LoanResid | Loan Residual amount. The amount of the loan left outstanding at the end (+ve for outstanding balance that you owe) |
| LoanSolveSwitch | What loan parameter you want solved for |
| LoanStartDate | Loan Start Date |
| LoanTerm | Term of loan(s), in years |
| LongStopRepDate | Date at which if the loan isn"t already repaid, it is repaid as a bullet. If not present, loan carries on. |
| LookupSwitch | A switch indicating how the lookup decides to return a value |
| LookupTol | The maximum difference between the InputValue and the looked up value of the InputRange that will be accepted before the function returns a #NUM! error. You can set to a large number or let it default. It"s designed to flag extreme lookups where the match is a long way from the nearest data point. |
| Look_UpSwitch | A switch that allows you determine how the lookup should be carried out (top to bottom, bottom to top etc) |
| LRSwitch | Linear Regression output switch |
| MarginOpt | Optional Margin, or Spread, to be applied over and above the simple interest rate. If MarginOpt is not zero, then Total interest rate = Interest Rate + Margin. Note however that Interest on Interest is charged at Interest Rate only, ie no Margin added. If you want Interest on Interest to include the margin, then build the margin into the Interest Rate and omit MarginOpt. |
| MargRates | List of Marginal percentage Rates, expressed as fractions. |
| MaturityDate | Bond Maturity Date |
| MaxDegPoly | The Maximum degree of Polynomial |
| Maximum | Maximum Acceptable Value |
| MaximumOpt | A maximum acceptable value returnable by the function |
| MaxRange | The maximum extent of the range |
| Mean | The statistical mean of the distribution |
| Means | The statistical mean of the distribution |
| MidPoint | Mid point in time of a distributed payment |
| Minimum | Minimum Acceptable Value |
| MinimumOpt | A minimum acceptable value returnable by the function |
| MinPayBack | Minimum payback date acceptable (if you want to stop a payback occurring to early because there are more negative cashflows to come) |
| MinRSqrdOpt | Minimum acceptable value of R squared (will throw an error if actual R squared is less than this value) |
| MktAnnRate | The annual market rate prevailing (before any growth is applied) |
| MktLevel | The market level |
| MktPrice | Market price |
| MktPriceFromDates | The date from which each of the MktPrices applies |
| MktPrices | Market price |
| MktPriceToDates | |
| MktRent | The annual Market Rent (ERV) prevailing (prior to having any growth applied) |
| MktRent_s | One or more annual Market Rents (ERV) prevailing (prior to having any growth applied). If plural, a different market rent is applied to the lease and each relet. |
| MktValue | The market value which is referred to as required by the function |
| Mnth | Month, expressed as a whole number |
| MonthInYear | An integer month number (1-12) within the year |
| MonthInYearOpt | 1-12 |
| Monthname | The name of the month |
| Months | A number of months. |
| MonthsDeferred | Months deferred (how long in months from valuation date to the deferral date) |
| MonthsLag | A range of lags, in months, |
| MonthsNextRev | Months until next review |
| MoveWeekend | A switch that describes how dates that fall on a weekhend are moved forward or backward (Sat to Mon, Sat to Fri, etc) |
| n | An integer number, n |
| Nearest | In a rounding function, the value x expressed as "to the nearest x", incremented from zero unless StartingFrom is specified |
| NetAdvance | Advance (+ve) (or Repayment (-ve)) |
| NetAdvances | Advances (+ve) or Repayments (-ve) |
| NetIncomes | Net Incomes |
| NetRockVolume | Net Rock Volume |
| nn | An integer number, n |
| NomYield | Nominal, or Simple Yield |
| NPer | Number of periods |
| NPV | The Net Present Value. |
| NPVDate | The date at which the Net Present Value (NPV) is discounted to. |
| NSim | Number of Monte-Carlo Simulations |
| Number | A number |
| NumberOfTokens | |
| NumOfPrds | Number Of Periods |
| NumPmts | Number of payments |
| NumPmtsPerYr | Number of payments Per Year (eg 4 = qtrly, 2=biannual). Must be 1,2,3,4, 6 or 12. |
| NumSteps | Number of steps required |
| OBArray | |
| OBCash | Opening Balance of Cash |
| OBSTD | Opening Balance of Short Term Debt |
| OccurrenceNo | The number of an event after or before a certain date, eg the n-th Monday in August, or the n-th Tuesday before Easter. |
| OnDiv0_s | The value to be returned in the event on a #DIV/0! error. |
| OnErrorN | What number to return on an error if any. If omitted, a #NUM! error will result if the function fails to find an answer. |
| OnErr_s | The value to be returned in the event on ANY error (INCLUDING ERR, NA etc). |
| OnName_s | The value to be returned in the event on a #NAME? error. |
| OnNA_s | The value to be returned in the event on an #NA! error. |
| OnNull_s | The value to be returned in the event on a #NULL! error. |
| OnNum_s | The value to be returned in the event on a #NUM! error. |
| OnRef_s | The value to be returned in the event on a #REF! error. |
| OnValue_s | The value to be returned in the event on a #VALUE! error. |
| Operation | Switch governing which operation you want done |
| Operator | Arithmetic operator for combining the two variables (eg 0 = multiply) |
| OptionExpiry | Option Expiry (Exercise) Date |
| OptionLetters | A string indicating which of the single letter options for this function you require. |
| OptionOutput | What you want the function to calculate (default = 0 = Option Value) |
| Options | A number comprising either the option number you require or an additive combination of option numbers. See function narrative for details. |
| OptionStyle | 0=European,1=American |
| OptionType | 0=call price, 1=put price |
| OptionValue | Option Value |
| Order | Optional. The order you want the GoalSeeks performed in, if you have multiple GoalSeeks in a single file, or amongst all teh files in memory. |
| OutList | The range in a Lookup where the OutputValue is read off from. |
| OutputData | The range of data outputs that are looked up |
| OutputMatrix | The matrix of data that is being looked up. |
| OutputMatrixPoly | The matrix of data that is being looked up. |
| OutputPoly_s | The output value(s) from a Lookup. |
| OutputRange | The range in a Lookup where the OutputValue is read off from. |
| OutputRangePoly | The range in a Lookup where the OutputPoly is read off from. |
| OutputSwitch | Output Switch (see narrative for details) |
| OutputValue | The output value from a Lookup. |
| OverallFinishDate | The overall Finish date for a projections function, which will override other specific start dates in the functions argument list |
| OverallStartDate | The overall Start date for a projections function, which will override other specific start dates in the functions argument list |
| p | A number. |
| ParamArray | Range of parameters for the function. See function narrative for details. |
| Params | A parameter, or list of parameters. See function narrative for detail. |
| ParBaseDate | Base Date for the Par Yield data ie time zero (ParDates>ParBaseDate by definition) |
| ParCoupFreqs | The frequency in payments per year, with which coupons are paid (positive number). |
| ParDates | The maturity dates of a series of fixed income financial instruments. |
| ParYields | The published par, or nominal, yields of a series of fixed income financial instruments. (Not the market yield or yield to redemption). |
| PassingAnnRent | The Passing Rent, per annum |
| PayBackDate | Payback date |
| PayBackOptions | Options governing how the payback is calculated. Options additive. |
| Peakness | The degree to which the distribution is peaked. High numbers (say 1000) means flat, whereas zero means a 25%/50%/25% moderate peakness (in fact, its a sin curve). |
| Periodicity | Time Interval between periodic repeating payments or functions, in exact months. |
| Periods | Either an option number, or a range of floats, describing the accruals periods or the timing of cash payments, in the format mm.dd for payments in advance or -mm.dd for payments in arrears. See Using Daycount |
| PeriodsRec | Periods for receipts (as opposed to costs) Either an option number, or a range of floats, describing the accruals periods or the timing of cash payments, in the format mm.dd for payments in advance or -mm.dd for payments in arrears. See Using Daycount |
| PickEvery | |
| PlateauRate | Plateau rate, an amount (eg bbl) per year |
| Pmt | The required payment to be made |
| Pmt10 | A payment to be made on a PmtDate |
| Pmt2 | A payment to be made on a PmtDate |
| Pmt3 | A payment to be made on a PmtDate |
| Pmt4 | A payment to be made on a PmtDate |
| Pmt5 | A payment to be made on a PmtDate |
| Pmt6 | A payment to be made on a PmtDate |
| Pmt7 | A payment to be made on a PmtDate |
| Pmt8 | A payment to be made on a PmtDate |
| Pmt9 | A payment to be made on a PmtDate |
| PmtDate | The date at which the payment (Pmt) is to be made |
| PmtDates | The dates at which payments are made |
| PmtDatesOpt | Optional payment dates |
| PmtIntervalYrs | Payment interval between payments in years. First payment is at end of first payment interval. |
| Pmts | The payments made. |
| Pmts10 | The payments to be made. |
| Pmts2 | The payments to be made. |
| Pmts3 | The payments to be made. |
| Pmts4 | The payments to be made. |
| Pmts5 | The payments to be made. |
| Pmts6 | The payments to be made. |
| Pmts7 | The payments to be made. |
| Pmts8 | The payments to be made. |
| Pmts9 | The payments to be made. |
| PmtsHistory | Payments that have already been made historically. In a history (...H) function, they are the "actuals" prior to projecting the remainder of the forecast. |
| PmtsOpt | Optional Payments |
| PmtsPerYear | Number of payments Per Year (eg +4 = qtrly in advance, -4 = qtrly in arrear) |
| PmtsPerYearOpt | Number of payments Per Year (eg +4 = qtrly in advance, -4 = qtrly in arrear) |
| PmtsPerYearRec | Payments Per Year Received in Revenue to cover the loan |
| PmtsPerYrInt | Payments Per Year Paid as interest |
| PmtsPerYrSrce | Number of payments Per Year (eg +4 = qtrly in advance, -4 = qtrly in arrear) |
| PmtsPerYrTarg | Number of payments Per Year (eg +4 = qtrly in advance, -4 = qtrly in arrear) |
| PmtsPerYr_s | How many interest payments are made per year |
| PolyList | A 1 dimensional range, or single value |
| PolyOrder | Order of polynomial you want (0 for best polynomial of order 1 to 20), or input -1 for straight line connection between each data point |
| Porosity | Porosity |
| PPSwitch | Production Profile Switch |
| PrdsArray | Series of preset sequence options, relating to the timing and/or accrual of interest payments. See Function Narrative. |
| PrdsCash | Annual Sequence or preset sequence option, relating to the timing and/or accrual of interest payments. |
| PrdsDisc | Discount Periods for use with DayCountDisc Annual Sequence or preset sequence option |
| PrdsEM | Periods for EM interest rates |
| PrdsGroup | The Periods sequence describing the time periods you want to gather the payments into |
| PrdsInt | Annual Sequence or preset sequence option, relating to the timing and/or accrual of interest payments. |
| PrdsLoan | Annual Sequence or preset sequence option, relating to the timing and/or accrual of interest payments. |
| PrdsPrin | Annual Sequence or preset sequence option, relating to the timing and/or accrual of principal payments. |
| PrdsRates | Either an option number, or a range of floats, describing the accruals periods or the timing of cash payments, in the format mm.dd for payments in advance or -mm.dd for payments in arrears. See Using Daycount |
| PrdsRep | Annual Dates when repayments are made |
| PrdsSource | The Periods sequence of the interest rate you want to convert FROM. |
| PrdsSTD | Short Term Debt: Annual Sequence or preset sequence option, relating to the timing and/or accrual of interest payments. |
| PrdsTarget | The Periods sequence of the interest rate you want to convert TO. |
| PresentValue | The Net Present Value |
| PriceGrowthDates | Dates from which PriceGrowthRates apply |
| PriceGrowthRates | Annual growth rates, % per year, expressed as an AER (Annual Equivalent Rate) and as a fraction eg 0.10 = 10% |
| PriceIndex | Which price index you want |
| Prices | Range of prices |
| ProjMode | Accruals=0, Cash=1. Has other settings. See detail and the topic Accruals and Cash |
| Proportions | A range of proportions. |
| PVDate | The date the Present Value is worked out to. |
| PVTOptions | A set of additive options governing how the DCF calculation is to be performed |
| q | A number. |
| QuotedRate | Quoted interest rate, per annum, as a simple interest rate (ie 12% pa = 1% per month) |
| r | A number. |
| RandOpt | Either a random number between zero and ,1 or alternatively -1 for the function to choose its own a random number (defaults to random) |
| RangeDirection | Direction of the range (0=flat,1=ascending, 2=descending etc) |
| RangeLocation | A cell reference pointing to the range of cells to be returned on the sheet where a match is found on ID |
| RangeOperation | What you want to do - sum, average, or count |
| RangeRef | A cell or range, or reference to a cell or range. |
| Rate | A rate, expressed as a fraction |
| RateableValue | Estimate of annual Market Rent (ERV) prevailing (prior to having any growth applied). |
| RateableValue_s | One or more estimates of annual Market Rent (ERV) prevailing (prior to having any growth applied). More than one applies to each subsequent relet. |
| RateOrFactor | Interest Rate or Discount Factor (depending on function settings) |
| RatesHol_s | One or more rates holiday(s) on non-occupancy. More than one applies for each subsequent relet. |
| RatesMultiplier | Rates multiplier at next revaluation date Historic ones up to April 2005 are fixed in the function. Recommend: use the latest known muliplier or what you estimate to be the multiplier at next revlautaion. |
| RateType | To what type of Rate RateOrFactor, ZCRateOrFactor?, ZCRatesOrFactors or RatesOrFactors refer. Default = AER Interest Rate |
| RecurringYrs | The interval in years at which this date recurs |
| RefString | A range reference expressed as a string |
| RegSought | Regular Expression pattern to seek |
| Relativity | The date relative to which the new date is being determined (Month Start, Easter, etc) |
| RelCost_s | |
| RelCurve_s | See CurveModel |
| RelDur_s | Duration in months |
| RelRF | Relet Rent-Free in months, immediately following any void period (eg ?ReletVoid?) |
| RelRF_s | Relet Rent-Free in months, immediately following any void period (eg ?ReletVoid?) |
| RelShape_s | A parameter indicating Skewness and Peakedness in a time spread functions. 0.00=symmetrical, evenly distributed; -100=backloaded;+100 frontloaded; 0.50 symmetrical, moderately peaked; 50.90, skewed to front ent, highly peaked. |
| RelTerm | Relet Term in years |
| RelTerm_s | Relet Term in years. Where there are more than one, applies to each subsequent relet, starting at the first. |
| RelVoid | Relet Void Years in months, immediately following previous expiry (eg ?ExpOrBreak?) |
| RelVoid_s | Relet Void Years in months, immediately following previous expiry (eg ?ExpOrBreak?) |
| RentDateSwitch | An option indicating what item of information you require |
| RentEventType | An option indicating the type of rent event |
| RentFreeMonths | Months of Rent Free before the first rent passes |
| RentStart | The date when rent commences |
| RentStartDate | |
| RepaymentDate | The repayment date of the loan, where any outstanding balance is repaid |
| RepDate | The repayment date of the loan, where any outstanding balance is repaid |
| Replacement | Replacement string to substitute |
| RepType | Repayment Type |
| Res1 | The result if the corresponding Condition or Case is true. |
| Res10 | The result if the corresponding Condition or Case is true. |
| Res11 | The result if the corresponding Condition or Case is true. |
| Res12 | The result if the corresponding Condition or Case is true. |
| Res2 | The result if the corresponding Condition or Case is true. |
| Res3 | The result if the corresponding Condition or Case is true. |
| Res4 | The result if the corresponding Condition or Case is true. |
| Res5 | The result if the corresponding Condition or Case is true. |
| Res6 | The result if the corresponding Condition or Case is true. |
| Res7 | The result if the corresponding Condition or Case is true. |
| Res8 | The result if the corresponding Condition or Case is true. |
| Res9 | The result if the corresponding Condition or Case is true. |
| Reserves | Total Reserves. |
| ReservesDec | Reserves in Decline |
| ResText1 | The text result of the switch in this case. |
| ResText10 | The text result of the switch in this case. |
| ResText2 | The text result of the switch in this case. |
| ResText3 | The text result of the switch in this case. |
| ResText4 | The text result of the switch in this case. |
| ResText5 | The text result of the switch in this case. |
| ResText6 | The text result of the switch in this case. |
| ResText7 | The text result of the switch in this case. |
| ResText8 | The text result of the switch in this case. |
| ResText9 | The text result of the switch in this case. |
| Result | The result of the function, expressed as a number. |
| Result1 | The result if the corresponding Condition or Case is true. |
| Result10 | The result if the corresponding Condition or Case is true. |
| Result11 | The result if the corresponding Condition or Case is true. |
| Result12 | The result if the corresponding Condition or Case is true. |
| Result2 | The result if the corresponding Condition or Case is true. |
| Result3 | The result if the corresponding Condition or Case is true. |
| Result4 | The result if the corresponding Condition or Case is true. |
| Result5 | The result if the corresponding Condition or Case is true. |
| Result6 | The result if the corresponding Condition or Case is true. |
| Result7 | The result if the corresponding Condition or Case is true. |
| Result8 | The result if the corresponding Condition or Case is true. |
| Result9 | The result if the corresponding Condition or Case is true. |
| ResultInt | An integer result |
| Results | A numerical list of results for each condition. |
| ResultsInt | A numerical list of results. |
| ResultsNum | The range of results, as numbers |
| ResultsNumOrDate | Results either as a number or a date |
| ResultsPoly | Range of polymorphic |
| ResultsText | A textual list of results for each condition. |
| ResultText | The result of the function (a text value) |
| ResultTxt | The result of the function (a text value) |
| Result_s | One or more results of the function, expressed as a number. |
| ResvsOrDcRate | Either the Reserves (if>0), or the decline rate (if<0, ie -ve) |
| ReturnBehaviour | One or more option values (additive) |
| ReturnPoly | The return value |
| Returns | The Returns in each period |
| ReturnSwitch | A switch indicating what value you would like returned |
| ReturnVar | The return value |
| RevDis | Discount to the market forecast, expressed as a positive fraction, that happens at review. |
| RevDisc | Discount to the market forecast, expressed as a positive fraction, that happens at review. |
| ReviewDates | List of rent reviews that define the date up until a corresponding rent flows |
| Reviews | List of rent reviews (that define the date up until any corresponding rent flows) |
| ReviewsOpt | List of rent reviews (that define the date up until any corresponding rent flows) |
| ReviewTypes | The type of rent review that occurs at the corresponding date |
| RevMonths | Length of time in months between successive market reviews in the lease (default=60 (5 years)) |
| RevMonthsAnnRateOpt | The length of each review period, expressed in months. For continuous growth or review, input zero. |
| RevMonthsLevelsOpt | The length of each review period, expressed in months. For continuous growth or review, input zero. |
| RevMonthsOpt | The length of each review period, expressed in months. For continuous growth or review, input zero. |
| RevMos | The length of each review period, expressed in months. (For continuous growth or review in a growth function, input zero.) |
| RevToMkt | First review to market (for example, after a fixed rent section) |
| RevYears | The standard time inbetween market rent reviews |
| RiskFreeRateAER | Risk free interest rate expressed as an AER (annually compounded rate) |
| RollTo | Roll up interest until this date (in a loan) |
| ROpts | Real Estate Options. A number comprising either the option number you require or an additive combination of option numbers. See function narrative for details. |
| RoundDown | Either a boolean (True/False) value or an integer (True=1,False=0) indicating whether the function should round down to the previous value or date where an "equals" circumstance arises. |
| RoundedValue | The rounded value |
| RoundMethod | Whether to round(0), floor(1) or ceiling(2) |
| Rows | A number of rows |
| SampleVariance | The Sample Variances parameter for each History Period |
| ScaleDateMax | The value of the maximum on the X axis |
| ScaleDateMin | The value of the minimum on the X axis |
| ScaleMax | The value of the maximum on the X axis |
| ScaleMin | The value of the minimum on the X axis |
| SCFcstBase | The base (ie the length in exact months of the individual time periods) of a forecast specified by SCFcstTotalServCharge and SCStartFcst |
| SCFcstTotalServCharge | The values of a forecast of the total annual rate of service charge specified by SCFcstBase and SCStartFcst |
| SCFromDates | The dates from which each of the SCPercentages apply |
| SCPercentages | The percentage to multiply the total service charge by to arrive at this tenants service charge |
| SCRevMonths | The length of each service charge review period, expressed in months. (For continuous growth or review in a growth function, input zero.) |
| SCStartDate | Service Charge Start Date |
| SCStartFcst | Start of the forecast specified by SCFcstBase and SCFcstTotalServCharge |
| SeasonFactors | List of up to 100 factors, or weights for adjusting an annual rate. See Modelling Seasonality |
| SeasonSeq | List of up to 100 annual date sequence numbers for adjusting an annual rate. See Modelling Seasonality |
| SeqRelFinish | Finish of accrual, defined in terms of a number of sequence dates relative to TheDate (-2=2 sequence dates prior,+1=1 sequence date subsequent) |
| SeqRelStart | Start of accrual, defined in terms of a number of sequence dates relative to TheDate (-2=2 sequence dates prior,+1=1 sequence date subsequent) |
| ServChargeAnnRates | Annual rates of service charge |
| ServChargeDue | Service Charge Due |
| ServChargeTotal | Total Service Charge for building or Estate |
| SettlementDate | Bond Settlement Date |
| SettlementPrice | How much the bond is purchased for. |
| SFDepoRateAss | |
| SFDepoRateDebt | |
| SFDeposEst | * Estimates of the SF deposits |
| SFExogAssBals | * |
| SFExogDates | * |
| SFExogDebtBals | * |
| SFExogDepos | * exogenous SF deposits, in addition to whats calcd. |
| SFIntOverRide | * |
| SFRateFee | *Sinking Fund Admin Fee annual rate |
| Shape | A parameter indicating Skewness and Peakedness in a time spread functions. 0.00=symmetrical, evenly distributed; -1.00=backloaded;+1.00 frontloaded; 0.50 symmetrical, moderately peaked; 0,90, symmetrical, highly peaked. |
| SheetID | The ID of the sheet being sought. |
| SheetIDLocation | A cell reference pointing to the row and column on on each sheet where an ID for the shaeet (can be number or text) can be found. |
| SheetLocation1 | A cell reference pointing to the start of the sheets to be searched |
| SheetLocation2 | A cell reference pointing to the end of the sheets to be searched |
| SheetNameString | Sheet Name |
| SignChangeType | Type of sign change (0=sign change, 1=change in sign of gradient) |
| Skew | A parameter indicating Skewness in a Distribution (symmetrical=1, less than 1 skewed towards earlier time, greater than 1 skewed toward later time). |
| SpaceToBarRatio | How much bigger is a space to a bar in the font you selected |
| SpecificDates | Additional, specific, dates you want to include as part of a date sequencing calculation |
| SpecificDates1 | Additional, specific, dates you want to include as part of a date sequencing calculation |
| SpecificDates2 | Additional, specific, dates you want to include as part of a date sequencing calculation |
| SpecificDates3 | Additional, specific, dates you want to include as part of a date sequencing calculation |
| SpecificDates4 | Additional, specific, dates you want to include as part of a date sequencing calculation |
| SplitMode | How you want the split to work: 0=RegSought is the delimiter;1=each token must match RegSought |
| SpotRatesAER | A series of AER (Annual Equivalent Rate) interest rates that run from BaseDate to the corresponding date in ToDates. See Annual Equivalent Rates |
| Srange | Range of strings |
| StanDev | Standard Deviation |
| Start | The start date from which calculations commence, or the start date of a projection or payment stream. |
| Start2 | The start date from which calculations commence, or the start date of a projection or payment stream. |
| Start3 | The start date from which calculations commence, or the start date of a projection or payment stream. |
| StartAnnDate | Start date of annual cash flows |
| StartCost | Date when costs commence |
| StartDates | A range of dates denoting the start of each timeperiod. |
| StartDCF | Optional Start Date for cashflows to be included in the DCF (PV or IRR) calculation. If omitted, all cashflows are included. Over-rides other Start dates in the function. |
| StartDep | The Start date of Depreciation (this is usually the Initial Date, but it is possible for depreciation to commence later) |
| StartFcst | Start of the forecast specified by FcstBase and FcstVals |
| StartFcstRates | Start of the forecast specified by FcstBase and FcstVals |
| StartFlows | The start date of the cashflows |
| StartingAt | Where the first value you want is. (First item in the input list = 1) |
| StartingFromOpt | In a rounding function, used with nearest to determine the nearest roundoff. Nearest is incremented from StartingFrom |
| StartingIdxRev | Which of the range of IdxBaseDates you want to start from (for relet calcs) |
| StartingSeqNum_s | One or more date sequence numbers in the form mm.dd (strictly optional). See notes to function. |
| StartingValue | The starting value |
| StartLease | Start of the lease |
| StartLevels | When the level(s) start |
| StartOfWeek | A number indicating on what day a week starts (1=Sunday,2=Monday etc) |
| StartOfWeek1 | A number indicating when the first week starts. 1=Week containing first Sunday in January,2=contains first Monday ... 5=first Thursday or 0=Week 1 starts January 1st |
| StartPos | Starting Position |
| StartRepayments | Start Date for repayments |
| Starts | Either one Start date or a list of Start dates |
| StdEquation | Standard Equation |
| StepsPerYear | How many steps make up a year eg 12 implies a step length of 1 month, 4 implies a step length of 1 quarter. |
| StockPrice | Current Stock Price at point of calculation |
| StockPrices | Range of Stock Prices |
| STOIIP | Stock Tank Oil initially in place |
| StrikePrice | Strike Price of the Option at exercise (expiration) |
| Swc | Connate (irreducible) water saturation |
| SwitchVar | The Switch Variable that is compared with each Case Variable to decide which Result to return. |
| TargetCell | Reference to a cell containing the result of your calculations. |
| TargetValue | Value or reference to a cell containing the value you want TargetCell to achieve. |
| Tension | A parameter indicating tension (slack, or curvature) in an Interpolation (only required for Hermite Interpolation) |
| TermYrs | Term in years of loan, lease etc |
| TermYrsOpt | The term of the lease in years |
| Term_s | One or more Terms, in years |
| TestMS | |
| TextResults | A textual list of results for each condition. |
| Textstring | A string of text |
| Textstrings | A range of strings (text) |
| Textstring_s | Either one string or a range of strings (text) |
| TheDate | A date. |
| TheOption | A number comprising an option number (1,2,4,8,16,32 etc) |
| TheRange | A range of any type and size |
| Threshold | The level of cash (or short term debt (if -ve)) below which loan is taken out |
| Time | The Time or Date that signifies the start of a time period. Usually accompanied by Base, the length (months) or end of the time period. |
| Timebase | A range of dates that indicate time periods. The timebase specifies the start and end dates of the time periods on a continuous timeline. |
| TimeSteps | For a financial option, the number of evenly spaced timesteps (dt) over which the underlying asset value changes. Make as big as performance allows. |
| ToDate | The date up until which a period of time runs |
| ToDates | A range of dates up until a rate or level changes |
| ToDates2 | A range of dates up until a rate or level changes |
| ToDates3 | A range of dates up until a rate or level changes |
| ToDates4 | A range of dates up until a rate or level changes |
| ToDate_s | One date or a range of dates up until which you want a calculations to run |
| ToFinish | The Finish date of the payment stream after it is rephased |
| Token | A piece of text delineated as specified by DELIMITER |
| TokenNo | The number of the token (from the left) that you wish to extract |
| TolDays | Tolerance, in days |
| Tolerance | Tolerance |
| ToPmtDate | The PmtDate after is rephased |
| ToPmtDates | The PmtDates after they are rephased |
| ToStart | The Start date of the payment stream after it is rephased |
| Tot | The total amount. |
| Total | The total amount. |
| Totals | Either one Total amount, or a list of Total amounts. |
| ToThresholds | Levels UP TO which certain rates apply |
| Tranche | The multiple in which amounts of loan are taken out. eg for Tranche=200, loan must be 200, 400 etc |
| TrimSwitch | Options for trimming |
| TrueFalse | A variable that specifies true or false, according to Excel"s definitions of true and false. |
| TrueYield | Real Estate True, or AER Yield |
| Turnovers | Turnover expressed as annual rates |
| TurnSwitch | Turnover Rent output switch (0 or omitted=rent, 1=average turnover, etc) |
| TWRROptions | Options relating to the TWRR calculation (additive) eg 1=annualise returns |
| TWRRSwitch | What type of TWRR you want |
| TxtGraph | The graph, as text |
| UOTog | One or more dates that from which, rent reviews are upwards only or upwards/downwards. |
| USAPR | Interest Rate per annum expressed as US-style APR, as a simple interest rate (ie 12% pa = 1% per month) |
| uu | An integer number |
| Valuation | Valuation or Purchase Price, AFTER deducting any fees or costs as might be specified in CostsPerc |
| ValuationDate | Date of the valuation (or purchase). |
| Value | A value, expressed as a number. |
| Value2 | |
| Values | Range of Values |
| Values1 | The first range of numerical values |
| Values2 | The second range of numerical values |
| Values3 | The third range of numerical values |
| Values4 | The fourth range of numerical values |
| VarName | Variable Name |
| VarNo | The id number (optional) of the variable. Only needed for multiple VarVals. |
| VarReq | The number required (1,2, or 3) |
| VarVal | The value of the variable |
| VarValue | The value of the variable |
| Volatility | Volatility, % p.a. |
| vv | An integer number |
| WeekendDays | Range of integers indicating which days are weekends 1=Sunday. Conventional weekend={7,1} |
| WeekNum | Week Number within year 1-53 |
| Weights | A list of weighting factors (needn"t add to 1) |
| WhichMoment | |
| WhichOne | The number, starting from 1, of the value or date you want to pick out |
| x | A number. |
| XMax | Maximum X Value |
| XMin | Minimum X Value |
| XValues | Range of X Values |
| XValues2 | Range of X Values |
| y | A number. |
| YearOrDate | The year number (eg 2004) or a date within the year where you want to determine the date |
| Yield | Real Estate Yield |
| YieldTypeOpt | Type of yield specified or required (0 and default=True (AER),1 = Nominal) |
| Yr | Year, expressed as a whole number |
| Yrs | A number of years. |
| Yrs_t | Years from the start of the decline (end of the plateau) |
| YValues | Range of Y Values |
| YValues2 | Range of Y Values |
| ZCRateOrFactor | Zero Coupon Rate or Discount Factor (depending on function settings) |
| ZCRatesOrFactors | Zero Coupon Rates or Discount Factors (depending on function settings) |
| ZDOptstr | A string indicating which of the single letter options for this function you require. |
Any comments on this documentation? Send us your suggestions below.
