A	B	C	D	E	F	G	H	I	J	K	L	M	N
2
3		Amortising Loan
4		Simple Loan Example
5
6
7
8		Base	3 months		Date	Drawdowns
9						/Repmnts
10		Simple Interest	8.00%		1 Jan 02	100
11					1 Jan 03	(10)
12		IRR	8.2432%		1 Jul 03	(10)
13					1 Jan 04	(10)
14		Check:			1 Jul 04	(70)
15		Simple Interest	8.0000%
16
17			Draws/	Interest	Cash
18			Repayments		Flow
19
20		Jan 02	100		100
21		Apr 02		(2)	(2)
22		Jul 02		(2)	(2)
23		Oct 02		(2)	(2)
24		Jan 03	(10)	(2)	(12)
25		Apr 03		(2)	(2)
26		Jul 03	(10)	(2)	(12)
27		Oct 03		(2)	(2)
28		Jan 04	(10)	(2)	(12)
29		Apr 04		(1)	(1)
30		Jul 04	(70)	(1)	(71)
31		Oct 04
32		Jan 05
33		Apr 05
34		Jul 05
35		Oct 05
36		Jan 06
37		Apr 06
38		Jul 06
39		Oct 06
40		Jan 07
41		Apr 07
42		Jul 07
43		Oct 07
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80