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
    Old Composite DayCount Format
    Superceded Daycount specification format
    The old method of specifying daycount, which still works and will continue to work, uses one or two digits.
    • The first digit specifies the daycount of the whole periods within the start and end date.
    • The optional second digit specifies the daycount applicable to the stub periods, or partial periods, at either end of the projection near to the start or end.
    The new format for daycount is ww.sssf where:
    • The whole number ww, is the daycount applicable to the whole periods.
    • The optional digits after the decimal point apply to stub periods, for example 6.03, or using the newer daycounts 10 and above, you might have 6.11 or 11.12. be careful to put in the zero if the stub daycount type is less than 10, ie 6.03.
    • If you want a different daycount for all three sections of the time difference between the start and end date, use the full format ww.sssf, where the whole number is the daycount of the whole periods, the first two digits after the decimal point apply to the starting stub period, and the last two digits apply to the finishing stub period. For example, 6.1103 has daycount 6 for the whole periods, 11 for the starting stub period and 3 for the finishing stub. Again, be sure to include zeros where the daycount is less than 10, ie 6.1103.
    The new format allows for more daycount options than just 0 to 9, and allows a different daycount setting for each stub.

    The old format will continue to work fine, but note the following:
    • If you just have a single daycount format, you don"t need to worry. Both methods amount to the same thing.
    • Old style composite daycounts 10 (ie 1+0) and 12 (ie 1+2) will not work as expected, because they will be interpreted as type 10 and type 12. This is the only incompatibility.
    • All other old composite daycounts, eg 63, 31, 50 etc will work fine,

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