present value of an annuity
annuity(cash, rate, nperiods)
number of periods
The function annuity gives the present value at time=0 of an annuity of nperiods equal payments of the amount cash, starting at time=1.
Mortgages are examples of annuities.
Since annuity used to be part of the (now deprecated) finance package, for compatibility with older worksheets, this command can also be called using finance[annuity]. However, it is recommended that you use the superseding package name, Finance, instead: Finance[annuity].
Present value of an annuity paying 100 units per year for 15 years starting next year. The interest rate is 10% per year.
Monthly payments required for a mortgage of 10000 units, amortized over 25 years, not in advanced, with interest at 10% per year, compounded semiannually. There are 25*12 monthly payments.
Npayments ≔ 25⋅12
The semi-annual interest rate is 5% (10%/2). We need to find the monthly interest rate that when compounded give this 5% figure. This is calculated as follows. The range 0 .. 0.5, is to ensure we obtain the appropriate value.
mrate ≔ fsolve⁡effectiverate⁡r,6=0.05,r,0..0.56
Verification: the future value of 1 units after 6 months should be 1.05
The value of an annuity of 1 units paid monthly for 25 years at the interest rate we calculated is then
A ≔ annuity⁡1,mrate,Npayments
The required monthly payments are thus:
P ≔ 10000A
The total payments amount to:
Tot ≔ P⁢Npayments
From which the cost of the loan is readily obtained. The mortgage rules above are typical of mortgages obtained from banks in Canada. As with all legal matters, rules can change, so check first about their applicability.
The payments if the mortgage is paid in advanced (so the first payment is already deducted from the loan) are given by
The Finance[annuity] command was introduced in Maple 15.
For more information on Maple 15 changes, see Updates in Maple 15.
Download Help Document