Produces an Amortised schedule based on the fixed-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.AmortiseDB( _
Double Notional, _
Double FinalNot, _
String ScheduleKey, _
Long nRepeatNot)

=CT.UTIL.AmortiseDB(
Excel Numeric Cell Notional,
Excel Numeric Cell FinalNot,
Excel String Cell ScheduleKey,
Excel Numeric Cell nRepeatNot)

static CTRangeDataCPP AmortiseDB(
double Notional,
double FinalNot,
std::string ScheduleKey,
long nRepeatNot);

CTRangeData CTUtilsSA.AmortiseDB(
System.Double Notional,
System.Double FinalNot,
System.String ScheduleKey,
System.Int32 nRepeatNot);

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.