Maple Professional
Maple Academic
Maple Student Edition
Maple Personal Edition
Maple Player
Maple Player for iPad
MapleSim Professional
MapleSim Academic
Maple T.A. - Testing & Assessment
Maple T.A. MAA Placement Test Suite
Möbius - Online Courseware
Machine Design / Industrial Automation
Aerospace
Vehicle Engineering
Robotics
Power Industries
System Simulation and Analysis
Model development for HIL
Plant Modeling for Control Design
Robotics/Motion Control/Mechatronics
Other Application Areas
Mathematics Education
Engineering Education
High Schools & Two-Year Colleges
Testing & Assessment
Students
Financial Modeling
Operations Research
High Performance Computing
Physics
Live Webinars
Recorded Webinars
Upcoming Events
MaplePrimes
Maplesoft Blog
Maplesoft Membership
Maple Ambassador Program
MapleCloud
Technical Whitepapers
E-Mail Newsletters
Maple Books
Math Matters
Application Center
MapleSim Model Gallery
User Case Studies
Exploring Engineering Fundamentals
Teaching Concepts with Maple
Maplesoft Welcome Center
Teacher Resource Center
Student Help Center
Finance[amortization] - amortization table for a loan
Calling Sequence
amortization(amount, payments, rate, nperiods)
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
Description
The result is 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 payment 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
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.
The command with(Finance,amortization) allows the use of the abbreviated form of this command.
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].
Compatibility
The Finance[amortization] command was introduced in Maple 15.
For more information on Maple 15 changes, see Updates in Maple 15.
Examples
Amortization table for a loan of 1000 U at interest rate of 10% per period with payments of 500 U
From this we see that there will be 3 payments, the last one being of 176 U. The cost of the loan is 176 U.
Now we make payments to be of 500 U + the interest for that period:
There are now 2 payments, one of 600 U and one of 550 U. The cost of the loan is 150 U. Now we make quarterly payments of 150 U on a loan of 1000 U at a stated rate of 12%. The payments are increased yearly by 10 U. The amortization table is computed as follows:
There were 8 payments altogether with a loan cost of 138 U. Obtaining just the first year, we make use of the fourth argument:
which indicates the cost of the loan at that point.
See Also
Finance[annuity], Finance[effectiverate]
Download Help Document
