Business Functions - freeware Excel modelling library

Date and Time Calculations category
Date Information family	Functions that calculate dates or provide information about dates
Date Difference family	Functions that work out differences between dates
Date Increment family	Functions that add or subtract increments of time onto a date.
Time Period family	Calculations with Timeperiods (a period of time between two dates).
Special Dates category
Business Days family	Functions that determine whether a day is a business day or not, or do calculations on business days.
Holidays family	Functions that calculate the dates of holidays in various countries
Discrete Amount Projections category
Payments family	Functions that project discrete amounts at certain times.
Payments Periodic family	Functions that project discrete amounts but repeat them at set time intervals.
Payments Market family	Functions that project discrete amounts at certain times, where missing values are read off a forecast.
Distributed Amount Projections category
Time Spread family	Distributed Projections based on spreading an amount over time.
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
Constant Rate Projections category
Constant Rate family	Projections functions that apply to a constant rate.
Constant Rate Periodic family	Constant Rate Periodic
Constant Rate Market family	Constant Rate functions that involve some form of reference to a market rate
Constant Rate Revenue family	Make projections at a constant rate and multiply the result by the prevailing market price, calculated off a forecast
Stepped Rate Projections category
Stepped Rate From family	Stepped Rate Continuous Projections
Stepped Rate To family	Stepped Rate Continuous Projections
Stepped Rate Market family	Continuous Stepped Rate projections that involve some form of reference to a market estimate
Stepped Rate Revenue family	Make stepped rate projections combining a rate and a price to give a revenue
Interpolated and Curve-Fitted Projections category
Interpolated and Curve-Fitted Rates family	Interpolated and Curve-Fitted Projections where a Rate is applied to a timeperiod
Interpolated and Curve-Fitted Levels family	Projecting Interpolated and Curve-Fitted Levels against future points in time
Instantaneous Level Projections category
Levels family	Instantaneous Levels: Reading off a level at a moment in time
Levels Market family	Forecasts based on looking up a current balance off a list of levels as well as a market estimate
Growth family	Calculations involving time-dependent growth.
Forecast family	Forecasts using an constant interval even forecast.
Forecast Specific Times family	Forecasts using a forecast based on any list of times and values.
Levels Over Time Projections category
Levels Average family	Changing Levels over time where the level depends on the timeperiod it is in rather than a single time.
Levels Average Market family	Determine the average level in a timeperiod, and where there are missing values refer to a market forecast
Projections NPV category
NPV Constant Rate family	Calculate the NPV of constant rate functions
NPV Stepped Rate family	Calculate the NPV of stepped rate functions
NPV Payments family	Calculate the NPV of discrete amount functions
NPV Time Spread family	Calculate the NPV of timespread functions
Time Value Of Money Analysis category
Basic Interest Rate Conversions family	Converting between different kinds of interest rate compounding
Advanced Interest Rate Conversions family	Converting between different kinds of interest rate compounding
Annuity family	Functions based around annuity formulae
Annuity Extended family	The standard annuity functions (PMT etc) extended to allow for industry methods of interest daycount and payment periodicity
US APR family	USA style Annual Percentage Rates
Discounted Cash Flow category
DCF One-Off family	DCF and NPV calculations for one-off amounts in the future or past
DCF Annual family	Discounted Cashflow calculations for Annual cashflows
DCF Even Intervals family	Discounted Cashflow calculations for cashflows that are evenly spaced but not necessarily annual
DCF Specific Times family	DCF and NPV calculations where the cashflows are irregular and you can specify exact dates and amounts
DCF Dispersed Annual family	DCF and NPV calculations where the cashflows are annual but dispersed over the year
Accounting And Tax category
Accounting family	Accounting, Depreciation etc
Tax family	Calculations involving taxation.
Mathematical Calculations category
Statistics family	Statistics
Range Operations category
Range Lookup family	Functions for performing a lookup where a value is dependent on a lookup table of values.
Range Sum family	Calculations involving selectively summing one or more ranges.
Range Reference family	Functions for getting information on cell and range references.
Range Calcs family	Calculations on ranges including averages and special maximum/minimums
Range Information family	Range Information
Range Manipulation family	Range Management
Interpolation family	Interpolation
Simulation Modelling category
Monte Carlo family	Sample from distributions, rand numbers and other Monte Carlo functions
Real Estate category
Rent family	Functions for performing rent projections.
Rent From family	Rent projections using From Dates
Rent To family	Rent projection using To Dates
Rent Reletting family	Rental functions that automatically relet
UK Valuation family	Real Estate Valuation (UK specific)
UK Valuation DCF family	Real Estate Valuation (DCF Math)
NPV Rent Projections family	Calculate the NPV of rent functions
Retail Rent family	Retail Rent
Index Rent family	Index rent
Real Estate Costs family	Real Estate Costs
Real Estate Costs UK family	Real Estate Costs (UK specific)
Lease Information family	Lease Information
Banking category
Interest family	Projection of interest paid and accrued
Yield Curve family	Calculating aspects of the interest rate yield curve
Loan family	Calculations involving loans.
Residual Cash family	Deals with what to with residual cash in a cash flow ie cash balances and overdrafts
Equity Trading family	Equity trading calculations
Options family	Options
Petroleum Economics category
Petroleum Engineering family	Functions for Petroleum Engineers
Decline Curve family	Production Profiling using Decline Curves
Text category
Numbers To Text family	Numbers To Text
Text String family	Manipulations of strings
Regular Expressions family	Regular Expressions
Miscellaneous category
Special Arithmetic family	Functions for arithmetic operations where you want to suppress errors or do special calculations.
Rounding family	Functions for rounding off numbers.
Library Information family	Information about Library parameters
Flow Of Control family	Switching, If/Then/Else and other flow of control functions
Comparisons family	Comparing the values of two variables
Excel Information family	Excel Information

Any comments on this documentation? Send us your suggestions below.

315