0 1 2 3

Yr 0 Yr 1 Yr 2 Yr 3
Cash Out 100
Cash In 10 10 10
Net Cash -100 10 10 10

Discount 8%
Disc. Factor 1.00 0.926 0.857 0.794
Discounted Annual CF -100.00 9.26 8.57 7.94
Sum 6.62
IRR 10.00%
NPV 6.13

Discount 10%
Disc. Factor 1.00 0.91 0.83 0.75
Annual CF -100.00 9.09 8.26 7.51
SUM 0.00
IRR
NPV -0.00
 4
Yr 4

110
110

0.735
80.85

0.68
75.13
 Yr 0 Yr 1 Yr 2 Yr 3 Yr 4
Cash Out 100
Cash In 50 90
Net Cash -100 50 90
IRR 23.1%

Yr 0 Yr 1 Yr 2 Yr 3 Yr 4
Cash Out 100
Cash In 40 40 50 50
Net Cash -100 40 40 50 50
27%
 Yr0 Yr1 Yr2 Yr3 Yr4 Yr5 Yr6 Yr7 Yr8

Investment 27
Revenue 0 9.5 19 19 19 19 19 19

Interest 6.3 6.3 6.3 6.3 6.3 6.3 6.3 6.3

Profit before tax -6.3 3.2 12.7 12.7 12.7 12.7 12.7 12.7
33.50% tTax 1.072 4.255 4.255 4.255 4.255 4.255 4.255
Repay Princi
NetCF -27 -6.3 2.128 8.446 8.446 8.446 8.446 8.446 8.446
23.932
IRR 8.4%

Loan 63
Interest Rate 10%
6.3 6.3
Yr9 Yr10 Yr11 Yr12 Yr13 Yr14

19 19 19 19 19 19

6.3 6.3
12.7 12.7 19 19 19 19
4.255 4.255 6.365 6.365 6.365 6.365
63
8.446 -54.55 12.64 12.64 12.64 12.64
 YEAR 1 YEAR 2 YEAR 3 YEAR 4

CASH INFLOW 0 8.85 17.7 17.7

CASH OUTFLOW 27
INTEREST 6.3 6.3 6.3 6.3
PBT -33.3 2.55 11.4 11.4
33.50% TAX -11.1555 0.85425 3.819 3.819
REPAYMENT OF PRINCIPLE
NET CASH FLOW -22.1445 1.69575 7.581 7.581
SUM 7.52325
IRR 14.0%
NPV ($0.0)
YEAR 5 YEAR 6 YEAR 7 YEAR 8 YEAR 9 YEAR 10 YEAR 11 YEAR 12

17.7 17.7 17.7 17.7 17.7 17.7 17.7 17.7

6.3 6.3 6.3 6.3 6.3 6.3 6.3 6.3

11.4 11.4 11.4 11.4 11.4 11.4 11.4 11.4
3.819 3.819 3.819 3.819 3.819 3.819 3.819 3.819
63
7.581 7.581 7.581 7.581 7.581 7.581 -55.419 7.581
YEAR 13 YEAR 14

17.7 17.7

6.3 6.3
11.4 11.4
3.819 3.819

7.581 7.581
 YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5

CASH INFLOW 63 3.5 7 7 7

CASH OUTFLOW 27
INTEREST 10.97 10.97 10.97 10.97 10.97
PBT 25.03 -7.47 -3.97 -3.97 -3.97
33.50% TAX 8.38505 -2.50245 -1.32995 -1.32995 -1.32995

NET CASH FLOW 16.64495 -4.96755 -2.64005 -2.64005 -2.64005

SUM -18.67985
IRR 14.9%
NPV ($0.5)
YEAR 6 YEAR 7 YEAR 8 YEAR 9 YEAR 10 YEAR 11 YEAR 12 YEAR 13

7 7 7 7 7 7 7 7

10.97 10.97 10.97 10.97 10.97 10.97 10.97 10.97

-3.97 -3.97 -3.97 -3.97 -3.97 -3.97 -3.97 -3.97
-1.32995 -1.32995 -1.32995 -1.32995 -1.32995 -1.32995 -1.32995 -1.32995

-2.64005 -2.64005 -2.64005 -2.64005 -2.64005 -2.64005 -2.64005 -2.64005

YEAR 14

3.5

5.48
-1.98
-0.6633

-1.3167
loan value 63
interest rate 5%
term period 15

semi annual payments - 6.07

1H1 1H2 2H1

LOAN OB 63 66.15 69.46
INTEREST PAYABLE 3.15 3.31 3.47
INTEREST PAID 0 0 0
PRICIPLE REPAID 0.00 0.00 0.00
LOAN CB 66.15 69.46 72.93

SEMI ANNAUAL PAYEMENTS 6.07 6.07 6.07

INTEREST PAID 0 0 0
PRICIPLE REPAYMENT 0.00 0.00 0.00

1H1 1H2 2H1

CASH INFLOW 63 0 0
CASH OUTFLOW 27
EBIT 36 0 0
INTEREST 0 0 0
TAX
REPAYMENT OF PRINCIPLE
PAT
2H2 3H1 3H2 4H1 4H2 5H1 5H2 6H1
72.93 66.86 60.79 54.72 48.65 42.58 36.51 30.44
3.65 3.34 3.04 2.74 2.43 2.13 1.83 1.52
3.65 3.34 3.04 2.74 2.43 2.13 1.83 1.52
2.42 2.73 3.03 3.33 3.64 3.94 4.24 4.55
66.86 60.79 54.72 48.65 42.58 36.51 30.44 24.37

6.07 6.07 6.07 6.07 6.07 6.07 6.07 6.07

3.65 3.34 3.04 2.74 2.43 2.13 1.83 1.52
2.42 2.73 3.03 3.33 3.64 3.94 4.24 4.55

2H2 3H1 3H2 4H1 4H2 5H1 5H2 6H1

10 10 10 10 10 10 10 10

10 10 10 10 10 10 10 10
3.646519 3.343041 3.039562 2.736084 2.432606 2.129128 1.82565 1.522171
6H2 7H1 7H2 8H1 8H2 9H1 9H2
24.37 18.30 12.23 6.17 0.10
1.22 0.92 0.61 0.31 0.00
1.22 0.92 0.61 0.31
4.85 5.15 5.46 5.76
18.30 12.23 6.17 0.10

6.07 6.07 6.07 6.07 6.07

1.22 0.92 0.61 0.31 0.00
4.85 5.15 5.46 5.76 6.06

6H2 7H1 7H2 8H1 8H2 9H1 9H2 10H1

10 10 10 10 10 10 10 10

10 10 10 10 10 10 10 10
1.218693 0.915215 0.611737 0.308258 0.00478 0 0 0
10H2 11H1 11H2 12H1 12H2 13H1 13H2 14H1
10 10 10 10 10 10 10 10

10 10 10 10 10 10 10 10
0 0 0 0 0 0 0 0
loan value 63
interest rate 5%
term period 18

semi annual payments - 5.39

1H1 1H2 2H1 2H2

LOAN OB 63 66.15 69.46 72.93
INTEREST PAYABLE 3.15 3.31 3.47 3.65
INTEREST PAID 0 0 0 3.65
PRICIPLE REPAID 2.24 2.08 1.92 1.74
LOAN CB 66.15 69.46 72.93 67.54

SEMI ANNAUAL PAYEMENTS 5.39 5.39 5.39 5.39

INTEREST PAID 0 0 0 3.65
PRICIPLE REPAYMENT 2.24 2.08 1.92 1.74
3H1 3H2 4H1 4H2 5H1 5H2 6H1 6H2
67.54 62.15 56.76 51.37 45.98 40.59 35.20 29.82
3.38 3.11 2.84 2.57 2.30 2.03 1.76 1.49
3.38 3.11 2.84 2.57 2.30 2.03 1.76 1.49
2.01 2.28 2.55 2.82 3.09 3.36 3.63 3.90
62.15 56.76 51.37 45.98 40.59 35.20 29.82 24.43

5.39 5.39 5.39 5.39 5.39 5.39 5.39 5.39

3.38 3.11 2.84 2.57 2.30 2.03 1.76 1.49
2.01 2.28 2.55 2.82 3.09 3.36 3.63 3.90
7H1 7H2 8H1 8H2 9H1 9H2 10H1 10H2
24.43 19.04 13.65 8.26 2.87 - 2.52 - 7.91 - 13.30
1.22 0.95 0.68 0.41 0.14 - 0.13 - 0.40 - 0.67
1.22 0.95 0.68 0.41 0.14 - 0.13 - 0.40 - 0.67
4.17 4.44 4.71 4.98 5.25 5.52 5.78 6.05
19.04 13.65 8.26 2.87 - 2.52 - 7.91 - 13.30 - 18.69

5.39 5.39 5.39 5.39 5.39 5.39 5.39 5.39

1.22 0.95 0.68 0.41 0.14 - 0.13 - 0.40 - 0.67
4.17 4.44 4.71 4.98 5.25 5.52 5.78 6.05
 LOAN VALU 63 72.93
INTERST 5%
TIME PERIOD 18

PMT FOR 6 MONTHS ($6.24)

1H1 1H2 2H1 2H2

LOAN OB 63 66.15 69.4575 72.93038
INTEREST PAYABLE 3.15 3.3075 3.472875 3.646519
INTERST PAID 0 0 0 3.646519
PRINCIPAL REPAID 0 0 0 $2.59
LOAN CB 66.15 69.4575 72.93038 $70.34

1H1 1H2 2H1 2H2

SEMI ANNUAL LOAN PAYMENTS $0.00 0 0 $6.24
INTEREST 0 0 0 3.646519
PRINCIPAL 0 0 0 $2.59

1H1 1H2 2H1 2H2

CASH INFLOW 0 0 0 12.05
Equity Infusion -9 -9 -9
EBIT 9 9 9 12.05
INTEREST 3.15 3.31 3.47 3.65
EBT 5.69 5.53 8.40
33% TAX 1.88 1.82 2.77
REPAYMENT OF PRINCIPAL 0 0.00 0.00 2.59
NET CASH -12.15 3.81 3.70 3.04
IRR 26.6% 60.24%
NPV $8.82
 $72.93

3H1 3H2 4H1 4H2 5H1 5H2 6H1 6H2

70.33801 67.61602 64.75794 61.75695 58.60591 55.29732 51.8233 48.17558
3.5169 3.380801 3.237897 3.087847 2.930295 2.764866 2.591165 2.408779
3.5169 3.380801 3.237897 3.087847 2.930295 2.764866 2.591165 2.408779
$2.72 $2.86 $3.00 $3.15 $3.31 $3.47 $3.65 $3.83
$67.62 $64.76 $61.76 $58.61 $55.30 $51.82 $48.18 $44.35

3H1 3H2 4H1 4H2 5H1 5H2 6H1 6H2

$6.24 $6.24 $6.24 $6.24 $6.24 $6.24 $6.24 $6.24
3.5169 3.380801 3.237897 3.087847 2.930295 2.764866 2.591165 2.408779
$2.72 $2.86 $3.00 $3.15 $3.31 $3.47 $3.65 $3.83

3H1 3H2 4H1 4H2 5H1 5H2 6H1 6H2

12.05 12.05 12.05 12.05 12.05 12.05 12.05 12.05

12.05 12.05 12.05 12.05 12.05 12.05 12.05 12.05

3.52 3.38 3.24 3.09 2.93 2.76 2.59 2.41
8.53 8.67 8.81 8.96 9.12 9.29 9.46 9.64
2.82 2.86 2.91 2.96 3.01 3.06 3.12 3.18
2.72 2.86 3.00 3.15 3.31 3.47 3.65 3.83
3.00 2.95 2.90 2.85 2.80 2.75 2.69 2.63
7H1 7H2 8H1 8H2 9H1 9H2 10H1 10H2
44.34547 40.32386 36.10117 31.66734 27.01182 22.12352 16.99081 11.60147
2.217274 2.016193 1.805058 1.583367 1.350591 1.106176 0.849541 0.580073
2.217274 2.016193 1.805058 1.583367 1.350591 1.106176 0.849541 0.580073
$4.02 $4.22 $4.43 $4.66 $4.89 $5.13 $5.39 $5.66
$40.32 $36.10 $31.67 $27.01 $22.12 $16.99 $11.60 $5.94

7H1 7H2 8H1 8H2 9H1

10H1 10H2 9H2
$6.24 $6.24 $6.24 $6.24 $6.24 $6.24 $6.24 $6.24
2.217274 2.016193 1.805058 1.583367 1.350591 1.106176 0.849541 0.580073
$4.02 $4.22 $4.43 $4.66 $4.89 $5.13 $5.39 $5.66

7H1 7H2 8H1 8H2 9H1 9H2 10H1 10H2

12.05 12.05 12.05 12.05 12.05 12.05 12.05 12.05

12.05 12.05 12.05 12.05 12.05 12.05 12.05 12.05

2.22 2.02 1.81 1.58 1.35 1.11 0.85 0.58
9.83 10.03 10.24 10.47 10.70 10.94 11.20 11.47
3.24 3.31 3.38 3.45 3.53 3.61 3.70 3.79
4.02 4.22 4.43 4.66 4.89 5.13 5.39 5.66
2.57 2.50 2.43 2.36 2.28 2.20 2.11 2.03
11H1
5.942656
0.297133
0.297133
$5.94
$0.00

11H1
$6.24
0.297133
$5.94

11H1 11H2 12H1 12H2 13H1 13H2 14H1

12.05 12.05 12.05 12.05 12.05 12.05 12.05

12.05 12.05 12.05 12.05 12.05 12.05 12.05

0.30 0.00 0.00 0.00 0.00 0.00 0.00
11.75 12.05 12.05 12.05 12.05 12.05 12.05
3.88 3.98 3.98 3.98 3.98 3.98 3.98
5.94 0.00 0.00 0.00 0.00 0.00 0.00
1.93 8.07 8.07 8.07 8.07 8.07 8.07
 LOAN VALU 63 68.04788
INTERST 5.0%
TIME PERIOD 18

PMT FOR 6 MONTHS ($5.82)

1H1 1H2 2H1 2H2

LOAN OB 0 3.15 34.8075 68.04788
New Loan Tranche 3 30 30
INTEREST PAYABLE 0.15 1.6575 3.240375 3.402394
INTERST PAID 0 0 0 3.402394
PRINCIPAL REPAID 0 0 0 $2.42
LOAN CB 3.15 34.8075 68.04788 $65.63

1H1 1H2 2H1 2H2

SEMI ANNUAL LOAN PAYMENTS $0.00 0 0 $5.82
INTEREST 0 0 0 3.402394
PRINCIPAL 0 0 0 $2.42

1H1 1H2 2H1 2H2

CASH INFLOW 0 0 0 10.5
Equity Infusion -27 0 0
EBIT 27 0 0 10.5
INTEREST 0 0 0 3.40
EBT 0.00 0.00 7.10
33% TAX 0.00 0.00 2.34
REPAYMENT OF PRINCIPAL 0 0.00 0.00 2.42
NET CASH -27 0.00 0.00 2.34
IRR 6.8% 13.97%
 $68.05

3H1 3H2 4H1 4H2 5H1 5H2 6H1 6H2

65.62903 63.08924 60.42247 57.62235 54.68223 51.5951 48.35362 44.95006

3.281452 3.154462 3.021123 2.881118 2.734112 2.579755 2.417681 2.247503

3.281452 3.154462 3.021123 2.881118 2.734112 2.579755 2.417681 2.247503
$2.54 $2.67 $2.80 $2.94 $3.09 $3.24 $3.40 $3.57
$63.09 $60.42 $57.62 $54.68 $51.60 $48.35 $44.95 $41.38

3H1 3H2 4H1 4H2 5H1 5H2 6H1 6H2

$5.82 $5.82 $5.82 $5.82 $5.82 $5.82 $5.82 $5.82
3.281452 3.154462 3.021123 2.881118 2.734112 2.579755 2.417681 2.247503
$2.54 $2.67 $2.80 $2.94 $3.09 $3.24 $3.40 $3.57

3H1 3H2 4H1 4H2 5H1 5H2 6H1 6H2

10.5 10.5 10.5 10.5 10.5 10.5 10.5 10.5

10.5 10.5 10.5 10.5 10.5 10.5 10.5 10.5

3.28 3.15 3.02 2.88 2.73 2.58 2.42 2.25
7.22 7.35 7.48 7.62 7.77 7.92 8.08 8.25
2.38 2.42 2.47 2.51 2.56 2.61 2.67 2.72
2.54 2.67 2.80 2.94 3.09 3.24 3.40 3.57
2.30 2.25 2.21 2.16 2.12 2.07 2.01 1.96
7H1 7H2 8H1 8H2 9H1 9H2 10H1 10H2
41.37633 37.6239 33.68386 29.54681 25.20292 20.64182 15.85268 10.82407

2.068816 1.881195 1.684193 1.477341 1.260146 1.032091 0.792634 0.541204

2.068816 1.881195 1.684193 1.477341 1.260146 1.032091 0.792634 0.541204
$3.75 $3.94 $4.14 $4.34 $4.56 $4.79 $5.03 $5.28
$37.62 $33.68 $29.55 $25.20 $20.64 $15.85 $10.82 $5.54

7H1 7H2 8H1 8H2 9H1

10H1 9H2
10H2
$5.82 $5.82 $5.82 $5.82 $5.82 $5.82 $5.82 $5.82
2.068816 1.881195 1.684193 1.477341 1.260146 1.032091 0.792634 0.541204
$3.75 $3.94 $4.14 $4.34 $4.56 $4.79 $5.03 $5.28

7H1 7H2 8H1 8H2 9H1 9H2 10H1 10H2

10.5 10.5 10.5 10.5 10.5 10.5 10.5 10.5

10.5 10.5 10.5 10.5 10.5 10.5 10.5 10.5

2.07 1.88 1.68 1.48 1.26 1.03 0.79 0.54
8.43 8.62 8.82 9.02 9.24 9.47 9.71 9.96
2.78 2.84 2.91 2.98 3.05 3.12 3.20 3.29
3.75 3.94 4.14 4.34 4.56 4.79 5.03 5.28
1.90 1.83 1.77 1.70 1.63 1.55 1.48 1.39
11H1
5.544037

0.277202
0.277202
$5.54
$0.00

11H1
$5.82
0.277202
$5.54

11H1 11H2 12H1 12H2 13H1 13H2 14H1

10.5 10.5 10.5 10.5 10.5 10.5 10.5

10.5 10.5 10.5 10.5 10.5 10.5 10.5

0.28 0.00 0.00 0.00 0.00 0.00 0.00
10.22 10.50 10.50 10.50 10.50 10.50 10.50
3.37 3.47 3.47 3.47 3.47 3.47 3.47
5.54 0.00 0.00 0.00 0.00 0.00 0.00
1.31 7.04 7.04 7.04 7.04 7.04 7.04
 LOAN VALU 63 68.04788
INTERST 5.0%
TIME PERIOD 18

PMT FOR 6 MONTHS ($5.82)

1H1 1H2 2H1 2H2

LOAN OB 0 3.15 34.8075 68.04788
New Loan Tranche 3 30 30
INTEREST PAYABLE 0.15 1.6575 3.240375 3.402394
INTERST PAID 0 0 0 3.402394
PRINCIPAL REPAID 0 0 0 $2.42
LOAN CB 3.15 34.8075 68.04788 $65.63

1H1 1H2 2H1 2H2

SEMI ANNUAL LOAN PAYMENTS $0.00 0 0 $5.82
INTEREST 0 0 0 3.402394
PRINCIPAL 0 0 0 $2.42

1H1 1H2 2H1 2H2

CASH INFLOW 0 0 0 8.3
Equity Infusion -27 0 0
EBIT 27 0 0 8.3

INTEREST 0 0 0 3.40
DEPRECIATION 4.50

EBT 0.00 0.00 0.40

33% TAX 0.00 0.00 0.13

REPAYMENT OF PRINCIPAL 0 0.00 0.00 2.42

Add Depreciation 4.50
NET CASH -27 0.00 0.00 2.35
IRR 6.8% 14.04%

ASSET VALUE 90
Life of Asset 10
Depreciation Amount 9.0
 $68.05

3H1 3H2 4H1 4H2 5H1 5H2 6H1 6H2

65.62903 63.08924 60.42247 57.62235 54.68223 51.5951 48.35362 44.95006

3.281452 3.154462 3.021123 2.881118 2.734112 2.579755 2.417681 2.247503

3.281452 3.154462 3.021123 2.881118 2.734112 2.579755 2.417681 2.247503
$2.54 $2.67 $2.80 $2.94 $3.09 $3.24 $3.40 $3.57
$63.09 $60.42 $57.62 $54.68 $51.60 $48.35 $44.95 $41.38

3H1 3H2 4H1 4H2 5H1 5H2 6H1 6H2

$5.82 $5.82 $5.82 $5.82 $5.82 $5.82 $5.82 $5.82
3.281452 3.154462 3.021123 2.881118 2.734112 2.579755 2.417681 2.247503
$2.54 $2.67 $2.80 $2.94 $3.09 $3.24 $3.40 $3.57

3H1 3H2 4H1 4H2 5H1 5H2 6H1 6H2

8.3 8.3 8.3 8.3 8.3 8.3 8.3 8.3

8.3 8.3 8.3 8.3 8.3 8.3 8.3 8.3

3.28 3.15 3.02 2.88 2.73 2.58 2.42 2.25

4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50

0.52 0.65 0.78 0.92 1.07 1.22 1.38 1.55

0.17 0.21 0.26 0.30 0.35 0.40 0.46 0.51

2.54 2.67 2.80 2.94 3.09 3.24 3.40 3.57

4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50
2.31 2.27 2.22 2.18 2.13 2.08 2.02 1.97
7H1 7H2 8H1 8H2 9H1 9H2 10H1 10H2
41.37633 37.6239 33.68386 29.54681 25.20292 20.64182 15.85268 10.82407

2.068816 1.881195 1.684193 1.477341 1.260146 1.032091 0.792634 0.541204

2.068816 1.881195 1.684193 1.477341 1.260146 1.032091 0.792634 0.541204
$3.75 $3.94 $4.14 $4.34 $4.56 $4.79 $5.03 $5.28
$37.62 $33.68 $29.55 $25.20 $20.64 $15.85 $10.82 $5.54

7H1 7H2 8H1 8H2 9H1

10H1 9H2
10H2
$5.82 $5.82 $5.82 $5.82 $5.82 $5.82 $5.82 $5.82
2.068816 1.881195 1.684193 1.477341 1.260146 1.032091 0.792634 0.541204
$3.75 $3.94 $4.14 $4.34 $4.56 $4.79 $5.03 $5.28

7H1 7H2 8H1 8H2 9H1 9H2 10H1 10H2

8.3 8.3 8.3 8.3 8.3 8.3 8.3 8.3

8.3 8.3 8.3 8.3 8.3 8.3 8.3 8.3

2.07 1.88 1.68 1.48 1.26 1.03 0.79 0.54

4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50

1.73 1.92 2.12 2.32 2.54 2.77 3.01 3.26

0.57 0.63 0.70 0.77 0.84 0.91 0.99 1.08

3.75 3.94 4.14 4.34 4.56 4.79 5.03 5.28

4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50
1.91 1.85 1.78 1.71 1.64 1.57 1.49 1.40
11H1
5.544037

0.277202
0.277202
$5.54
$0.00

11H1
$5.82
0.277202
$5.54

11H1 11H2 12H1 12H2 13H1 13H2 14H1

8.3 8.3 8.3 8.3 8.3 8.3 8.3

8.3 8.3 8.3 8.3 8.3 8.3 8.3

0.28 0.00 0.00 0.00 0.00 0.00 0.00

4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50

3.52 3.80 3.80 3.80 3.80 3.80 3.80

1.16 1.25 1.25 1.25 1.25 1.25 1.25

5.54 0.00 0.00 0.00 0.00 0.00 0.00

4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50
1.32 7.05 7.05 7.05 7.05 7.05 7.05
4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50

4.50 4.50 4.50 4.50 4.50 4.50

4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50
4.50
 LOAN VALU 80 87.7275
INTERST 5.0%
TIME PERIOD 18

PMT FOR 6 MONTHS ($7.50)

1H1 1H2 2H1 2H2

LOAN OB 0 21 53.55 87.7275
New Loan Tranche 20 30 30
INTEREST PAYABLE 1 2.55 4.1775 4.386375
INTERST PAID 0 0 0 4.386375
PRINCIPAL REPAID 0 0 0 $3.12
LOAN CB 21 53.55 87.7275 $84.61

1H1 1H2 2H1 2H2

SEMI ANNUAL LOAN PAYMENTS $0.00 0 0 $7.50
INTEREST 0 0 0 4.386375
PRINCIPAL 0 0 0 $3.12

1H1 1H2 2H1 2H2

CASH INFLOW 0 0 0 7.45
Equity Infusion -10 0 0
EBIT 10 0 0 7.45

INTEREST 0 0 0 4.39
DEPRECIATION 4.50

EBT 0.00 0.00 -1.44

33% TAX 0.00 0.00 -0.47

REPAYMENT OF PRINCIPAL 0 0.00 0.00 3.12

Add Depreciation 4.50
NET CASH -10 0.00 0.00 0.42
IRR 5.8% 11.86%

ASSET VALUE 90
Life of Asset 10
Depreciation Amount 9.0
 $87.73

3H1 3H2 4H1 4H2 5H1 5H2 6H1 6H2

84.60912 81.33482 77.8968 74.28689 70.49648 66.51654 62.33761 57.94974

4.230456 4.066741 3.89484 3.714344 3.524824 3.325827 3.116881 2.897487

4.230456 4.066741 3.89484 3.714344 3.524824 3.325827 3.116881 2.897487
$3.27 $3.44 $3.61 $3.79 $3.98 $4.18 $4.39 $4.61
$81.33 $77.90 $74.29 $70.50 $66.52 $62.34 $57.95 $53.34

3H1 3H2 4H1 4H2 5H1 5H2 6H1 6H2

$7.50 $7.50 $7.50 $7.50 $7.50 $7.50 $7.50 $7.50
4.230456 4.066741 3.89484 3.714344 3.524824 3.325827 3.116881 2.897487
$3.27 $3.44 $3.61 $3.79 $3.98 $4.18 $4.39 $4.61

3H1 3H2 4H1 4H2 5H1 5H2 6H1 6H2

7.45 7.45 7.45 7.45 7.45 7.45 7.45 7.45

7.45 7.45 7.45 7.45 7.45 7.45 7.45 7.45

4.23 4.07 3.89 3.71 3.52 3.33 3.12 2.90

4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50

-1.28 -1.12 -0.94 -0.76 -0.57 -0.38 -0.17 0.05

-0.42 -0.37 -0.31 -0.25 -0.19 -0.12 -0.06 0.02

3.27 3.44 3.61 3.79 3.98 4.18 4.39 4.61

4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50
0.37 0.31 0.26 0.20 0.13 0.07 0.00 -0.07
7H1 7H2 8H1 8H2 9H1 9H2 10H1 10H2
53.34247 48.50484 43.42532 38.09183 32.49167 26.61149 20.43731 13.95442

2.667123 2.425242 2.171266 1.904592 1.624583 1.330575 1.021866 0.697721

2.667123 2.425242 2.171266 1.904592 1.624583 1.330575 1.021866 0.697721
$4.84 $5.08 $5.33 $5.60 $5.88 $6.17 $6.48 $6.81
$48.50 $43.43 $38.09 $32.49 $26.61 $20.44 $13.95 $7.15

7H1 7H2 8H1 8H2 9H1

10H1 10H2 9H2
$7.50 $7.50 $7.50 $7.50 $7.50 $7.50 $7.50 $7.50
2.667123 2.425242 2.171266 1.904592 1.624583 1.330575 1.021866 0.697721
$4.84 $5.08 $5.33 $5.60 $5.88 $6.17 $6.48 $6.81

7H1 7H2 8H1 8H2 9H1 9H2 10H1 10H2

7.45 7.45 7.45 7.45 7.45 7.45 7.45 7.45

7.45 7.45 7.45 7.45 7.45 7.45 7.45 7.45

2.67 2.43 2.17 1.90 1.62 1.33 1.02 0.70

4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50

0.28 0.52 0.78 1.05 1.33 1.62 1.93 2.25

0.09 0.17 0.26 0.34 0.44 0.53 0.64 0.74

4.84 5.08 5.33 5.60 5.88 6.17 6.48 6.81

4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50
-0.15 -0.23 -0.31 -0.40 -0.49 -0.59 -0.69 -0.80
11H1
7.147387

0.357369
0.357369
$7.15
($0.00)

11H1
$7.50
0.357369
$7.15

11H1 11H2 12H1 12H2 13H1 13H2 14H1

7.45 7.45 7.45 7.45 7.45 7.45 7.45

7.45 7.45 7.45 7.45 7.45 7.45 7.45

0.36 0.00 0.00 0.00 0.00 0.00 0.00

4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50

2.59 2.95 2.95 2.95 2.95 2.95 2.95

0.86 0.97 0.97 0.97 0.97 0.97 0.97

7.15 0.00 0.00 0.00 0.00 0.00 0.00

4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50
-0.91 6.48 6.48 6.48 6.48 6.48 6.48
4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50

4.50 4.50 4.50 4.50 4.50 4.50

4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50
4.50