Produces an Amortised schedule.

Returns a 6 column range consisting of the following columns : Interest, Principal, Balance, CumPrincipal, CumInterest and Total.

You specify an interest rate for 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.Amortise( _
Double Notional, _
Double FinalNot, _
String ScheduleKey, _
Double dRate, _
Long AmortFreq, _
Long AmortCompounding, _
Long nRepeatNot)

=CT.UTIL.Amortise(
Excel Numeric Cell Notional,
Excel Numeric Cell FinalNot,
Excel String Cell ScheduleKey,
Excel Numeric Cell dRate,
Excel Numeric Cell AmortFreq,
Excel Numeric Cell AmortCompounding,
Excel Numeric Cell nRepeatNot)

static CTRangeDataCPP Amortise(
double Notional,
double FinalNot,
std::string ScheduleKey,
double dRate,
long AmortFreq,
long AmortCompounding,
long nRepeatNot);

CTRangeData CTUtilsSA.Amortise(
System.Double Notional,
System.Double FinalNot,
System.String ScheduleKey,
System.Double dRate,
System.Int32 AmortFreq,
System.Int32 AmortCompounding,
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.