Bond Issue DayCount 6.04 Main Period:Actual/Actual (Within Period),Stub Periods:30/360 (European). Periods -2.22 -8.22 +21.00 in arrear, Feb 22 Aug 22 Plain Business Days 1: Weekends only excluded (if date on Saturday needs moving Interest Net Rate pa From Advances Date 5.00% 1 Jan 06 200,000 8 Jan 06 Repayment 8.00% 1 Jul 08 (20,000) 1 Jan 15 (20,000) 1 Jan 16 (20,000) 1 Jan 17 (20,000) 1 Jan 18 (20,000) 1 Jan 19 (20,000) 1 Jan 20 (20,000) 1 Jan 21 (20,000) 1 Jan 22 (20,000) 1 Jan 23 (20,000) 1 Jan 24 CashFlow Periodic Summary Cash/Acc 1 cash Cash/Acc 1 cash Periods Interest Principal Balance Interest Principal 1 0 5 1 0 8 Jan 06 200,000 200,000 1 Jan 06 (6,222) 200,000 22 Feb 06 (1,222) 200,000 1 Jan 07 (10,000) 22 Aug 06 (5,000) 200,000 1 Jan 08 (10,857) 22 Feb 07 (5,000) 200,000 1 Jan 09 (16,000) 22 Aug 07 (5,000) 200,000 1 Jan 10 (16,000) 22 Feb 08 (5,000) 200,000 1 Jan 11 (16,000) 22 Aug 08 (5,857) 200,000 1 Jan 12 (16,000) 23 Feb 09 (8,000) 200,000 1 Jan 13 (16,000) 24 Aug 09 (8,000) 200,000 1 Jan 14 (16,000) 22 Feb 10 (8,000) 200,000 1 Jan 15 (14,994) (20,000) 23 Aug 10 (8,000) 200,000 1 Jan 16 (13,310) (20,000) 22 Feb 11 (8,000) 200,000 1 Jan 17 (11,769) (20,000) 22 Aug 11 (8,000) 200,000 1 Jan 18 (10,169) (20,000) 22 Feb 12 (8,000) 200,000 1 Jan 19 (8,570) (20,000) 22 Aug 12 (8,000) 200,000 1 Jan 20 (6,992) (20,000) 22 Feb 13 (8,000) 200,000 1 Jan 21 (5,345) (20,000) 22 Aug 13 (8,000) 200,000 1 Jan 22 (3,762) (20,000) 24 Feb 14 (8,000) 200,000 1 Jan 23 (2,172) (20,000) 22 Aug 14 (8,000) (20,000) 180,000 1 Jan 24 (573) (20,000) 23 Feb 15 (7,794) 180,000 1 Jan 25 24 Aug 15 (7,200) (20,000) 160,000 1 Jan 26 22 Feb 16 (6,910) 160,000 1 Jan 27 22 Aug 16 (6,400) (20,000) 140,000 1 Jan 28 22 Feb 17 (6,169) 140,000 1 Jan 29 22 Aug 17 (5,600) (20,000) 120,000 1 Jan 30 22 Feb 18 (5,369) 120,000 1 Jan 31 22 Aug 18 (4,800) (20,000) 100,000 1 Jan 32 22 Feb 19 (4,570) 100,000 1 Jan 33 22 Aug 19 (4,000) (20,000) 80,000 1 Jan 34 24 Feb 20 (3,792) 80,000 1 Jan 35 24 Aug 20 (3,200) (20,000) 60,000 1 Jan 36 22 Feb 21 (2,945) 60,000 1 Jan 37 23 Aug 21 (2,400) (20,000) 40,000 1 Jan 38 22 Feb 22 (2,162) 40,000 1 Jan 39 22 Aug 22 (1,600) (20,000) 20,000 1 Jan 40 22 Feb 23 (1,372) 20,000 1 Jan 41 22 Aug 23 (1,373) (20,000) 1 Jan 42 1 per year in advance22 Feb 24 1 Jan 43 22 Aug 24 1 Jan 44 24 Feb 25 1 Jan 45 22 Aug 25 1 Jan 46 23 Feb 26 1 Jan 47 24 Aug 26 1 Jan 48 22 Feb 27 1 Jan 49 23 Aug 27 1 Jan 50 22 Feb 28 1 Jan 51 22 Aug 28 1 Jan 52 22 Feb 29 1 Jan 53 22 Aug 29 1 Jan 54 22 Feb 30 1 Jan 55 22 Aug 30 1 Jan 56 24 Feb 31 1 Jan 57 22 Aug 31 1 Jan 58 23 Feb 32 1 Jan 59 23 Aug 32 1 Jan 60 22 Feb 33 1 Jan 61 22 Aug 33 1 Jan 62 22 Feb 34 1 Jan 63 22 Aug 34 1 Jan 64 22 Feb 35 1 Jan 65 22 Aug 35 1 Jan 66 22 Feb 36 1 Jan 67 22 Aug 36 1 Jan 68 23 Feb 37 1 Jan 69 24 Aug 37 1 Jan 70 22 Feb 38 1 Jan 71 23 Aug 38 1 Jan 72 22 Feb 39 1 Jan 73 22 Aug 39 1 Jan 74 22 Feb 40 1 Jan 75 22 Aug 40 1 Jan 76 22 Feb 41 1 Jan 77 22 Aug 41 1 Jan 78 24 Feb 42 1 Jan 79 22 Aug 42 1 Jan 80 23 Feb 43 1 Jan 81 24 Aug 43 1 Jan 82 22 Feb 44 1 Jan 83 22 Aug 44 1 Jan 84date on Saturday needs moving it goes to Monday UK-style) 1 Jan 24 <-try 0,1 <-try 1,2,4,12 Balance 5 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 1 per year in advance