Business Functions Library for Excel

Note: In order to use the spreadsheet examples, you need to download Business Functions
TStepGTurnRentGrow (Time, Base, RentStart, BrksOrExp, MargTurnRates, [RateFromThresholds], [RateFromDates], GrowDatesTh, GrowRatesTh, ToDates, Turnovers, GrowthDates, GrowthRates, [GrowEvery], [TurnSwitch], [DayCount], [Periods], [ProjMode], [Brk])
Stepped Gross Turnover Rent
Auto Array Function
###### Features
...Grow...Incorporating growth rates
Step...Has a stepped rate profile
###### Key Points

Setting Turnover Percentage Rates

• The basic function configuration is set up to work as the spreadsheet example shows, with a 2-dimensional matrix of percentage rates which are the subject of a look woith respect to FromDates and Turnover Thresholds. This is not the only way to set up the percentages.
• If you just want to set a turnover rate and forget about thresholds and dates, just input the turnover percentage rate as Marginal Rates, and either omit entering RateFromDates and RateFromThresholds, or enter a small date (eg 1960) and a zero threshold.
• If you just want your percentage rate to depend on time, enter some RateFromDates and there is no need to enter any RateFromThresholds.
• If you just want your percentage rate to depend on turnover thresholds, enter some RateFromThresholds and there is no need to enter any RateFromDates.
• If you enter both RateFromThresholds and RateFromDates, note that the function expects dates to be along the top axis of the turnover matrix and and thresholds to down the side. However, if you only enter one of RateFromThresholds and RateFromDates, orientation does not matter, the function will perform the (one-dimensional) lookup without problem.

###### Step By Step

See the template on the website for details.

• Turnover is controlled principally by Turnovers, GrowthRates and GrowthDates. GrowEvery determines how often the turnover grows or reviews to a higher level (it needs to be at least 1 month).
• The percentage is read of a 2 dimensional lookup table. The body of the table is a 2D array MargRates, which is a table against RateFromDates along the top as the horizontal lookup, and RateFromThresholds down the side as the different turnover levels. For a simple single percentage, just put in a zero threshold, a fromdate at the rent start and a percentage in the top left corner of MargRates.
• That describes the core of this function: it simply applies different MargRates against an escalating turnover.

###### Things To Watch Out For

• Marginal Rates are the rates that apply to the trnover that lies between the corresponding turnover threshold and and the threshold above. They are like (UK) income tax bands.
• Currently, the function grows the thresholds continously, whereas turnover growth is governed by GrowEvery. This behaviour may change in the future.

###### Example
TStepGTurnRentGrow.xls
###### Templates
This function features in the following downloadable spreadsheet template(s):

turnrent.xls

Business Functions Ltd, London, UK Website Design: Webpure