A B C D E F G H I J K L M N  
2 Amortising Loan
3
4 Start Date  15 Dec 03
5 Annual Date Sequence   20    -1.10    -4.10    -7.10    -10.10  
6 Interest Rates Annual Rate   10.00%    12.00%    10.00% 
7 From  15 Dec 03  1 Jan 04  1 Apr 05
8  15 Dec 03  1 Apr 05  1 Apr 07  1 Apr 09  1 Apr 11  1 Apr 13
9 Drawdowns (Repayments)   1,000 (200) (200) (200) (200) (200)
10
11 IRR   11.04% 
12
13 Notes:
14 n  The date sequence is in the form mm.dd, -ve if in arrears.  The value of 20 is a Business Day Switch to skip weekends (optional)
15 n  Where an interest rate changes between dates, this version of Loan Amortisation does not time-average the rate.
16 n  The ranges can be extended simply by insert columns at about column I.
17 n  Business Functions Used: NextDateSeq, DayName, MkPmts, FLevels (All Basic Edition)
18
19 Beginning Principal Interest Total Closing Interest
20       Balance       Balance Rate
21
22
23  15 Dec 03 Monday   1,000   1,000   1,000   10.00% 
24  12 Jan 04 Monday   1,000 (8) (8)   1,000   12.00% 
25  12 Apr 04 Monday   1,000 (30) (30)   1,000   12.00% 
26  12 Jul 04 Monday   1,000 (30) (30)   1,000   12.00% 
27  11 Oct 04 Monday   1,000 (30) (30)   1,000   12.00% 
28  10 Jan 05 Monday   1,000 (200) (30) (230)   800   12.00% 
29  11 Apr 05 Monday   800 (24) (24)   800   10.00% 
30  11 Jul 05 Monday   800 (20) (20)   800   10.00% 
31  10 Oct 05 Monday   800 (20) (20)   800   10.00% 
32  10 Jan 06 Tuesday   800 (20) (20)   800   10.00% 
33  10 Apr 06 Monday   800 (20) (20)   800   10.00% 
34  10 Jul 06 Monday   800 (20) (20)   800   10.00% 
35  10 Oct 06 Tuesday   800 (20) (20)   800   10.00% 
36  10 Jan 07 Wednesday   800 (200) (20) (220)   600   10.00% 
37  10 Apr 07 Tuesday   600 (15) (15)   600   10.00% 
38  10 Jul 07 Tuesday   600 (15) (15)   600   10.00% 
39  10 Oct 07 Wednesday   600 (15) (15)   600   10.00% 
40  10 Jan 08 Thursday   600 (15) (15)   600   10.00% 
41  10 Apr 08 Thursday   600 (15) (15)   600   10.00% 
42  10 Jul 08 Thursday   600 (15) (15)   600   10.00% 
43  10 Oct 08 Friday   600 (15) (15)   600   10.00% 
44  12 Jan 09 Monday   600 (200) (15) (215)   400   10.00% 
45  10 Apr 09 Friday   400 (10) (10)   400   10.00% 
46  10 Jul 09 Friday   400 (10) (10)   400   10.00% 
47  12 Oct 09 Monday   400 (10) (10)   400   10.00% 
48  11 Jan 10 Monday   400 (10) (10)   400   10.00% 
49  12 Apr 10 Monday   400 (10) (10)   400   10.00% 
50  12 Jul 10 Monday   400 (10) (10)   400   10.00%