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
    Golden Rules
    Recommendations
    You probably need to consult the rest of the help file to see where we are coming from on some of these, but we thought we"d introduce some of our own "Golden Rules", even at this early stage:

    Excel Generally
    • Understand CELL REFERENCING, whether by absolute, relative or range naming. Recognise that, where you have the time and where its appropriate, that range naming has great benefits in terms of clarity and auditability. There are some people who are against range naming because they are concerned that its harder to see where the data has come from, but in our opinion the improved clarity in formulae outweighs this. Your formulae must be readable.
    • When projecting time-dependent streams like cashflows, revenues and costs, use REPEATING FORMULAE over the full extent of the timebase. Avoid one-off "kludges" in particular timeperiods. The understandability of the model will improve and you will be also be able to make the most effective use of Business Functions Time and Base variables.

    Business Functions in Particular
    • Find out what Projections functions do. There are several categories of these and they are one of the "big ideas" of Business Functions. They enable you to use a single formula over the whole timebase of your model without resorting to single cell "kludges" that are hard to debug.
    • When using a projections function in cash mode, use DayCount and Periods specifically rather than use the defaults. This is because these variables are crucial to your cash payment calculations. This is more a point for those of you interested in accounting-like precision, but it looks better, for example, if your rent or interest payment actually occurs in the correct month!
    • Always make your models timebase flexible. Do this by always using Business Functions to project cash flows and using Base to reference a single timeperiod length specified in your spreadsheet inputs. It"s such a good habit to get into and makes your models much more widely useable: for example, the accouting department might want the model on a monthly basis, top management might want quarterly or even yearly. BF enables you to have such versatile models.
    • Be aware of the various methods of specifying Time and Base. In the simplest form of input, Time is a date and Base is a timeperiod length in months. However, you can also specify both as dates, where Base then marks the end of the timeperiod, giving very fine control over the timeperiod length. Also, when specifying dates, remember you can use Business Functions decimal year format as well (eg 2000.5 = 1st July 2000).
    • Note that where a timeperiod is specified as two dates, BF will "include the first, exclude the last". So the period 1st January-1st July can be though of running from 1 minute past midnight on 1st January to 1 minute past midnight on 1st July, and therefore exclude any revenue or cost accruing on 1st July.
    • Understand the difference between cash and accruals, in advance and in arrears. Note that, in arrears, BF always pays the day after the accruals period ends, so periods of {-1.01,-7.01}, which refer to accruals periods 1st January-30th June and 1st July-31s December actually pay out on 1st July and 1 January.

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