AMORTISATION
ColinCSmith2010
8
14.3 Amortisingthepaymentsusingafinancialcalculatortocalculatetheamountofcapitalandinterestpaidand
thebalanceattheendofeachyear
Thisstepfollowsdirectlyonyourcalculationoftheinstalmentabove.
Weenterthefirstfinancialperiodandthe
numberofpaymentsmade
inthatperiod
Note:Youcansettheamortisationfunctionfor
anyperiodbuthereitisfora12‐monthperiod.
Thisisforperiods1‐12
cCapitalpaidinyear1
dInterestpaidinyear1
eBalanceattheendofyear1
HP10BIIfinancialcalculator
KEYS DISPLAY
1INPUT12 12_
AMORT 1‐12
=‐47,543.02
c
= ‐8,385.86
d
= 52,456.98
e
Forthenext12months(periods13–24)
fCapitalpaidinyear2
gInterestpaidinyear2
hBalanceattheendofyear2
HP10BIIfinancialcalculator
AMORT 13‐24
=‐52,457.00
f
= ‐3,471.88
f
=‐0.02
h
YOUCANCHECKTHESENUMBERSAGAINSTTHEAMORTISATIONSCHEDULEinsection14.2thatwascompletedusing
MicrosoftExcel.
15.1 Calculatingtheintalment/payment(PMT)forafinancialtransaction–OrdinaryAnnuitywithamortisation
AcompanytakesaloanofR100,000loanrepayable
inequalmonthinstalments,at
theendofthe
month,overaperiodoftwoyearsterm,aninterest
rateof12%peryearisquotedbythebank(thisis
thenominalorAnnualPercentageRateAPR.
Thisisyourmonthlyinstalment.
HP10BIIfinancialcalculator
KEYS DISPLAY
*MustnotdisplayBEGIN
CALL 0.00
1 P/YR 1.00
100,000PV
100,0000.00
0FV
0.00
12÷12I/YR 1.00
2x12N 24.00
PMT
‐4,707.35