Welcome to the online function referenceThere are 586 functions currently in BF. Click on a category, family or function from the tree menu on the left hand side. This online reference is a slightly smaller version of the help file provided with BF. Each function has its own example in Excel, and many functions are also used in some more realisitic worked examples and spreadsheet templates that we have built to illustrate their usage. | ||||||||
Time Spread Periodic family | ||||||||
Time Spread Periodic | ||||||||
Time Spread Weighted family | ||||||||
Time Spread functions where you input specific factors or rates rather than using standard distributions or curves | ||||||||
Time Spread History family | ||||||||
Time Spread functions that take into account an existing payment history and adjust the forward forecast accordingly | ||||||||
Time Spread family | ||||||||
Distributed Projections based on spreading an amount over time. | ||||||||
NPV Time Spread family | ||||||||
Calculate the NPV of timespread functions | ||||||||
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 | ||||||||
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 | ||||||||
UniSpreadGrow (Time, Base, Start, Finish, Total, GrowthDates, GrowthRates, [DayCount], [Periods], [ProjMode]) | ||||||||
Spread an amount Uniformly over time, with Growth |