AMORTISATION
ColinCSmith20109
15.2.THEAMORTISATIONSCHEDULE–ORDINARYANNUITY
Asforthescheduleat14.2thiswaspreparedusingMicrosoftExcel.
Month Instalment InterestCapitalpaidoff CapitalBalance
today 100,000.00
1R4,707.351,000.003,707.3596,292.65
2R4,707.35962.933,744.4292,548.23
3R4,707.35925.483,781.8688,766.37
4R4,707.35887.663,819.6884,946.68
5R4,707.35849.473,857.8881,088.80
6R4,707.35810.893,896.4677,192.34
7R4,707.35771.923,935.4273,256.92
8R4,707.35732.573,974.7869,282.14
9R4,707.35692.824,014.5365,267.62
10R4,707.35652.684,054.6761,212.95
11R4,707.35612.134,095.2257,117.73
12R4,707.35571.184,136.1752,981.56
13R4,707.35529.824,177.5348,804.03
14R4,707.35488.044,219.3144,584.72
15R4,707.35445.854,261.5040,323.22
16R4,707.35403.234,304.1236,019.10
17R4,707.35360.194,347.1631,671.95
18R4,707.35316.724,390.6327,281.32
19R4,707.35272.814,434.5322,846.79
20R4,707.35228.474,478.8818,367.91
21R4,707.35183.684,523.6713,844.24
22R4,707.35138.444,568.909,275.33
23R4,707.3592.754,614.594,660.74
24R4,707.3546.614,660.740.00
15.3 Amortisingthepaymentstocalculatetheamountofcapitalandinterestpaidandthebalanceattheendof
eachyear
Thisstepfollowsdirectlyonyourcalculationoftheinstalmentabove.
Weenterthefirstfinancialperiodandthe
numberofpaymentsmadeinthatperiod.The
amortisationfunctioncanbeforanyperiodbut
hereitisfora12‐monthperiod.
Thisisforperiods1‐12
cCapitalpaidinyear1
dInterestpaidinyear1
eBalanceattheendofyear1
HP10BIIfinancialcalculator
KEYSDISPLAY
1INPUT1212_
AMORT1‐12
=‐47,018.47c
= ‐9,469.73d
=52,981.53e
Forthenext12months(periods13–24)
fCapitalpaidinyear2
gInterestpaidinyear2
hBalanceattheendofyear2
HP10BIIfinancialcalculator
KEYSDISPLAY
AMORT13‐24
=‐52,981.59f
= ‐3,506.61f
=‐0.06h
YOUCANCHECKTHESENUMBERSAGAINSTTHEAMORTISATIONSCHEDULEABOVE.
Year1interest
R9,469.73
Year1capital
R47,018.47
Year2interest
R3,506.61
Year1capital
R52,981.59