Note: In order to use the spreadsheet examples, you need to download Business Functions
|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|
|Auto Array Function|
|...Fcst...||Changes are read of a supplied forecast.|
|Step...||Has a stepped rate profile|
|...Idx...||Changes in line with a supplied Index|
This function would normall have had a FinishDCF parameter. Thgis has been omitted because of Excel"s limit of 30 input variables to a function (limit removed in Excel 2007, but we have to remain backward compatible). Use AbFin instead.