Produces an Amortised schedule based on the general-declining balance calculation (same as the AmortiseDDB() function), but in this case we solve for the value of the 'factor' parameter to force the cashflow after the last period to have a balance value equal to 'FinalNot'. 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).

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

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

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

CTRangeData CTUtilsSA.AmortiseDDBExact2(
System.Double Notional,
System.Double FinalNot,
System.Int32 NumPeriods,
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.