Business Functions Library for Excel

      1. Getting Started
      2. Using The Help File
      3. Top Dozen Functions
      4. Golden Rules
      5. Excel 2007
      1. Go To
      2. Function Selector
      3. CalculateFull
      4. Calculate WorkSheet
      5. Trace Facility
      6. Quick Paste Example
      7. Tutorials
      8. Function Finder
      9. Examples
      10. Help
      11. Excel"s Function Wizard
      12. Access Internet
      13. Usage of Functions (Audit)
      14. Uninstall
      1. Time Periods
      2. Inclusive and Exclusive Dates
      3. Using Daycount
      4. Examples of DayCount
      5. Annual Date Sequences
      6. ProjMode and Inclusive Dates
      7. Date Rolling Convention
      1. Rate Projections Functions Walkthrough
      2. Accruals and Cash
      3. Repeating Formulae
      4. Range Names and References
      5. Optional Parameters
      6. Using PmtsPerYear
      7. Modelling Seasonality
      8. Calculating Interest
      9. Using Business Functions in VBA (Visual Basic for Applications)
      10. Array Functions
      11. Volatility
      12. Annual Equivalent Rates
      13. Array Function
      14. Auto Multi Functions
      15. Variable Plurality
      16. GoalSeek
      1. Introduction To the Worked Examples
      2. Daycount
      3. General Projections
      4. Business Plans
      5. Cashbasis And Periods
      6. Using Timebases
      7. Using Dates
      1. How To Generate a time scale for a structured financing
      2. How To Project Rents off a Rental Forecast
      3. How To Run a model on different time bases
      4. How To Isolate The Cause of a Errors in Cells using Trace
      1. Introduction to the Utilities
      2. Audit
      3. Synchronized Range Insert/Delete
      4. Database Edit
      5. Insert Macro Button
      6. Link Analyser
      7. Range Describer
      8. PrintScript (beta)
      9. Create Local Range Name
      1. Number Formats
      2. Apply BF"s Color Palette
      3. Bullets
      4. Color Cells
      5. Conditional Formats
      1. Validation DropDowms
      2. Validation Standards
      1. Select Excel Function
      2. Array Function Tools
      3. Sort Sheets
      4. Range Value
      5. Named Range Manager
      6. Enforce WorkBook Settings
      7. Monte-Carlo
      8. TimeChart
      1. The ".ini" file
      1. Forum
      2. Online Help
      3. Templates
      1. Conversion of Input Strings to Values
      2. List of Holidays
      3. Acknowledgements and Trademarks
      4. Published Editions Changes in Behaviour
      5. Range Handling And Constraints
      6. Dates in Excel and Business Functions
      7. Old Composite DayCount Format
      8. DayCount in Excels"s Functions
      1. NPV of Annual To Periodic CashFlows - CorrectionM
      2. Interest - Simple, Annual, Continous and Discount Factors
      1. New Functions
      2. Obsolete Functions
      3. Discontinued Functions
      4. Deprecated Functions
    Top Dozen Functions
    Our own view
    Of the hundreds of functions in the Business Functions library, the following are, from our experience, the most popular.

    1. In the Date and Time Calculations category, DpY (date plus years) and DpM (date plus months) are essential for setting up any schedule of dates or linking event times from one part of a model to another.
    2. In the Constant Rate Projections category, Con is the basic function for an annual rate that has a start and an end date.
    3. In the Stepped Rate Projections category, FStep is very useful in any stepped rate situation, using the more popular FromDates method of specifying rates and having a very simple variable list. Not far behind it in popularity, and quite handy in Real Estate projections, is TStep, where the ToDates method is used.
    4. Also in this category is AnnGrow, of general application in any situation of growing costs.
    5. In the Discrete Amount Projections category MkPmts is of general use in any list of payments and dates. With DpY/DpM, FStep, AnnGrow, and MkPmts you can do a powerful forecast or budget which will have variable timebase capability (could be run on quarterly or annual basis), ability to model recessions (change in growth rates) and be very fast.
    6. In the Distributed Amount Projections category, UniSpread is the simplest of the time spread functions, spread an amount uniformly between a start and an end date. Going on from there SCurve is a long-time steady performer for spreading capital costs that peak somewhere in the middle of their time duration.
    7. In the Instantaneous Level Projections category, Fcst is the simple standard function for reading a value off an even spaced forecast of values against time (eg price forecasts).
    8. In the Range Operations category, SumCat is a simple and effective way of breaking a total down into different categories. Excels SumIf function does a similar kind of job, but it is somehow a little less direct.
    9. Also in the Range Operations category, WeightAv is a very quick way of computing a weighted average.
    10. In the Time Value Of Money Analysis category, NPVM is essential for calculating the NPV where you have cash flow that occurs throughout the year rather than at year end.

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