Finance - Maple Help

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : Mathematics : Finance : Personal Finance : Finance/amortization

Finance

  

amortization

  

amortization table for a loan

 

Calling Sequence

Parameters

Description

Examples

Compatibility

Calling Sequence

amortization(amount, payments, rate, nperiods,output)

Parameters

amount

-

amount of the loan

payments

-

(number or procedure) size of the payments

rate

-

interest rate

nperiods

-

maximum number of payments (default = infinity). Stops when balance reaches 0

output

-

display the return values as list, matrix, embedded table, or value for cost of interest. The default is matrix.

Description

• 

The amortization command gives a sequence of two elements: an amortization table and the cost of the loan.

• 

The amortization table consists of lists comprising of 5 elements

1) The period number

2) The amount of the payment

3) The interest for the period

4) The amount by which the principal is reduced (increased if negative)

5) The new balance

• 

The cost of the loan is the sum of the third column.

• 

The payments option can be a procedure. It will be called with two arguments: the period number and the interest to be paid. This can be used, for example, to have increasing payments, or to pay down a fixed amount of principal at each period.

• 

The output option controls the display of the returned values. By default, a matrix of values is returned. This matrix can be returned as an embedded datatable component using the embed option. list returns the same matrix as a list, including also the value of the cost of interest. The cost of interest can be returned using the cost output option.

• 

Refer to Finance[annuity] for more details on mortgages. Refer to Finance[effectiverate] for selecting the appropriate value for the interest rate to be used.

• 

Since amortization used to be part of the (now deprecated) finance package, for compatibility with older worksheets, this command can also be called using finance[amortization]. However, it is recommended that you use the superseding package name, Finance instead: Finance[amortization].

Examples

with(Finance):

Amortization table for a loan of 1000 units at interest rate of 10% per period with payments of 500 units

amortization( 1000.00, 500.00, 0.10 );

nPaymentInterestPrincipalBalance0001000.001000.001500.00100.0000400.0000600.00002500.0060.000000440.000000160.0000003176.000000016.00000000160.00000000.

(1)

From this you can see that there will be 3 payments, the last one being of 176 units.

amortization( 1000.00, 500.00, 0.10, output = cost );

176.0000000

(2)

The cost of the loan is 176 units.

You can make payments to be of 500 units + the interest for that period:

amortization( 1000.00, (i,interest)->500.00+interest, 0.10, output = list );

0,0,0,1000.00,1000.00,1,600.0000,100.0000,500.0000,500.0000,2,550.000000,50.000000,500.000000,0.,150.000000

(3)

There are now 2 payments, one of 600 units and one of 550 units. The cost of the loan is 150 units. Now, if you make quarterly payments of 150 units on a loan of 1000 units at a stated rate of 12%, the payments are increased yearly by 10 units. The amortization table is computed as follows:

compute_payment:=(i,interest) -> 150.00+10.00*trunc((i-1)/4):

amortization( 1000.00, compute_payment, effectiverate(0.12,4)/4 );

nPaymentInterestPrincipalBalance0001000.001000.001150.0031.37720250118.6227975881.37720252150.0027.65515096122.3448490759.03235353150.0023.81631186126.1836881632.84866544150.0019.85702073130.1429793502.70568615160.0015.77349811144.2265019358.47918426160.0011.24807395148.7519260209.72725827160.006.580654650153.419345456.3079128858.07469761.76678478256.30791280.

(4)

There were 8 payments altogether with a loan cost of 138 units. For obtaining just the first year, you can make use of the nperiods argument:

amortization( 1000.00, compute_payment, effectiverate(0.12,4)/4, nperiods = 4);

nPaymentInterestPrincipalBalance0001000.001000.001150.0031.37720250118.6227975881.37720252150.0027.65515096122.3448490759.03235353150.0023.81631186126.1836881632.84866544150.0019.85702073130.1429793502.7056861

(5)

It is also possible to display the amortization table as an embedded datatable with the output = embed option:

amortization( 1000.00, compute_payment, effectiverate(0.12,4)/4, nperiods = 4, output = embed);

amortizationtable0

(6)

Compatibility

• 

The Finance[amortization] command was introduced in Maple 15.

• 

For more information on Maple 15 changes, see Updates in Maple 15.

• 

The Finance[amortization] command was updated in Maple 2015.

• 

The output parameter was introduced in Maple 2015.

• 

For more information on Maple 2015 changes, see Updates in Maple 2015.

See Also

Finance

Finance[annuity]

Finance[effectiverate]

 


Download Help Document

Was this information helpful?



Please add your Comment (Optional)
E-mail Address (Optional)
What is ? This question helps us to combat spam