Business Functions Library for Excel



Business Functions is a free function library for Microsoft Excel that's been around since 2002.

It's for financial and business analysts in corporates, banks and property companies.

We built it to make business plans, budgets, structured financings and cashflows more powerful and manageable. Using standard functions makes models:


  • more adaptable, because a single function call can invoke a large variety of different kinds of behaviour.
  • more accurate, because, amongst other things, over the years we've built in quite a sophisticated date/time system that models daycount very accurately.
  • faster to build, because you can build from an existing palette of standard algorithms, rather than reinventing the wheel every time.
  • quicker to run, because of the fast language the functions are written in (C++).
  • less error prone, because of the standard and tested behaviour of the functions. Be aware, that it doesn’t eliminate the cause of spreadsheet errors.
  • more transparent and understandable, because the function's name and documentation explains the intent of what's being modelled better than a hieroglyphic formula.

BF is therefore a comprehensive collection of projections functions that project cashflows and accruals with a high degree of daycount accuracy.

Some 500 or so functions do the dirty work of projecting costs and revenues, coping with time periods, growth etc. In many contexts it is a complete solution, allowing models to dynamically run on any timebase (quarterly, annually etc) by changing a single cell.

Business Functions phone: +44 (0)20 8144 9374 (London UK)
Website Design: Webpure