
 Rate Projections Functions Walkthrough
 Accruals and Cash
 Repeating Formulae
 Range Names and References
 Optional Parameters
 Using PmtsPerYear
 Modelling Seasonality
 Calculating Interest
 Using Business Functions in VBA (Visual Basic for Applications)
 Array Functions
 Volatility
 Annual Equivalent Rates
 Array Function
 Auto Multi Functions
 Variable Plurality
 GoalSeek
 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 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.
 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,
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 old format will continue to work fine, but note the following: 