Produces an Amortised schedule based on the general-declining balance calculation [ Depreciation for PeriodN = (({Notional}-{FinalNot}) - Total depreciation from prior periods) * ({Factor} divided by {NumOfPeriods}) ]. If you use a factor of 2, the calculation will be based on a double-declining balance calculation.

Returns a three column range object, Balance, Depreciation and Cumulative Depreciation.

You can indicate an ending notional and whether you would like to repeat notional amounts (ie - useful for the cases where you are comparing notional amounts for two legs that have been built on two different frequencies, Semi-Annual and Quarterly.

You probably want the Quarterly notional amounts to be repeated twice in order to match the notional amounts of the leg build using the semi-annual frequency).

This function requires the input of a Schedule object key, which must have been produced via a call to one of the following functions : MakeSchedule() or MakeSchedule2(). These functions would have returned a string 'KEY' which is to be passed to the 'ScheduleKey' parameter of this function.

Variant CTUtils.AmortiseGeneralDB2( _
Double Notional, _
Double FinalNot, _
Long NumPeriods, _
Double dFactor, _
Long nRepeatNot, _
Boolean ShortFirstPeriod)

=CT.UTIL.AmortiseGeneralDB2(
Excel Numeric Cell Notional,
Excel Numeric Cell FinalNot,
Excel Numeric Cell NumPeriods,
Excel Numeric Cell dFactor,
Excel Numeric Cell nRepeatNot,
Excel Boolean Value Cell ShortFirstPeriod)

static CTRangeDataCPP AmortiseGeneralDB2(
double Notional,
double FinalNot,
long NumPeriods,
double dFactor,
long nRepeatNot,
bool ShortFirstPeriod);

CTRangeData CTUtilsSA.AmortiseGeneralDB2(
System.Double Notional,
System.Double FinalNot,
System.Int32 NumPeriods,
System.Double dFactor,
System.Int32 nRepeatNot,
System.Boolean ShortFirstPeriod);

The C# example below contains all the sub-function calls leading up to this function call. As a result, the example can contain a lot of code.

The VB.NET, J#, C++.NET, Java, Excel VBA, Visual Basic 6 (via COM) and C++ examples below contain function code stubs for the calls leading up to this function call. However, the function call for this function is displayed.
You can easily reproduce the stub functions code from the C# example.